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

Explore all topics

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

(Short Answer)

4.8/5

(82)

Question 61

Error messages begin with the _____ symbol.

(Multiple Choice)

4.9/5

(82)

Question 62

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

(Multiple Choice)

4.7/5

(73)

Question 63

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

(Short Answer)

4.9/5

(74)

Question 64

The path to the Logical button is (FORMULAS tab | Function Library group).

(True/False)

4.9/5

(97)

Question 65

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

(Multiple Choice)

4.9/5

(68)

Question 66

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

(Multiple Choice)

4.9/5

(73)

Question 67

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

(Short Answer)

4.9/5

(92)

Question 68

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

(True/False)

4.8/5

(82)

Question 69

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

(Multiple Choice)

4.8/5

(79)

Question 70

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

(Multiple Choice)

4.9/5

(79)

Question 71

Showing 61 - 71 of 71

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

Error messages begin with the _____ symbol.

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

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

The path to the Logical button is (FORMULAS tab | Function Library group).

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

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

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

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

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

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

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

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

Error messages begin with the _____ symbol.​

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

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

The path to the Logical button is (FORMULAS tab | Function Library group).

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

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

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

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

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

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

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

Error messages begin with the _____ symbol.