Create formulas referencing data within a spreadsheet.

The Snowboard Shop Selling Expense Budget For The Year Ended December 31, 2017 First Second Quarter Third Quarter Fourth Quarter Annual Total Rates Comments Quarter 4,000 2,000 2,000 4,000 Luarterly sales hours verage sales hourly rate $ 8.25 25.0% 4.5% Sales Hours X Rate Times sales salaries Times net sales ales Salaries ayroll taxes and benefits ommissions dvertising core Rent and Utilities ternet and Phone epreciation Expense otal Selling Expenses otes dvertising Q1 and Q4 $6,000 each, Q2 and Q3 $2,000 each core rent and Utilities $5,500 per quarter nternet and Phone $2,000 per quarter epreciation - $2,500 per quarter alculate all subtotals and totals opy formulas using relative or absolute references to save time armat xcept where otherwise noted, use Number format","and no decimal places ne 11 and 19 use $ format and no decimal places Take the sheet look like the shell given to you me numbers may not add exactly due to rounding