excel chapter 1 exam
The Percent Style button formats selected cells as a percentage with ________.
0 decimal places
Sparklines are tiny charts located within a cell that provide a visual trend summary of data.
True
A cell style often includes font, font size, font color, and cell borders.
t
A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.
t
An outlined cell in a worksheet is the active cell.
t
Auto Fill generates and extends a series of value into adjacent cells in a worksheet.
t
AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
t
You can create a custom footer in Excel.
true
When preparing a document for printing, a ________ indicates that only the columns to the left will be printed on the first page.
vertical dotted line between columns
The value axis is also known as the ________.
y-axis
All formulas begin with a(n) ________.
= sign
Which of the following is the default number format in Excel 2016?
Correct General format, Calibri, 11 pt
Hold down the ________ key to select nonadjacent cells.
Ctrl
The keyboard shortcut to display Print Preview is ________.
Ctrl + F2
________ is the keyboard shortcut for the Spelling command.
F7
The orientation of a worksheet can be changed on the Home tab as well as in Print Preview.
False
The default number format for cells is the ________ number format.
General
Where is the fill handle located?
In the lower right corner of a selected cell
Which of the following is NOT one of the default calculations displayed by AutoCalculate?
Maximum
Which of the following does not display to the right side of a selected chart?
Move Chart button
Using a touchscreen, which of the following actions is the same as right-clicking the mouse?
Press and hold for a few seconds
When you type data in a cell and press Enter, what cell becomes the active cell?
The cell below
Which of the following is NOT part of the Accounting Number Format?
Three decimal places
A data series is a collection of related data points.
True
The Sum button resides on both the Home tab and the Formulas tab.
True
The range finder feature in Excel is useful for verifying formulas.
True
When a cell is part of an active formula, it is surrounded with ________.
a colored border with small boxes on each side
A defined set of formatting characteristics such as font, font size, and font color are known as a ________.
cell style
A data marker is a value that originates in a worksheet cell.
f
Auto Fill works only with alphabetic values.
f
Ctrl + = starts the Sum function in a worksheet.
f
If two cells are merged into one, the cell contents are automatically left justified in the new, merged cell.
f
Sparklines cannot be formatted.
f
Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.
f
The AutoCalculate feature display three calculations by default: Sum, Subtraction, and Multiplication.
f
The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.
f
The Wrap Text command displays numbers or formulas on multiple lines as well as text.
f
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.
f
To indicate a range, include a dash between the two cell references.
f
Typically, you should include totals when creating a chart.
f
You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.
f
To display the document properties, click the ________ tab.
file
When you type text in a cell it is ________.
left-aligned
If you move formulas by inserting additional rows or columns in your worksheet, Excel automatically adjusts the formulas.
t
Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.
t
The Formula Bar in Excel 2016 displays the value or formula in the active cell.
t
The Percent Style can have fewer or more places after the decimal that the default setting.
t
The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.
t
When two or more cells are merged, the individual cells cannot be selected.
t
When you type in a cell and the cell to the right contains data, the text in the cell to the left is truncated.
t
Normal view maximizes the number of cells visible on your screen.
true
The asterisk (*) indicates multiplication in Excel 2016.
true
The spelling checker in Excel performs similarly to other Microsoft Office programs.
true
Comma Style format displays a number with ________.
two decimal places
