71
1. Use the absolute
cell reference in a
formula.
V
erizon Wireless® operates the nati on's largest and most reliable wireless
voice and 3G network. Headquartered in Basking Ridge, N.J., Verizon
Wireless® is a joint venture of Verizon Communicati ons® and Vodafone®. A
leader in wireless voice and data services, the company built the nati on's fi rst
wide-area wireless broadband network, delivered the nati on's fi rst wireless
consumer 3G multi media service, and launched the most comprehensive
mobile music service in the world. As of October 2010, they service 99.7
million customers and have 79,000 employees.
The following acti vity illustrates how spreadsheets can be used to calculate
percentage of sales for each Smartphone purchased with a two-year contract
as it relates to the total sales for the week.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Bold cell A2 and change the font size to 16 point.
4. Bold and underline rows 12 and 35.
5. Bold cell E11.
6. Format the width of column A to 35.0 and left align.
7. Format the width of columns B D to 15.0 and right align.
8. Format cells B14 D35 as numbers displaying 2 decimal places with a comma
separator.
9. Format the width of column E to 15.0 and right align.
10. Format cells E14 E35 as percentages displaying 2 decimal places.
11. Compute the total for column B, SALES In cell B35, type
=SUM(B14:B33)
12. Compute the formulas for the fi rst Smartphone as follows:
a. TAX=8.625%*SALES In cell C14, type
=8.625%*B14
b. TOTAL=SALES+TAX In cell D14, type
=B14+C14
c. % OF SALES=SALES/TOTAL SALES In cell E14, type
=B14/$B$35
Note: The dollar signs in the % OF SALES formula generates the absolute cell
reference.
13. Use the AutoFill feature to copy the formulas down for the remaining
Smartphones.
14. Enter formulas to total columns C E.
31
Verizon Wireless®
NEW SKILL
ACTIVITY
For Evaluation Purposes Only