Question 1

The incorrect use of copying,deleting,inserting,and moving ranges of cells has the potential to render a worksheet useless.

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

Accepted Answer

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

Question 3

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Accepted Answer

A)  section 
B)  sparkline 
C)  special 
D)  sparkle 
A)  section 
B)  sparkline 
C)  special 
D)  sparkle

Question 4

Charts can either be embedded in a worksheet or placed in a separate ____.

Accepted Answer

A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range 
A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range

Question 5

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

Accepted Answer

Question 6

When you magnify a worksheet,Excel enlarges the view of the characters on the screen and displays more rows and columns.

Accepted Answer

A) True 
 B)False

Question 7

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

Accepted Answer

The answer of When you change a value on which...

Question 8

When working with a large worksheet,you can split the window into ____ panes.

Accepted Answer

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

Question 9

Which of the following is the path to the Insert Cells arrow?

Accepted Answer

Question 10

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 11

AND,OR,and NOT are called ____________________ operators.

Accepted Answer

The answer of AND,OR,and NOT are called ____________________ operators....

Question 12

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

Accepted Answer

A)  45 
B)  90 
C)  0 
D)  125 
A)  45 
B)  90 
C)  0 
D)  125

Question 13

Cell references in a formula are called ____.

Accepted Answer

A)  assumptions 
B)  comments 
C)  numbers 
D)  content 
A)  assumptions 
B)  comments 
C)  numbers 
D)  content

Question 14

Which comparison operator means "not equal to"?

Accepted Answer

A)   
C)   
A)   
C)

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell that uses a number incorrectly.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 18

Error messages begin with the ____ symbol.

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

The incorrect use of copying,deleting,inserting,and moving ranges of cells has the potential to render a worksheet useless.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Charts can either be embedded in a worksheet or placed in a separate ____.

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

When you magnify a worksheet,Excel enlarges the view of the characters on the screen and displays more rows and columns.

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

When working with a large worksheet,you can split the window into ____ panes.

Which of the following is the path to the Insert Cells arrow?

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

AND,OR,and NOT are called ____________________ operators.

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

Cell references in a formula are called ____.

Which comparison operator means "not equal to"?

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

Error messages begin with the ____ symbol.

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

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

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

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

The incorrect use of copying,deleting,inserting,and moving ranges of cells has the potential to render a worksheet useless.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

A(n)____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Charts can either be embedded in a worksheet or placed in a separate ____.

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

When you magnify a worksheet,Excel enlarges the view of the characters on the screen and displays more rows and columns.

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

When working with a large worksheet,you can split the window into ____ panes.

Which of the following is the path to the Insert Cells arrow?

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

AND,OR,and NOT are called ____________________ operators.

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

Cell references in a formula are called ____.

Which comparison operator means "not equal to"?

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell that uses a number incorrectly.

Error messages begin with the ____ symbol.

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

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

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters