Microsoft Excel Unit 1
An Excel file with one or more 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.
The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet.
The active cell contains the cell pointer. There is a dark outline around the active cell.
As you enter data into a cell, it simultaneously appears in the Formula bar, which is located above the worksheet.
The location of a cell in a worksheet as identified by its column letter and row number. Also known as the cell's address.
A way to view locations on the worksheet without changing the active cell.
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.
A new, empty workbook contain three worksheets.
A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets.
Text in the first row or column of a worksheet that identifies the type of data contained there.
The standard settings Excel uses in its software.
The command used to reverse on or a series of editing actions.
The command used to redo an action you have undone.
A feature used to complete an entry based on previous entries made in the column containing the active cell.
A feature used to automate the correction of common typing errors.
A tool used to assist you in finding and correcting typographical or spelling errors.
A number entered in the worksheet.
A number entered in the worksheet as a label, not as a value—such as the year 2005 used as a column label.
An apostrophe (') used to indicate that a number is a label and not a value.
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.
An instruction Excel uses to calculate a number.
Symbols used in mathematical operations.
Order of Mathematical Operations
The order in which Excel performs the calculations specified in a formula.
Upgrade to remove ads