NEW
Font size
WorksheetsExcel Module 2 Quiz 1
Total questions: 35
Worksheet time: 18mins
A ____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
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.
contiguous
indexed
direct
indirect
All of the following are valid Excel arithmetic operators EXCEPT ____.
^
*
%
>
Which of the following calculations multiplies 23 by 0.01?
=23%
=23
=23+.01
=24-.01
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
placement
operations
positioning
selections
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
40
26
48
13
Which of the following happens when you enter the formula =G15 into a cell?
Excel recalculates all formulas in the worksheet
Excel assigns the sum of the values in the previous 15 cells to the active cell
Excel assigns the value in cell G15 to the active cell
Nothing; =G15 is an invalid formula
The adjusted cell references in a copied and pasted formula are called ____ cell references.
related
relative
pasted
alternative
You can click the ____ button to undo an automatic correction.
autofill options
autocorrect options
paste options
trace error
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
AutoCorrect Options
Insert Options
Paste Options
The ____ button lists error-checking options following the assignment of an invalid formula to a cell.
Find Error
Explain Error
Fix Error
Trace Error
The ____ Option button lists formatting options following an insertion of cells, rows, or columns.
AutoCorrect
Insert
AutoFill
Paste
The ____ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
The ____ function determines the lowest number in a range.
LOW
BASE
LEAST
MIN
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
DIVSUM
RANGEAVG
AVERAGE
MAX
The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
Function
Formula
Equal
Calculate
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
left parenthesis
right bracket
right parenthesis
left bracket
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Formula Finder
Range Finder
Calculation Finder
Function Finder
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
scheme
gallery
theme
style
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.
Comma style format
Accounting number format
Percent style format
Currency style format
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
7.52
11.65
9.43
When you decrease the row height to ___, the row is hidden.
0
1
2
3
A ____ is text and graphics that print at the top of each page.
header
topper
margin
crown
A _____ is text and graphics that print at the bottom of every page.
footer
toe
margin
stopper
The default view is Excel is called _____ view.
Normal
Standard
Basic
Values
_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
Normal
Page Layout
Page Break Preview
Full Screen
To print a range of cells in the active worksheet, click _____ in the Settings area in the Print gallery.
Print Active Sheets
Print Selection
Print Entire Workbook
none of the above
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
Avoiding the temptation to use flashy or confusing visual elements within the worksheet
Which of the following are valid formulas?
=3 ^ 4
=H3/H11
=11+9
=22-F15
All of the above
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
All of the above
Using the Excel spell checker, you can ____.
check the spelling of words in a selected range
add words to the dictionary
Both of the above
The equal sign (=) precedes a formula.
True
False
The most common error when entering a formula is to reference the wrong cell in the formula.
True
False
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
True
False
The arithmetic operator, ^, directs Excel to perform the division operation.
True
False
