How can we help?

You can also find more resources in our Help Center.

26 terms

Microsoft Excel Unit 1

STUDY
PLAY
Workbook
An Excel file with one or more worksheet
Worksheet
The work area for entering and calculation data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.
Cell
The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet.
Active Cell
The active cell contains the cell pointer. There is a dark outline around the active cell.
Formula bar
As you enter data into a cell, it simultaneously appears in the Formula bar, which is located above the worksheet.
Cell Reference
The location of a cell in a worksheet as identified by its column letter and row number. Also known as the cell's address.
Scroll
A way to view locations on the worksheet without changing the active cell.
Sheet tabs
Tabs that appear at the bottom of the workbook window, which display the name of each worksheet.
Tab scrolling buttons
Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view.
Blank workbook
A new, empty workbook contain three worksheets.
Template
A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets.
Label
Text in the first row or column of a worksheet that identifies the type of data contained there.
Defaults
The standard settings Excel uses in its software.
Undo
The command used to reverse on or a series of editing actions.
Redo
The command used to redo an action you have undone.
AutoComplete
A feature used to complete an entry based on previous entries made in the column containing the active cell.
AutoCorrect
A feature used to automate the correction of common typing errors.
Spelling Checker
A tool used to assist you in finding and correcting typographical or spelling errors.
Value
A number entered in the worksheet.
Numeric Label
A number entered in the worksheet as a label, not as a value—such as the year 2005 used as a column label.
Label Prefix
An apostrophe (') used to indicate that a number is a label and not a value.
Series
A list of sequential numbers, dates, times, or text.
Standard Column Width
The default number of characters that display in a column based on the default font.
Formula
An instruction Excel uses to calculate a number.
Mathematical Operators
Symbols used in mathematical operations.
Order of Mathematical Operations
The order in which Excel performs the calculations specified in a formula.