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