Topic 2 - Spreadsheets

Study Unit 4 / 5: Exam – Formulas

15 FUNCTIONS YOU NEED TO KNOW USING EXCEL OFF BY HEART

USE AN EQUAL SIGN TO BEGIN THE FUNCTION
SPECIFY THE FUNCTION NAME
ENCLOSE ALL OF THE FUNCTION’S ARGUMENTS WITHIN PARENTHESES
USE A COMMA TO SEPARATE THE FUNCTION’S INDIVIDUAL ARGUMENTS

Combining text /values with & =( & )
COUNTIF =COUNTIF(range,argument)
SUM =SUM( )
ROUND =ROUND(NUMBER, NUMBER OF DIGITS)
AVERAGE =AVERAGE( )
MAX =MAX( )
MIN =MIN( )
IF =IF(logical_test,Value_if_True,Value_if_False)
LEFT =LEFT( )
MID =MID( )
RIGHT =RIGHT( )
PMT =PMT(rate,nper,pv,fv,type)
FV =FV(rate,nper,pmt,pv,type)
PV =PV(rate,nper,pmt,fv,type)
VLOOKUP =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Study Unit 4 / 5: Creating user-friendly spreadsheets (Prev Lesson)
(Next Lesson) Study Unit 4 / 5: Exam – Operators
Back to Topic 2 – Spreadsheets

No Comments

Comments are closed.