mr. R Final Exam Review
an excel __ allows data easily to be summarized and charted.
__ is/are used to add worksheet, column, and row titles on a worksheet
Clicking the __ box completes an entry
The __ Feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
By defualt, text is __ in a cell.
A. left- aligned
The cell being copied is called the souce are (or copy area). The range of cells receiving the copy is called the __
D. destination area (or paste area)
in general, use no more than __ font types in a worksheet.
you can apply the Bold font style by pressing the __ keyboard shortcut keys.
Which of the following is the Ribbon path to the Cell Styles button
A. (Home tab / Styles group)
in the accompanying figure, the __
Which of the following keys moves the insertion point to the beginning of data in a cell?
remove an embedded chart, you should __ it and press the DELETE key
When more than one arithmetic operator-is involved in a formula, Excel follows the same basic order of __ that you use in algebra
Point mode allows you to , as shown in the accompanying figure.
C.select cells for use in a formula using the mouse pointer
Which of the following is the path to the Copy and Paste buttons?
c. (Home tab | Clipboard group)
You can click the __ button to undo an automatic correction.
b. AutoCorrect Options
You can select a range using the keyboard by pressing the __ key and then an ARROW key.
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
The __ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign
20. You should a function name in the Formula AutoComplete list to select the function
21. If you do not assign a format to a cell or cells in a column, the column width will remain __ characters.
22. Cell references in a formula are called
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to __
a. use Excel to create the worksheet
The Auto Fill Option that fills the destination area using the format of the source area; no content is
b. Fill Formatting Only
The Copy button copies the contents and format of the source area to the Office, a reserved place in the
26. Which of the following is not a valid format symbol?
a. semi-colon (;)
the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the
A Pie chart with one of more slices offset is called a(n) .
b. exploded Pie chart
Which of the following is the path to the Zoom button?
a. (View tab | Zoom group)
Which of the following is the path to the Goal Seek button?
c. (Data tab | Data Tools group)
examines the formulas in a workbook in a manner similar to the way the spell checker examines a __workbook for misspelled words
b. The formula checker
Which of the following is the path to the Fill button?
c. (Home tab | Editing group)
In the accompanying figure, the Print area box accepts a name or a __
Which of the following is the path to the Cell Styles button?
d. (Home tab j Styles group)
A check mark in the __ check box speeds up printing by ignoring formatting and not printing most graphics
d. Draft quality
the __ function is used when a table direction is vertical.
The Conditional Formatting __ dialog box display all of the rules for the curent selection or for the entire workbook.
d. Rules Manager
In the Sort box, shown in the accompanying figure , the __ is the Sort by field
b. major sort key
When you first create a table, Excel automatically enables __, as shown in the accompanying figure.
You can display all records in the table after a query hid some of the records by clicking the filter button on
c (Data tab/ Sort & Filter group)
A requirements document includes a needs statement, source of data, summary of calulations, and any other special requirements for a worksheet, as shown inthe accompanying figure.
A thin red border indicates the active cell, as shown in the accompanying figure.
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
44. Excel uses the default Oriel Theme for all new workbooks.
45. You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).
You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position.
47. You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
48. To clear the entire worksheet, click the Clear All button on the worksheet.
49. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.
Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.
The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range
A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area
The NETWORKDAYS function checks a formula for correctness.
Many Ribbon commands, galleries, and shortcut keys function as toggles or switches.
Changing the order of sheets in a workbook allows you to position the most important worksheets first.
You can add only a maximum of five conditional formats to a range
Excel does not allow you to create forms and reports based on data in a table
Placing more than one table on the same worksheet is recommended.
You can apply merge and center formatting with the Center button (Home tab | Alignment group).
Excel automarically creates an empty row in he row in the table, as shown in the accompanying figure, so that you are ready to enter the first record in the table.
64. The path to the Percent Style button is (Home tab | Editing group).
65. HLOOKUP uses the same arguments as VLOOKUP.
Excel's __, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
You can click the ___ Page Layout view button on the to switch to Page Layout view.
When Excel draws a(n) chart, it always positions the chart so that one of the __dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees)
Each ___ in any given table column should have similar data.
you can start data in a table by clicking the Sort button in the Sort & Filter group on the __ tab.
The recommended methodology for creating worksheets includes
Which of the following are considered guidelines to use when making decisions
Which of the following is true of a function?
Which of the following are valid formulas?
Which of the following actions are provided by the Paste Options button?
76. Which of the following are formatting symbols?
You can name a range by
78. Which of the following are financial functions?
79. Which of the following functions have these three arguments: rate, periods, payment.
Which of the following are guidelines for creating a table in Excel?
Identify the letter of the choice that best matches the phrase or definition.
A. ALT+PAGE DOWN
Deletes characters to the left of the insertion point.
Applies the Currency style with a floating dollar sign and two decimal places.
Spell-checking a worksheet.
Pastes a formula
Opens the Format Cells dialog box.
87. Displays the worksheet with formulas
I. CTRL+ACCENT MARK (*)
Fills a destination area using the format of the source area; no content is copied.
B. Fill Formatting Only
Pastes the contents and format of the source area.
G. Keep Source Formatting
Copies the format and contents.
H. Fill Series
91. Returns a number that corresponds to the system date and time beginning with December 31,1899
A. Now function
92. Indicates a cell is using a name Excel does not recognize
Cannot be used to begin a cell or range name.
B. periods and underscore characters
Invoked by clicking the Error Checking button
I. formula checker
Returns the present value of an investment or annuity.
E. Returns the present value of an investment
A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.
Fixes round-off errors
G. Fixes round-off errors.
98. Displays all records that meet the criteria as a subset of the table by hiding records that do not pass the test
99. An area of the worksheet that you use to manipulate records that pass the comparison criteria.
E. criteria range
Allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
J. conditional formatting