etech 1

excel

Contains information and numbers also called advanced spreadsheet

column headers

Set of letters found at the top of the spreadsheet

Row headers

The set of numbers found on the left side of the spreadsheet

cells

each box in the spreadsheet are called

active cell

a selected cell is called

autofill cell

the green border of an active cell is called

ctrl

to select multiple cells in different locations click

$

What sign would make a value an absolute reference from a relative reference

‘

this changes a value into text

Concatenate

Joins several strings into one text string

min

Find slowest value from list of numbers

max

Finds the highest value from a list of numbers

rand

Generates a number between 0 to 1

randbetween

Generates random numbers between lower and upper bounds

count

Determines the number of cells that contain numbers

counti

determines the number of cells that matches the given condition

counta

Determines of cells that is not empty

countblank

Determines the number of cells that is empty

sum

Finds the total of a set of numbers

sumi

Finds the sum of numbers that fits the condition within a range

sumifs

Finds the sum of numbers that fit the sets of conditions

average

Find the mean of a set

averagei

Fancy average of numbers within a range that meets the given condition

averageifs

Finds the average of numbers within a range that meets the sets of conditions

Median

Finds the central number from a sorted data set

mode

Finds the most frequent value of a sorted data set

round

Simplifies numbers to the number of decimal digits required to be rounded off

rept

Repeats a text string by a number of times

or

Chats for one criterion to be true if it matches if not false

and

Checks for multiple criterion to be true if none false

if

Creates logical result when condition fits and if the condition doesn't fit

vlookup

Quickly look for an information with in the required condition for which it matches to specific information being requested in a record for a specific column

lookup_value

Option where your tight variables will go to look for the values in the cells of the larger table for information

table_array

Sets the range of the large table from where the information will be drawn sets the extent of the data you want to pick

col_index_num

This command box specifies the column from where data has to be pulled

range_lookup

True gives a set of info closest to what is desired false gives the exact value you are looking for and show NA when not found

combin

Solves for basic combination

permut

Solves basic permutation

fact

Solves factorials

sqrt

Finds the square root of a number

roman

Converts arabic to numerals in text form

arabic

Convert roman to numerals in number form

rank

Shows descending or ascending of numbers 0 for descent 1 for ascend