Comp25: Review: Excel Quiz 1

This quiz will focus on the following lectures:

• Excel Basics
• Formulas and Functions

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

• Types of data used in Excel cells
• How to create a formula
• Algebraic Order of Operations
• Absolute vs Relative Cell address:
  • When to use one versus the other in formulas
  • How absolute cell addresses affect the outcome of a formula
• Functions
  • What are functions?
  • Know the basic statistical functions in Excel