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.

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.

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.

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 ____.