Question 1

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

Accepted Answer

The answer of  
-The type of chart shown in...

Question 2

Which of the following is the path to the Goal Seek button?

Accepted Answer

Question 3

Excel includes four types of sparkline charts: line,column,win/loss,and stock.

Accepted Answer

A) True 
 B)False

Question 4

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Accepted Answer

A) Click or tap 
B) Press or long-press 
C) Double-click or double-tap 
D) Triple-click or tap 
A) Click or tap 
B) Press or long-press 
C) Double-click or double-tap 
D) Triple-click or tap

Question 5

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

Accepted Answer

Fill Witho

Question 6

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Accepted Answer

The answer of A(n)____________________ cell reference instructs a paste operation...

Question 7

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) included 
B) other 
C) nested 
D) duplicate 
A) included 
B) other 
C) nested 
D) duplicate

Question 8

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

Accepted Answer

The answer of The ____________________ option on the Auto Fill...

Question 10

The path to the Format Painter button is ____.

Accepted Answer

Question 11

The NETWORKDAYS function checks a formula for correctness.

Accepted Answer

A) True 
 B)False

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.NOW function
f.#NAME?
b.Fill Formatting Only
g.Keep Source Formatting
c.goal seeking
h.Fill Series
d.what-if analysis
i.IF function
e.NUM!
j.absolute cell referencing
-Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 13

Which of the following formulas contains an absolute cell reference?

Accepted Answer

A) =$B4 
B) =B$4 
C) =$B$4 
D) =B4 
A) =$B4 
B) =B$4 
C) =$B$4 
D) =B4

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.NOW function
f.#NAME?
b.Fill Formatting Only
g.Keep Source Formatting
c.goal seeking
h.Fill Series
d.what-if analysis
i.IF function
e.NUM!
j.absolute cell referencing
-Indicates a cell is using a name Excel does not recognize.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 15

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Accepted Answer

A) logical 
B) constant 
C) consistent 
D) calculated 
A) logical 
B) constant 
C) consistent 
D) calculated

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.NOW function
f.#NAME?
b.Fill Formatting Only
g.Keep Source Formatting
c.goal seeking
h.Fill Series
d.what-if analysis
i.IF function
e.NUM!
j.absolute cell referencing
-Pastes the contents,format,and styles of the source area.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 17

Which of the following are formatting symbols?

Accepted Answer

A) Dollar sign ($) 
B) Comma (,) 
C) Pound sign (#) 
D) Percent sign (%) 
A) Dollar sign ($) 
B) Comma (,) 
C) Pound sign (#) 
D) Percent sign (%)

Question 18

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

Accepted Answer

A) True 
 B)False

Question 19

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Accepted Answer

SPARKLINE

Question 20

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Accepted Answer

A) ENTER 
B) ALT 
C) CTRL 
D) SHIFT 
A) ENTER 
B) ALT 
C) CTRL 
D) SHIFT

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

Which of the following is the path to the Goal Seek button?

Excel includes four types of sparkline charts: line,column,win/loss,and stock.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

The path to the Format Painter button is ____.

The NETWORKDAYS function checks a formula for correctness.

Which of the following formulas contains an absolute cell reference?

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Which of the following are formatting symbols?

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 9: Excel: Working With Large Worksheets, Charting, and What-If Analysis

-The type of chart shown in the accompanying figure is a(n)____________________ chart.

Which of the following is the path to the Goal Seek button?

Excel includes four types of sparkline charts: line,column,win/loss,and stock.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

The ____________________ option on the Auto Fill Options menu fills the destination area with the contents but without the formatting of the source area.

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

The path to the Format Painter button is ____.

The NETWORKDAYS function checks a formula for correctness.

Which of the following formulas contains an absolute cell reference?

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

Which of the following are formatting symbols?

When you rest the mouse pointer over a chart item,such as the legend,Excel displays a chart tip containing the name of the item.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters