Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Terms
Excel Basics
| Term | Definition |
|---|---|
| Spreadsheet | used to organize information in cells formed by columns and rows |
| Cell | the intersection of a row and a column |
| Column | vertical columns that are identified by letters |
| Row | horizontal rows that are identified by numbers |
| Cell address | a cells column letter and row number form a cell name (ex |
| Active cell | the current cell that you are working with; it is surrounded by a heavy black outline |
| Range | a block of adjoining cells |
| Range address | consists of the cell address for the upper-left cell, a colon, then for the lower right cell |
| Workbook | a saved spreadsheet file |
| Worksheet | an individual page or sheet within a workbook |
| Worksheet tab | used to identify a worksheet |
| Value | numeric data (numbers) that is entered into a spreadsheet as data that will can be calculated |
| Numeric label | numbers that are entered into a spreadsheet to label information |
| Alphabetic label | text (alphabets or symbols) that is entered into a spreadsheet to label information |
| Chart | provides a graphic image of the data in your spreadsheet. It reveals a trend or compares data |
| AVERAGE Function | calculates the average of all the values in the selected range |
| SUM Function | calculates the cells or range of cells you want to total |
| Fill | used to copy a formula from one cell to a range of adjoining cells |
| MAX Function | finds the maximum (largest) value within the range specified as the argument |
| MIN Function | finds the minimum (smallest) value within the range specified as the argument |
| Function | performs a predefined calculation in a formula to help you create formulas more quickly |
| Formulas | performs calculations on the values |
| Operators | basic formulas use operators to add (+), subtract (-), multiply (*), or divide (/) information |
| Currency format | changes the appearance of the values to dollar values with a dollar sign |
| Cell Style | a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading |
| Percentage format | changes the appearance of the values to a percent |
| Wrap Text | cell formatting that forces text to break into multiple lines within a cell |
Created by:
cebates1
Popular Computers sets