click below
click below
Normal Size Small Size show me how
Excel 2010
Term | Definition |
---|---|
Name Box | Shows the name of the active cell |
Formula Bar | Bar that shows the formula. Also can be typed in to insert a formula into the active cell. |
Active Cell | The cell that is selected. |
Columns | Is named by letters and displays data going up and down. |
Rows | Is named by numbers and displays data going left and right. |
Worksheet tabs | They are like pages in a book |
Cell addresses | Made from the cells column letter and number such as cell A1, A2, B1, B2, etc. |
Shift + Space | Select entire row |
Ctrl + Space | Select entire column |
Ctrl + 9 | Hide selected rows |
Ctrl + 0 | Hide selected columns |
F5 | Go to dialog box |
F2 | Edit active cell |
F4 | Create an absolute, normal, or mixed reference |
Auto Fill | Allows you to fill cells with preset data. |
Equal Sign = | You type this when you begin a formula. |
f(x) | What the "Insert Function" button looks like |
Comment box | Allows you to type comments within a certain cell. |
Range | Group of cells in a worksheet that have been selected |
Contiguous range | Range that consists of a simple connected rectangular group of two or more cells |
Non-contiguous range | Range that consists of two or more non-connected contiguous ranges |
Chart | Visual representation of worksheet data |
Sparkline | Small embedded line graph that illustrates a single trend. |
Values - Number format | Is used to change the appearance of a number or value in a cell in the spreadsheet. |
Cell Style | Allows you to change the look of the active cell |
Document theme | Allows you to put preset themes with different fonts and colors on the entire document |
Conditional formatting | Allows you to put a preset format on certain cells |
AutoFit | Feature in Excel that automatically changes the size of a cell |
Shift + F11 | Create a new worksheet tab |
Alt + = (Autosum) | Shortcut for adding the SUM function in the active cell |