stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Grade 9 revision Flashcards | StudBud
Explore
/
Grade 9 revision
Grade 9 revision
23 terms
·
StudBud Administration
·
61 plays
questions on MS Word, Excel and jobs in IT
Flashcards
23 cards
F
Practice quiz
P
Host live
L
Questions
23
Answers
1
What is the function of the SUM formula in Excel?
To count the number of cells in a range
To find the highest number in a range
To calculate the average of numbers
To add numbers in a selected range
2
What is the shortcut key to save a document in MS Word?
Ctrl + P
Ctrl + V
Ctrl + S
Ctrl + C
3
What is the shortcut key to undo in Excel?
Alt + Enter
Ctrl + Z
Ctrl + N
Shift + F11
4
What is the purpose of the AutoFill feature in Excel?
To copy and extend data patterns in adjacent cells
To format text
To create automatic charts
To delete empty cells
5
what best describes the picture?
a mechanic doing checks
a doctor consulting with a patient
none of the above
a scientist reviewing findings with a colleague
6
What is the default font in Microsoft Word 2016 and later?
Calibri
Verdana
Arial
Times New Roman
7
Which tab contains the "Font" group in MS Word?
Home
Insert
Layout
View
8
What is the function of the "Header and Footer" in MS Word?
To insert page numbers and document title
To format text color
To create a table
To add images
9
Which of the following is used to create a bulleted list in MS Word?
Both (b) and (c)
Ctrl + Shift + B
The Numbering Button
The Bullet Button
10
Which file extension is used for a Microsoft Word document?
.xls
.docx
.ppt
.pdf
11
Which of the following is the file extension for an Excel workbook?
.pdf
.docx
.xlsx
.pptx
12
In Excel, you can insert charts to visually represent data.
True
False
13
What feature is used to combine multiple cells into one large cell in a table?
Format Cells
split Cells
Merge Cells
Wrap Text
14
Which IT job involves designing and building websites?
Web Developer
Cybersecurity Specialist
Network Engineer
Data Analyst
15
Which feature in MS Word helps check spelling and grammar errors?
Spell Check
Format Painter
Find and Replace
Track Changes
16
What is the role of a System Administrator?
Design marketing materials
Write code for mobile applications
Manage and maintain IT infrastructure, including servers and networks
Design marketing materials
17
Which symbol is used to start a formula in Excel?
=
@
&
$
18
Which Excel function is used to add numeric values in a range?
AVERAGE
COUNTIF
COUNT
SUM
19
What is the purpose of the “Track Changes” feature?
To automatically format text
To track and display edits made to a document
To insert hyperlinks
To check the word count
20
Which of the following tasks is Microsoft Excel commonly used for
Creating presentations
Editing photos
Data analysis and financial calculations
Writing reports
21
Which of the following is NOT a common IT job role
Software Developer
Data Analyst
Network Administrator
Chef
22
In MS Word, the “Find and Replace” feature allows you to search for a word and automatically replace it with another.
True
False
23
Which Microsoft Office application is best suited for creating a company budget?
MS Excel
MS Word
MS PowerPoint
MS Outlook
