Exam 5: Working With Multiple Worksheets and Workbooks

Explore all topics

If multiple sheets are selected and you want to select the active sheet,if you are using a mouse,hold down the CTRL key and then click the sheet tab of the active sheet._________________________

(True/False)

4.8/5

(28)

Question 61

A ____ is a reference to a cell or range of cells in another workbook.

(Multiple Choice)

4.8/5

(31)

Question 62

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

(True/False)

4.8/5

(29)

Question 63

You should hold down the ____ key to select the nonadjacent cells.

(Multiple Choice)

4.9/5

(45)

Question 64

A code is a group of format specifications that are assigned a name.

(True/False)

4.8/5

(38)

Question 65

You can display the ____ tab to specify page setup options.

(Multiple Choice)

4.9/5

(33)

Question 66

Which of the following format codes insures that Excel will display a decimal point in the number?

(Multiple Choice)

4.8/5

(32)

Question 67

To select adjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

(Multiple Choice)

4.9/5

(29)

Question 68

Showing 61 - 68 of 68

If multiple sheets are selected and you want to select the active sheet,if you are using a mouse,hold down the CTRL key and then click the sheet tab of the active sheet._________________________

A ____ is a reference to a cell or range of cells in another workbook.

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

You should hold down the ____ key to select the nonadjacent cells.

A code is a group of format specifications that are assigned a name.

You can display the ____ tab to specify page setup options.

Which of the following format codes insures that Excel will display a decimal point in the number?

To select adjacent sheets,select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

Financial Functions, Data Tables, and Amortization Schedules

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