Search
Create
Log in
Sign up
Log in
Sign up
Excel Functions
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (37)
SQRT
Finds the square root of a number
ROUND
Rounds the number to the number of decimal places given in the second argument. A negative number of decimal places rounds to the left of the decimal
AVERAGE
Calculates the average (or mean) of a range of values
COUNT
Returns the number of cells in the range that contain numeric data
COUNTA
Returns the number of cells in the range that contain any data whether numeric or alphabetic
MAX
Finds the largest value in the range
MIN
Finds the smallest value in the range
STDEV.P
Calculates the standard deviation of the values in the range
IF
Returns one result if the condition is true and another if the condition is false
AND
Returns "True" if all conditions are true and "False" if one or more of the conditions are false
OR
Returns "True" if any of the conditions are true and "False" if none of the conditions are true
TODAY
Returns the current date
NOW
Returns the current date and time
LEFT
Extracts a specified number of characters from the beginning of a text entry
CONCATENATE
Combines two or more text entries into one
RIGHT
Extracts a specified number of characters from the end of a text entry
PROPER
Converts the first letter of each word to uppercase and all others to lowercase
UPPER
Converts all letters to uppercase
LOWER
Converts all letters to lowercase
5400
What is the result of the following function? =ROUND(5412.892,-2)
ComputerScience (notice no space because it wasn't added to the arguments)
What is the result of the following function if "Computer" is stored in cell D1 and "Science" is stored in cell D2? =CONCATENATE(D1,D2)
=CONCATENATE(D1," ",D2)
If "Computer" is stored in cell D1 and "Science" is stored in cell D2 what function will return "Computer Science" as its result?
=UPPER(CONCATENATE(LEFT(D1,4),LEFT(D2,3)))
If "Computer" is stored in cell D1 and "Science" is stored in cell D2 what function will return "COMPSCI" as its result?
=OR(A1>=5,A2>=5,A3>=5)
What function will return "True" if any one of the values in A1, A2, or A3 is at least 5 and will return "False" if all values are less than 5?
=AND(A1>=5,A2>=5,A3>=5)
What function will return "True" if all values in A1, A2, or A3 are at least 5 and will return "False" if any of the values is less than 5?
4
What will the result of the following function be if the sum of cells A1 and A2 is less than 657? =IF(A1+A2>=657,2^3,2^2)
VLOOKUP
Finds a row in a table based on a given value and returns the specified data from that row
HLOOKUP
Finds a column in a table based on a given value and returns the specified data from that column
CHOOSE
Returns a value from a list of items that are entered as individual arguments in the function; limited to 254 values
COUNTBLANK
Returns the number of cells that do not contain data
3D Cell Reference
Includes the sheet name
!
Separates the sheet name from the cell reference in a 3D cell reference
$
Used in mixed and absolute cell references to keep the column letter and/or the row number from changing when a formula is copied
lookup_value
The argument in VLOOKUP and HLOOKUP functions that identifies the data value that is to be looked for in the table
row_index_num
The argument in HLOOKUP functions that identifies the data to be retrieved from the table
table_array
The argument in VLOOKUP and HLOOKUP functions that identifies the table that holds data
col_index_num
the argument in VLOOKUP functions that identifies the data to be retrieved from the table
;