BUS 237 Study Guide - Final Guide: Sparkline, Microsoft Office 2010, North American Numbering Plan

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 237
• Professor: Zorana Svedic

Document Summary

In this project, you will add data to a worksheet, format cells and numeric values, and create formulas and functions. You will also create and format a column chart and sparklines. Additionally, you will prepare the workbook for printing. For the purpose of grading the project you are required to perform the following tasks: Merge and center the title over the range a1:h1 and then apply the title cell style. Merge and center the subtitle over the range a2:h2 and then apply the heading 1 cell style. In cell f4, enter a function to sum the values in cells b4:e4. Format the ranges b4:f4 and b7:f7 with the accounting number format. Insert a new row between rows 5 and 6. Enter dallas in cell a6, 105985. 12 in cell b6, 98674. 38 in cell c6, 100548. 22 in d6, and 106222. 17 in e6. Copy the function in cell f5 down to cell f6 to sum the values in the new row.