Question 1

In the Show Error dialog box, you can choose to show the calculation steps to help identify where the problem occurs.

Accepted Answer

A) True 
 B)False

Question 2

You can make a perfect square or circle by pressing and holding the F5 key as you drag in the worksheet to draw the shape.

Accepted Answer

A) True 
 B)False

Question 3

If the Developer tab is not displayed on the Ribbon, you can add it to the Ribbon.

Accepted Answer

A) True 
 B)False

Question 4

If a function contains more than one argument, semicolons separate the arguments.

Accepted Answer

A) True 
 B)False

Question 5

FIGURE EX 8-1  In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

Accepted Answer

A)  legend 
B)  vertical axis title 
C)  horizontal axis title 
D)  chart title

Question 6

A(n) ____________________ workbook lets you save the macro in the workbook and then run the macro.

Accepted Answer

The answer of A(n) ____________________ workbook lets you save the...

Question 7

____ allows you to access and share files online with friends, family members, or co-workers.

Accepted Answer

A)  Document Inspector 
B)  Signature line 
C)  Exporter 
D)  SkyDrive

Question 8

To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.

Accepted Answer

A)  Format 
B)  Shape 
C)  Data 
D)  Picture

Question 9

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: The value that Excel will look for in the first column of the lookup table.

Accepted Answer

The Answer of condition and lookup table and Table_array and is...

Question 11

FIGURE EX 5-1  In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

Accepted Answer

A)  the entry is income 
B)  the entry is a payment 
C)  there is an error 
D)  the person is behind on their payments

Question 12

The Sum button is located in the ____ group on the Home tab of the Ribbon.

Accepted Answer

A)  Commands 
B)  Formulas 
C)  Editing 
D)  Data

Question 13

Data that is used to create a PivotTable can contain some blank columns or blank rows.

Accepted Answer

A) True 
 B)False

Question 14

You use the HLOOKUP function when the lookup table is listed vertically in columns.

Accepted Answer

A) True 
 B)False

Question 15

Passwords for a workbook are case sensitive.

Accepted Answer

A) True 
 B)False

Question 16

The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.

Accepted Answer

A) True 
 B)False

Question 17

When you use the VLOOKUP function, you will need to enter information into the ____ dialog box.

Accepted Answer

A)  Functions 
B)  Function Arguments 
C)  Lookup 
D)  Lookup Data

Question 18

Modifying code is similar to modifying text in a Microsoft Word document.

Accepted Answer

A) True 
 B)False

Question 19

The quickest way to select a chart element is to ____.

Accepted Answer

A)  navigate using the Ribbon 
B)  use the shortcut menus 
C)  click it with the pointer 
D)  none of the above

Question 20

Match between columns
                        Premises: A feature that shows changes made to an Excel worksheet.

Accepted Answer

The Answer of password and decrypting and Share Workbook and is...

Exam 2: Microsoft Excel Basics

In the Show Error dialog box, you can choose to show the calculation steps to help identify where the problem occurs.

You can make a perfect square or circle by pressing and holding the F5 key as you drag in the worksheet to draw the shape.

If the Developer tab is not displayed on the Ribbon, you can add it to the Ribbon.

If a function contains more than one argument, semicolons separate the arguments.

FIGURE EX 8-1 In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

A(n) ____________________ workbook lets you save the macro in the workbook and then run the macro.

____ allows you to access and share files online with friends, family members, or co-workers.

To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.

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

FIGURE EX 5-1 In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

The Sum button is located in the ____ group on the Home tab of the Ribbon.

Data that is used to create a PivotTable can contain some blank columns or blank rows.

You use the HLOOKUP function when the lookup table is listed vertically in columns.

Passwords for a workbook are case sensitive.

The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.

When you use the VLOOKUP function, you will need to enter information into the ____ dialog box.

Modifying code is similar to modifying text in a Microsoft Word document.

The quickest way to select a chart element is to ____.

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