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.
Which out of the following you will not find in Paste Special Dialog Box in MS Excel?
Q.2
Which of the following refers to dangerous programs that can be 'caught' on opening E-mail attachments and downloading software from the Internet?
Q.3
What will the function given below return in MS Excel 2010?
=MATCH(12,{10,13,30,40,60},1)
Q.4
Sajal created a PowerPoint presentation on his Physics project which he wants to present to his class. Sajal wants to add some additional point (not present in the slides) to help him remember what he wants to say in each slide. Which PowerPoint feature is best suited for this purpose?
Q.5
In MS Word, what will happen if you press the F8 key three times?
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
Which of the following is FALSE with reference to cell editing in MS Excel?
Q.8
Fill in the blank:
A processor that collects the transmission from several communication media and send them over a single line that operates at a higher capacity is called _____.
Q.9
Fill in the blank:
Exchange of text messages and computer files over network either local network as LAN or over internet as WAN is called as __________.
Q.10
Which one of the following provides the ability to query information from the database, to insert tuples into the database, delete tuples from the database and modify tuples in the database?
Answers to Previous Year Questions from CREST Olympiads:
Q.1
d
Q.2
b
Q.3
b
Q.4
c
Q.5
b
Q.6
a
Q.7
d
Q.8
a
Q.9
a
Q.10
a
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 : d | Q.2 : b | Q.3 : b | Q.4 : c | Q.5 : b | Q.6 : a | Q.7 : d | Q.8 : a | Q.9 : a | Q.10 : a
