Question 1

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

Accepted Answer

If a formula contains two or more operat

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

There are times when you want Excel to r

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

SUM and AVERAGE are examples of ____.

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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?

Accepted Answer

To enter data in multiple cells in a col

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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.

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

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

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

SUM and AVERAGE are examples of ____.

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

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

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

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

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

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

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

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

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

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

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

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit A: Getting Started With Access 2007

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit C: Formatting a Worksheet

Excel 2007 Unit D: Working With Charts

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit B: Integrating Word, Excel, and Access

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters