WorksheetsIntroduction to MS Excel 2016
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What does MS Excel 2016 belong to?
a)
Windows OS
b)
Microsoft Office suite
c)
Google suite
d)
OpenOffice
2.
How many worksheets does a new workbook contain by default in MS Excel 2016?
a)
None
b)
Two
c)
One
d)
Three
3.
Which bar displays the contents of the active cell?
a)
Status bar
b)
Title bar
c)
Formula bar
d)
Ribbon
4.
To save a workbook, which tab should you click on?
a)
Insert
b)
File
c)
Data
d)
Review
5.
What is the shortcut key to open a new workbook?
a)
Ctrl+O
b)
Ctrl+N
c)
Ctrl+S
d)
Ctrl+P
6.
Which button is used to autofill the same content in adjacent cells?
a)
Format Painter
b)
Merge & Center
c)
Wrap Text
d)
Fill Handle
7.
What does the Name box display?
a)
Contents of the current cell
b)
Address of the active cell
c)
Total number of rows and columns
d)
Status of the worksheet
8.
How are rows in an Excel worksheet labeled?
a)
A, B, C...
b)
1, 2, 3...
c)
I, II, III...
d)
i, ii, iii...
9.
Which group contains options for formatting numbers in MS Excel?
a)
Font group
b)
Alignment group
c)
Number group
d)
Styles group
10.
How can you rename a worksheet?
a)
Double-click on the worksheet tab
b)
Right-click on the worksheet tab and select Rename
c)
Both a and b
d)
None of the above
11.
What should you click to combine cells?
a)
Merge & Center
b)
Wrap Text
c)
Format Painter
d)
Fill Handle
12.
Which shortcut key selects the entire worksheet?
a)
Ctrl+A
b)
Ctrl+C
c)
Ctrl+X
d)
Ctrl+V
13.
In which group under the Home tab is the Wrap Text option located?
a)
Clipboard
b)
Font
c)
Alignment
d)
Styles
14.
What is the file extension for an Excel 2016 workbook?
a)
.xlsx
b)
.docx
c)
.pptx
d)
.pdf
15.
How do you open an existing workbook if the Excel application window is not open?
a)
Go to File tab and select Open
b)
Double-click on the file in the folder that contains it
c)
Right-click on the file and select Open
d)
Use the Ctrl+O shortcut
16.
How do you change the number format to add two decimal places?
a)
Use the Font group options
b)
Click on the drop-down arrow in the Number group and select Number
c)
Use the Conditional Formatting options
d)
Apply the Format Painter
17.
What feature allows you to fit the content within the same cell by displaying it in multiple lines?
a)
Merge & Center
b)
Wrap Text
c)
Format Painter
d)
Fill Handle
18.
How do you delete the contents of a cell without deleting the cell itself?
a)
Press the Delete key
b)
Right-click and select Clear Contents
c)
Both a and b
d)
None of the above
19.
When working with a range of cells, how do you select non-adjacent ranges?
a)
Hold down the Ctrl key and select the ranges
b)
Hold down the Shift key and select the ranges
c)
Double-click each range
d)
Use the Format Painter
20.
How do you apply currency formatting to a number in Excel?
a)
Use the Font group options
b)
Use the Number group and select Currency
c)
Apply the Conditional Formatting
d)
Use the Format Painter
100 %
