QUESTION 1 Using lab 1 part 1, what is the formula that should be in cell G14 using all the proper absolute and relative referencing? a =(C3/E3)+G$7+(G$8*$C14) O b. =(C3/E3)+G7+(G8*C14) OC. =($C$3/$E$3)+G$7+(G8*C14 O d.=($C$3/$E$3)+G$7+(G$8*$C14) QUESTION 2 What is the cost of a phone and plan that has a phone rental cost of $152, uses 2.000 MB of data and has a fixed service cost and variable cost per MB equal to those on plan D? (Round answer to two decimal places) QUESTION 3 What is (are) the error(s) with the data copied over in part 2 of lab 1? O a Inconsistent formatting (bolding, font, size, etc) O b. All of these OC. November 2016 total number is formatted wrong O d. Partially abbreviated months QUESTION 4 What are some ways to format an Excel document, in general? I a. Number O b. Font I c. Solver d. Alignment e. Data Analysis Styles QUESTION 5 How many times does the number 64 show up in the fourth question on the scavenger hunt? (Answer with whole number) QUESTION 6 (day of the week) and start at Virtual lab office hours are held on Blackboard Collaborate on pm QUESTION 6 (day of the week) and start at Virtual lab office hours are held on Blackboard Collaborate on pm QUESTION 7 Select all that you think are reasons that you should attend and complete each lab. A. There are assignments worth grades B. To increase your critical thinking skills O C. Reinforcement of concepts I D. To increase your Excel knowledge QUESTION 8 Your lab instructor graduated from the University of in August of 2020 with a Masters of Professional Accounting Phone Rental Cost Months In Year 12 D A 30.00 $ 0.10 $ B 35.00 $ 0.09 $ 40.00 $ 0.08 $ 45.00 0.07 TOTAL MONTHLY COST: PLAN: Fixed Service Cost: $ Variable Cost (per MB): $ 100 150 200 250 500 1000 1500 2000 4000 5000 10000 Data Airport Data Airport Data Month January February March April May June July August September October November December Total Domestic 426,381 413,219 462,812 461,704 523,078 522,120 598,181 632,864 518,014 513,647 457,704 488,598 6,018,322 2017 Transborder International 84,817 60,541 83,376 53,681 90,462 55,594 86,993 55,809 64,615 28,136 53,961 21,383 61,441 29,505 61,105 28,813 59,766 21,090 70,003 19,684 81,073 43,681 82,221 56,222 879,833 474,139 Total 571,739 550,276 608,868 604,506 615,829 597,464 689,127 722,782 598,870 603,334 582,458 627,041 7,372,294 Month January February March April May June July August September October November December Total Domestic 398,154 380,918 421,422 413,376 438,699 490,913 559,446 583,402 493,555 472,385 405,582 469,059 5,526,911 2015 Transborder International 118,217 65,690 119,725 60,969 129,143 63,210 119,259 60,059 95,149 31,653 82,097 25,460 93,494 30,639 93,632 32,932 81,253 27,317 96,954 25,577 99,231 46,170 100,052 56,125 1,228,206 525,801 Total 582,061 561,612 613,775 592,694 565,501 598,470 683,579 709,966 602,125 594,916 550,983 625,236 7,280,918 Month January February March April May June July August September October November December Total Domestic 400,033 397,925 426,708 399,485 492,660 497,579 559,097 586,241 503,743 491,675 421,246 459,720 5,636,112 2016 Transborder International 96,994 65,361 95,166 61,089 95,474 56,139 85,929 49,708 70,524 28,779 62,983 22,788 60,200 25,707 57,193 26,074 61,749 23,384 72,268 22,180 78,400 41,402 79,794 51,521 916,674 474,132 Total 562,388 554,180 578,321 535,122 591,963 583,350 645,004 669,508 588,876 586,123 541 048 591,035 6,485,870 Month Jan Feb Mar Apr May June July August September October November December Total Domestic 409,056 392,278 427,133 439,363 459,895 478,107 536,206 572,105 479,005 466,259 405,170 436,015 5,500,592 2014 Transborder International 118,614 56,246 123,450 51,711 140,076 57,590 130,201 49,295 109,223 28,631 91,810 23,288 103,965 26,730 107,846 28,823 91,106 21,438 111,262 20,136 119,512 41,391 124,761 53,981 1,371,826 459,260 Total 583,916 567,439 624,799 618,859 597,749 593,205 666,901 708,774 591,549 597,657 566,073 614,757 7,331,678 QUESTION 1 Using lab 1 part 1, what is the formula that should be in cell G14 using all the proper absolute and relative referencing? a =(C3/E3)+G$7+(G$8*$C14) O b. =(C3/E3)+G7+(G8*C14) OC. =($C$3/$E$3)+G$7+(G8*C14 O d.=($C$3/$E$3)+G$7+(G$8*$C14) QUESTION 2 What is the cost of a phone and plan that has a phone rental cost of $152, uses 2.000 MB of data and has a fixed service cost and variable cost per MB equal to those on plan D? (Round answer to two decimal places) QUESTION 3 What is (are) the error(s) with the data copied over in part 2 of lab 1? O a Inconsistent formatting (bolding, font, size, etc) O b. All of these OC. November 2016 total number is formatted wrong O d. Partially abbreviated months QUESTION 4 What are some ways to format an Excel document, in general? I a. Number O b. Font I c. Solver d. Alignment e. Data Analysis Styles QUESTION 5 How many times does the number 64 show up in the fourth question on the scavenger hunt? (Answer with whole number) QUESTION 6 (day of the week) and start at Virtual lab office hours are held on Blackboard Collaborate on pm QUESTION 6 (day of the week) and start at Virtual lab office hours are held on Blackboard Collaborate on pm QUESTION 7 Select all that you think are reasons that you should attend and complete each lab. A. There are assignments worth grades B. To increase your critical thinking skills O C. Reinforcement of concepts I D. To increase your Excel knowledge QUESTION 8 Your lab instructor graduated from the University of in August of 2020 with a Masters of Professional Accounting Phone Rental Cost Months In Year 12 D A 30.00 $ 0.10 $ B 35.00 $ 0.09 $ 40.00 $ 0.08 $ 45.00 0.07 TOTAL MONTHLY COST: PLAN: Fixed Service Cost: $ Variable Cost (per MB): $ 100 150 200 250 500 1000 1500 2000 4000 5000 10000 Data Airport Data Airport Data Month January February March April May June July August September October November December Total Domestic 426,381 413,219 462,812 461,704 523,078 522,120 598,181 632,864 518,014 513,647 457,704 488,598 6,018,322 2017 Transborder International 84,817 60,541 83,376 53,681 90,462 55,594 86,993 55,809 64,615 28,136 53,961 21,383 61,441 29,505 61,105 28,813 59,766 21,090 70,003 19,684 81,073 43,681 82,221 56,222 879,833 474,139 Total 571,739 550,276 608,868 604,506 615,829 597,464 689,127 722,782 598,870 603,334 582,458 627,041 7,372,294 Month January February March April May June July August September October November December Total Domestic 398,154 380,918 421,422 413,376 438,699 490,913 559,446 583,402 493,555 472,385 405,582 469,059 5,526,911 2015 Transborder International 118,217 65,690 119,725 60,969 129,143 63,210 119,259 60,059 95,149 31,653 82,097 25,460 93,494 30,639 93,632 32,932 81,253 27,317 96,954 25,577 99,231 46,170 100,052 56,125 1,228,206 525,801 Total 582,061 561,612 613,775 592,694 565,501 598,470 683,579 709,966 602,125 594,916 550,983 625,236 7,280,918 Month January February March April May June July August September October November December Total Domestic 400,033 397,925 426,708 399,485 492,660 497,579 559,097 586,241 503,743 491,675 421,246 459,720 5,636,112 2016 Transborder International 96,994 65,361 95,166 61,089 95,474 56,139 85,929 49,708 70,524 28,779 62,983 22,788 60,200 25,707 57,193 26,074 61,749 23,384 72,268 22,180 78,400 41,402 79,794 51,521 916,674 474,132 Total 562,388 554,180 578,321 535,122 591,963 583,350 645,004 669,508 588,876 586,123 541 048 591,035 6,485,870 Month Jan Feb Mar Apr May June July August September October November December Total Domestic 409,056 392,278 427,133 439,363 459,895 478,107 536,206 572,105 479,005 466,259 405,170 436,015 5,500,592 2014 Transborder International 118,614 56,246 123,450 51,711 140,076 57,590 130,201 49,295 109,223 28,631 91,810 23,288 103,965 26,730 107,846 28,823 91,106 21,438 111,262 20,136 119,512 41,391 124,761 53,981 1,371,826 459,260 Total 583,916 567,439 624,799 618,859 597,749 593,205 666,901 708,774 591,549 597,657 566,073 614,757 7,331,678