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 . item :
Create the formulas needed to calculate the following for each
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 ))