EXCEL

EXCEL

Print FlashCard
Term Definition
Worksheet A spreadsheet that contains formulas, functions, values, text, and visual aids.
Fill handle is the small black square at the bottom right corner of the 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 content (text,value,data,formula) in an active cell
Select all click it to select everything contained in the active worksheet.
Column Heading The letters above the columns.
Row heading the numbers to the left of the arrows.
Sheet tabs located at the bottom-left corner of the window, shows the names of the worksheets contained in the workbook. can be renamed.
Insert Worksheet click this button to add a new worksheet to the workbook
Sheet Navigation Button if the workbook contains several worksheets, they may not be displayed so use this button to display the first, previous, next to last and 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 cell by a column letter and a row number
Active cell the current cell, indicated by a dark border.
Arrow Keys move cell by one in the direction of the pressed arrow.
Tab Key move right one cell in the same row.
Text includes letters, numbers, symbols, and spaces.
Value is a number that represents a quantity or amount.
Formula is a combination of cell references, operators, values, and or functions used to perform a calculation. ALL FORMULAS MUST BEGIN WITH AN = 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 *