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