Question 1

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

Accepted Answer

(Answers may vary):
- Some workbooks inc

Question 2

In a PMT function, the argument indicated by fv refers to ____.

Accepted Answer

A)  future value 
B)  past value 
C)  favorite value 
D)  fixed value 
A)  future value 
B)  past value 
C)  favorite value 
D)  fixed value

Question 3

Each line of data in a line chart is a(n) ____.

Accepted Answer

A)  data marker 
B)  data series 
C)  data label 
D)  data axis 
A)  data marker 
B)  data series 
C)  data label 
D)  data axis

Question 4

When using the Arrange Windows dialog box, the ____ layout is NOT an option.

Accepted Answer

A)  Tiled 
B)  Vertical 
C)  Cascade 
D)  Split 
A)  Tiled 
B)  Vertical 
C)  Cascade 
D)  Split

Question 5

The ____ function can be used to count, sum, or average filtered data.

Accepted Answer

A)  Calc 
B)  Subtotal 
C)  SUM 
D)  COUNT 
A)  Calc 
B)  Subtotal 
C)  SUM 
D)  COUNT

Question 6

Match between columns
                        Premises: The file used to store worksheets.

Accepted Answer

The Answer of Spreadsheet and Cell reference and Worksheet and is...

Question 7

When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.

Accepted Answer

A)  Drawing tab 
B)  Status bar 
C)  Side bar 
D)  Ribbon 
A)  Drawing tab 
B)  Status bar 
C)  Side bar 
D)  Ribbon

Question 8

Figure EX 13-1   In Figure EX 13-1 above, item 2 points to Amount, which is the ____.

Accepted Answer

A)  function text 
B)  named range 
C)  condition 
D)  row name 
A)  function text 
B)  named range 
C)  condition 
D)  row name

Question 9

If you want to specify a precise column width, use the Column Width ____.

Accepted Answer

A)  wizard 
B)  task pane 
C)  status bar 
D)  dialog box 
A)  wizard 
B)  task pane 
C)  status bar 
D)  dialog box

Question 10

Match between columns
                        Premises: A security feature that you add to a workbook file so that someone else can sign, or verify, the information.

Accepted Answer

The Answer of delimited and Access and signature line and is...

Question 11

You can switch between banded rows and banded columns using the ____ tab.

Accepted Answer

A)  Page Layout 
B)  Data 
C)  Review 
D)  Table Tools Design 
A)  Page Layout 
B)  Data 
C)  Review 
D)  Table Tools Design

Question 12

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

Accepted Answer

A) True 
 B)False

Question 13

The Goal Seek feature is referred to as a(n) "____________________" analysis tool.

Accepted Answer

The answer of The Goal Seek feature is referred to...

Question 14

Match between columns
                        Premises: A simple way of recording the actions necessary to complete a certain task.

Accepted Answer

The Answer of code and Visual Basic for Applications and is...

Question 15

After you click the Trace Dependents or Trace Precedents buttons, you can remove the tracer arrows by clicking the Delete Arrows button in the Formula Auditing group.

Accepted Answer

A) True 
 B)False

Question 16

Figure EX 17-1   Item 1 in Figure EX 17-1 above points to the ____.

Accepted Answer

A)  document properties 
B)  signature line 
C)  footer line 
D)  sign checker 
A)  document properties 
B)  signature line 
C)  footer line 
D)  sign checker

Question 17

To count cells with text, you use the ____ function.

Accepted Answer

A)  COUNTA 
B)  COUNT 
C)  SUMIF 
D)  VLOOKUP 
A)  COUNTA 
B)  COUNT 
C)  SUMIF 
D)  VLOOKUP

Question 18

Match between columns
                        Premises: Identifies the cell, and is formed by combining the cell's column letter and row number.

Accepted Answer

The Answer of Worksheet and Workbook and Spreadsheet and Cell is...

Question 19

Design view is helpful when you prepare a worksheet for printing.

Accepted Answer

A) True 
 B)False

Question 20

The data that you consolidate in Excel needs to be in the exact location in each of the worksheets.

Accepted Answer

A) True 
 B)False

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

In a PMT function, the argument indicated by fv refers to ____.

Each line of data in a line chart is a(n) ____.

When using the Arrange Windows dialog box, the ____ layout is NOT an option.

The ____ function can be used to count, sum, or average filtered data.

When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.

Figure EX 13-1 In Figure EX 13-1 above, item 2 points to Amount, which is the ____.

If you want to specify a precise column width, use the Column Width ____.

You can switch between banded rows and banded columns using the ____ tab.

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

The Goal Seek feature is referred to as a(n) "____________________" analysis tool.

After you click the Trace Dependents or Trace Precedents buttons, you can remove the tracer arrows by clicking the Delete Arrows button in the Formula Auditing group.

Figure EX 17-1 Item 1 in Figure EX 17-1 above points to the ____.

To count cells with text, you use the ____ function.

Design view is helpful when you prepare a worksheet for printing.

The data that you consolidate in Excel needs to be in the exact location in each of the worksheets.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

In a PMT function, the argument indicated by fv refers to ____.

Each line of data in a line chart is a(n) ____.

When using the Arrange Windows dialog box, the ____ layout is NOT an option.

The ____ function can be used to count, sum, or average filtered data.

When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.

Figure EX 13-1 In Figure EX 13-1 above, item 2 points to Amount, which is the ____.

If you want to specify a precise column width, use the Column Width ____.

You can switch between banded rows and banded columns using the ____ tab.

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

The Goal Seek feature is referred to as a(n) "____________________" analysis tool.

After you click the Trace Dependents or Trace Precedents buttons, you can remove the tracer arrows by clicking the Delete Arrows button in the Formula Auditing group.

Figure EX 17-1 Item 1 in Figure EX 17-1 above points to the ____.

To count cells with text, you use the ____ function.

Design view is helpful when you prepare a worksheet for printing.

The data that you consolidate in Excel needs to be in the exact location in each of the worksheets.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters