Question 1

In a data table,the formula(s)you are analyzing must include a cell reference to the output cell.​

Accepted Answer

A) True 
 B)False

Question 2

You can delete a data table by selecting the data table and then ____.

Accepted Answer

A)  clicking the Delete command in the Clipboard group on the Home tab 
B)  pressing the DELETE key 
C)  clicking the DELETE DATA TABLE command on a shortcut menu 
D)  pressing the OVERTYPE key 
A)  clicking the Delete command in the Clipboard group on the Home tab 
B)  pressing the DELETE key 
C)  clicking the DELETE DATA TABLE command on a shortcut menu 
D)  pressing the OVERTYPE key

Question 3

Names are ____ to the workbook.

Accepted Answer

A)  national 
B)  international 
C)  global 
D)  inclusive 
A)  national 
B)  international 
C)  global 
D)  inclusive

Question 4

To select noncontiguous ranges,after selecting the first range,hold down the ____ key an drag through the additional ranges of cells to select them.

Accepted Answer

A)  ALT 
B)  F3 
C)  CTRL 
D)  F10 
A)  ALT 
B)  F3 
C)  CTRL 
D)  F10

Question 5

Which of the following is the path to the Borders button?

Accepted Answer

Question 6

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

Accepted Answer

A) True 
 B)False

Question 7

An alternative to a one-input data table is a three-input data table.

Accepted Answer

A) True 
 B)False

Question 8

Once you set a print area,Excel will continue to print the specified range,rather than the entire worksheet.

Accepted Answer

A) True 
 B)False

Question 9

You can add only a maximum of five conditional formats to a range.

Accepted Answer

A) True 
 B)False

In a data table,the formula(s)you are analyzing must include a cell reference to the output cell.

You can delete a data table by selecting the data table and then ____.

Names are ____ to the workbook.

To select noncontiguous ranges,after selecting the first range,hold down the ____ key an drag through the additional ranges of cells to select them.

Which of the following is the path to the Borders button?

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

An alternative to a one-input data table is a three-input data table.

Once you set a print area,Excel will continue to print the specified range,rather than the entire worksheet.

You can add only a maximum of five conditional formats to a range.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

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 4: Financial Functions, Data Tables, and Amortization Schedules

In a data table,the formula(s)you are analyzing must include a cell reference to the output cell.​

You can delete a data table by selecting the data table and then ____.

Names are ____ to the workbook.

To select noncontiguous ranges,after selecting the first range,hold down the ____ key an drag through the additional ranges of cells to select them.

Which of the following is the path to the Borders button?

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

An alternative to a one-input data table is a three-input data table.

Once you set a print area,Excel will continue to print the specified range,rather than the entire worksheet.

You can add only a maximum of five conditional formats to a range.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

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

In a data table,the formula(s)you are analyzing must include a cell reference to the output cell.