Unit V Homework
For this homework assignment, complete the following
projects, which involve navigating within Microsoft Excel and using several of
the moderate features.
Complete Project 4-1: Basic Formulas on page 505.
Click here to access the 2013_output file, and save it as
project_4-1_formulas.
Complete Project 4-2: Range Names on page 505.
Click here to access the 4-2-source file, and save it as
project_4-2_range_names.
Complete Project 5-1: Creating a Simple Chart on page 535.
Create a new blank Excel worksheet, and save it as project_5-1_simple_chart.
Complete Project 5-2: Chart Elements page 535.
Click here to access the 5-2-source file, and save it as
project_5-2_elements.
Complete Project 6-1: Filtering Lists on page 562.
Click here to access the state_rankings file, and save it as
project_6-1_filters.
Complete Project 6-2: More Sorts on page 562.
Click here to access the 6-2-source file, click here to open
the project file, and save it as project_6-2_sorting.
Be sure to save and upload all six (6) files in Blackboard
for grading. Click here to access a brief tutorial on uploading more than one
file for one assignment.
Information about accessing the Blackboard Grading Rubric
for this assignment is provided below.





