92 terms

# Excel chapters 1-3 test

###### PLAY
A(n) ______ is a predefined formula that performs calculations by using specific values in a particular order or structure.
Function
The _______ function is a predefined formula that adds all the numbers in a selected range of cells.
SUM
The ____ function adds a group of values, and then divides the result by the number of values in the group.
Average
The _____ function finds the middle value that has as many values above it in the group as are below it.
Median
The ____ function is a statistical function that counts the number of cells within a range that meet the given condition.
Countif
When you _____ a formula, the cell references within the formula do not change, no matter what type of cell reference you use.
Move
The _____ function retrieves the date and time from your computer's calendar and clock, and inserts the information into the selected cell.
Now
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.
True
When you paste cells, the Cell Styles gallery displays, which includes Live Preview to preview the Paste formatting that you want.
False
Arranging all the data in a specific order- in ascending or descending order- is referred to as filtering a table.
False
Operators are the symbols with which you specify the type of calculation that you want to perform on the elements of a formula.
True
A summary sheet is a worksheet where totals from other worksheets are displayed and summarized.
True
The paste area refers to the target destination for data that has been cut or copied using the Office Clipboard.
True
Statistical functions test for specific conditions.
False
Clearing contents of a cell deletes the value or formula typed there, but it does not clear formatting applied to a cell.
True
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.
False
You can filter tables- arrange all the data in a specific order- in ascending or descending order.
False
The statistical MAX function determines the smallest value in a selected range of values.
False
Specified conditions
Criteria
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
volatile
greater than
>
equal to
=
less than
<
not equal to
<>
On startup, Excel displays a new blank ______.
Workbook
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.
label
Text or numbers in a cell are referred to as ________.
data
The default number format is the _______ format.
General
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.
Style
A _______ chart is useful for illustrating comparisons among related numbers.
Column
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.
Formatting
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
True
An absolute cell reference refers to a cell by its relative position in the worksheet.
False
A relative cell reference automatically adjusts when a formula is copied.
True
The Comma Style button formats the selected cell as a percentage rounded to the nearest hundredth.
False
The intersection of a column and a row forms a box referred to as a spreadsheet.
False
When you activate the Sum function, Excel first looks below the active cell for a range of cells to sum.
False
AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
True
Sparklines are tiny charts embedded in a cell and given a visual trend summary alongside your data.
True
If you move formulas by inserting additional rows or columns in your worksheet, Excel automatically adjusts the formulas.
True
A data marker is a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
True
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.
column
A unique letter that identifies each column.
A horizontal group of cells.
Row
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.
Pie
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 _______.
worksheet
You can _______ one or more slices of a pie chart to emphasize a specific slice or slices.
explode
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.
WordArt
________ 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.
Parentheses
A ______ chart displays trends over time.
line
A(n) _______ cell reference refers to a cell by its fixed position in the worksheet.
absolute
_______ is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
Bevel
In a pie chart, the size of each pie slice is equal to its value compared to the total value of all the slices.
True
A fund is a sum of money set aside for a specific purpose.
True
2-D refers to an image that appears to have all three spatial dimensions- length, width, and depth.
False
Bevel is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.
True
The entire chart and all of its elements comprise the chart area.
True
If you edit the data in your worksheet, the chart data markers will not adjust automatically.
False
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).
True
Formatting marks are the short lines that display on an axis at regular intervals.
False
A plot area is a line that serves as a frame of reference for measurement.
False
The area along the bottom of a chart that identifies the categories of data is referred to as the category axis.
True.
The set of mathematical rules that Excel follows is called the order of operations.
True
A line that serves as a frame of reference for measurement
Axis
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.
X-axis
The area along the left side of a chart that shows the range of numbers for data points.
Y-axis
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