Worksheet/Spreadsheet Formula Bar
a sub-component document of a workbook. It is also
called spreadsheets; you can have multiple sheets Nestled between the workbook and ribbon, the
nestled in a workbook. Formula Bar will display the contents of an active cell. In
the case of formulas, the formula bar will display all
Active worksheet. components of the formula.
indicate which of your worksheets you are presently
working on; Function
are formulas that are pre-built into Excel. They are
Cell intended to help simplify hypothetically complex
A cell is an intersection between a column and a row on formulas in a worksheet.
a spreadsheet.
Error Code
Columns and Rows Error Codes appear if Excel finds a problem with a
Columns and Rows refer to how your cells are aligned. formula provided.
Rows are aligned horizontally while columns are aligned
vertically. Cell Formatting
is the act of changing how a cell or its contents are
Column and Row Headings displayed in the spreadsheet.
These headings are the lettered and numbered gray
areas located just outside of columns and rows. Filters
are guidelines that you can employ to choose which
Ribbon rows in a worksheet to display.
is a segment of command tabs AutoFill
This enables you to copy data to more than one cell
Cell Reference easily.
a set of coordinates that classifies a specific cell. It's a
combination of letters and numbers AutoSum
This feature will add up the numbers you have entered
Cell Range in your sheet and displays the total in a cell of your
a cluster of cells that have been identified as a group choice.
based on a variety of criteria. By using a colon (:)
between cell references AutoFormat
array This is an automatic format application to cells that
A range in a row match pre-determined conditions
Merged Cell Pivot Table
When two or more cells are united This is a data summarization tool most commonly used
to sort, average, to sum up, data automatically.
Template
a formatted workbook or worksheet intended to help Pivot Area
users fulfill a specific need in Excel. where you would drag a Pivot Table field to rearrange
Example: Grading Sheet, Payroll Sheet how a report is displayed.
Operator Source Data
specify the type of calculation that you want to perform information used to create your pivot table. It can
on elements in a formula either exist within the worksheet or from an external
database.
Formula
A sequence inside a cell that is used to produce value is Values Area
called formula. It must begin with an equality sign (=). the cells that contain the direct information.