Excel CH 2 Objective Quiz
All of the following are valid Excel arithmetic operators EXCEPT ____ (*) (>) (%)
^
Clicking the Create Function box opens the Function Arguments dialog box.
false
The Accounting number format assigns a floating dollar sign.
false
The arithmetic operator, ^, directs Excel to perform the division operation.
false
To use Range Finder to verify that a formula contains the intended cell references, click or tap the cell with the formula you want to check.
false
With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.
false
A ____ is text and graphics that print at the bottom of every page.
footer
A ____ is text and graphics that print at the top of each page
header
A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
indirect
Excel has more than 400 functions that perform just about every type of calculation you can imagine.
true
Point mode allows you to select cells for use in a formula by using your finger or the pointer.
true
The default font for the Basis theme is different than the default font for the Office theme.
true
The equal sign (=) precedes a formula.
true
You can choose from 12 categories of formats in the Format Cells dialog box.
true
You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.
true
When you enter a two-digit year that is less than 30, Excel changes the year to ____.
20xx
Which of the following is the path to the Copy and Paste buttons?
(HOME tab - Clipboard group)
Which of the following is the path to the Sum arrow?
(HOME tab - Editing group)
Which of the following is the path to the Conditional Formatting button?
(HOME tab - Styles group)
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters
8.43
Which of the following are valid formulas?
=3 ^ 4 =H3/H11 =11+9 =22-F15
When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?
Identification of how to format various elements of the worksheet
____ view allows you to create or modify a worksheet while viewing how it will look in printed format
Page Layout
Which of the following actions are provided by the Paste Options button?
Pastes synonyms or acronyms
To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.
Print Selection
Using the Excel spell checker, you can ____.
checking spelling of words in selected range adds words to the dictionary
Which of the following is the path to the Spelling button?
(Review tab - Proofing group)
When you decrease the row height to ____, the row is hidden.
0
To start a new line in a cell, press the ____ keys.
ALT + ENTER
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
You can click the ____ button to undo an automatic correction.
AutoCorrect Options
You can open the Format Cells dialog box by pressing the ____ keys.
CTRL + 1
To copy cell contents, you can select the cell and then press the ____ keys.
CTRL + V
To paste copied cell contents, you can press the ____ keys.
CTRL + V
Clicking the ____ opens the Insert Function dialog box.
Insert Functions box in the formula bar
The ____ function displays the highest value in a range
MAX
The Insert Options button lists formatting options
True
Which of the following is a method of entering functions?
keyboard, touch gesture, or pointer the Sum menu the Insert Function box in the formula bar the Name box area in the formula bar
Point mode allows you to ____, as shown in the accompanying figure.
select cells for use in formula using the mouse pointer