Excel 1 Assessment

Function

A ____ is a predefined formula such as Sum or Median

One-Variable

A _______ data table changes the value in only one cell.

Trendline

A _______ is a graphic representation of trends in a data series.

Data Point

A _______ is a value in a worksheet cell that is represented in a chart by a data marker.

Chart Area

A chart and all of its elements is known as the ____.

Embedded

A chart that is inserted into the same worksheet that contains the data used to create the chart is called ______.

Determining the Future Value FV

A data tables is useful for all of the following except for _________.

False

A one-variable table will allow you to see how different interest rates and different payment periods will affect a monthly payment.

True

A relative cell reference is a reference based on the relative position of a cell that the default setting.

False

A series of rows that contains related data is known as a query.

Label

A text value in Excel is also referred to as a ____.

Reporting relationships

An organization chart depicts___________ within an organization.

Cell Styles

Apply styles to cells, such as Headings and Titles and Data and Model, by using the _____ command in the Styles group.

False

Auto Fill works only with alphabetic values.

Chart Sheet

Charts can be placed on a separate sheet called a ______.

True

Clearing the contents of a cell deletes the value or formula, but does not clear the formatting applied to the cell.

True

Excel's Scale to Fit commands enable you to stretch or shrink the width, height, or both of a printed page.

It is a green plus sign

How can you identify the Chart Elements button when you select a chart?

True

If you create a defined name and then decide that you no longer need it, you can delete the name and its associated range reference.

To Value

In Goal Seek, you enter the specific value that you want to achieve in the ____ box.

ScreenTip

In the Data Validation dialog box, you can create a _____ that will display when the cell is selected and that provides instructions to the person entering data.

Format Axis

In the ______ pane, you can change the bounds of the axes.

Extracting

Instead of displaying a filtered list, you can copy the results of a filter to another area of your worksheet for comparison purposes; this action is known as ______.

ID, IIE, IIIC, IVA, VB

Match each of the following functions to its descriptions: I. SUM II. MEDIAN III. AVERAGE IV. COUNTIF V. COUNT A. Counts the number of cells in a range that meet the given condition B. Counts the number of cells in a range that contain numbers C. Adds a range of cells and divides by the number of values in the range D. Adds a range of cells E. Locates the middle value in a range of cells

IE, IID, IIB, IVC, VA

Match each of the following terms to its definition: I. Data series II. Chart Sheet III. Pie Chart IV. Legend V. Chart Area A. Entire Chart and all of its elements B. Shows the relationship of parts to a whole C. Identifies the data markers in a chart D. A worksheet that contains only a chart E. Related data points represented by data markers

ID, IIB, IIIA, IVC, VE

Match each of the following terms to its definition: I. NOW Function II. Freeze Panes Command III. Split Command IV. Scale to Fit Command V. Find and Replace Command A. Divides a window into multiple resizable panes B. A command that enables you to select one or more rows or columns and lock them into place C. Stretch or shrink the width, height, or both of printed output D. Inserts the date stored on the computer calendar and clock E. Searches the cells of a worksheet

IA, IID, IIIE, IVB, VC

Match each of the following terms to its definition: I. Split II. Navigate III. Scale IV. Hide V. Copy A. Divide a worksheet into panes B. Remove a worksheet from view C. Place cell contents on the clipboard D. Move among worksheets E. Fit a worksheet on a printed page

IB, IIC, IIIA, IVE, VD

Match each of the tab names to an action found on that tab: I. Home Tab II. Formulas Tab III. View Tab IV. Insert Tab V. File Tab A. Freeze panes B. Flash Fill command C. More functions D. Document properties E. Create a table

IB, IIA, IIIE, IVC, VD

Match the terms or phases with their meanings: I. Custom Filter II. Extract III. Advanced Filter IV. Comparison Operators V. Criteria A. Used for copying selected rows to another part of the worksheet. B. A filter with which you can apply complex criteria to a single column C. Symbols that evaluate each value to determine if it is the same, greater than, less than, or in between a range of values specified by the criteria D. Conditions that you specify in a logical function or filter. E. A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria

True

Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range.

Tiny charts that fit within a cell and give a visual trend summary alongside your data

Sparklines are _______.

False

Sparklines cannot be formatted.

True

The Percent Style can have fewer or more places after the decimal that the default.

False

The Sum Function is so frequently used that it has its own button on the Quick Access Toolbar.

Trace Dependents

The _______ command displays arrows that indicate what cells are affected by the value of the selected cell.

Subtotal

The ________ button totals several row or related data together by automatically inserting subtotals and totals for the selected cells.

True

The active area of a worksheet contains data or has contained data and does NOT contain cells that were not used in the worksheet.

Plot Area

The area bounded by the axes, including all the data series is called _______.

True

The criteria range is an area on your worksheet where you define the criteria for the filter.

Chart Area

The entire chart and all of its elements comprise the _______.

The middle value in a range of cells

The median function finds ______.

True

The order of data in the worksheet determines how the pie slices are ordered in a pie chart.

True

The paste area is the target destination for data that has been cut or copied using the clipboard.

Panes

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called ____.

True

The process SmartArt graphic can show steps in a timeline.

True

The spelling checker in Excel performs similarly to other Microsoft Office programs.

Principal

The total amount that a series of future payment is worth is called the ______.

Protection

To prevent others from altering the formulas or changing other template components, you should use _______.

Red Diamond

To rotate text in a worksheet, in the format cells dialog box, you can click and drag the ______.

Format and Design

What are the two contextual tabs that display under Chart Tools when a chart is selected ?

Formula AutoComplete List

When you start typing a formula, such as =SUM{B Excel will display the ______, which contains all of Excel's built in functions starting with the letter B.

On the mini toolbar and the Home tab

Where is the Format Painter button located?

A Line Chart

Which of the following displays trends over time?

Height

Which of the following is NOT one of the three spatial dimensions of 3-D?

True

You can add effects, for example a bevel, to a SmartArt graphic.

Scaling

You can force the data in a worksheet into a selected number of pages by using the _______ command.

False

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

HTML

You can save a single worksheet as a webpage, where Excel changes the content of the worksheet into _____, a language web browsers can interpret.

Formatting

_____ is the term for specifying the appearance of cells and overall layout of a worksheet.

Data Validation

_________ is a technique in which you control the data or the values that are entered into a cell.