'ACE' TERMS
An electronic spreadsheet program used to organize data, analyze information, calculate figures, produce charts and create what-if scenarios.
Excel
run horizontally in a worksheet and are identified by a number in the row heading.
Row Numbers
All formulas begin with what?
=
The box where a row and column intersect.
Cell
What displays the name of each worksheet in the workbook and when clicked on display the pressed worksheet.
Sheet Tabs
Displays the sum of the selected cells directly after the selected cells.
AutoSum
The cell being worked in as indicated by a dark rectangle that outlines the border.
Active Cell
A Workbook is a collection of what?
Worksheets
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Sum
Run vertically on a worksheet and each one is identified by a letter in the column heading.
Column Letters
What command do you click on to add boxes around a cell?
Border
What symbol on the keyboard is used to multiply in Excel?
*
AKA mean, this is calculated by dividing the sum of the values in the set by their number.
Average
What command will reorder data based on several criteria at once?
Sort
What is money received from business transactions called?
Revenue