Question 1

The ____________________ Wizard walks you through the steps to import text data into an Excel workbook.

Accepted Answer

The answer of The ____________________ Wizard walks you through the...

Question 2

When you ____________________ panes, you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls.

Accepted Answer

The answer of When you ____________________ panes, you select which...

Question 3

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

Accepted Answer

A)  left 
B)  right 
C)  either a. or b. 
D)  neither a. nor b.

Question 4

The slicer includes ____ that you click to filter data in a PivotTable.

Accepted Answer

A)  sparklines 
B)  charts 
C)  row headings 
D)  column headings

Question 5

Match between columns
                        Premises: The y-axis on the right side of a chart that has two y-axes.

Accepted Answer

The Answer of Data point and Secondary axis and Primary is...

Question 6

Explain what the Track Changes feature does and discuss the reasons for using this feature.

Accepted Answer

The answer of Explain what the Track Changes feature does...

Question 7

Case EX 17-2 Adam works at a textile company. The company stores information about its products in an Excel workbook. Adam needs to find an easy way to share some of the information with clients. Adam can save the information from the worksheet as a(n) ____, which can be easily viewed by anyone who has Adobe Acrobat or Adobe Reader.

Accepted Answer

A)  TXT 
B)  PDF 
C)  HTML 
D)  CSS

Question 8

To prevent a workbook from being opened by an unauthorized person, you can ____-protect a workbook.

Accepted Answer

A)  password 
B)  change 
C)  share 
D)  network

Question 9

FIGURE EX 15-1  In Figure EX 15-1 above, item 1 points to a(n) ____ icon.

Accepted Answer

A)  precedent 
B)  suggestion 
C)  information 
D)  dependent

Question 10

The function number ____ calculates AVERAGE.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4

Question 11

Match between columns
                        Premises: The worksheet that is displayed in the work area.

Accepted Answer

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

Question 12

The default number format is General, which displays numbers the way you type them.

Accepted Answer

A) True 
 B)False

Question 13

When you need to edit a worksheet with many formulas, you can specify ____________________ calculation, which lets you determine when Excel calculates the formulas.

Accepted Answer

The answer of When you need to edit a worksheet...

Question 14

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.

Accepted Answer

A)  computer 
B)  company 
C)  copy of Excel 
D)  copy of Office 2010

Question 15

The Check for Issues button is found on the ____________________ tab.

Accepted Answer

The answer of The Check for Issues button is found...

Question 16

A ____ is a miniature chart that can be displayed in a single row or column of data.

Accepted Answer

A)  legend 
B)  data marker 
C)  sparkline 
D)  chart meta

Question 17

As a best practice, you should set the security level in Excel to Enable all macros.

Accepted Answer

A) True 
 B)False

Question 18

After you finish typing a formula in a cell, you must enter it by pressing the ____.

Accepted Answer

A)  Enter key 
B)  Tab key 
C)  Enter button on the formula bar 
D)  any of the above

Question 19

PDF stands for ____ document format.

Accepted Answer

A)  printed 
B)  portable 
C)  personal 
D)  private

Question 20

Match between columns
                        Premises: Functions used to describe large quantities of data.

Accepted Answer

The Answer of Text functions and Financial functions and Statistical is...

Exam 2: Microsoft Excel Basics

The ____________________ Wizard walks you through the steps to import text data into an Excel workbook.

When you ____________________ panes, you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls.

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

The slicer includes ____ that you click to filter data in a PivotTable.

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

Explain what the Track Changes feature does and discuss the reasons for using this feature.

To prevent a workbook from being opened by an unauthorized person, you can ____-protect a workbook.

FIGURE EX 15-1 In Figure EX 15-1 above, item 1 points to a(n) ____ icon.

The function number ____ calculates AVERAGE.

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

The default number format is General, which displays numbers the way you type them.

When you need to edit a worksheet with many formulas, you can specify ____________________ calculation, which lets you determine when Excel calculates the formulas.

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. After entering a comment, Mariana notices that the username in the comment box is not her name. The name matches the user name entered for that ____.

The Check for Issues button is found on the ____________________ tab.

A ____ is a miniature chart that can be displayed in a single row or column of data.

As a best practice, you should set the security level in Excel to Enable all macros.

After you finish typing a formula in a cell, you must enter it by pressing the ____.

PDF stands for ____ document format.

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