Section 1: Algorithms and Flowcharts in Programming, Visual Basic, Animations, HTML (Links, Anchors and Table tags), MS Word, MS Excel (Formula Auditing, Data Tools, Protecting and Sharing Workbooks/Worksheets, Working with Cell Range), MS PowerPoint, Hardware, Software, Input & Output Devices, Memory & Storage Devices, Flash CS6, Communication Technology (Networking, Internet and Multimedia), Operating Systems (Types-Interactive (GUI based), Real Time and Distributed, Commonly used OS), Windows, Latest Developments in the Field of IT.
Achievers Section: Higher Order Thinking Questions - Syllabus as per Section 1.
Questions are based on Windows 11 and MS Office 2016.
What is the value of the following MS Excel formula?
=MOD(11,3) & 32/4/2
Q.2
< SCRIPT > … < /SCRIPT > tag can be placed within which of the following HTML tag?
Q.3
Shane is working on excel. She wants to add a pie chart in her sheet. Which of the following steps should she perform to open Chart Wizard?
Q.4
What will the function given below return in MS Excel 2010?
=MATCH(12,{10,13,30,40,60},1)
Q.5
Consider the following code segment if (Y < 0) {X = -X: Y = - Y} ; Z = 0; while (Y > 0) {Z = Z + X ; Y + Y - 1 ; } Assume that X, Y and Z are inter variables, and that X and Y have be initialised. Which of the following best describes what these code segment does?
Q.6
Match the following MS-PowerPoint components in Column A with their description in Column B:
Column A
Column B
(a) Slide Design
(i) are the dotted-line containers on slide layouts that hold such content as titles, body text, tables, charts, SmartArt graphics, pictures, clip art, videos, and sounds
(b) Auto Content Wizard
(ii) These are the templates for Microsoft Office and PowerPoint that you can use to enhance your presentations
(c) Place Holder
(iii) is a feature available in some programs, usually found on the left side of the window. It displays thumbnails of files or features available in the program
(d) Slide Pane
(iv) It leads you through a series of questions so you can choose the best layout for your presentation
Q.7
In Flowchart, diamond shaped symbol is used to represent which of the following options?
Q.8
Which of the following device takes data sent from one network device and forwards it to all devices on the network regardless of the intended recipient?
Q.9
In Visual Basic, what do you call the process of hiding variable information in a class that doesn't need to be seen by the rest of the program?
Q.10
Identify the term with the help of the description given below:
(i) It is the maximum rate of data transfer across a given path (ii) This is computed by taking the number of bits - in a Gigabit network, that would be 1 billion and dividing that by eight to determine the bytes (iii) It is the capacity of a wired or wireless network communications link to transmit the maximum amount of data from one point to another over a computer network or internet connection in a given amount of time, usually one second
Answers to Previous Year Questions from CREST Olympiads:
Q.1
a
Q.2
c
Q.3
c
Q.4
b
Q.5
c
Q.6
a
Q.7
a
Q.8
c
Q.9
b
Q.10
c
Students can easily download the CREST Cyber Olympiad previous year paper pdf for class 9 from this page. The answer key for all the questions is also provided on the last page.
The best method for students to familiarize themselves with the CREST Cyber Olympiad exam is to refer to previous years question papers. CREST Cyber Olympiad previous year paper for class 9 will not only assist students in comprehending the format of the test but also the kind of questions they must practice in order to do well in the exam.
CREST Cyber Olympiad past years papers are an excellent self-assessment resource to evaluate exam preparation. Students can compare their present performance to previous efforts and identify their strengths and weaknesses. Hence, with so many benefits associated with practicing previous years' papers, students must spare a good amount of time-solving these papers before the final exam.
Additional Preparation Resource
CREST Cyber Olympiad Worksheets Package for class 9 - It is a package of 5 worksheets. The worksheets are in the same pattern as the previous year paper. Hence, very useful for preparation. Existing users can purchase additional practice worksheets by following these steps: Login at https://www.crestolympiads.com/login -> Dashboard -> Additional Practice -> Buy & new users can visit https://www.crestolympiads.com/registration
Note: Don’t forget to download the CREST Cyber Olympiad past year paper pdf for class 9.
Answers to Previous Year Questions from CREST Olympiads:
Q.1 : a | Q.2 : c | Q.3 : c | Q.4 : b | Q.5 : c | Q.6 : a | Q.7 : a | Q.8 : c | Q.9 : b | Q.10 : c
