Question 1

You can use a 3-D reference with 24 different functions.

Accepted Answer

A) True 
 B)False

Question 2

The Subtotal function is ____.

Accepted Answer

A)  =SUBTOTAL (function number, data range) 
B)  =SUBTOTAL (data range, function number) 
C)  =SUBTOTAL (data range, function number, result range) 
D)  =SUBTOTAL (function number, data range, result range) 
A)  =SUBTOTAL (function number, data range) 
B)  =SUBTOTAL (data range, function number) 
C)  =SUBTOTAL (data range, function number, result range) 
D)  =SUBTOTAL (function number, data range, result range)

Question 3

All of the fonts, formats, and images used in Excel are preserved in the ____ format.

Accepted Answer

A)  DOC 
B)  HTML 
C)  ACCDB 
D)  PDF 
A)  DOC 
B)  HTML 
C)  ACCDB 
D)  PDF

Question 4

FIGURE EX 4-1   In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

Accepted Answer

A)  Customize Calculations 
B)  Calculations Options 
C)  Show Formulas 
D)  Manual Calculations 
A)  Customize Calculations 
B)  Calculations Options 
C)  Show Formulas 
D)  Manual Calculations

Question 5

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

Accepted Answer

A)  Delimiter 
B)  Cell Watch 
C)  Watch Window 
D)  Concatenation Window 
A)  Delimiter 
B)  Cell Watch 
C)  Watch Window 
D)  Concatenation Window

Question 6

If you enter an Average function in a cell but #DIV/0! appears instead, the calculation includes an error.

Accepted Answer

A) True 
 B)False

Question 7

To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the ____ group, click the arrow to the right of the Delete button, and then click Delete Sheet.

Accepted Answer

A)  Workbook 
B)  Cells 
C)  Data 
D)  Worksheet 
A)  Workbook 
B)  Cells 
C)  Data 
D)  Worksheet

Question 8

Click the Ctrl+C keys to cut selected cells.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

Accepted Answer

The answer of The ____________________ is the value the function...

Question 10

Match between columns
                        Premises: Functions that are used to format and work with cell contents.

Accepted Answer

The Answer of Date and time functions and Text functions is...

Question 11

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.

Accepted Answer

A) True 
 B)False

Question 12

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

Accepted Answer

A)  In the Styles group on the Home tab of the Ribbon, click the Cell Styles button. 
B)  In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button. 
C)  In the Editing group on the Home tab of the Ribbon, click the Cell Styles button. 
D)  None of the above 
A)  In the Styles group on the Home tab of the Ribbon, click the Cell Styles button. 
B)  In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button. 
C)  In the Editing group on the Home tab of the Ribbon, click the Cell Styles button. 
D)  None of the above

Question 13

Match between columns
                        Premises: A language that is used to create macros.

Accepted Answer

The Answer of code and Visual Basic for Applications and is...

Question 14

To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button.

Accepted Answer

A)  Page Layout 
B)  Layout 
C)  Format 
D)  Page Setup 
A)  Page Layout 
B)  Layout 
C)  Format 
D)  Page Setup

Question 15

The ____________________ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options.

Accepted Answer

The answer of The ____________________ menu displays a list of...

Question 16

____ is used to store large amounts of data and provides for easy viewing and printing of data.

Accepted Answer

A)  Access 
B)  Notepad 
C)  Explorer 
D)  Document Inspector 
A)  Access 
B)  Notepad 
C)  Explorer 
D)  Document Inspector

Question 17

FIGURE EX 1-1   Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.

Accepted Answer

A)  Match case 
B)  Match entire cell contents 
C)  both a. and b. 
D)  neither a. nor b. 
A)  Match case 
B)  Match entire cell contents 
C)  both a. and b. 
D)  neither a. nor b.

Question 18

The ____ function repeats the text in the specified cell a specified number of times.

Accepted Answer

A)  MIRROR 
B)  REPT 
C)  AGAIN 
D)  OVER 
A)  MIRROR 
B)  REPT 
C)  AGAIN 
D)  OVER

Question 19

Chart templates are saved in the same default location as the preformatted chart templates.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

Accepted Answer

The answer of A(n) ____________________ is an equation that calculates...

You can use a 3-D reference with 24 different functions.

The Subtotal function is ____.

All of the fonts, formats, and images used in Excel are preserved in the ____ format.

FIGURE EX 4-1 In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

If you enter an Average function in a cell but #DIV/0! appears instead, the calculation includes an error.

To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the ____ group, click the arrow to the right of the Delete button, and then click Delete Sheet.

Click the Ctrl+C keys to cut selected cells.

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button.

The ____________________ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options.

____ is used to store large amounts of data and provides for easy viewing and printing of data.

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.

The ____ function repeats the text in the specified cell a specified number of times.

Chart templates are saved in the same default location as the preformatted chart templates.

A(n) ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

You can use a 3-D reference with 24 different functions.

The Subtotal function is ____.

All of the fonts, formats, and images used in Excel are preserved in the ____ format.

FIGURE EX 4-1 In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

You can add cells of data into a ____ if you want to be able to view the data while working in another worksheet.

If you enter an Average function in a cell but #DIV/0! appears instead, the calculation includes an error.

To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the ____ group, click the arrow to the right of the Delete button, and then click Delete Sheet.

Click the Ctrl+C keys to cut selected cells.

The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button.

The ____________________ menu displays a list of all the values that appear in that column along with additional criteria and color filtering options.

____ is used to store large amounts of data and provides for easy viewing and printing of data.

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.

The ____ function repeats the text in the specified cell a specified number of times.

Chart templates are saved in the same default location as the preformatted chart templates.

A(n) ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters