Create an account
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.
The _______ command enables you to specify rows and columns to repeat on each printed page.
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.
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.
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.
A text value or _______ usually provides information about number values in other worksheet cells.
The ______ command joins selected cells into one larger cell and centers the contents of the new cell.
Merge & Center
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
The Comma Style button formats the selected cell as a percentage rounded to the nearest hundredth.
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.
Displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average.
The order in which the data series in pie charts are plotted in Excel is determined by the order of the data on the _______.
________ refers to the process of changing the values in cells to see how those changes affect the outcome of formulas in your worksheet.
______ find(s) the input needed in one cell to arrive at the desired result in another cell.
When writing a formula in Excel, use _____ to communicate the order in which the operations should occur.
_______ 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.
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.
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).
The area along the bottom of a chart that identifies the categories of data is referred to as the category axis.
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together