Microsoft Excel 2016 Exam Review

11 September 2022
4.7 (114 reviews)
50 test answers

Unlock all answers in this set

Unlock answers (46)
question
You can select nonadjacent ranges using the SHIFT key.
answer
False
question
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
answer
True
question
The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.
answer
True
question
The range automatically selected by Excel is always correct.
answer
False
question
You cannot format an entire column at once.
answer
False
question
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab - Charts group)
answer
True
question
You should press the SPACEBAR to clear a cell.
answer
False
question
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
answer
True
question
The Sum button menu allows you to enter one of five often-used functions easily into a cell.
answer
False
question
A thin red border indicates the active cell.
answer
False
question
Excel has more than 400 functions that preform just about every type of calculations you can imagine.
answer
True
question
Excel can display characters in only three font colors: black, red, and blue.
answer
False
question
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.
answer
False
question
The equal sign (=) precedes a formula.
answer
True
question
The underline format underlines the entire cell, not just the characters in the cell.
answer
False
question
Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.
answer
True
question
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to prefrom the division operation.
answer
False
question
To select a number format, you can choose a category in the Number tab in the format Cells dialog box and then select the number of decimal places, whether or not dollar sin should be displayed, and how negative numbers should appear.
answer
True
question
The most common error when entering a formula is to reference the wrong cell in the formula.
answer
True
question
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
answer
True
question
What effect does the Accounting Number Format have on the selected cells.
answer
Displays cell contains with two decimal places that align vertically.
question
An Excel ______ allows data to be summarized and charted easily.
answer
worksheet
question
__________ refers to cells not wide enough to display the entire entry
answer
#####
question
The _____ function determines the lowest number in a range.
answer
MIN
question
The ______ function displays the highest value in a range.
answer
MAX
question
The _____ function is useful when you want to assign a value to a cell based on a logical test.
answer
IF
question
The ________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left spaces between it and the first digit in the cell.
answer
Accounting Number Format
question
To print a range of cells in the active worksheet, click ______ in the Settings area in the Print gallery.
answer
Print Selection
question
Charts can either be embedded in a worksheet or placed in a separate _________.
answer
chart sheet
question
A ______ function is a prewritten formula that is built into Excel.
answer
function
question
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra.
answer
operations
question
What effect does the Comma Style format have on the selected cells?
answer
Displays cell contents with two decimal places and commas as thousands separators
question
A _______ is text and graphics that print at the bottom of every page.
answer
footer
question
The INCREASE INDENT button indents the contents of a cell to the right by _____ spaces each time you click it.
answer
two
question
_______ view allows you to create or modify a worksheet while viewing how it will look in printed format.
answer
Page Layout
question
Which of the following happens when you enter the formula =G15 into a cell?
answer
Excel assigns the value in cell G15 to the active cell
question
You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
answer
format
question
The default view in Excel is called ______ view.
answer
Normal
question
Combining two or more selected cells into one is called ____ cells.
answer
merging
question
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.
answer
#REF!
question
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.
answer
AVERAGE
question
Which of the following formulas contains an absolute cell reference?
answer
=$b$4
question
Which of the following is an extension of the fill pattern Sunday, Tuesday>
answer
Thursday, Saturday, Monday
question
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ______ values.
answer
Constant
question
The ______ button allows you to erase recent cell entries.
answer
Undo
question
The _______ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.
answer
Formula
question
A _______ is text and graphics that print at the top of each page.
answer
Header
question
A ______ chart provides a simple way to show trends and variations in a range of data within a single cell.
answer
Sparkline
question
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ______/
answer
Colon (:)
question
When assigned to a cell, the _____ function returns the current date and time formatted as a date and time.
answer
NOW