Section 1 Flashcards by Unknown Unknown

What is excel used for?

Organizign data, statitics, making predictions

How well did you know this?

Not at all

Perfectly

ROWS VS COLUMNS
HOW ARE THEY DISTINGUISHED

Rows are horizontal!!! They are by number
Columns vertical!!!!!!! they are by letter

How well did you know this?

Not at all

Perfectly

What is a cell

Where row and column intersect named by C,R
B1 H3 J18 F23

How well did you know this?

Not at all

Perfectly

Range of cells

A selection of multiple cells

How well did you know this?

Not at all

Perfectly

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 well did you know this?

Not at all

Perfectly

How to insert a function to a cell?

Directly to the cell

INSERT FUNCTION BUTTON

How well did you know this?

Not at all

Perfectly

Name box

What ssays the active cell/ the first cell in the range

How well did you know this?

Not at all

Perfectly

Formula bar

shows content of active cell and lets you edit

How well did you know this?

Not at all

Perfectly

Bottom left is the

WORKSHEET TAB

How well did you know this?

Not at all

Perfectly

Status BAR

BOTTOM RIGHT! SHOWS: sum count average

How well did you know this?

Not at all

Perfectly

Active cell

the cell you are working in!

How well did you know this?

Not at all

Perfectly

Functions
ADD
SUBTRACT
MULTIPLY
DIVIDE
EXPONENNT

=A2+B2
=A2-B1
=A3*A2
=A1/V3
=H1^N4

How well did you know this?

Not at all

Perfectly

How to add without using =X1+R1?

USE AUTOSUM
=(Find the Auto sum button in the home menu)

How well did you know this?

Not at all

Perfectly

which function shoul dyou use to detemine how many cell inputs you have?

=Count(range)

How well did you know this?

Not at all

Perfectly

how to count conditionally

=COUNTIF( RANGE, “—”)
THE “—” CAN BE REPLACED BY >4 ETC.

How well did you know this?

Not at all

Perfectly

What is sumproduct

Gets the products of everything, and then sums it all up!

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

Formatting where are the decimals/whole numbers?

UNDER Menu on our RIBBON! there is everything

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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

1. either =swrt(cell) 2. 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