click below
click below
Normal Size Small Size show me how
IS15:PCConcepts
Excel
Action | Method |
---|---|
When you delete a row/column, what does it delete? | The entire row/column and all information pertaining to those cells |
SUM | Adds all the numbers in a range of cells |
MIN | Find the smallest number in a range of cells |
MAX | Finds the maximum number in a range of cells |
COUNT | Counts the number of variables in a range of cells |
=now() | gives current date and time |
Creating Percentages | Cell/Cell, press percentages sign while it is selected |
How to create an absolute reference | Meaning "fixed" reference, place a $ before the column and row |
Selecting non-adjacent cells | Select first cell, hold CTRL, and select additional cells |
Advanced Formulas | Complex formulas with a formula within a formula, like "solving for x" ie. 2+2+x=6 |
Filling Adjacent cells | Click the cell, grab the cell handle at the bottom right and drag to fill adjacent cells |
Fill formatting only | Click the cell, grab the cell handle and fill adjacent cells, click the auto fill options button, click "fill formatting only" |
Function, f4 does what? | Creates an absolute reference in relation to the selected cell |
Formula for SUM | =SUM(Cell1:Cell2) |