Question 1

Match between columns
                        Premises: A sequence of characters, known only by you, that is required for access to a file.

Accepted Answer

The Answer of decrypting and Track Changes and password and is...

Question 2

To edit button text, you must ____ the button and choose ____.

Accepted Answer

A)  right-click, Edit Text 
B)  right-click, Format Text 
C)  left-click, Edit Text 
D)  left-click, Format Text 
A)  right-click, Edit Text 
B)  right-click, Format Text 
C)  left-click, Edit Text 
D)  left-click, Format Text

Question 3

Match between columns
                        Premises: Places the last item from the Clipboard into the cell or range selected in the worksheet.

Accepted Answer

The Answer of Copy and Paste and Cut and Scale is...

Question 4

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. If Sharon decides to go to another worksheet in the workbook, she can still view data from the Books worksheet by using a(n) ____.

Accepted Answer

A)  Sub Window 
B)  Watch Window 
C)  Message Window 
D)  Add Window 
A)  Sub Window 
B)  Watch Window 
C)  Message Window 
D)  Add Window

Question 5

FIGURE EX 14-1   Based on Figure EX 14-1 above, the macro will apply the ____ format to a selected cell.

Accepted Answer

A)  center 
B)  left-aligned 
C)  bold 
D)  right-aligned 
A)  center 
B)  left-aligned 
C)  bold 
D)  right-aligned

Question 6

The ____________________ feature is useful when you want to view totals in the worksheet data but you don't want formulas permanently entered into the worksheet at that time.

Accepted Answer

The answer of The ____________________ feature is useful when you...

Question 7

FIGURE EX 12-1   Item 2 in Figure EX 12-1 above shows a ____.

Accepted Answer

A)  slicer 
B)  PivotTable 
C)  Watch Window 
D)  ViewTable 
A)  slicer 
B)  PivotTable 
C)  Watch Window 
D)  ViewTable

Question 8

Match between columns
                        Premises: A requirement that needs to be met.

Accepted Answer

The Answer of lookup table and function number and Table_array is...

Question 9

The Macros button is found in the Code group on the ____ tab.

Accepted Answer

A)  Home 
B)  Developer 
C)  Data 
D)  View 
A)  Home 
B)  Developer 
C)  Data 
D)  View

Question 10

The macro name and the shortcut key assigned to the macro is entered in the Macro Settings dialog box.

Accepted Answer

A) True 
 B)False

Question 11

The Lookup & Reference button is found on the ____ tab.

Accepted Answer

A)  Home 
B)  Insert 
C)  Formulas 
D)  Data 
A)  Home 
B)  Insert 
C)  Formulas 
D)  Data

Question 12

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

Accepted Answer

The answer of The ____________________(text) function converts the first letter...

Question 13

Each workbook opens with five worksheets.

Accepted Answer

A) True 
 B)False

Question 14

The equation used to calculate values in a cell is called a command .

Accepted Answer

A) True 
 B)False

Question 15

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.

Accepted Answer

A)  Location 
B)  Move 
C)  Chart Sheet 
D)  Chart 
A)  Location 
B)  Move 
C)  Chart Sheet 
D)  Chart

Question 16

The function number 5 calculates SUM.

Accepted Answer

A) True 
 B)False

Question 17

FIGURE EX 3-1   The area marked with the number 3 in Figure EX 3-1 above, shows ____scrolled out of view.

Accepted Answer

A)  rows 3 through 16 
B)  rows 4 through 15 
C)  columns A through D 
D)  columns B through D 
A)  rows 3 through 16 
B)  rows 4 through 15 
C)  columns A through D 
D)  columns B through D

Question 18

The ____________________ dialog box is used to select the data for creating a PivotTable.

Accepted Answer

The answer of The ____________________ dialog box is used to...

Question 19

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea would like to highlight the months where her spending was more than her earnings. She needs to use a ____ formatting formula.

Accepted Answer

A)  theme 
B)  filter 
C)  banded 
D)  conditional 
A)  theme 
B)  filter 
C)  banded 
D)  conditional

Question 20

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

Accepted Answer

The answer of To prevent changes to a worksheet, you...

To edit button text, you must the button and choose .

FIGURE EX 14-1 Based on Figure EX 14-1 above, the macro will apply the ____ format to a selected cell.

The ____________________ feature is useful when you want to view totals in the worksheet data but you don't want formulas permanently entered into the worksheet at that time.

FIGURE EX 12-1 Item 2 in Figure EX 12-1 above shows a ____.

The Macros button is found in the Code group on the ____ tab.

The macro name and the shortcut key assigned to the macro is entered in the Macro Settings dialog box.

The Lookup & Reference button is found on the ____ tab.

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

Each workbook opens with five worksheets.

The equation used to calculate values in a cell is called a command .

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.

The function number 5 calculates SUM.

FIGURE EX 3-1 The area marked with the number 3 in Figure EX 3-1 above, shows ____scrolled out of view.

The ____________________ dialog box is used to select the data for creating a PivotTable.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea would like to highlight the months where her spending was more than her earnings. She needs to use a ____ formatting formula.

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

To edit button text, you must ____ the button and choose ____.

FIGURE EX 14-1 Based on Figure EX 14-1 above, the macro will apply the ____ format to a selected cell.

The ____________________ feature is useful when you want to view totals in the worksheet data but you don't want formulas permanently entered into the worksheet at that time.

FIGURE EX 12-1 Item 2 in Figure EX 12-1 above shows a ____.

The Macros button is found in the Code group on the ____ tab.

The macro name and the shortcut key assigned to the macro is entered in the Macro Settings dialog box.

The Lookup & Reference button is found on the ____ tab.

The ____________________(text) function converts the first letter of each word in the specified cell to uppercase and the rest to lowercase.

Each workbook opens with five worksheets.

The equation used to calculate values in a cell is called a command .

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.

The function number 5 calculates SUM.

FIGURE EX 3-1 The area marked with the number 3 in Figure EX 3-1 above, shows ____scrolled out of view.

The ____________________ dialog box is used to select the data for creating a PivotTable.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea would like to highlight the months where her spending was more than her earnings. She needs to use a ____ formatting formula.

To prevent changes to a worksheet, you can protect it with a(n) ____________________.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

To edit button text, you must the button and choose .