Deck 4: Excel: Formulas, Functions, and Formatting

Question 1

Which of the following calculations multiplies 23 by 0.01?

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

Answer 1

A

Question 2

All of the following are automatic features that Excel displays as option buttons in a workbook while you are working on it EXCEPT ____.

A)AutoCorrect
B)Auto Fill
C)error checking
D)entry validation

Answer 2

D

Question 3

Which of the following is the toolbar that contains the Copy and Paste buttons?

A)Copy and Paste
B)Editing
C)Standard
D)Clipboard

Answer 3

C

Question 4

The ____ Options button lists formatting options following an insertion of cells, rows, or columns.

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

Question 5

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 6

All of the following are valid Excel arithmetic operators EXCEPT ____.

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

Question 7

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

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

Question 8

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 9

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

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

Question 10

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

A)CONTROL-RETURN
B)TAB-RETURN
C)CONTROL-OPTION-RETURN
D)SHIFT-RETURN

Question 11

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 12

You can click the ____ button to determine how moved items should appear, for example.

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

Question 13

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
D)edit cell contents directly in the cell

Question 14

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 15

What is the value when Excel calculate the average of three cells with values of 10, blank, and 8?

A)6
B)9
C)10
D)none; Excel cannot calculate an average in a range that includes a blank cell

Question 16

By default, Excel for Mac uses a ____ year value.

A)two-digit
B)four-digit
C)hexadecimal
D)none; there is no default value for years to an Excel for Mac.

Question 17

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

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

Question 18

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 19

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 20

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

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

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

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

A)COMMAND-V
B)COMMAND-X
C)COMMAND-B
D)COMMAND-C

Question 23

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

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

Question 24

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

A)COMMAND-C
B)COMMAND-P
C)COMMAND-V
D)COMMAND-X

Question 25

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

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

Question 26

Clicking the Formula Builder button in the ____ opens the Formula Builder shown in the accompanying figure.

A)formula bar
B)Calculations group
C)Home tab
D)status bar

Question 27

____ 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 28

In the accompanying figure, the value $19.33 in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

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

Question 29

The ____ function displays the highest value in a range.

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

Question 30

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 31

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 32

The ____ function determines the lowest number in a range.

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

Question 33

Which of the following is not connoted by the color blue?

A)intelligence
B)serenity
C)reflection
D)proficiency

Question 34

In the accompanying figure, the topmost numerical value in the column labeled Hourly Pay Rate is formatted with a ____ dollar sign.

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

Question 35

The most popular background color is ____.

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

Question 36

To print a range of cells in the active worksheet, click ____ in the Print What area in the Print dialog.

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

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

The ____ style assigned using the Format Cells dialog uses a floating dollar sign that appears immediately to the left of the first digit.

A)Accounting
B)Conditional
C)Normal
D)Currency

Question 39

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

A)7
B)8
C)9
D)10

Question 40

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter button or press the RETURN key.

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

Question 41

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

Question 42

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

Question 43

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 44

Pressing the COMMAND-= keys instructs Excel to recalculate all formulas.

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

The AutoSum pop-up menu allows you to enter one of five often-used functions easily into a cell.

Question 47

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

Question 48

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

Question 49

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

Question 50

The equal sign (=)precedes a formula.

Question 51

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

Question 52

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 53

Modified Multiple Choice Which of the following are valid formulas?

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

Question 54

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 55

The Insert Options button lists formatting options.

Question 56

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

Question 57

The MAX function can only be entered using the Formula Builder in the formula bar.

Question 58

Clicking the Insert Function button opens the Formula Builder window, as shown in the accompanying figure.

Question 59

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 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

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 62

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

Question 63

Typing =av in a cell displays the ____________________.

Question 64

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 65

You cannot format an entire column at once.

Question 66

You can learn more about Excel's functions with options in the ____________________.

Question 67

Cooler colors (red and orange)tend to pull away from the reader.

Question 68

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

Question 69

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

Question 70

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 71

You change the ____________________ when you cannot see clearly the content on which you are working.

Question 72

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 73

The / arithmetic operator indicates ____________________.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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