92 terms

Excel chapters 1-3 test

A(n) ______ is a predefined formula that performs calculations by using specific values in a particular order or structure.
The _______ function is a predefined formula that adds all the numbers in a selected range of cells.
The ____ function adds a group of values, and then divides the result by the number of values in the group.
The _____ function finds the middle value that has as many values above it in the group as are below it.
The ____ function is a statistical function that counts the number of cells within a range that meet the given condition.
When you _____ a formula, the cell references within the formula do not change, no matter what type of cell reference you use.
The _____ function retrieves the date and time from your computer's calendar and clock, and inserts the information into the selected cell.
The ______ command enables you to select one or more rows or columns and then lock them into place.
Freeze Panes
The _______ command enables you to specify rows and columns to repeat on each printed page.
Print Titles
The _______ command enables you to stretch or shrink the width, height, or both, of the printed output to fit a maximum number of pages.
Scale to fit
__________ identify each worksheet in a workbook and are located along the lower eft edge of the workbook window.
Sheet tabs
When you filter a table, only a portion of the data displays based on matching a specific value.
When you paste cells, the Cell Styles gallery displays, which includes Live Preview to preview the Paste formatting that you want.
Arranging all the data in a specific order- in ascending or descending order- is referred to as filtering a table.
Operators are the symbols with which you specify the type of calculation that you want to perform on the elements of a formula.
A summary sheet is a worksheet where totals from other worksheets are displayed and summarized.
The paste area refers to the target destination for data that has been cut or copied using the Office Clipboard.
Statistical functions test for specific conditions.
Clearing contents of a cell deletes the value or formula typed there, but it does not clear formatting applied to a cell.
You can sort tables- display only a portion of the data based on matching a specific value- to show only the data that meets the criteria that you specify.
You can filter tables- arrange all the data in a specific order- in ascending or descending order.
The statistical MAX function determines the smallest value in a selected range of values.
Specified conditions
Changes the appearance of a cell based on a condition
conditional format
Provides a visual cue to the reader about the value of a cell relative to other cells
data bar
When the information inserted from a function will not remain as entered
greater than
equal to
less than
not equal to
On startup, Excel displays a new blank ______.
A time saving technique for entering data is to first ______.
select a range of cells
The Formula Bar displays:
the value or formula contained in the active cell.
A text value or _______ usually provides information about number values in other worksheet cells.
Text or numbers in a cell are referred to as ________.
The default number format is the _______ format.
All formulas begin with the _____ sign.
The ______ command joins selected cells into one larger cell and centers the contents of the new cell.
Merge & Center
A cell ______ is a defined set of formatting characteristics.
A _______ chart is useful for illustrating comparisons among related numbers.
In _______ view, you can see the edges of multiple pages, the margins, and the rulers.
Page Layout
________ refers to the process of specifying the appearance of cells.
In Excel, the spelling checker performs similarly to those of the other Microsoft Office programs.
???? not sure
Operators are symbols with which you can specify the type of calculation you want to perform in a formula
An absolute cell reference refers to a cell by its relative position in the worksheet.
A relative cell reference automatically adjusts when a formula is copied.
The Comma Style button formats the selected cell as a percentage rounded to the nearest hundredth.
The intersection of a column and a row forms a box referred to as a spreadsheet.
When you activate the Sum function, Excel first looks below the active cell for a range of cells to sum.
AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
Sparklines are tiny charts embedded in a cell and given a visual trend summary alongside your data.
If you move formulas by inserting additional rows or columns in your worksheet, Excel automatically adjusts the formulas.
A data marker is a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
Displays the value or formula contained in the active cell; also permits entry or editing.
Formula Bar
Displays the name of the selected cell, table, chart, or object.
Name Box
Displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average.
Status bar
identify the worksheets
Sheet tabs
A vertical group of cells in a worksheet.
A unique letter that identifies each column.
column heading
A horizontal group of cells.
Displays the columns and rows that intersect to form the worksheet's cells.
Worksheet grid area
A ______ chart shows the relationship of each part to a whole.
To create a pie chart, you must select ________.
two ranges
The order in which the data series in pie charts are plotted in Excel is determined by the order of the data on the _______.
You can _______ one or more slices of a pie chart to emphasize a specific slice or slices.
A ________ is a movable, resizable container for text or graphics.
Text box
______ is a gallery of text styles with which you can create decorative effects.
________ refers to the process of changing the values in cells to see how those changes affect the outcome of formulas in your worksheet.
What-If Analysis
______ find(s) the input needed in one cell to arrive at the desired result in another cell.
Goal Seek
When writing a formula in Excel, use _____ to communicate the order in which the operations should occur.
A ______ chart displays trends over time.
A(n) _______ cell reference refers to a cell by its fixed position in the worksheet.
_______ is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
In a pie chart, the size of each pie slice is equal to its value compared to the total value of all the slices.
A fund is a sum of money set aside for a specific purpose.
2-D refers to an image that appears to have all three spatial dimensions- length, width, and depth.
Bevel is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
The entire chart and all of its elements comprise the chart area.
If you edit the data in your worksheet, the chart data markers will not adjust automatically.
Formula autocomplete is an Excel feature which, after typing an equal sign and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).
Formatting marks are the short lines that display on an axis at regular intervals.
A plot area is a line that serves as a frame of reference for measurement.
The area along the bottom of a chart that identifies the categories of data is referred to as the category axis.
The set of mathematical rules that Excel follows is called the order of operations.
A line that serves as a frame of reference for measurement
The area bounded by the axes, including all the data series.
plot area
The area along the bottom of a chart that identifies the categories of data.
The area along the left side of a chart that shows the range of numbers for data points.
Shows the relationship of each part to a whole.
Pie chart
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
data point
The related data points represented by data markers.
data series
A workbook sheet that contains only a chart.
Chart sheet