Assignment #7
(30 points)
- Watch the video
vLookUp Function (MS Excel)
(CC).
- Create a MS Excel spreadsheet similar to the document
developed in the video and shown below.
(Data).
A two-way vLookUp function must be created to allow the user
to find scores based on either the name or the subject area.
Insert your name somewhere in the document.
- Explore the tutorial 10 VLOOKUP Examples For
Beginner & Advanced Users.
Convince the instructor that you understand the key concepts in this tutorial by including
one or more of the following:
a summary of the tutorial, modified formulas similar to those covered in the tutorial,
details, examples, charts, tips you learned, etc.
Add this information (in a separate tab) to the document
created in the previous step.
- Save your work as "assignment7.xlsx" when you are finished.
- Upload this file to YOUR-CLASS-WEBSITE.
Help
|