Section 1 Flashcards
What is excel used for?
Organizign data, statitics, making predictions
ROWS VS COLUMNS
HOW ARE THEY DISTINGUISHED
Rows are horizontal!!! They are by number
Columns vertical!!!!!!! they are by letter
What is a cell
Where row and column intersect named by C,R
B1 H3 J18 F23
Range of cells
A selection of multiple cells
Organization of the top of excel
MENU is the one with FIle Home Insert
Ribbon is the big middle one!!!!!! wil cut copy paste
NAME BOX/INSERT FUNCTION/ FORMULA BAR IS WHAT IS RIGHT ABOVE WORKSHEET!
How to insert a function to a cell?
Directly to the cell
OR
INSERT FUNCTION BUTTON
Name box
What ssays the active cell/ the first cell in the range
Formula bar
shows content of active cell and lets you edit
Bottom left is the
WORKSHEET TAB
Status BAR
BOTTOM RIGHT! SHOWS: sum count average
Active cell
the cell you are working in!
Functions
ADD
SUBTRACT
MULTIPLY
DIVIDE
EXPONENNT
=A2+B2
=A2-B1
=A3*A2
=A1/V3
=H1^N4
How to add without using =X1+R1?
USE AUTOSUM
=(Find the Auto sum button in the home menu)
which function shoul dyou use to detemine how many cell inputs you have?
=Count(range)
how to count conditionally
=COUNTIF( RANGE, “—”)
THE “—” CAN BE REPLACED BY >4 ETC.
What is sumproduct
Gets the products of everything, and then sums it all up!
Logic operator- If?
** KEY TO NOTE?
=IF(CELL>4, “YES”, “NO”)
=IF(Cell(logic operation), “true”, “false”)
DONT NEED A QUOTES AROUND THE >4 SIGN HERE BC EXCEL KNOWS WASSUP
Formatting where are the decimals/whole numbers?
UNDER Menu on our RIBBON! there is everything
Formatting:
Decimal
Currencies
Percent
Whole number
Use the -> and <- buttons to adjust
$, or the arrow beside > more acct formats > currency > choose symbol
Click Percent button
COMMA
Conditionnaly formatting?
- click conditionally format
- HIGHLIGHT CELLS RULE, pick rule
- put in number, and then change the colour
How to insert a chart?
- Select entire area
- Insert > choose ur type of chart
EXCEL ERROR MESSAGES
####
#DIV/0!
#NA
#NAME?
#NULL
#NUM!
#REF!
#VALUE!
Cell has negative date/time/column width is not wide
div by 0 or blank cell
No reference cell value available (not necessarily error value)
formula name text not recognized! (wHEN U FORGET “”)
2 or more cell references separated incorrectly by space in aforumla
invalid numeric data for sort of operation!!
reference is invalid
wrong type or argument is used
EXCEL ERROR MESSAGES
####
#DIV/0!
#NA
#NAME?
#NULL
#NUM!
#REF!
#VALUE!
Cell has negative date/time/column width is not wide
div by 0 or blank cell
No reference cell value available (not necessarily error value)
formula name text not recognized! (wHEN U FORGET “”)
2 or more cell references separated incorrectly by space in aforumla
invalid numeric data for sort of operation!!
reference is invalid
wrong type or argument is used
cell reference vs. absolute reference
Cell reference: they move with each new cell!!
absolute reference, will always reference one cell even if you move!!!
How to do absolute references?
When you put the column,row PUT A $ IN FRONT OF BOTH!!!
$E$2 (will refer to the same column adn row)
$E2 (will refer to the same column every time)
E$2 (Will refere to the same row each time)
How to make cell adress?
=ADDRESS(Row num, cell num)
How to find adress
=ADDRESS(ROW#,COLUMN#)
make sure you have the numbers not B1, 1,2
Root fORMULA
ROOT= ^1/2
=(cell)^(1/cell 2)
Growing by a percentage
Dying by a percent
NOTE
what r these
(cell)*(1+—- %)
(Cell)*(1——%)
IT MUST BE IN PERCENTAGE FORMAT!!!!!!!!!!!
FORMULAS
Calculating square root function/ formula
- either =swrt(cell)
- cell^(1/2)
FORMULA VS FUCNTION
Straight up add subtract w/ +-/*
=SUM =AVERAGE =PRODUCT
####
negative date/time
column width is not wide
DIV/0!
Division by zero doesnt work
N/A
no value available
Null
cell references are wrong
YOU put a space in the formula
num!
invalid numeric data (non numbers)
ref!
reference is invalid!!!!!!!
value
wrong argument is being used
name
text in formula not recognized
VALUES vs ARRAYS
when does this apply
Numbesrs, cell reference, cell ranges
cell ranges
Count(value1,value2)
SUPRODUCT(array1, array 2)
How to copy all the data in a sheet to another?
2
TRIANGLE IN TOP LEFT CORNER!!!!!!!!
OR CLICK IN TOP LEFT BOX, CTRL SHIFT RIGHT AND CTRL SHIFT DOWN
What would you do if you need to find a specific cell sections?
FILTER> EDIT> TYPE WHATEVER INTO THE BLANK BOX
What is freeze pane
Basically making sure you can see a select amount of cells even when scrolling
choose a cell to the bottom right of the two rows that you want to see even if you scroll
WHEREVER POSSIBLE DO NOT WHAT?
esp in what sort of scenarios (homework)
TYPE NUMBERS!!!!! YOU SHOULD USE CELL REFERENCE!!
=SUM(XXX)/COUNT(XXX)
NOT COUNT 53 OR WHATEEVER
How to fill a column verticallyy?
Hover over the corner until you can see the white cross and double clikc
How to do equal to more than or less?U
USE THE <= AND >= FORMULAS
WHAT IF CTRL SHIFT GETS TOO MANY CELLS?
U USE THE SHIFT UP AND SHUFT FOWN TO MOVE INDIVIDUALLY UP DOWN
HOW TO SEE ALL FORMULAS
CTRL+APOSTROPHE
GROUP EXERCISES?
DO THE SHEET BEFOR EYOU START QUIZ