NEW
Font size
S
M
L
XL
WorksheetsEXCEL - Lesson 3 & 4
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
a)
Backstage
b)
Print
c)
Edit
d)
Windows
2.
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
a)
Info
b)
Options
c)
Print
d)
Open
3.
Which of the following can be customized for quicker access to your most commonly used commands?
a)
Print Preview
b)
Quick Access Toolbar
c)
Printer setup
d)
Workbook
4.
When you modify the ribbon, which of the following is created?
a)
command
b)
tab
c)
button
d)
worksheet
5.
Which predesigned file already has a significant amount of formatting, text, and other features?
a)
Blank workbook
b)
Preset file
c)
Text file
d)
Template
6.
To access an Excel template, you can click the File tab and then click New.
a)
True
b)
False
7.
If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.
a)
True
b)
False
8.
You can access Backstage view by pressing Ctrl+B.
a)
True
b)
False
9.
In Excel, you can add your most commonly used commands to the Quick Access Toolbar.
a)
True
b)
False
10.
You can create a completely new ribbon tab as well as groups on that ribbon.
a)
True
b)
False
11.
Which of the following is not an arithmetic operator?
a)
+
b)
-
c)
*
d)
]
12.
Per the order of operations, which of the following is calculated first?
a)
Addition (+) and subtraction (−) (left to right)
b)
Exponentiation (ˆ)
c)
Percent (%)
d)
Negative number (−)
13.
Which of the following is an acceptable name for a named range?
a)
C7
b)
subtotal_west
c)
subtotal west
d)
subtotal/west
14.
Which of the following is an example of an absolute cell reference?
a)
A9
b)
A$9
c)
$A$9
d)
A9:E9
15.
Which of the following is an example of a mixed cell reference?
a)
A9
b)
A$9
c)
$A$9
d)
A9:E9
16.
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
a)
True
b)
False
17.
Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.
a)
True
b)
False
18.
You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.
a)
True
b)
False
19.
The order of operations determines which parts of a formula are calculated before other parts of the formula.
a)
True
b)
False
20.
The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).
a)
True
b)
False
Reset
