Excel Module 1 & 2
Which of the following is the Ribbon path to the Cell Styles button?
(HOME tab | Styles group)
When you decrease the row height to ____, the row is hidden.
0
Excel remembers the last ____ actions you have completed.
100
How many chart types does Excel offer?
15
Which of the following calculations multiples 23 by 0.01?
23%
When Excel follows the order of operations, the formula, 8*3+2, equals ___.
26
If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.
8.43
All of the following are valid Excel arithmetic operations EXCEPT _____.
>
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
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
The ___ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
AutoCalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
You can click the ____ button to undo an automatic correction.
AutoCorrect options?
Press _____ to select the entire worksheet.
CTRL+A
You can apply the Bold font style by pressing the _____ keyboard shortcut keys.
CTRL+B
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
Which effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
Which of the following keys moves the insertion point to the end of data in a cell?
END
To erase an entire entry in a cell and then reenter the data from the beginning, press the _____ key.
ESC
Click the _____ box completes an entry.
Enter
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in the cell G15 to the active cell
(T/F) A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.
False
(T/F) A single point is about 1/32 of one inch in height.
False
(T/F) A thin red border indicates the active cell.
False
(T/F) Best fit means that the width of the column will be increased or decreased by a percentage you specify.
False
(T/F) Clicking the Create Function box open the Function Arguments dialog box.
False
(T/F) Excel can display characters in only three font colors: black, red, and blue.
False
(T/F) In a worksheet, columns typically contain information that is similar to a list.
False
(T/F) Live preview is available on a touch screen.
False
(T/F) The Accounting number format assigns a floating dollar sign.
False
(T/F) The arithmetic operator, ^, directs Excel to perform the division operations.
False
(T/F) The range automatically selected by Excel is always correct.
False
(T/F) To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalulate area to display the Customize Status Bar shortcut menu.
False
(T/F) When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.
False
(T/F) While holding down the ALT key, you can select nonadjacent ranges and cells.
False
(T/F) 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
(T/F) Worksheet titles and subtitles should be as wordy as possible.
False
(T/F) You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).
False
(T/F) You can use the arrow keys to complete an entry in Point mode.
False
(T/F) You should press the SPACEBAR to clear a cell.
False
The ____ AutoComplette list contains those functions that alphabetically match the letters you type following the equal sign.
Formula
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
The ___ Option button lists formatting options following an insertion of cells, rows, or columns.
Insert
The ____ function determines the lowest number in a range.
MIN
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
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
You can use the ____ to check which cells are referenced in the formula assigned to the active cell.
Range finder
_____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
______ is/are used to place worksheet, column, and row title on a worksheet.
Text
The _____ button lists error-checking options following the assignment of an invalid formula to a cell.
Trace Error
(T/F) A character with a point size of 10 is about 10/72 of one inch in height.
True
(T/F) A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
True
(T/F) Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.
True
(T/F) Cooler colors tend to pull away from the reader.
True
(T/F) Excel has more that 400 functions that perform just about every type of calculation you can imagine.
True
(T/F) Excel recognizes the following text: 401AX21, 921-231, 619 321, 883XTY
True
(T/F) Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cell sin the column.
True
(T/F) Moving from left to right, the first calculation in the order of operations is negation (-).
True
(T/F) Point mode allows you to select cells for use in a formula by using your finger or the pointer.
True
(T/F) The AVERAGE function requires that the argument be included within parentheses following the function name.
True
(T/F) The AutoCorrect feature can automatically capitalize the first letter in the names of days.
True
(T/F) The Insert Options button lists formatting options.
True
(T/F) 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
(T/F) The Sum button menu allows you to enter one of five often-used functions easily into a cell.
True
(T/F) The equal sign (=) proceeds a formula.
True
(T/F) The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range.
True
(T/F) The most common error when entering a formula is to reference the wrong cell in the formula.
True
(T/F) The opposite of merging cells is splitting a merged cell.
True
(T/F) 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
(T/F) 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 a dollar sign should be displayed, and how negative numbers should appear.
True
(T/F) Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
True
(T/F) 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
(T/F) With Excel in Edit mode, you can edit cell contents directly in the cell.
True
(T/F) You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.
True
(T/F) You can press the RIGHT ARROW of LEFT ARROW keys to position the insertion point during in-cell editing.
True
The ____ button allows you to erase recent cell entries.
Undo
You can use ____ to view an XPS file.
XPS Viewer
The date you change a file is an example of a(n) ____ property.
automatically updated
To enter data in a cell, you must first select the _____.
cell
You can enter the correct range in a function by typing the beginning and ending cell references separated by a _____.
colon (:)
The range of cells receiving the content of copied cells in a called the ____.
destination area
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
A _____ is text and graphic 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 ____ is a prewritten formula that is built into Excel.
function
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
Combining two or more selected cells into one cell is call ______ cells.
merging
The range of cells receiving copied contents called the ____ area.
paste
A _____ reference is an adjusted cell reference in a copied and pasted formula.
relative
The adjusted cell references in a copied and pasted formula are called _____ cell references.
relative
The person or persons requesting the worksheet should supply their requirements in a _____ document.
requirements
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.
theme
The first step in creating an effective worksheet is to make sure you _____.
understand what is required
An Excel ____ allows data to be summarized and charted easily.
worksheet