Question 1

Error values and error indicators CANNOT appear in the same cell.

Accepted Answer

A) True 
 B)False

Question 2

A message that appears in a cell when a formula cannot perform the specified calculations is a(n) ________.

Accepted Answer

A)  error value 
B)  failure message 
C)  edit message 
D)  error indicator 
A)  error value 
B)  failure message 
C)  edit message 
D)  error indicator

Question 3

The range finder is used to verify which cells are used in a formula and to edit formulas.

Accepted Answer

A) True 
 B)False

Question 4

When used on a cell containing a number value, the Decrease Decimal button removes decimals from the displayed value and the underlying value.

Accepted Answer

A) True 
 B)False

Question 5

AutoFit is applied to a column by double-clicking on the right border of the column in the ________.

Accepted Answer

The answer of AutoFit is applied to a column by...

Question 6

When the mouse is placed in the column heading between the border of columns B and C and is dragged to the right, column B becomes narrower.

Accepted Answer

A) True 
 B)False

Question 7

Which is NOT a category in the Quick Analysis gallery?

Accepted Answer

A)  Formatting 
B)  Charts 
C)  AutoSum 
D)  Tables 
A)  Formatting 
B)  Charts 
C)  AutoSum 
D)  Tables

Question 8

The ________ outlines all the cells referenced in a formula.

Accepted Answer

A)  error value 
B)  range finder 
C)  error indicator 
D)  range detector 
A)  error value 
B)  range finder 
C)  error indicator 
D)  range detector

Question 9

When the fill handle is used to copy a cell that contains content that is part of a series, the AutoFill feature continues the series in the copy.

Accepted Answer

A) True 
 B)False

Question 10

A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart ________.

Accepted Answer

A)  caption 
B)  title 
C)  legend 
D)  category label 
A)  caption 
B)  title 
C)  legend 
D)  category label

Question 11

The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.

Accepted Answer

A)  chart border 
B)  gridline 
C)  category border 
D)  axis 
A)  chart border 
B)  gridline 
C)  category border 
D)  axis

Question 12

Select the description that best matches the chart type.
-Bar chart

Accepted Answer

A) Displays part-whole relationship 
B) Emphasizes magnitude of change over time 
C) Illustrates comparisons of individual items 
D) Illustrates change in data over time 
E) Illustrates trends over time 
A) Displays part-whole relationship 
B) Emphasizes magnitude of change over time 
C) Illustrates comparisons of individual items 
D) Illustrates change in data over time 
E) Illustrates trends over time

Question 13

The AutoFill feature does NOT work with statistical functions.

Accepted Answer

A) True 
 B)False

Question 14

When Print is clicked from the File tab, the right side of the Print pane is a ________.

Accepted Answer

A)  review of document properties 
B)  list of possible printers 
C)  preview of the page to be printed 
D)  list of Page Setup settings 
A)  review of document properties 
B)  list of possible printers 
C)  preview of the page to be printed 
D)  list of Page Setup settings

Question 15

SUM and AVERAGE are the only functions listed in the options displayed by the AutoSum arrow.

Accepted Answer

A) True 
 B)False

Question 16

Both long text entries and long numeric entries are truncated when the column they are in is too narrow or when there is content in the column to the right.

Accepted Answer

A) True 
 B)False

Question 17

Select the description that best matches the chart element.
-x-axis

Accepted Answer

A) Nonnumeric text that identifies data categories 
B) Axis that displays data identifiers 
C) Horizontal axis of chart 
D) Axis that displays the numeric data 
E) Vertical axis of chart 
A) Nonnumeric text that identifies data categories 
B) Axis that displays data identifiers 
C) Horizontal axis of chart 
D) Axis that displays the numeric data 
E) Vertical axis of chart

Question 18

The ________ indicates an absolute cell reference.

Accepted Answer

The answer of The ________ indicates an absolute cell reference....

Question 19

Using ________ can give text a banner-like appearance in a worksheet.

Accepted Answer

The answer of Using ________ can give text a banner-like...

Question 20

A formula that attempts to divide by zero displays both an error indicator and an error value.

Accepted Answer

A) True 
 B)False

Error values and error indicators CANNOT appear in the same cell.

A message that appears in a cell when a formula cannot perform the specified calculations is a(n) ________.

The range finder is used to verify which cells are used in a formula and to edit formulas.

When used on a cell containing a number value, the Decrease Decimal button removes decimals from the displayed value and the underlying value.

AutoFit is applied to a column by double-clicking on the right border of the column in the ________.

When the mouse is placed in the column heading between the border of columns B and C and is dragged to the right, column B becomes narrower.

Which is NOT a category in the Quick Analysis gallery?

The ________ outlines all the cells referenced in a formula.

When the fill handle is used to copy a cell that contains content that is part of a series, the AutoFill feature continues the series in the copy.

A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart ________.

The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.

Select the description that best matches the chart type. -Bar chart

The AutoFill feature does NOT work with statistical functions.

When Print is clicked from the File tab, the right side of the Print pane is a ________.

SUM and AVERAGE are the only functions listed in the options displayed by the AutoSum arrow.

Both long text entries and long numeric entries are truncated when the column they are in is too narrow or when there is content in the column to the right.

Select the description that best matches the chart element. -x-axis

The ________ indicates an absolute cell reference.

Using ________ can give text a banner-like appearance in a worksheet.

A formula that attempts to divide by zero displays both an error indicator and an error value.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters

Exam 8: Insert Summary Functions and Create Charts

Error values and error indicators CANNOT appear in the same cell.

A message that appears in a cell when a formula cannot perform the specified calculations is a(n) ________.

The range finder is used to verify which cells are used in a formula and to edit formulas.

When used on a cell containing a number value, the Decrease Decimal button removes decimals from the displayed value and the underlying value.

AutoFit is applied to a column by double-clicking on the right border of the column in the ________.

When the mouse is placed in the column heading between the border of columns B and C and is dragged to the right, column B becomes narrower.

Which is NOT a category in the Quick Analysis gallery?

The ________ outlines all the cells referenced in a formula.

When the fill handle is used to copy a cell that contains content that is part of a series, the AutoFill feature continues the series in the copy.

A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart ________.

The ________, the line that borders the chart plot border area, is used as a frame of reference for measurement.

Select the description that best matches the chart type. -Bar chart

The AutoFill feature does NOT work with statistical functions.

When Print is clicked from the File tab, the right side of the Print pane is a ________.

SUM and AVERAGE are the only functions listed in the options displayed by the AutoSum arrow.

Both long text entries and long numeric entries are truncated when the column they are in is too narrow or when there is content in the column to the right.

Select the description that best matches the chart element. -x-axis

The ________ indicates an absolute cell reference.

Using ________ can give text a banner-like appearance in a worksheet.

A formula that attempts to divide by zero displays both an error indicator and an error value.

Create Database Tables

Create Select Queries

Create Forms

Create Reports

Common Features of Office 2013

Getting Started With Computer Concepts

Create Workbooks With Excel 2013

Manage Multiple Worksheets

More Functions and Excel Tables

Browse With Internet Explorer

Getting Started With Powerpoint 2013

Format a Presentation

Enhance Presentations With Graphics

Present Data Using Tables, Charts, and Animation

Getting Started With Windows 8

Create Letters and Memos

Create Business Reports

Create Flyers

Create Newsletters and Mail Merge Documents

Filters