WorksheetsMicrosoft Office Quiz
Total questions: 30
Worksheet time: 15mins
The menu to insert a table in Microsoft Word is …
Layout
Insert
References
Review
The main function of Microsoft Excel is …
Word processor
Image processor
Number processor
Presentation processor
The shortcut to open an existing file is …
Ctrl + S
Ctrl + O
Ctrl + N
Ctrl + P
Rows in Excel are marked with …
Letters
Numbers
Symbols
Colors
The feature to print documents is found in the menu …
File
Home
Insert
View
A pie chart in Excel is called …
Column Chart
Line Chart
Bar Chart
Pie Chart
The MIN function in Excel is used for …
Largest value
Smallest value
Average value
Data count
The Word feature to add comments to text is …
Track Changes
Notes
Comment
Footnote
To merge several cells into one, the command used is …
Wrap Text
Merge Cells
Split Cells
Align Center
The Excel function to count cells containing numbers and text is …
COUNT
COUNTA
COUNTBLANK
SUM
Headers and Footers usually do not contain …
Page number
Document title
Footnotes
Author name
The Excel feature to sort data from largest to smallest is …
Filter
Sort Descending
Conditional Formatting
Freeze Panes
The shortcut for Center Alignment is …
Ctrl + L
Ctrl + R
Ctrl + J
Ctrl + E
The function LEFT(text,n) is used to …
Get right characters
Get left characters
Combine text
Change text case
To display table borders, use …
Shading
Border
Layout
Gridline
The formula to display 'Discount' if total purchase ≥ 1,000,000 is …
=IF(A1>1000000,'Discount','No')
=IF(A1>=1000000,'Discount','No')
=IF(A1=1000000,'Discount','No')
=IF(A1<1000000,'Discount','No')
The formula for the average of A1:A10 is …
=AVERAGE(A1:A10)
=AVERAGEIF(A1:A10,'>75')
=COUNTIF(A1:A10,'>75')
=SUMIF(A1:A10,'>75')
The TRIM function is used to …
Remove numbers
Remove excess spaces
Remove text
Change format
To restrict editing part of a Word document, use …
Protect Document
Restrict Editing
Encrypt File
Lock Page
The best chart to show time trends is …
Pie Chart
Bar Chart
Line Chart
Column Chart
Mail Merge will fail if …
Data source is empty
Word document is closed
Font is unavailable
Margins are too small
The best chart to compare different categories is …
Pie Chart
Bar Chart
Scatter Plot
Line Chart
The shortcut to save a document in Microsoft Word is …
Ctrl + S
Ctrl + A
Ctrl + N
Ctrl + P
The function to find the maximum value in a range in Excel is …
SUM
MAX
MIN
AVERAGE
The feature in Word that allows you to create a table of contents is …
Home
Layout
Insert
References
The Excel function to find the minimum value in a range is …
MIN
SMALLEST
MINIMUM
LOWEST
The shortcut to print a document in Microsoft Word is …
Ctrl + T
Ctrl + R
Ctrl + Q
Ctrl + P
The Excel function to calculate the average of a range is …
MEAN
AVG
MEDIAN
AVERAGE
The feature in Word that allows you to track changes made to a document is …
Review
Editing
Comments
Track Changes
The command to create a new worksheet in Excel is …
New Workbook
Add Worksheet
Insert Sheet
New Sheet
