BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 16

Apply formatting to your spreadsheet.
Your goal is to take into consideration readability, reliability, and reusability. Remember that presentation has an impact on the viewer,
and professional appearance is important for reporting data, just as
personal appearance impacts perception. The goal is to make the
data more readable, and possibly to highlight data that might
otherwise be lost in many numbers.
The minimum formatting requirements (per the Grading Rubric) are:
Title Rows formatted as titles
Font Size changes
Color Changes
Use of Shading and Borders
Currency and numeric formatting
Note: Refer to the Formatting video in the lesson tutorials for help
with this step.
STEP 4: Add Formulas
A.
Create the formulas needed to calculate the following for each
item:
Net Selling Price = Selling Price * (1 - Sales Discount)
Total Sales = Sum(Daily Sales) * Net Selling Price
Total Profit = Total Sales - (Cost per item * sum(Daily Sales))