Excel Function Cheat Sheet
Function name Definition
Summary
Average Returns the average of the subject
Max Highest number number in a range
Count
Conditional
CountBlank Counts blanks cells in a range
Join Functions
IF Checks whether a condition is met
Left Returns the specified numbers from a text string
Upper Will upper case all letters in a cell
Text
Concat joins text from a text string
n Cheat Sheet
Formula
Average()
Max()
Countblank()
IF(logical test, Value if true, value if fase)
Left(text,number of characters)
Upper()
Concat(text1, text2…)
EXCEL CLASS 101
First Semester Scores
Posted: December 20th
Students # of Students who did not show up for final
Students
Exam Weight Mike's Marks Maximum Average
Class Summary
Exam 1 20%
Exam 2 20%
Exam 3 20%
Final Exam 40%
Overall
Upper
Student Scores IF
Student ID Exam 1 Exam 2 Exam 3 FINAL EXAM Overall Pass/Fail
Mike 100.0 83.0 79.0 72.0
392-267-4 84.0 91.0 94.0 80.0
393-299-8 55.0 56.0 47.0 65.0
394-354-3 95.0 91.0 93.0 94.0
395-423-5 83.0 82.0 76.0 77.0
396-433-8 52.0 66.0 61.0 53.0
397-452-0 85.0 94.0 94.0 91.0
398-485-7 89.0 78.0 80.0 87.0
399-648-6 92.0 87.0 89.0 97.0
400-699-6 74.0 75.0 47.0 64.0
401-260-8 96.0 82.0 91.0 96.0
402-273-8 69.0 74.0 81.0
403-315-1 87.0 89.0 70.0 82.0
404-373-1 100.0 94.0 86.0 93.0
405-383-6 93.0 90.0 95.0 80.0
406-500-8 78.0 89.0 81.0 88.0
407-642-7 74.0 81.0 83.0 86.0
408-865-0 88.0 71.0 84.0 81.0
409-926-7 94.0 90.0 97.0 97.0
410-928-5 83.0 71.0 62.0 87.0
411-248-7 72.0 70.0 88.0 77.0
412-302-1 83.0 76.0 81.0 80.0
413-363-7 89.0 72.0 77.0 73.0
414-475-2 100.0 96.0 90.0 99.0
415-539-3 95.0 96.0 91.0 85.0
416-709-8 72.0 49.0 60.0
417-798-4 82.0 61.0 70.0 61.0
418-834-1 82.0 71.0 64.0 70.0
419-181-6 76.0 69.0 58.0 70.0
420-254-4 90.0 76.0 91.0 71.0
421-287-6 84.0 85.0 66.0 74.0
422-332-3 96.0 88.0 94.0 93.0
423-411-8 80.0 74.0 75.0 82.0
424-440-4 86.0 85.0 85.0
425-552-0 100.0 96.0 87.0 94.0
426-792-5 78.0 60.0 87.0 70.0
Countblank Max
Average
Count Blank
IF
Left
Upper
Concat
Concat LEFT
Email Code
