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.





