Exam 2: Microsoft Excel Basics

When you use the Find command , new data is substituted for the data found.

Axes are lines that establish a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis.

The ____ feature formats the worksheet in an outline, which lets you automatically display or hide data.

Theme formats apply to your entire workbook with the exception of very few objects, such as an embedded object.

An example of the function that returns the number of cells in a range of cells that contain data is ____.

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

The default magnification for a workbook is ____, which you can see on the Zoom level button.

Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. If Gregory wants to find out the total amount of money that has actually been received by the station, he needs to use the ____ function.

Pasting replaces any content already in the cell.

Describe how to add totals to rows in a table.

Using the COUNT function lets you count only cells that are displayed.

You switch between a chart sheet and a worksheet by clicking the appropriate ____.

Case EX 14-1 Lynda is responsible for creating a weekly update report in Excel for her boss detailing the performance of the ice cream store where she works. For each report, Lynda has to carry out the same formatting steps for the heading. Lynda wants to protect her computer and data from a potential virus attack. She should check to make sure that the ____ level in Excel is set to Disable all macros with notification or Disable all macros except digitally signed macros.

You can save an ordinary Excel workbook as a macro-enabled workbook using the ____ command.

A ____ is text that prints in the bottom margin of each page.

You can create a copy of a worksheet by pressing the ____ key as you drag and drop its sheet tab.

A pie chart is similar to the column chart, but columns are replaced by points connected by a line.

Hidden data does not occur in workbooks that are shared among several people.

A picture is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart.

When importing text data, you need to identify the type of data in the imported file as delimited or ____.