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

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?

Free

(Essay)

4.8/5

(30)

Question 1

Correct Answer:

Verified

In Excel, formulas automatically update the value of a cell as values of other cells change. Therefore, the only changes you need to make to the spreadsheet are to correct the erosion totals per month. After pressing enter, the value in the total erosion column will update accordingly to adjust all totals to the correct amount. This is one of the major advantages of using formulas in Excel.

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

Free

(Multiple Choice)

4.8/5

(39)

Question 2

Correct Answer:

Verified

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

Free

(Multiple Choice)

4.8/5

(40)

Question 3

Correct Answer:

Verified

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.

(Multiple Choice)

5.0/5

(29)

Question 4

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

(True/False)

4.7/5

(37)

Question 5

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

(True/False)

4.9/5

(35)

Question 6

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

(Short Answer)

4.8/5

(31)

Question 7

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

(True/False)

4.7/5

(35)

Question 8

Absolute cell references are the default in Excel.

(True/False)

4.8/5

(43)

Question 9

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

(Multiple Choice)

4.8/5

(34)

Question 10

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

(Multiple Choice)

4.7/5

(33)

Question 11

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

(Multiple Choice)

4.8/5

(32)

Question 12

Describe the various Auto Fill options.

(Essay)

4.9/5

(31)

Question 13

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?

(Essay)

4.9/5

(38)

Question 14

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

(Multiple Choice)

4.9/5

(37)

Question 15

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

(Multiple Choice)

4.9/5

(40)

Question 16

Identify the letter of the choice that best matches the phrase or definition.

A predesigned workbook file intended to save time when you create common documents such as balance sheets, expense statements, loan amortizations, sales invoices, or timecards.

Office Clipboard

Changes based on the location when you copy the formula.

relative cell reference

A temporary storage area that holds the selections you copy or cut.

template

Correct Answer:

Verified

A predesigned workbook file intended to save time when you create common documents such as balance sheets, expense statements, loan amortizations, sales invoices, or timecards.

Changes based on the location when you copy the formula.

A temporary storage area that holds the selections you copy or cut.

Does not change when you copy the formula.

A predefined worksheet formula that enables you to perform complex calculations easily.

(Matching)

4.9/5

(36)

Question 17

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

(Short Answer)

5.0/5

(30)

Question 18

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

(Multiple Choice)

4.8/5

(42)

Question 19

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

(Short Answer)

4.7/5

(38)

Question 20

Showing 1 - 20 of 66

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

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

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

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.

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

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

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

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

Absolute cell references are the default in Excel.

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

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

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

Describe the various Auto Fill options.

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

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

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

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

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

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