This Excel Quickie assignment provides a good opportunity to learn about or practice using the COUNTIF() function in Excel. For information about the COUNTIF() function, you may want to visit Microsoft’s COUNTIF information page.
This is the first of my quickie assignments, which are meant to be short but very useful for teaching and reviewing valuable Excel skills. These assignments do not include step-by-step instructions. They are meant to be used as formative assessment or possibly as material for walking students through how to complete tasks.
Click here to download Smitty’s Restaurant Item Sales Summary. Student instructions are listed in the textbox contained in the sheet. Remember that there are other, much more advanced skills that could be taught with this simple dataset, so think about ways you can rework the instructions to better target whatever skill you are trying to teach.