Question 1

When you right-click a button, a(n) ____________________ menu appears.

Accepted Answer

The answer of When you right-click a button, a(n) ____________________...

Question 2

With ____, you can have borders, background colors, shading, and graphic effects applied instantly to an entire workbook.

Accepted Answer

A)  tables 
B)  themes 
C)  AutoFilters 
D)  conditional formatting 
A)  tables 
B)  themes 
C)  AutoFilters 
D)  conditional formatting

Question 3

When Track Changes is enabled, Excel identifies the name of the person who made the change and the date of the change.

Accepted Answer

A) True 
 B)False

Question 4

As an example of a financial function, =____________________(.1,5,-500) displays the current value of five payments of $500 at a 10% interest rate.

Accepted Answer

The answer of As an example of a financial function,...

Question 5

A formula is the intersection of a row and a column.

Accepted Answer

A) True 
 B)False

Question 6

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

Accepted Answer

A)  Formula Complete 
B)  Formula Now 
C)  Formula Selector 
D)  Formula AutoComplete 
A)  Formula Complete 
B)  Formula Now 
C)  Formula Selector 
D)  Formula AutoComplete

Question 7

____________________ copies a cell's contents and/or formatting into an adjacent cell or range.

Accepted Answer

The answer of ____________________ copies a cell's contents and/or formatting...

Question 8

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

Accepted Answer

A)  sheet box 
B)  sheet task bar 
C)  sheet dialog box 
D)  sheet tab 
A)  sheet box 
B)  sheet task bar 
C)  sheet dialog box 
D)  sheet tab

Question 9

Match between columns
                        Premises: Enables you to resize a worksheet to print on a specific number of pages.

Accepted Answer

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

Question 10

After you name a range, Excel remembers that name.

Accepted Answer

A) True 
 B)False

Question 11

FIGURE EX 2-1   In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.

Accepted Answer

A)  row width 
B)  row height 
C)  column width 
D)  column height 
A)  row width 
B)  row height 
C)  column width 
D)  column height

Question 12

To locate errors with formulas or functions, you can use the Error Checking tool.

Accepted Answer

A) True 
 B)False

Question 13

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.

Accepted Answer

A) True 
 B)False

Question 14

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

Accepted Answer

A)  Selection 
B)  Print Now 
C)  Print 
D)  Output 
A)  Selection 
B)  Print Now 
C)  Print 
D)  Output

Question 15

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: A structure in which the data can be rearranged and summarized in different ways so that you can view the data from various perspectives.

Accepted Answer

The Answer of PivotTable and horizontal axis and slicer and is...

Question 17

If you try to close a workbook that contains changes you haven't saved, ____.

Accepted Answer

A)  a dialog box asks you whether or not you want to save the file 
B)  the workbook closes and your changes are lost 
C)  you receive an error message 
D)  the workbook closes and your changes are saved anyway 
A)  a dialog box asks you whether or not you want to save the file 
B)  the workbook closes and your changes are lost 
C)  you receive an error message 
D)  the workbook closes and your changes are saved anyway

Question 18

After you export or upload a file to your SkyDrive account, the file can then be shared and accessed.

Accepted Answer

A) True 
 B)False

Question 19

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea wants to display the months in the format 2014-March. She needs to ____.

Accepted Answer

A)  use one of Excel's existing number formats 
B)  create a custom number format 
C)  create a new theme 
D)  apply an existing theme 
A)  use one of Excel's existing number formats 
B)  create a custom number format 
C)  create a new theme 
D)  apply an existing theme

Question 20

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. If Matt needs to only display the information about male cats who are older than 3 years, he can use a ____.

Accepted Answer

A)  Conditional Format 
B)  Custom AutoFilter 
C)  Universal Search 
D)  Banded search 
A)  Conditional Format 
B)  Custom AutoFilter 
C)  Universal Search 
D)  Banded search

When you right-click a button, a(n) ____________________ menu appears.

With ____, you can have borders, background colors, shading, and graphic effects applied instantly to an entire workbook.

When Track Changes is enabled, Excel identifies the name of the person who made the change and the date of the change.

As an example of a financial function, =____________________(.1,5,-500) displays the current value of five payments of $500 at a 10% interest rate.

A formula is the intersection of a row and a column.

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

____________________ copies a cell's contents and/or formatting into an adjacent cell or range.

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

After you name a range, Excel remembers that name.

FIGURE EX 2-1 In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.

To locate errors with formulas or functions, you can use the Error Checking tool.

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

If you try to close a workbook that contains changes you haven't saved, ____.

After you export or upload a file to your SkyDrive account, the file can then be shared and accessed.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea wants to display the months in the format 2014-March. She needs to ____.

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. If Matt needs to only display the information about male cats who are older than 3 years, he can use a ____.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

When you right-click a button, a(n) ____________________ menu appears.

With ____, you can have borders, background colors, shading, and graphic effects applied instantly to an entire workbook.

When Track Changes is enabled, Excel identifies the name of the person who made the change and the date of the change.

As an example of a financial function, =____________________(.1,5,-500) displays the current value of five payments of $500 at a 10% interest rate.

A formula is the intersection of a row and a column.

____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.

____________________ copies a cell's contents and/or formatting into an adjacent cell or range.

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

After you name a range, Excel remembers that name.

FIGURE EX 2-1 In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.

To locate errors with formulas or functions, you can use the Error Checking tool.

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

If you try to close a workbook that contains changes you haven't saved, ____.

After you export or upload a file to your SkyDrive account, the file can then be shared and accessed.

Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea wants to display the months in the format 2014-March. She needs to ____.

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. If Matt needs to only display the information about male cats who are older than 3 years, he can use a ____.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters