Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Accepted Answer

A) True 
 B)False

Question 5

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

Accepted Answer

The answer of Excel allows you to ____________________ the titles...

Question 6

You can press the ____ keys to open the Format Cells dialog box.

Accepted Answer

A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4 
A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4

Question 7

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 8

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 9

Which of the following is an extension of the fill pattern Sunday,Tuesday?

Accepted Answer

A)  Wednesday,Thursday,Saturday 
B)  Thursday,Saturday,Monday 
C)  Saturday,Sunday,Monday 
D)  Monday,Wednesday,Friday 
A)  Wednesday,Thursday,Saturday 
B)  Thursday,Saturday,Monday 
C)  Saturday,Sunday,Monday 
D)  Monday,Wednesday,Friday

Question 10

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

Accepted Answer

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

Question 11

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 12

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 13

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 14

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Accepted Answer

The answer of When the Paste Options button is visible,you...

Question 15

Which of the following is not a valid format symbol?

Accepted Answer

A)  semi-colon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  comma (,) 
A)  semi-colon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  comma (,)

Question 16

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 17

The path to the Format Painter button is ____.

Accepted Answer

Question 18

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.​

Accepted Answer

A)  ​Position 
B)  ​Orientation 
C)  ​Slope 
D)  ​Incline 
A)  ​Position 
B)  ​Orientation 
C)  ​Slope 
D)  ​Incline

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

The range of entries that identifies the major groups for a clustered column chart are called the category names.

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

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

You can press the ____ keys to open the Format Cells dialog box.

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.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

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

Which of the following formulas contains an absolute cell reference?

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

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

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Which of the following is not a valid format symbol?

Which of the following are formatting symbols?

The path to the Format Painter button is ____.

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

The arguments in an IF function are ____.

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

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

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

The range of entries that identifies the major groups for a clustered column chart are called the category names.

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

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

You can press the ____ keys to open the Format Cells dialog box.

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.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

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

Which of the following formulas contains an absolute cell reference?

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

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

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Which of the following is not a valid format symbol?

Which of the following are formatting symbols?

The path to the Format Painter button is ____.

A date stamp shows the date a workbook,report,or other document was created or the time period it represents.

The arguments in an IF function are ____.

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.​

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

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

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.