Deck 11: Excel : Formulas, Functions, and Formatting

Question 1

A _____ cell in Excel has a numerical value of zero.

A)blank
B)formatted
C)copied
D)filled

Answer 1

A

Question 2

When you enter a two-digit year that is less than 30, Excel changes the year to _____.

A)20xx
B)30xx
C)18xx
D)19xx

Answer 2

A

Question 3

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.

A)40
B)26
C)48
D)13

Answer 3

B

Question 4

You can click the _____ button to undo an automatic correction.

A)Auto Fill Options
B)AutoCorrect Options
C)Paste Options
D)Trace Error

Question 5

Which of the following is the path to the Copy and Paste buttons?

A)(Home tab | Copy group)
B)(Home tab | Paste group)
C)(Home tab | Clipboard group)
D)(Home tab | Formulas group)

Question 6

A _____ is a prewritten formula that is built into Excel.

A)function
B)feature
C)task
D)calculation

Question 7

The adjusted cell references in a copied and pasted formula are called _____ references.

A)related
B)relative
C)pasted
D)alternative

Question 8

The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

A)Function
B)Formula
C)Equal
D)Calculate

Question 9

All of the following are valid Excel arithmetic operators except _____.

A)^
B)*
C)%
D)>

Question 10

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.

A)placement
B)operations
C)positioning
D)selections

Question 11

Point mode allows you to ____, as shown in the accompanying figure.

A)select cells for use in a formula using the keyboard
B)select a function from the Sum button list
C)select cells for use in a formula using the mouse pointer
D)edit cell contents directly in the cell

Question 12

Which of the following happens when you enter the formula =G15 into a cell?

A)Excel recalculates all formulas in the worksheet
B)Excel assigns the sum of the values in the previous 15 cells to the active cell
C)Excel assigns the value in cell G15 to the active cell
D)Nothing; =G15 is an invalid formula

Question 13

The _____ Option button lists formatting options following an insertion of cells, rows, or columns.

A)AutoCorrect
B)Insert
C)Auto Fill
D)Paste

Question 14

You can select a range using the keyboard by pressing the _____ key and then an ARROW key.

A)F2
B)F4
C)F6
D)F8

Question 15

Which of the following Option buttons gives options for filling cells following a fill operation?

A)Auto Fill Options
B)AutoCorrect Options
C)Insert Options
D)Paste Options

Question 16

Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

A)left parenthesis
B)right bracket
C)right parenthesis
D)left bracket

Question 17

The _____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

A)Find Error
B)Explain Error
C)Fix Error
D)Trace Error

Question 18

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.

A)MIN
B)SUM
C)AVERAGE
D)MAX

Question 19

To start a new line in a cell, press the _____ keys.

A)CTRL+ENTER
B)TAB+ENTER
C)ALT+ENTER
D)SHIFT+ENTER

Question 20

Which of the following calculations multiplies 23 by 0.01?

A)=23%
B)=23
C)=23+.01
D)=24-.01

Question 21

Which of the following is the path to the Spelling button?

A)(Home tab | Proofing group)
B)(Proofing tab | Spelling group)
C)(Review tab | Proofing group)
D)(Review tab | Checking group)

Question 22

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

A)scheme
B)gallery
C)theme
D)style

Question 23

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign.

A)fixed
B)formatted
C)floating
D)none of the above

Question 24

You can open the Format Cells dialog box by pressing the _____ keys.

A)SHIFT+TAB
B)CTRL+1
C)ALT+1
D)SHIFT+F1

Question 25

You can use the _____ to check which cells are referenced in the formula assigned to the active cell.

A)Formula Finder
B)Range Finder
C)Calculation Finder
D)Function Finder

Question 26

To paste copied cell contents, you can press the _____ keys.

A)CTRL+C
B)CTRL+P
C)CTRL+V
D)CTRL+X

Question 27

To print a range of cells in the active worksheet, click _____ in the Settings area in the Print gallery, as shown in the accompanying figure.

A)Print Active Sheets
B)Print Selection
C)Print Entire Workbook
D)none of the above

Question 28

Clicking the _____ opens the Insert Function dialog box shown in the accompanying figure.

A)Insert Function box on the formula bar
B)Function dialog box launcher (Home tab | Calculations group)
C)Function button (Home tab | Function group)
D)Functions & Formulas button on the status bar

Question 29

When you decrease the row height to _____, the row is hidden.

A)0
B)1
C)2
D)3

Question 30

Which of the following is the path to the Conditional Formatting button?

A)(Home tab | Editing group)
B)(Styles tab | Formatting group)
C)(Formatting tab | Styles group)
D)(Home tab | Styles group)

Question 31

The _____ function displays the highest value in a range.

A)MIN
B)SUM
C)MAX
D)AVERAGE

Question 32

To copy cell contents, you can select the cell and then press the _____ keys.

A)CTRL+V
B)CTRL+X
C)CTRL+B
D)CTRL+C

Question 33

You should _____ a function name in the Formula AutoComplete list to select the function.

A)double-click
B)click
C)right-click
D)none of the above

Question 34

Which of the following is the path to the Sum button?

A)(Editing tab | Home group)
B)(Home tab | Editing group)
C)(Home tab | Clipboard group)
D)(Calculation tab | Editing group)

Question 35

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

A)Normal
B)Page Layout
C)Page Break Preview
D)Full Screen

Question 36

The _____ function determines the lowest number in a range.

A)MAX
B)AVERAGE
C)SUM
D)MIN

Question 37

The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

A)Comma style format
B)Accounting number format
C)Percent style format
D)Currency style format

Question 38

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.

A)8)43
B)7)52
C)11.65
D)9)43

Question 39

Which of the following is the path to the Comma Style button?

A)(Home tab | Alignment group)
B)(Home tab | Font group)
C)(Home tab | Cells group)
D)(Home tab | Number group)

Question 40

The most popular background color is _____.

A)blue
B)white
C)red
D)yellow

Question 41

Modified Multiple Choice Which of the following is true of a function?

A)Takes a value or values
B)Performs a calculation
C)Returns a result to the cell
D)Contains arguments

Question 42

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Question 43

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Question 44

The Insert Options button lists formatting options.

Question 45

To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check.

Question 46

Moving from left to right, the first calculation in the order of operations is negation (-).

Question 47

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Question 48

Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.

Question 49

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Question 50

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Question 51

The arithmetic operator, ^, directs Excel to perform the division operation.

Question 52

Modified Multiple Choice Which of the following actions are provided by the Paste Options button?

A)Pastes an exact copy of what you copied including contents and formatting
B)Pastes synonyms or acronyms
C)Pastes just formulas
D)Pastes just formatting

Question 53

You can use the arrow keys to complete an entry in Point mode.

Question 54

The equal sign (=)precedes a formula.

Question 55

Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.

Question 56

Modified Multiple Choice Which of the following are valid formulas?

A)=3 ^ 4
B)=H3/H11
C)=11+9
D)=22-F15

Question 57

Point mode allows you to select cells for use in a formula by using the keyboard.

Question 58

Modified Multiple Choice Using the Excel spell checker, you can _____.

A)check the spelling in a single cell
B)check the spelling of words in a selected range
C)add words to the dictionary
D)add words to the AutoCorrect list

Question 59

Pressing the F9 key instructs Excel to recalculate all formulas.

Question 60

Modified Multiple Choice Which of the following are considered guidelines to use when making decisions about creating a new workbook?

A)Determine the necessary formulas and functions needed
B)Identify how to format various elements of the worksheet
C)Specify how the hard copy of the worksheet should appear
D)Enter data into the worksheets and format the cells

Question 61

If you have a long text entry, such as a paragraph, you can instruct Excel to _________________________ text in the cell.

Question 62

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.

Question 63

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

Question 64

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Question 65

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.

Question 66

In the order of operations, the last operation Excel performs is _________________________.

Question 67

Typing =av in a cell displays the _________________________.

Question 68

Worksheet _________________________ typically contain items analogous to items in a list.

Question 69

The / arithmetic operator indicates _________________________.

Question 70

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as _________________________.

Question 71

You can learn more about Excel's functions with options in the _________________________ dialog box.

Question 72

One of the reasons Excel is such a valuable tool is that you can assign a(n)_________________________ to a cell, and Excel will calculate the result.

Question 73

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.

Question 74

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Question 75

You cannot format an entire column at once.

Question 76

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Question 77

The function, or _________________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

Question 78

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

Question 79

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.

Question 80

A formula in a cell that contains a reference back to itself is called a(n)_________________________.