Deck 16: Excel 2007 Unit B: Working With Formulas and Functions

Question 1

In an Excel complex formula, addition and subtraction operators are calculated before multiplication and division operators.

Answer 1

False

Question 2

When you cut cells, the original data remains in the original location.

Answer 2

False

Question 3

You CANNOT insert a function as part of another formula.

Answer 3

False

Question 4

The order of precedence in Excel formulas can be changed by using ____.

A) quotation marks
B) parentheses
C) colons
D) question marks

Question 5

In the calculation =8+.98/3500*9-7, which operation is performed first?

A) Division
B) Multiplication
C) Addition
D) Subtraction

Question 6

Functions are organized into categories, such as Financial, Date & Time, and Statistical, based on their purpose.

Question 7

In the calculation =1200/23-600+75*45, which mathematical operation is performed first?

A) Subtraction
B) Multiplication
C) Division
D) Addition

Question 8

To enter a function into a cell, you can manually type the function, including its arguments, into the cell.

Question 9

You can click the AutoSum button list arrow to enter frequently used functions, such as Sum, Average, and Count.

Question 10

Absolute cell references are the default in Excel.

Question 11

When you click on a function in the AutoComplete list, a ScreenTip appears describing the selected function.

Question 12

Which of the following values would be considered a complex formula?

A) =B3+C9*D12
B) =B3
C) =B3+C9
D) =B3*D12

Question 13

The Paste Options button allows you to paste only specific elements of the copied selection if you wish.

Question 14

When pasting an item from the Clipboard into the worksheet, you only need to specify the upper-right cell of the range where you want to paste the selection.

Question 15

You can drag the fill handle in a cell to copy cells or to continue a series of data based on previous cells.

Question 16

The formula =(20-8)/6 equals ____.

A) 1.33
B) 2
C) 6
D) 18.67

Question 17

An Excel formula can include more than one operation; for example, multiplication and addition.

Question 18

With each press of the [F1] key, you cycle through all the possible combinations of relative, absolute, and mixed references.

Question 19

In an Excel formula containing more than one arithmetic operator, operations inside parentheses are calculated before any other operations.

Question 20

You can use the AutoSum button on the Ribbon to quickly insert the AVERAGE function.

Question 21

As shown in the figure above, the plus sign (+) in the cell pointed to by item 2 indicates ____.

A) a fill handle
B) the cell content being copied
C) dragging in progress
D) copying in progress

Question 22

As shown in the figure above, item 1 points to a(n) ____.

A) function
B) argument
C) field
D) variable

Question 23

As shown in the figure above, item 4 points to the ____.

A) Expand button
B) Minimize button
C) Insert Function button
D) Collapse button

Question 24

When you click the Insert Function button on the formula bar, a(n) ____ is inserted in the active cell and in the formula bar, and the Insert Function dialog box opens.

A) pound sign (#)
B) plus sign (+)
C) equal sign (=)
D) percent sign (%)

Question 25

As shown in the figure above, item 1 points to a(n) ____ formula.

A) absolute
B) relative
C) mixed
D) complex

Question 26

Clicking the ____ button on the Function Arguments dialog box minimizes the dialog box so you can select cells in the worksheet.

A) Select
B) Minimize
C) Expand
D) Collapse

Question 27

Clicking the ____ button on the Function Arguments dialog box restores the dialog box.

A) Select
B) Restore
C) Expand
D) Maximize

Question 28

As shown in the figure above, item 3 points to the ____.

A) Copy button
B) Paste button
C) Clipboard launcher
D) Collapse button

Question 29

As shown in the figure above, item 2 points to the ____.

A) Expand button
B) Minimize button
C) Insert Function button
D) Collapse button

Question 30

As shown in the figure above, item 2 points to the ____.

A) Copy button
B) Paste button
C) Clipboard launcher
D) Collapse button

Question 31

As shown in the figure above, item 1 points to the ____.

A) Copy button
B) Paste button
C) Clipboard launcher
D) Collapse button

Question 32

SUM and AVERAGE are examples of ____.

A) buttons
B) toggles
C) functions
D) arguments

Question 33

As shown in the figure above, item 2 points to the ____.

A) Mode indicator
B) Clipboard
C) ScreenTip
D) fill handle

Question 34

The information in the parentheses in =MAX(A1:F5) is an example of a(n) ____.

A) argument
B) function wizard
C) prefix
D) template

Question 35

When you copy a range, a moving border surrounds the selected range until you press ____ or copy an additional item to the Clipboard.

A) [Shift]
B) [Ctrl]
C) [Tab]
D) [Esc]

Question 36

In the calculation =8+.98/3500*9-7, which operation is performed second?

A) Division
B) Multiplication
C) Addition
D) Subtraction

Question 37

If you use a function alone, it always begins with the formula prefix ____.

A) * (asterisk)
B) # (pound sign)
C) = (equal sign)
D) $ (dollar sign)

Question 38

As shown in the figure above, item 3 points to a(n) ____.

A) function
B) argument
C) field
D) template

Question 39

A cell containing =SUM(D1:D4) is recognized as containing a(n) ____.

A) function
B) average
C) label
D) template

Question 40

As shown in the figure above, item 3 points to the ____.

A) cell being copied
B) new location of copied content
C) cell being dragged
D) cell on which the fill handle is used

Question 41

Describe the various Auto Fill options.

Question 42

A(n) ____________________ formula is one that uses more than one arithmetic operator.

Question 43

An Excel template has the extension ____.

A) .xml
B) .temp
C) .xltx
D) .xlsx

Question 44

What does the AutoComplete feature do? What advantages does this feature offer?

Question 45

You can use the Copy and Paste commands or the ____________________ to copy formulas.

Question 46

As shown in the figure above, item 2 points to the ____.

A) Auto Fill Options button
B) fill handle
C) Paste Options button
D) Clipboard launcher

Question 47

In Excel, when you insert or delete cells from a spreadsheet, ____.

A) Excel automatically adjusts cell references to reflect new locations
B) you have to manually adjust all formulas
C) formulas will appear as errors
D) None of the above. You cannot insert or delete cells from a spreadsheet.

Question 48

The formula =SUM(A4:A13) contains ____ cell references.

A) absolute
B) relative
C) mixed
D) complex

Question 49

$A$1 is an example of a(n) ____.

A) mixed formula
B) absolute cell reference
C) calculation
D) relative cell reference

Question 50

As shown in the figure above, item 1 points to the ____.

A) Auto Fill Options button
B) fill handle
C) Paste Options button
D) Clipboard launcher

Question 51

Cell referencing that combines elements of both absolute and relative referencing is called a(n) ____________________ reference.

Question 52

Explain the order of precedence that Excel uses with complex formulas.

Question 53

You can create an absolute cell reference by selecting a cell address on the formula bar and then pressing ____.

A) [F2]
B) [F3]
C) [F4]
D) [F5]

Question 54

What are some of the different ways of copying or moving cells and ranges from one location to another?

Question 55

The ____________________ feature makes it easier to enter function names by suggesting functions depending on the first letters you type.

Question 56

Discuss why you might want to use an absolute reference in a formula.

Question 57

In the reference $C14, ____.

A) both the column letter and the row number would be updated relative to their location
B) the column letter would not change, but the row number would be updated relative to its location
C) the column letter would be updated relative to its location, but the row number would not change
D) neither the column letter nor the row number would change

Question 58

To insert cells, click the Insert button list arrow in the Cells group on the ____ tab, and then click Insert Cells.

A) Home
B) Page Layout
C) Data
D) View

Question 59

You create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

A) # (pound sign)
B) = (equal sign)
C) / (slash)
D) $ (dollar sign)

Question 60

As shown in the figure above, item 4 points to an item in the ____________________.

Question 62

You are a scientist studying beach erosion at your local beach. You have created a simple worksheet to calculate the yearly erosion rate and to perform some what-if analysis. The spreadsheet that you have so far is given below. Each month, you will enter the erosion per month (in centimeters). You then want Excel to automatically calculate Total Erosion (of all months) after you enter the erosion for each month. What would you need to enter to accomplish this, and what would the formula read in cell C15?

Question 63

You are planning to work as a restaurant host/hostess for the next 6 months. During this time you plan to save 15 percent of your projected earnings each month. You want to use a worksheet to calculate how your existing savings will grow each month. So far, you have created the following worksheet. Each month, you plan to save 15%. How could you efficiently enter this data without manually typing 15 into each individual cell from January through June?

Question 64

You are planning to work as a restaurant host/hostess for the next 6 months. During this time you plan to save 15 percent of your projected earnings each month. You want to use a worksheet to calculate how your existing savings will grow each month. So far, you have created the following worksheet. You want to use Excel to track your earnings throughout the six months you will work. Each month, you would like to know your total savings for all the months you have worked. Using the above figure as a reference, what formula would result in tracking total earnings? Describe the formula you would use for January and February, and explain how you would go about entering the data. (Assume column C reads 15% and column D has been automatically calculated to show earnings per month.)

Question 65

You are a scientist studying beach erosion at your local beach. You have created a simple worksheet to calculate the yearly erosion rate and to perform some what-if analysis. The spreadsheet that you have so far is given below. In June, you re reviewing your spreadsheet and notice that you ve made an error in March s and April s erosion per month. You used a formula to calculate the values for total erosion. What changes would you need to make to your spreadsheet so that all erosion figures and totals are correct?

Question 66

You are planning to work as a restaurant host/hostess for the next 6 months. During this time you plan to save 15 percent of your projected earnings each month. You want to use a worksheet to calculate how your existing savings will grow each month. So far, you have created the following worksheet. Once you ve entered your savings in percentage points in Column C, you want to calculate your savings per month. As you know, one of the benefits of Excel is using formulas to automatically calculate values. How would you calculate savings per month, and what formula would you enter to calculate your savings for each month from January through June?