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