NEW
Font size
S
M
L
XL
WorksheetsExcel Review
Total questions: 50
Worksheet time: 28mins
Name
Class
Date
1.
Each cell's name is based on its _______ and _______.
a)
column, row
b)
column, cell
2.
You can select ________ using the arrow keys on your keyboard.
a)
Cells
b)
Rows
c)
Columns
d)
Worksheets
3.
You can use the _______ key on your keyboard to clear content from multiple cells at once.
a)
Clear
b)
Delete
4.
When you use _______ _____, choose a different name and/or location for the copied version.
a)
Auto Fill
b)
Auto Sum
c)
Save As
d)
Save
5.
Allows you to move content between cells.
a)
Drag and Drop
b)
Cut
c)
Paste Only
d)
Copy
6.
To access additional paste options on the Ribbon,
a)
Click the drop-down arrow.
b)
Right-Click the Active Cell.
7.
To open an existing workbook, go to the __________ ___ and click Open
a)
Home Tab
b)
BackStage View
8.
If you frequently work with the same workbook, you can ______ it to Backstage view for faster access.
a)
Save
b)
Pin
9.
You can also browse templates by category or use the _______________ to find something more specific.
a)
Search Bar
b)
Tell Me Bar
10.
When you open workbooks created with older versions of Excel, they will appear in _________ ______.
a)
BackStage View
b)
Compatibility Mode
11.
How many worksheets does a new Excel 2016 workbook open with?
a)
1
b)
2
c)
3
d)
4
12.
Which of the following is the intersection of a row and column?
a)
Range
b)
Cell
13.
By default, Excel autosaves every _____ minutes.
a)
5
b)
10
c)
15
d)
20
14.
Which command is used to insert a cut or copied selection to a cell or range of cells?
a)
Cut
b)
Copy
c)
Paste
d)
Drag and Drop
15.
To change a workbook to another kind of document, you can _______?
a)
Save As
b)
Save
16.
The ______ is a small green square in the lower-right corner that copies one cell to another.
a)
Paste Command
b)
Copy Command
c)
Drag and Drop Command
d)
Fill Handler
17.
You can select _____ cells at the same time. A group of cells is known as a ____ range.
a)
Multiple, Cell
b)
Multiple, Row
18.
Which predesigned file already has a significant amount of formatting, and other features?
a)
Template
b)
Blank Workbook
19.
Predefined set of colors, fonts, effects that can be applied to an entire or specific workbook.
a)
Document Theme
b)
Template
20.
An Excel view that enables you to see what your document will look like before printing.
a)
Print Preview
b)
BackStage
21.
Which of the following statements describes how to increase or decrease a column’s width?
a)
Right-click anywhere in the column and select Format Cells.
b)
Drag the boundary next to the column heading.
22.
By default, Excel will only export the _______ worksheet (s).
a)
First Three
b)
Active Sheet
23.
In most cases, you will need to select multiple cells before using the _____ _______.
a)
Auto Fill
b)
Active Cell
24.
Where can you insert and delete a columns?
a)
Cell Group
b)
Editing Group
25.
When you create or edit a workbook, you'll use the _______ command to save your changes.
a)
Save
b)
Save As
26.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
27.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
28.
By default, all cell references are _________ references.
a)
Absolute
b)
Relative
29.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
30.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
31.
If the parenthesis is removed, what will 9.5% be multiplied by?
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
32.
Which response best completes the following statement: A formula is used to
a)
perform calculations or other actions.
b)
find averages.
33.
The discount formula can be explained by saying the _______ minus 10% of the ___________.
a)
total
b)
Sum
34.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
35.
When calculating the tax per item the formula to use it
a)
= Total * sales tax%
b)
= Total +(Total * sales tax%)
36.
Generally speaking, the total from the sales tax formula represents
a)
The total of the cells (rows or columns) being calculated
b)
The total of sales tax being calculated
37.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
38.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
39.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
40.
The most common way to identify a cell reference is
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
41.
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
a)
range containing data
b)
Price of the item being looked for
42.
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
a)
True
b)
False
43.
The LOOKUP function in Excel is used to search one column of data and find data in the _______ row
a)
Corresponding
b)
Value
44.
The LookUp function has three arguments. First ___________ then data to search and finally, results column
a)
Value to Look Up
b)
Value to Calculate
45.
There are _______ ways to view a worksheet. Simply click a command to select the desired view.
a)
One
b)
Two
c)
Three
d)
Four
46.
The _____________________ lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
a)
Quick Access Tool Bar
b)
BackStage View
c)
Home Tab
d)
View Tab
47.
Excel 2016 uses a ______ Ribbon system instead of traditional menus. Each _____ will have one or more groups.
a)
Tabbed, Tab
b)
Quick Access, Ribbon
48.
Some _________ will have an ________ you can click for more options.
a)
Groups, arrow
b)
Tabs, Arrow
49.
You can add any feature of Excel to the ______________ so that you can easily access it from anywhere
a)
Ribbon
b)
Quick Access Tool Bar
50.
Excel has 1000s of features, they are grouped into several ___________.
a)
Ribbons
b)
Tabs
Reset
