| A | B |
|---|
| Excel | spreadsheet program used for organizing data and accounting |
| the extension for an Excel workbook | .xlsx |
| Excel file is made up of or called | workbook |
| Workbooks are made up of | worksheet(s) |
| Cells | intersection of a row and column, each little box in Excel |
| rows | horizontal group of cells - numbered - |
| columns | vertical vertical group of cells - lettered |
| tab key | moves from cell to cell within the same row |
| enter key | moves cell to cell within the same column |
| up and down arrows | moves from cell to cell within the same column |
| left and right arrows | moves from cell to cell within the same row |
| to enter data in a cell | double click on the cell or enter it in the formula bar |
| to make data fit within a cell | use the autofit feature |
| name box | you can enter the column letter and row number and navigate to the cell |
| mouse | click one time into a cell and the cell will be selected |
| to enter a formula in Excel begin with the | = (equal sign) |
| To multiply in Excel use the | * (asterisk) |
| To add in Excel use the | + (plus sign) |
| A button that will add cell values automotically | autosum |
| To calculate a formula in Excel press | Enter |
| To format a column into money use the | $ button |
| Sales tax in decimals for Los Angeles | .0975 |
| To calculate subtotal | use autosum or manually add prices |
| To calculate tax | multiply subtotal by .0975 |
| To calculate grand total | add the subtotal to the tax |
| Merge and center | converts many cells into one larger cell and centers the text |
| wrap text | places text on multiple lines within one cell |
| currency style | formats numbers to include dollar sign and two decimal places |
| comma style | formats numbers to include a comma and two decimal places |
| formula | computes mathematical values; always starts with = (equal sign) |
| function | a shortcut for a more complicated formula; found behind the ? button |
