Exam 2: Microsoft Excel Basics

Explain the possible dangers with macros and why it is important to be aware of the macro security levels in Excel.

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

You can use the ____ function to get the total amount for data in a range of cells.

The Track Changes arrow button is found on the ____ tab.

When you sort data contained in columns of a worksheet, Excel includes the column headings.

When you click the shape you want to insert the pointer changes to a crosshair.

____________________ formatting applies a font, border, or pattern to worksheet cells when certain conditions exist in those cells.

The formula = E6/4 is an example of a(n) ____ operation.

The slicer is professional in appearance, but difficult to use.

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____.

Please briefly describe the difference between portrait and landscape orientation, when each is used, and how to change the page orientation.

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. To maximize efficiency and productivity, Wendy feels that it is important that employees in the Human Resources department of both offices are able to work on the workbook simultaneously. She needs to make the workbook a ____ workbook.

Text formats that can be imported into Excel include .txt, ____, or .prn.

The formula =4*D5 is an example of a(n) ____________________ operation.

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

A gauge chart is also called a ____ chart.

A(n) ____ acts like a filter, but it is easier to use.

Charts are easy to make but difficult to format.