mr. R Final Exam Review

100 terms by lexraphael 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set