Q Search Sheet 2+ Share 1 AutoSum y DO05 Homework data_eco 321_2020.xls (Compatibility Mode] Home Insert Draw Page Layout Formulas Data Review View * XCu Arial 10 -A A = = 0 EWrap Text General Copy Paste Farmat BI U S A + Merge & Center $ % Conditional Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates A1 x f* Phoenix Boutique D Cell Styles . Insert X. Delete Format Formatting as Tabia Clear Sort & Filter Check for Updates 1 Phoenix que Inventory Cost Year Year 2010 type line Calendar Date 1-DAC Sun 1800 Quicy Magnum 1500 1000 Quincy Quincy cal pay truck delivery Calancar Dato 1-0 Sun 2-De Mon 3-Deal Tue 4-Decl Wed 5- Thu 6-Des Fri 7-09 Sat 8-De Sun 9-De Mon 10 Des Tue 11-Dec Wed 12- :| Tu 13.Das Fri 14 Deg Sat 15-D Sun 18-De Mon 17-Dec Tue 18-Des Wed 19-DeThu 20-Deal Fri 21-Del Sat 22-Bun 23-D Man 24-Des Tue 25-0e9 Wed 26-DecThu 27-Del Fri 20 Des Sat 29-De Sun 30-De Mon 31-Deal Tue 3 Dec Tue 4-Dec Viad 5- THU 6-Dec Fri 7-Dec Set 8-DAC Sun 9-Duc Mur 10 Dec Tue 11-Dec Viad 2-IHI: Tri 13-Dec Fri 14 Dec Sat 15.Dec Su 18-Dec Non 17 Dec Tue 18.Dec Wied 11-1HT: Tri 20-Duc Fri 21 Dnc Gat 22-Dec Sun 23-DAC Mor 24-Duc Tue 400 2000 280 mixed 1200 50 1200 RE-DRI: THI Bunny 27-0cfni 20 Dec sat 29.Dec Sun 30.Duc Mon 11-UMr Tuy Seydligerd By referring to homework data and by using the spreadsheet (or excel) in computer, solve the following questions. Your answers may accompany the computer print out. 1) Fill up the blank for revenue & cost. 2) Calculate the gross profit and generate the income statement. 3) Compute the average daily revenue for weekend (Saturday and Sunday), and for weekday (Mon through Fri), respectively. 4) By using the sort key, fill up the following blanks. Answer Question Number of rainy days Number of sunny days Number of snowy days The biggest sales day The weather condition for that day Q Search Sheet 2+ Share 1 AutoSum y DO05 Homework data_eco 321_2020.xls (Compatibility Mode] Home Insert Draw Page Layout Formulas Data Review View * XCu Arial 10 -A A = = 0 EWrap Text General Copy Paste Farmat BI U S A + Merge & Center $ % Conditional Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates A1 x f* Phoenix Boutique D Cell Styles . Insert X. Delete Format Formatting as Tabia Clear Sort & Filter Check for Updates 1 Phoenix que Inventory Cost Year Year 2010 type line Calendar Date 1-DAC Sun 1800 Quicy Magnum 1500 1000 Quincy Quincy cal pay truck delivery Calancar Dato 1-0 Sun 2-De Mon 3-Deal Tue 4-Decl Wed 5- Thu 6-Des Fri 7-09 Sat 8-De Sun 9-De Mon 10 Des Tue 11-Dec Wed 12- :| Tu 13.Das Fri 14 Deg Sat 15-D Sun 18-De Mon 17-Dec Tue 18-Des Wed 19-DeThu 20-Deal Fri 21-Del Sat 22-Bun 23-D Man 24-Des Tue 25-0e9 Wed 26-DecThu 27-Del Fri 20 Des Sat 29-De Sun 30-De Mon 31-Deal Tue 3 Dec Tue 4-Dec Viad 5- THU 6-Dec Fri 7-Dec Set 8-DAC Sun 9-Duc Mur 10 Dec Tue 11-Dec Viad 2-IHI: Tri 13-Dec Fri 14 Dec Sat 15.Dec Su 18-Dec Non 17 Dec Tue 18.Dec Wied 11-1HT: Tri 20-Duc Fri 21 Dnc Gat 22-Dec Sun 23-DAC Mor 24-Duc Tue 400 2000 280 mixed 1200 50 1200 RE-DRI: THI Bunny 27-0cfni 20 Dec sat 29.Dec Sun 30.Duc Mon 11-UMr Tuy Seydligerd By referring to homework data and by using the spreadsheet (or excel) in computer, solve the following questions. Your answers may accompany the computer print out. 1) Fill up the blank for revenue & cost. 2) Calculate the gross profit and generate the income statement. 3) Compute the average daily revenue for weekend (Saturday and Sunday), and for weekday (Mon through Fri), respectively. 4) By using the sort key, fill up the following blanks. Answer Question Number of rainy days Number of sunny days Number of snowy days The biggest sales day The weather condition for that day