Microsoft Excel

Microsoft Excel

Print FlashCard
Term Definition
Worksheet A spreadsheet that contains formulas, functions, values, text and visual aids
Fill Handle small black square at the bottom right corner of a cell
Name Box Displays the address of the cell currently used in the worksheet
Insert Function clicking on this enables you to search for and select a function to insert into the active cell
Spreadsheet An electronic file that contains a grid of columns and rows containing related data
Formula Bar Displays the context (text, value, date, or formula) in the active cell
Select All Click it to select everything contained in the active worksheet
Column Heading The letters above the columns, such as A, B, C, and so on
Row Heading The numbers to the left of the rows, such as 1, 2, 3, and so on
Sheet Tabs Located at the bottom-left corner of the window, shows the names of the worksheets contained in the workbook; defaults are Sheet 1, Sheet 2, and Sheet 3. You can rename these and also insert more worksheets
Insert Worksheet Click this button to add a new worksheet to the workbook
Sheet Navigation Buttons If the workbook contains several worksheets they may not all be displayed so use this button to display the first, previous, next to last, or last worksheet
Status Bar Located at the bottom of the window, it displays information about a selected command or operation progress
Cell Is the intersection of a column and a row
Cell Address Identifies a call by a column letter and a row number
Active Cell The current cell, indicated by a dark border
Arrow Keys Move one cell in the direction of the arrow
Tab Key Moves right one cell in the same row
Text Includes letters, numbers, symbols, and spaces
Value Is a number that represents a quantity or an amount
Formula Is a combination of cell references, operators, values, and/or functions used to perform a calculation. All formulas must BEGIN with an EQUAL SIGN (=)
Auto Fill Allows you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells
Workbook A file containing related worksheets

Leave a Reply

Your email address will not be published. Required fields are marked *