How can we help?

You can also find more resources in our Help Center.

100 terms

mr. R Final Exam Review

STUDY
PLAY
an excel __ allows data easily to be summarized and charted.
A. worksheet
__ is/are used to add worksheet, column, and row titles on a worksheet
B. Text
Clicking the __ box completes an entry
C. Enter
The __ Feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
B. AutoCorrect
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.
A. two
you can apply the Bold font style by pressing the __ keyboard shortcut keys.
B. CTRL+B
Which of the following is the Ribbon path to the Cell Styles button
A. (Home tab / Styles group)
in the accompanying figure, the __
d. legend
Which of the following keys moves the insertion point to the beginning of data in a cell?
a. HOME
remove an embedded chart, you should __ it and press the DELETE key
d. click
When more than one arithmetic operator-is involved in a formula, Excel follows the same basic order of __ that you use in algebra
b. operations
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.
d. F8
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
c. AVERAGE
The __ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign
b. Formula
20. You should a function name in the Formula AutoComplete list to select the function
a. double-click
21. If you do not assign a format to a cell or cells in a column, the column width will remain __ characters.
a. 8.43
22. Cell references in a formula are called
a. assumptions
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
filled.
b. Fill Formatting Only
The Copy button copies the contents and format of the source area to the Office, a reserved place in the
computer's memory
b. Clipboard
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
ranges
c. Double-click
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 __
a. range
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.
c. VLOOKUP
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.
c. AutoFilter
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.
True
A thin red border indicates the active cell, as shown in the accompanying figure.
false
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
true
44. Excel uses the default Oriel Theme for all new workbooks.
false
45. You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).
false
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.
true
47. You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
true
48. To clear the entire worksheet, click the Clear All button on the worksheet.
false
49. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
false
Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.
false
Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.
true
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
true
A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.
true
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
false
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area
true
The NETWORKDAYS function checks a formula for correctness.
false
Many Ribbon commands, galleries, and shortcut keys function as toggles or switches.
true
Changing the order of sheets in a workbook allows you to position the most important worksheets first.
true
You can add only a maximum of five conditional formats to a range
false
Excel does not allow you to create forms and reports based on data in a table
false
Placing more than one table on the same worksheet is recommended.
false
You can apply merge and center formatting with the Center button (Home tab | Alignment group).
false
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.
true
64. The path to the Percent Style button is (Home tab | Editing group).
false
65. HLOOKUP uses the same arguments as VLOOKUP.
true
Excel's __, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
SUM
You can click the ___ Page Layout view button on the to switch to Page Layout view.
status bar
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)
pie
Each ___ in any given table column should have similar data.
cell
you can start data in a table by clicking the Sort button in the Sort & Filter group on the __ tab.
Data
The recommended methodology for creating worksheets includes
A,B,C,D
Which of the following are considered guidelines to use when making decisions
A,C,D
Which of the following is true of a function?
A,B,C,D,
Which of the following are valid formulas?
A,B,C,D
Which of the following actions are provided by the Paste Options button?
A,C,D
76. Which of the following are formatting symbols?
A,B,D
You can name a range by
A,B,D
78. Which of the following are financial functions?
A,B,C
79. Which of the following functions have these three arguments: rate, periods, payment.
A,C
Which of the following are guidelines for creating a table in Excel?
A,B,C,D
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.
I. BACKSPACE
Applies the Currency style with a floating dollar sign and two decimal places.
G. CTRL+SHIFT+$
Spell-checking a worksheet.
H. F7
Pastes a formula
J. CTRL+V
Opens the Format Cells dialog box.
F. CTRL+1
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
F. #NAME?
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.
C. global
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
G. AutoFilter
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