Question 1

The ____________________ first offers a checklist of items it will inspect, and then offers you the ability to delete those items from the workbook.

Accepted Answer

The answer of The ____________________ first offers a checklist of...

Question 2

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

Accepted Answer

A) True 
 B)False

Question 3

You can change which reference books and research sites are available from the Research task pane by clicking the Research list link at the bottom of the task pane.

Accepted Answer

A) True 
 B)False

Question 4

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: A computerized spreadsheet.

Accepted Answer

The Answer of Cell reference and Workbook and Active worksheet is...

Question 6

A ____ is text that prints in the top margin of each page.

Accepted Answer

A)  header 
B)  footer 
C)  margin 
D)  marker 
A)  header 
B)  footer 
C)  margin 
D)  marker

Question 7

FIGURE EX 6-1   In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.

Accepted Answer

A)  Click the cell she wants to use for the hyperlink. On the Insert tab of the Ribbon, in the Links group, click the Hyperlink button. 
B)  Right-click the cell or object, and then click Hyperlink on the shortcut menu 
C)  either a. or b. 
D)  neither a. nor b. 
A)  Click the cell she wants to use for the hyperlink. On the Insert tab of the Ribbon, in the Links group, click the Hyperlink button. 
B)  Right-click the cell or object, and then click Hyperlink on the shortcut menu 
C)  either a. or b. 
D)  neither a. nor b.

Question 8

When you add levels of fields, ____ buttons appear in the PivotTable so that you can show or hide these levels.

Accepted Answer

A)  Levels 
B)  Show/Hide 
C)  Arrange 
D)  Outline 
A)  Levels 
B)  Show/Hide 
C)  Arrange 
D)  Outline

Question 9

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

Accepted Answer

A)  Format dialog box 
B)  Chart dialog box 
C)  Style dialog box 
D)  Layout dialog box 
A)  Format dialog box 
B)  Chart dialog box 
C)  Style dialog box 
D)  Layout dialog box

Question 10

On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells.

Accepted Answer

A)  Format 
B)  Worksheet 
C)  Workbook 
D)  Cells 
A)  Format 
B)  Worksheet 
C)  Workbook 
D)  Cells

Question 11

Match between columns
                        Premises: The location where the data will appear after it is transferred.

Accepted Answer

The Answer of Worksheet range and Active sheet and Source is...

Question 12

The formula =B5+C5 is an example of a multiplication operation.

Accepted Answer

A) True 
 B)False

Question 13

____ enables you to resize a worksheet to print on a specific number of pages.

Accepted Answer

A)  Maximizing 
B)  Scaling 
C)  Enlarging 
D)  Minimizing 
A)  Maximizing 
B)  Scaling 
C)  Enlarging 
D)  Minimizing

Question 14

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

Accepted Answer

A)  * (an asterisk) 
B)  (?)(a question mark) 
C)  ! (an exclamation point) 
D)  # (a pound sign) 
A)  * (an asterisk) 
B)  (?)(a question mark) 
C)  ! (an exclamation point) 
D)  # (a pound sign)

Question 15

In Excel, the chart data, called the record source , is stored in a range of cells in the worksheet.

Accepted Answer

A) True 
 B)False

Question 16

Case EX 3-2 Ben is preparing his worksheet to print and is making adjustments to the margin and print area. Ben had set a print area earlier and now he wants to print the entire worksheet. To clear the print area, Ben would choose the Page Layout tab in the Page Setup group, click the ____ button, and then click Clear Print Area.

Accepted Answer

A)  Print Range 
B)  Print Margins 
C)  Print Entire Page 
D)  Print Area 
A)  Print Range 
B)  Print Margins 
C)  Print Entire Page 
D)  Print Area

Question 17

The range of cells that you select to apply the validation rule is called the ____________________.

Accepted Answer

The answer of The range of cells that you select...

Question 18

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.

Accepted Answer

A)  Ctrl+? (question mark) 
B)  Ctrl+` (grave accent) 
C)  Ctrl+! (exclamation point) 
D)  Ctrl+* (asterisk) 
A)  Ctrl+? (question mark) 
B)  Ctrl+` (grave accent) 
C)  Ctrl+! (exclamation point) 
D)  Ctrl+* (asterisk)

Question 19

FIGURE EX 4-1   In Figure EX 4-1 above, number 1 is pointing to the ____ button.

Accepted Answer

A)  Show Now 
B)  Calculate Formulas 
C)  Calculate Now 
D)  Calculate Sheet 
A)  Show Now 
B)  Calculate Formulas 
C)  Calculate Now 
D)  Calculate Sheet

Question 20

Match between columns
                        Premises: The entire chart and all other chart elements.

Accepted Answer

The Answer of Chart sheet and Chart area and Chart is...

The ____________________ first offers a checklist of items it will inspect, and then offers you the ability to delete those items from the workbook.

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

You can change which reference books and research sites are available from the Research task pane by clicking the Research list link at the bottom of the task pane.

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

A ____ is text that prints in the top margin of each page.

FIGURE EX 6-1 In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.

When you add levels of fields, ____ buttons appear in the PivotTable so that you can show or hide these levels.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells.

The formula =B5+C5 is an example of a multiplication operation.

____ enables you to resize a worksheet to print on a specific number of pages.

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

In Excel, the chart data, called the record source , is stored in a range of cells in the worksheet.

The range of cells that you select to apply the validation rule is called the ____________________.

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.

FIGURE EX 4-1 In Figure EX 4-1 above, number 1 is pointing to the ____ button.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

The ____________________ first offers a checklist of items it will inspect, and then offers you the ability to delete those items from the workbook.

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

You can change which reference books and research sites are available from the Research task pane by clicking the Research list link at the bottom of the task pane.

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

A ____ is text that prints in the top margin of each page.

FIGURE EX 6-1 In order to access the Insert Hyperlink dialog box shown in Figure EX 6-1 above, you would ____.

When you add levels of fields, ____ buttons appear in the PivotTable so that you can show or hide these levels.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells.

The formula =B5+C5 is an example of a multiplication operation.

____ enables you to resize a worksheet to print on a specific number of pages.

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

In Excel, the chart data, called the record source , is stored in a range of cells in the worksheet.

The range of cells that you select to apply the validation rule is called the ____________________.

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.

FIGURE EX 4-1 In Figure EX 4-1 above, number 1 is pointing to the ____ button.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters