Match between columns Premises: A feature that finds the cells that are used in the function.

The Answer of Trace Error and Goal Seek and Trace is...

Exam 2: Microsoft Excel Basics

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. How does Ron go about renaming his worksheet?

(Multiple Choice)

4.8/5

(76)

Question 41

When you filter data, the data you want to show is displayed and the rest of the data is hidden.

(True/False)

4.8/5

(85)

Question 42

A keyboard shortcut is a shorthand way to write an equation that performs a calculation.

(True/False)

4.7/5

(77)

Question 43

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.

(Multiple Choice)

4.7/5

(78)

Question 44

Case EX 9-2 Matt runs a local cat shelter. He uses an Excel workbook to store information about the various cats residing at the shelter. Right now, Matt's workbook uses very basic formatting. To create a formatted table from the range of cells, he needs to use the ____ gallery.

(Multiple Choice)

4.7/5

(86)

Question 45

The Protect Sheet button is found on the ____ tab on the Ribbon.

(Multiple Choice)

4.7/5

(82)

Question 46

To create a drop-down list, it is easier if you first create a(n) ____________________ of cells that has the selections that should appear in the list.

(Short Answer)

4.7/5

(77)

Question 47

The ____ function is used to total only cells that meet a certain condition.

(Multiple Choice)

4.9/5

(80)

Question 48

In Excel, you can hide comments and columns or rows of data.

(True/False)

4.8/5

(84)

Question 49

____ refers to taking Excel data from a workbook and sending it to another program or to the Web.

(Multiple Choice)

4.8/5

(82)

Question 50

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

Premises:

A feature that finds the cells that are used in the function.

Responses:

Trace Error

Goal Seek

Trace Dependents

Correct Answer:

Verified

A feature that finds the cells that are used in the function.

(Matching)

4.9/5

(88)

Question 51

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

Premises:

Usually plots values, such as dollar amounts, along the left side of the chart.

Responses:

vertical axis

PivotTable

horizontal axis

Correct Answer:

Verified

Usually plots values, such as dollar amounts, along the left side of the chart.

(Matching)

4.9/5

(77)

Question 52

You can remove the borders from a selected cell by clicking ____ in the border style menu.

(Multiple Choice)

4.9/5

(67)

Question 53

When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key.

(Multiple Choice)

4.8/5

(70)

Question 54

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

Premises:

A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.

Responses:

Subtotal

Watch Window

Data Validation

Correct Answer:

Verified

A feature that enables you to view data from one worksheet while you enter or view data in another worksheet.

(Matching)

4.8/5

(78)

Question 55

____ graphics enhance worksheets by providing a visual representation of information and ideas.

(Multiple Choice)

4.9/5

(79)

Question 56

To count the number of cells without content, you will use the ____ function.

(Multiple Choice)

4.7/5

(78)

Question 57

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

(Short Answer)

4.9/5

(74)

Question 58

When Excel starts, the program window displays a blank workbook titled Book1 , which includes ____ blank worksheets.

(Multiple Choice)

4.9/5

(89)

Question 59

The Assign Macro dialog box allows you to select the macro you want assigned to a button.

(True/False)

4.8/5

(88)

Question 60

Showing 41 - 60 of 850

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. How does Ron go about renaming his worksheet?

When you filter data, the data you want to show is displayed and the rest of the data is hidden.

A keyboard shortcut is a shorthand way to write an equation that performs a calculation.

To open the Research task pane, click the Review tab on the Ribbon, and then, in the ____ group, click the Research button.

Case EX 9-2 Matt runs a local cat shelter. He uses an Excel workbook to store information about the various cats residing at the shelter. Right now, Matt's workbook uses very basic formatting. To create a formatted table from the range of cells, he needs to use the ____ gallery.

The Protect Sheet button is found on the ____ tab on the Ribbon.

To create a drop-down list, it is easier if you first create a(n) ____________________ of cells that has the selections that should appear in the list.

The ____ function is used to total only cells that meet a certain condition.

In Excel, you can hide comments and columns or rows of data.

____ refers to taking Excel data from a workbook and sending it to another program or to the Web.

You can remove the borders from a selected cell by clicking ____ in the border style menu.

When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key.

____ graphics enhance worksheets by providing a visual representation of information and ideas.

To count the number of cells without content, you will use the ____ function.

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

When Excel starts, the program window displays a blank workbook titled Book1 , which includes ____ blank worksheets.

The Assign Macro dialog box allows you to select the macro you want assigned to a button.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters