Comp25: Review: Excel Quiz 1

This quiz will focus on the following lectures:

• Conditional Formulas
• Text & Dates

You should be prepared for the quiz by being familiar with the following:

• Conditional Formulas - Review the hand outs passed out in class
  • =IF(
  • =IF(AND
  • =IF(Or
  • Nested IF Statements
  • =SUMIF(
• Concatenating cells - Combining textual data in Excel
  • Ex: = “Hello, ” & A4 & “!”     Hello, David!
  • =IF(B5>90,"Great Job "&A5,"Work Harder "&A5)
• COUNT Functions
  • =COUNT
  • =COUNTIF
  • =COUNTA
  • =COUNTBLANK