Microsoft Office Tutorials and References
In Depth Information
Cases and Places
•• 4: Creating a Table of Companies
Make It Personal
Gather information about companies at which you may want to work in your next job. Obtain information
for at least ten companies in fi ve different states. Include company name, state, city, miles from your current
residence, and assign a rating for each company between 1 and 4, with 4 being the most preferred. Add a
conditional format using the Data Bar format style, edit the formatting rule to show only bars, and change
the width of the column to at least 20 characters. Complete the following sorts, print each sorted version
of the table, and then undo the sorts in preparation for the next sort: (a) alphabetically (A to Z) by state, and
(b) descending (smallest to largest) by miles from home. Filter the list for records with a preference greater
than 2. Print the table and then show all of the records. Group the records by state, using the Average
function in the Use function list in the Subtotal dialog box. Print the worksheet.
•• 5: Creating a Table of Students
Working Together
Have your group design a table that includes a row for each student. The table should contain the
following information: (1) last initial and fi rst initial, (2) gender, (3) age, (4) college start date,
(5) resident state, (6) major, (7) credit hours required for degree, (8) credit hours towards degree,
(9) percent of degree completed (computational fi eld), (10) anticipated graduation year, and (11) letter
grade based on GPA (1 = D, 2 = C, 3 = B, and 4 = A). Use the concepts and techniques introduced
in this chapter to design and create a table from the data collected along with a grade fi eld that cor-
responds to the GPA. Add conditional formatting to the gender, age, percent of degree completed,
and anticipated graduation year fi elds. Also, run sorts, determine subtotals, and use the database,
COUNTIF, and SUMIF functions to generate statistics.
Search JabSto ::

Custom Search