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

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

(True/False)

5.0/5

(78)

Question 41

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

(Multiple Choice)

4.9/5

(80)

Question 42

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

(Multiple Choice)

5.0/5

(73)

Question 43

The <= comparison operator means less than or equal to.

(True/False)

4.9/5

(83)

Question 44

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

(Multiple Choice)

5.0/5

(87)

Question 45

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

(True/False)

4.9/5

(92)

Question 46

A sensitivity analysis is another name for a(n)____________________ analysis.

(Short Answer)

4.9/5

(72)

Question 47

You can select nonadjacent ranges using the SHIFT key.

(True/False)

4.9/5

(77)

Question 48

The underline format underlines the entire cell,not just the characters in the cell.

(True/False)

4.8/5

(85)

Question 49

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

(Short Answer)

4.8/5

(80)

Question 50

Cell references in a formula are called ____.

(Multiple Choice)

4.8/5

(77)

Question 51

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

(True/False)

4.8/5

(76)

Question 52

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

(True/False)

4.7/5

(83)

Question 53

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

(Multiple Choice)

4.9/5

(79)

Question 54

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

(True/False)

4.8/5

(70)

Question 55

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

(True/False)

4.7/5

(65)

Question 56

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

(Multiple Choice)

4.9/5

(81)

Question 57

Which of the following patterns extends the fill series to 525,475,425?

(Multiple Choice)

4.8/5

(91)

Question 58

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

(Short Answer)

4.9/5

(78)

Question 59

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

(Multiple Choice)

4.8/5

(76)

Question 60

Showing 41 - 60 of 71

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

The <= comparison operator means less than or equal to.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

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

A sensitivity analysis is another name for a(n)____________________ analysis.

You can select nonadjacent ranges using the SHIFT key.

The underline format underlines the entire cell,not just the characters in the cell.

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

Cell references in a formula are called ____.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

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

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

Which of the following patterns extends the fill series to 525,475,425?

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

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

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

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window._________________________

A(n)____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

The <= comparison operator means less than or equal to.

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

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

A sensitivity analysis is another name for a(n)____________________ analysis.

You can select nonadjacent ranges using the SHIFT key.

The underline format underlines the entire cell,not just the characters in the cell.

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

Cell references in a formula are called ____.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

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

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

If formulas located in other cells reference cells in a deleted row or column,Excel does not adjust these cell references but instead displays the ____ error message.

Which of the following patterns extends the fill series to 525,475,425?​

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

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

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

Which of the following patterns extends the fill series to 525,475,425?