# Like this study set? Create a free account to save it.

### A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

Spreadsheet

### The ________ allows the user to enter or edit the value or formula contained in the active cell.

Formula Bar

### The ________ allow(s) the worksheet to be split into two vertical views of the same worksheet.

Vertical Window Split

### The current cell mode, the page number, and the view and zoom buttons are displayed on the?

Status Bar

### ________ generates and extends a series of values into adjacent cells based on the values of other cells.

Auto Fill

### The ________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column.

Auto Complete

### A prewritten formula known as a(n) ________ looks at one or more values, performs an operation, and returns a value

Function

### The result of a formula is displayed in the active cell, and the ________ is displayed in the Formula Bar.

Underlying Value

### Excel's ________ command creates one cell out of the selected cells and centers the contents within the new cell.

Merge & Center

### ________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Cell Styles

### The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parenthese

Comma Style

### For data to be more easily understood, it can be presented in a ________ instead of a table of numbers.

Chart

### Labels that display along the bottom of a chart to identify the category of the data are called

Category Labels

### On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.

Legend

### Each worksheet is identified by the ________ found along the lower border of the Excel window

Sheet Tabs

### To widen a column to fit the cell content of the widest cell in the column, the user should utilize

Autofit

### The process of specifying the appearance of cells and the overall layout of a worksheet is called

Formattin

### A cell address used in a formula using a(n) ________ will be adjusted appropriately when the formula is copied to another cell.

Relative Cell Reference

### Applying the shape effect ________ causes the edges of a shape to appear to be curved or angled.

Bevel

### ) To ________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

Explode

### ) Why would you explode a slice on a pie chart?

To emphazise the slice to the person viewing the chart

### Excel's ________ finds the input needed in one cell for another cell to have a desired value

Goal Seek

### The ________ is the percent by which one number increases over another during a specified time frame.

Percentage Rate of increase

### ) The percentage rate of increase is calculated by using this formula: ________.

Base*Amount of increase

### Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing a

What-If analysis

### A(n) ________ is a line that borders the chart plot area and serves as a frame of reference for measurement.

axis

### Which Excel function would be used to calculate the total points a student earned on a series of tests?

...

### The Excel function ________ would be used to find the lowest score on a series of student test scores.

...

### Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.

...

### The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.

...

### If a cell's width is too narrow to properly display the numeric contents of the cell, Excel displays a series of ________ symbols.

...