Question 1

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

Accepted Answer

A) True 
 B)False

Question 2

Table_array is the range of cells for a lookup table.

Accepted Answer

A) True 
 B)False

Question 3

Case EX 16-1 George is the manager of a party planning company. He uses an Excel workbook to keep track of the parties that the company is planning or has planned in the past. George is concerned about a competitor gaining access to the information in the workbook. To make sure that there are no unwanted or unauthorized changes to the main sheet of the workbook, George can use the ____ dialog box.

Accepted Answer

A)  Protect Sheet 
B)  Password Protect 
C)  Encrypt Document 
D)  Encrypt Sheet 
A)  Protect Sheet 
B)  Password Protect 
C)  Encrypt Document 
D)  Encrypt Sheet

Question 4

The XPS format can be read on all platforms.

Accepted Answer

A) True 
 B)False

Question 5

Case EX 16-2 Wendy is the Human Resources manager for a company that has offices in two locations. The employee data is stored in an Excel workbook. If a conflict arises from employees in the different offices making changes to the same cell, ____.

Accepted Answer

A)  the change that is made first is accepted 
B)  the change that is made last is accepted 
C)  the data in the cell is not changed 
D)  Excel provides a prompt that allows the conflict to be resolved 
A)  the change that is made first is accepted 
B)  the change that is made last is accepted 
C)  the data in the cell is not changed 
D)  Excel provides a prompt that allows the conflict to be resolved

Question 6

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Accepted Answer

A) True 
 B)False

Question 7

Consolidating can only be performed in Excel with the Sum and Average functions.

Accepted Answer

A) True 
 B)False

Question 8

FIGURE EX 5-1   In Figure EX 5-1 above, the annual interest rate is ____.

Accepted Answer

A)  .015% 
B)  0.15% 
C)  1.5% 
D)  15% 
A)  .015% 
B)  0.15% 
C)  1.5% 
D)  15%

Question 9

Anyone can open and view a workbook that is password protected.

Accepted Answer

A) True 
 B)False

Question 10

When you create a table in Excel, the rows and columns appear with the same format.

Accepted Answer

A) True 
 B)False

Question 11

For the Row_index_num of the HLOOKUP function, you will need to specify what to look for in the lookup table.

Accepted Answer

A) True 
 B)False

Question 12

Excel inserts ____whenever it runs out of room on a page.

Accepted Answer

A)  a blank row 
B)  an automatic page break 
C)  an automatic hyperlink 
D)  a paragraph marker 
A)  a blank row 
B)  an automatic page break 
C)  an automatic hyperlink 
D)  a paragraph marker

Question 13

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.

Accepted Answer

A)  worksheets 
B)  workbooks 
C)  cells 
D)  ranges 
A)  worksheets 
B)  workbooks 
C)  cells 
D)  ranges

Question 14

____ retains the exact look of the Excel document and protects it from being changed.

Accepted Answer

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

Question 15

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

Accepted Answer

A) True 
 B)False

Question 16

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

Accepted Answer

The answer of If you place your mouse pointer over...

Question 17

An example of the function of the natural logarithm of a number written correctly is ____.

Accepted Answer

A)  =LOG(50) 
B)  =LN(50) 
C)  =NL(50) 
D)  =(NL,50,2) 
A)  =LOG(50) 
B)  =LN(50) 
C)  =NL(50) 
D)  =(NL,50,2)

Question 18

To use the Trace Precedents feature, click the ____ tab, and then click the Trace Precedents button in the Formula Auditing group.

Accepted Answer

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

Question 19

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

Accepted Answer

A)  Advanced 
B)  Options 
C)  Manage 
D)  Data 
A)  Advanced 
B)  Options 
C)  Manage 
D)  Data

Question 20

Match between columns
                        Premises: Formats the chart based on the colors, fonts, and effects associated with the workbook's theme.

Accepted Answer

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

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

Table_array is the range of cells for a lookup table.

The XPS format can be read on all platforms.

Case EX 16-2 Wendy is the Human Resources manager for a company that has offices in two locations. The employee data is stored in an Excel workbook. If a conflict arises from employees in the different offices making changes to the same cell, ____.

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Consolidating can only be performed in Excel with the Sum and Average functions.

FIGURE EX 5-1 In Figure EX 5-1 above, the annual interest rate is ____.

Anyone can open and view a workbook that is password protected.

When you create a table in Excel, the rows and columns appear with the same format.

For the Row_index_num of the HLOOKUP function, you will need to specify what to look for in the lookup table.

Excel inserts ____whenever it runs out of room on a page.

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.

____ retains the exact look of the Excel document and protects it from being changed.

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

An example of the function of the natural logarithm of a number written correctly is ____.

To use the Trace Precedents feature, click the ____ tab, and then click the Trace Precedents button in the Formula Auditing group.

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

Table_array is the range of cells for a lookup table.

The XPS format can be read on all platforms.

Case EX 16-2 Wendy is the Human Resources manager for a company that has offices in two locations. The employee data is stored in an Excel workbook. If a conflict arises from employees in the different offices making changes to the same cell, ____.

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Consolidating can only be performed in Excel with the Sum and Average functions.

FIGURE EX 5-1 In Figure EX 5-1 above, the annual interest rate is ____.

Anyone can open and view a workbook that is password protected.

When you create a table in Excel, the rows and columns appear with the same format.

For the Row_index_num of the HLOOKUP function, you will need to specify what to look for in the lookup table.

Excel inserts ____whenever it runs out of room on a page.

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.

____ retains the exact look of the Excel document and protects it from being changed.

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

If you place your mouse pointer over a highlighted cell in a workbook with the Track Changes feature enabled, a(n) ____________________ will appear showing information about the change.

An example of the function of the natural logarithm of a number written correctly is ____.

To use the Trace Precedents feature, click the ____ tab, and then click the Trace Precedents button in the Formula Auditing group.

The ____ tab in the Share Workbook dialog box gives you several options for managing workbook changes.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters