3/30/10 Microsoft Excel Understanding Functions

posted Mar 30, 2010, 5:58 AM by Abdulkader Alriyashi   [ updated Mar 30, 2010, 7:44 AM ]
Please check the attached PDF file. You are required to create a similar spread sheet ( with functions and conditional formatting )
  • Grade book
    • Conditional formatting 
      • Predefined rules 
        • Data bars
        • Color scales
        • Icon sets
      • Create new rules
        • Format cells based on their values 
      • Clear conditional formatting
    • Functions
      • Sum
      • Average
      • count
      • Max  (Maximum)
      • Min (Minimum)
  • How to write a function
    •  = sum(a1,a2,a3,a4,a5)
    •  = sum(a1:a5)

Ċ
Gradesbook.pdf
(20k)
Abdulkader Alriyashi,
Mar 30, 2010, 7:42 AM
v.1
Comments