MICROSOFT EXCEL (SPREADSHEET) Flashcards
it allow large set or group of data to be stored, organized, analyzed, and interpreted automatically
spreadsheet
it gives the total of the selected range of cell values. it performs the mathematical operation which is addition
sum ()
it focuses on calculating the average of the selected range of cell values
average ()
it counts the total number of cells in a range that contains a number. it does not include the cell that is blank and the ones that holds data in any other format apart from numeric
count ()
it returns the subtotal in a database.
subtotal
it works on returning the remainder when a particular number is divided by a divisor
modulus
returns the result of a number raised to a certain power
power
it rounds a number up to its nearest multiple of significance
ceiling
rounds a number down to the nearest multiple of significance
floor
it merges or joins several text strings into one text string
concatenate
it returns the total number of characters in a string. it will count the overall characters, including spaces and special characters
len
works on replacing the part of a text string with a different text string
replace
replaces the existing text with a new text in text string
substitute
converts any text string to uppercase
upper
converts any text string to lowercase
lower
converts any text string to proper case
proper
it gives the number of characters from the start of a text string
left
returns the characters from the middle of a text string
mid
returns the number of characters from the end of a text string
right ()
gives the current system date and time
now ()
provides the current system dateg
today ()
generates the hour from a time value as a number from 0-23
hour, minute, second
converts hours, minutes, seconds given us numbers to an excel serial number, formatted with a time format
time ()
provides the difference between two dates in terms of years, months, or days
datedif
it stands for the vertical lookup that is responsible for looking for a particular value in the leftmost column of a table
vlookup
it is the value that you have to look for in the first column of a table
lookup_value
indicates the table from which the value is retrieved
table
the column in the table from the value is to be retrieved
col_index
approximate match
TRUE
exact match
FALSE
looks for a value in the top row of a table or array of benefits
hlookup
checks a given condition and returns a particular value if it is TRUE. it will return another value if the condition is FALSE
IF ()
it is used to return a value in a column to the left. with this, you are stuck returning an appraisal from a column to the right
index-match
it is used to count the total number of cells within a range that meet the given condition
countif()
