WorksheetsREVIEW QUIZ 2ND PT
Total questions: 50
Worksheet time: 25mins
What is Microsoft Word primarily used for?
Creating spreadsheets
Editing images
Creating and editing documents
Sending emails
Which tab in Microsoft Word is used for formatting fonts?
Insert
Page Layout
Home
Review
What is the shortcut key for saving a document in Microsoft Word?
Ctrl + O
Ctrl + P
Ctrl + S
Ctrl + X
What is the function of the "Find and Replace" feature in Word?
To correct spelling errors
To locate and change specific text
To format paragraphs
To insert images
Which of the following is NOT a type of page break in Microsoft Word?
Page
Column
Text Wrapping
Document
What is the purpose of using headers and footers in a Word document?
To add color to the page
To display information at the top and bottom of each page
To insert images
To create tables
Which feature is used to track changes made in a Word document by multiple users?
Compare
Protect Document
Track Changes
Inspect Document
What is the default file extension for Microsoft Word documents?
.txt
.xls
.docx
What is the purpose of the "Mail Merge" feature in Microsoft Word?
To send emails directly from Word
To create personalized documents for multiple recipients
To merge multiple Word documents into one
To convert Word documents to PDF
Which view in Microsoft Word shows how the document will look when printed?
Web Layout
Draft
Print Layout
Outline
Which of the following is NOT a text alignment option in Word?
Align Left
Align Right
Justify
Align Center
How do you create a numbered list in Microsoft Word?
Insert Tab > Numbering
Page Layout > Numbering
Home Tab > Numbering
Review Tab > Numbering
How can you insert a hyperlink in a Word document?
Home Tab > Hyperlink
Page Layout > Hyperlink
Insert Tab > Hyperlink
Review Tab > Hyperlink
What is the function of the "Thesaurus" in Microsoft Word?
To check spelling
To find synonyms for a word
To translate text
To format paragraphs
Which option is used to change the margins of a Word document?
Insert Tab > Margins
Layout Tab > Margins
Review Tab > Margins
View Tab > Margins
Which shortcut is used to copy selected text in Microsoft Word?
Ctrl + X
Ctrl + S
Ctrl + C
Ctrl + V
What is the shortcut to paste text in Microsoft Word?
Ctrl + C
Ctrl + X
Ctrl + S
Ctrl + V
Which shortcut cuts selected text in Microsoft Word?
Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + Z
What does the shortcut Ctrl + Z do?
Save the document
Redo the last action
Undo the last action
Print the document
What is the shortcut to save a document in Microsoft Word?
Ctrl + P
Ctrl + S
Ctrl + O
Ctrl + N
Which shortcut opens an existing document in Microsoft Word?
Ctrl + S
Ctrl + N
Ctrl + O
Ctrl + P
What does Ctrl + B do to selected text?
Italicizes the text
Underlines the text
Bolds the text
Strikethroughs the text
Which shortcut italicizes selected text in Microsoft Word?
Ctrl + U
Ctrl + B
Ctrl + I
Ctrl + S
What is the shortcut to underline selected text in Microsoft Word?
Ctrl + I
Ctrl + B
Ctrl + S
Ctrl + U
Which shortcut creates a new document in Microsoft Word?
Ctrl + O
Ctrl + S
Ctrl + P
Ctrl + N
What is Microsoft Excel primarily used for?
Word processing
Spreadsheet management and data analysis
Graphic design
Video editing
Which function in Excel is used to add up a range of cells?
AVERAGE()
SUM()
PRODUCT()
COUNT()
What is the shortcut key to save an Excel workbook?
Ctrl + O
Ctrl + P
Ctrl + S
Ctrl + X
Which of the following is NOT a valid cell reference in Excel?
A1
A 1
A$1
1A
What is the shortcut key to select all cells in a worksheet?
Ctrl + Shift
Ctrl + A
Ctrl + Space
Ctrl + Z
What is the default file extension for Microsoft Excel workbooks?
.txt
.docx
.xlsx
.pptx
What is the function of the IF function in Excel?
To iterate through a loop
To perform a logical test and return one value if TRUE and another value if FALSE
To format cells
To find the sum of cells
Which function is used to count the number of cells that contain numbers?
SUM()
COUNT()
COUNTA()
COUNTIF()
Which function is used to find the largest value in a range of cells?
AVERAGE()
MIN()
MAX()
SUM()
What does the function CONCATENATE do in Excel?
Subtracts values
Joins several text strings into one text string
Counts cells
Calculates averages
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Formula
Field
Data
Excel
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ....
G1-G10
B1.G10
B1;G10
B1:G10
Which of the following formulas is not entered correctly?
=10+50
=B7*B1
=B7+14
10+50
Which of the following formulas will Excel NOT be able to calculate?
=SUM (A1:A5) - 5
=SUM(A1: A5) + 5
=SUM(A1;A5)/(10-10)
=SUM(A1:A5)-10
Which function will result in the total number of entries in the cell range B5 to B14?
Count
Max
Min
Sum
What functions will produce results that indicate whether a student has passed or failed a course by entering the text “Pass” or “Fail”?
Count
CountA
If
Spreadsheet rows are easily identified by:
numbers.
letters.
Roman numerals.
colors.
An individual box within a worksheet is known as?
square
range
reference
cell
What is the motion effect in between slides called?
Home
Transitions
Slideshow
Animations
If I want to add a chart or table with data, where do I go?
Home
Insert
Slideshow
View
Google's version of Presentation Software is called:
Google Docs
Google Sheets
Google Slides
Google Forms
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
Select all the text in MS Word document by
Ctrl +S
Ctrl + A
Ctrl + V
Ctrl + 1
Ctrl + I command is used for what purpose?
Save Document
Left Indent
Italic
Close Document
What is the function of the spelling and grammar tool?
Corrects Spelling Errors As You Type
Indicates Grammatical Errors
Identifies Words With Capitalization Problems
All of the above
