Match between columns Premises: Adjusts to its new location when copied or moved.

The Answer of Operator and Mixed cell reference and Relative is...

Exam 2: Microsoft Excel Basics

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben wants to copy a formula that is the sum of five rows. He wants the formula to change as he copies it so that it shows the sum of five rows for each column. What type of cell reference should Ben use?

(Multiple Choice)

5.0/5

(35)

Question 121

A(n) legend can appear as numbers or text next to each data marker in the data series.

(True/False)

4.8/5

(41)

Question 122

You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.

(Multiple Choice)

4.9/5

(28)

Question 123

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Adjusts to its new location when copied or moved.

Responses:

Operator

Mixed cell reference

Relative cell reference

Correct Answer:

Verified

Adjusts to its new location when copied or moved.

(Matching)

4.9/5

(38)

Question 124

When you make changes to a shared workbook, Excel keeps track of the changes.

(True/False)

4.9/5

(33)

Question 125

Click the Ctrl+V keys to ____ the selected cells.

(Multiple Choice)

4.9/5

(36)

Question 126

The code word ____ indicates the start of a macro.

(Multiple Choice)

4.8/5

(34)

Question 127

A text function can be used to convert text in a cell to all uppercase or lowercase letters.

(True/False)

4.9/5

(36)

Question 128

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.

(Multiple Choice)

4.8/5

(41)

Question 129

Deleting does not permanently remove a worksheet and all its contents from the workbook.

(True/False)

4.7/5

(34)

Question 130

The default ____________________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

(Short Answer)

4.7/5

(37)

Question 131

You can create your own number format by selecting the ____ category in the Format Cells dialog box.

(Multiple Choice)

4.8/5

(39)

Question 132

As you format cells, ____ shows the results of the different formatting options you can choose.

(Multiple Choice)

4.8/5

(40)

Question 133

If you select the ____ feature, all data points on the sparklines will be highlighted.

(Multiple Choice)

4.9/5

(37)

Question 134

To find the total number of cells that have numeric data, you use the ____________________ function.

(Short Answer)

4.9/5

(27)

Question 135

The data that you choose to create a PivotTable needs to have ____.

(Multiple Choice)

4.9/5

(26)

Question 136

A chart sheet does not have worksheet cells and cannot contain data or formulas.

(True/False)

4.7/5

(40)

Question 137

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Highlights worksheet data by changing the look of cells that meet a specified condition.

Responses:

Object

Filtering

Sort

Correct Answer:

Verified

Highlights worksheet data by changing the look of cells that meet a specified condition.

(Matching)

4.9/5

(38)

Question 138

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

(Multiple Choice)

4.8/5

(28)

Question 139

By default, Excel is set to print pages in landscape orientation.

(True/False)

4.8/5

(33)

Question 140

Showing 121 - 140 of 850

A(n) legend can appear as numbers or text next to each data marker in the data series.

You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.

When you make changes to a shared workbook, Excel keeps track of the changes.

Click the Ctrl+V keys to ____ the selected cells.

The code word ____ indicates the start of a macro.

A text function can be used to convert text in a cell to all uppercase or lowercase letters.

If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.

Deleting does not permanently remove a worksheet and all its contents from the workbook.

The default ____________________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

You can create your own number format by selecting the ____ category in the Format Cells dialog box.

As you format cells, ____ shows the results of the different formatting options you can choose.

If you select the ____ feature, all data points on the sparklines will be highlighted.

To find the total number of cells that have numeric data, you use the ____________________ function.

The data that you choose to create a PivotTable needs to have ____.

A chart sheet does not have worksheet cells and cannot contain data or formulas.

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

By default, Excel is set to print pages in landscape orientation.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters