Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

An Excel template has the extension ____.

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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?

Accepted Answer

For Excel to calculate the Total Erosion

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of A(n) ____________________ formula is one that uses...

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

You can copy or move cells and ranges (o

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

As shown in the figure above, item 3 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 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of   As shown in the figure...

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The AutoComplete feature makes it easier

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

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

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

An Excel template has the extension ____.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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