Question 1

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.

Accepted Answer

A) True 
 B)False

Question 2

The Custom AutoFilter is a feature that lets you display only cells that meet specific criteria.

Accepted Answer

A) True 
 B)False

Question 3

The ____ feature works by locating formulas and/or functions that depend on the value in a selected cell.

Accepted Answer

A)  Trace Dependents 
B)  Trace Precedents 
C)  Goal Seek 
D)  Trace Error

Question 4

Case EX 15-2 Shishir has just started working in a Web design firm. He is responsible for managing the contact information and details of all the clients. The person who worked before Shishir had a number of workbooks for the client data. The feature that Shishir needs to use is found on the ____ tab.

Accepted Answer

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

Question 5

The slicer will print when you print the worksheet .

Accepted Answer

A) True 
 B)False

Question 6

The ____ character divides the parts of the format code.

Accepted Answer

A)  ; (semicolon) 
B)  : (colon) 
C)  . (period) 
D)  , (comma)

Question 7

Horizontal alignments do NOT include ____.

Accepted Answer

A)  left 
B)  centered 
C)  right 
D)  bottom

Question 8

When using the Sum button, the active cell displays the sum.

Accepted Answer

A) True 
 B)False

Question 9

When you audit something, you are checking it for accuracy.

Accepted Answer

A) True 
 B)False

Question 10

Match between columns
                        Premises: A program offered by Microsoft which offers 25 GB of online Web storage for free.

Accepted Answer

The Answer of Access and delimited and signature line and is...

Question 11

A chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme.

Accepted Answer

A) True 
 B)False

Question 12

Please briefly describe these three ways to position data within cells: Orientation, Wrap Text, and Merge. Also, include an example of when you would use each type of positioning.

Accepted Answer

The answer of Please briefly describe these three ways to...

Question 13

An example of a square root function written correctly is ____.

Accepted Answer

A)  SQRT(C4) 
B)  =SQROOT(C4) 
C)  =SQRT(C4) 
D)  SQROOT(C4)

Question 14

To delete the legend from a chart, click the legend and then press Delete.

Accepted Answer

A) True 
 B)False

Question 15

____ determines the best width for a column or the best height for a row, based on its contents.

Accepted Answer

A)  MaxFit 
B)  FitAuto 
C)  FitNow 
D)  AutoFit

Question 16

Saving a workbook means loading an existing workbook file from a disk into the program window.

Accepted Answer

A) True 
 B)False

Question 17

When there is more than one level in a PivotTable, the level of detail below the main row heading is called the ____________________.

Accepted Answer

The answer of When there is more than one level...

Question 18

The TXT format was developed by Microsoft and is similar to PDF.

Accepted Answer

A) True 
 B)False

Question 19

FIGURE EX 14-1  Based on Figure EX 14-1 above, pressing ____ would run the macro.

Accepted Answer

A)  Ctrl+q 
B)  * : Ctrl+q 
C)  Sub 
D)  End Sub

Question 20

To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.

Accepted Answer

A)  Insert 
B)  Sheet 
C)  Worksheet 
D)  Insert Sheet

Exam 2: Microsoft Excel Basics

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.

The Custom AutoFilter is a feature that lets you display only cells that meet specific criteria.

The ____ feature works by locating formulas and/or functions that depend on the value in a selected cell.

The slicer will print when you print the worksheet .

The ____ character divides the parts of the format code.

Horizontal alignments do NOT include ____.

When using the Sum button, the active cell displays the sum.

When you audit something, you are checking it for accuracy.

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

A chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme.

Please briefly describe these three ways to position data within cells: Orientation, Wrap Text, and Merge. Also, include an example of when you would use each type of positioning.

An example of a square root function written correctly is ____.

To delete the legend from a chart, click the legend and then press Delete.

____ determines the best width for a column or the best height for a row, based on its contents.

Saving a workbook means loading an existing workbook file from a disk into the program window.

When there is more than one level in a PivotTable, the level of detail below the main row heading is called the ____________________.

The TXT format was developed by Microsoft and is similar to PDF.

FIGURE EX 14-1 Based on Figure EX 14-1 above, pressing ____ would run the macro.

To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.