Question 1

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A) ##### 
B) &&&&& 
C) $$$$$ 
D) +++++ 
A) ##### 
B) &&&&& 
C) $$$$$ 
D) +++++ A

Question 2

The arguments in an IF function are ____.

Accepted Answer

A) logical_test 
B) value_if_true 
C) value_if_true_false 
D) value_if_false 
A) logical_test 
B) value_if_true 
C) value_if_true_false 
D) value_if_false A,B,D

Question 3

Panes created using the vertical split bar scroll together horizontally.________________________

Accepted Answer

A) True 
 B)False  True

Question 4

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
-Returns a number that corresponds to the system date and time beginning with December 31,1899.

Accepted Answer

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

Question 5

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

Accepted Answer

The answer of The ____________________ at the bottom of the...

Question 6

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
-Fills a destination area using the format of the source area;no content is copied.

Accepted Answer

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

Question 7

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
-Determines the value of a cell on which the formula depends.

Accepted Answer

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

Question 8

In a clustered column chart,the names of each column are part of the ____ series.

Accepted Answer

A) category 
B) data 
C) label 
D) legend 
A) category 
B) data 
C) label 
D) legend

Question 9

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

Accepted Answer

A) Alignment 
B) Left and Right 
C) Center 
D) Position 
A) Alignment 
B) Left and Right 
C) Center 
D) Position

Question 10

Error messages begin with the ____ symbol.

Accepted Answer

A) (?) 
B) (=) 
C) (!) 
D) (#) 
A) (?) 
B) (=) 
C) (!) 
D) (#)

Question 11

Using the mouse to move or copy cells is called ____.

Accepted Answer

A) drop and drag 
B) drag and drop 
C) drag and copy 
D) drag and paste 
A) drop and drag 
B) drag and drop 
C) drag and copy 
D) drag and paste

Question 12

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

Accepted Answer

A) two 
B) three 
C) four 
D) five 
A) two 
B) three 
C) four 
D) five

Question 13

You can click the Logical button (FORMULAS tab | Function Library group)and tap or click IFERROR to insert the IF function._________________________

Accepted Answer

The answer of You can click the Logical button (FORMULAS...

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 that uses a number incorrectly.

Accepted Answer

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

Question 15

Which of the following cell contents is extended to Qtr3,Qtr4,and Qtr1 by dragging the fill handle?

Accepted Answer

A) Quarter 1 
B) Qtr1 
C) Qtr2 
D) Quarter4 
A) Quarter 1 
B) Qtr1 
C) Qtr2 
D) Quarter4

Question 16

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

Accepted Answer

The answer of The ____________________ function is useful when you...

Question 18

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
-Keeps a cell reference constant when copying a formula or function.

Accepted Answer

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

Question 19

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

Accepted Answer

A) SYSDATE 
B) NOW 
C) DATETIME 
D) CURRENT 
A) SYSDATE 
B) NOW 
C) DATETIME 
D) CURRENT

Question 20

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

Accepted Answer

A) Wednesday 
B) Thursday 
C) Saturday 
D) Monday 
A) Wednesday 
B) Thursday 
C) Saturday 
D) Monday

____ refers to cells not wide enough to display the entire entry.

The arguments in an IF function are ____.

Panes created using the vertical split bar scroll together horizontally.________________________

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

In a clustered column chart,the names of each column are part of the ____ series.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

Error messages begin with the ____ symbol.

Using the mouse to move or copy cells is called ____.

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

You can click the Logical button (FORMULAS tab | Function Library group)and tap or click IFERROR to insert the IF function._________________________

Which of the following cell contents is extended to Qtr3,Qtr4,and Qtr1 by dragging the fill handle?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

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

____ refers to cells not wide enough to display the entire entry.

The arguments in an IF function are ____.

Panes created using the vertical split bar scroll together horizontally.________________________

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

In a clustered column chart,the names of each column are part of the ____ series.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

Error messages begin with the ____ symbol.

Using the mouse to move or copy cells is called ____.

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

You can click the Logical button (FORMULAS tab | Function Library group)and tap or click IFERROR to insert the IF function._________________________

Which of the following cell contents is extended to Qtr3,Qtr4,and Qtr1 by dragging the fill handle?

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

When assigned to a cell,the ____ function returns a number that corresponds to the system date and time beginning with December 31,1899.

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

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