Answer following questions
16. Answer the question below. Use the rubric in materials for help if needed. Shaden is working on the spreadsheet shown below in Microsoft Excel. She has never used the Text to Columns feature before, but she needs to separate the data in column C. Explain how she should do this. Identify at least one common mistake users make during this process and how to correct it. Use details to support your answer. A B C D E F G Lin's Lawn Care Service W N - Date Client Address Mileage Time (hrs) Cost Reason 1-Feb Clifford Beula 1392 Keystone Dr, Monro, VA, 20149 12 1.25 $0.00 New client estimate 1-Feb Major Phillips 362 Reynoldane, Ashley, VA, 20134 16 $0.00 Second treatment 1-Feb Rayna Key 441 Birchbend Ave, Richland, VA, 20291 6 1.75 $1.50 Toll charge; second treatment 1-Feb Steven Depot 7552 Loughman Circle, Richland, VA, 2029 19 1.25 $0.00 Pick up payment; consultation with potential new client 1-Feb Doug Chin 2629 Skyline Dr, West Bend, VA, 29130 8 1.75 $1.50 Toll charge; third treatment 10 00 2-Feb Teresa Laverne 1402 Briton Road, Harrison, VA, 29123 15 2 $1.50 Toll charge; new client estimate 10 2-Feb Kev Turisi 429 Avenue A, River Springs, VA, 29304 2 $0.00 First treatment 11 2-Feb Reggie Lewis 336 Mortimer Ave, Richland, VA, 20291 1.75 $1.50 Toll charge; second treatment 12 2-Feb Asia Sun 528 West Fifth St, Ashley, VA, 20134 15 2 $0.00 Third treatment 13 2-Feb Sean Simmons 16 Soo St, North Country, VA, 20421 8 1 $0.00 Second treatmentAll mange; haveu 22. Shaden wants to create filters on a Microsoft Excel spreadsheet she is creating. What steps should she take to do this? 0 She should click on the Data tab, right-click and choose Sort, and then click on Filter. 0 She should select the data, click on the Data tab, and then click on Filter. 0 She should click on the Data tab, click on Sort, and then click on Filter. 0 She should click on the Data tab, click on Sort, and click on Filter. 23. Shaden has been asked to design a spreadsheet for a new client. Before she can create the spreadsheet, which of the following questions must she answer? 0 Will the spreadsheet t neatly on one page? 0 When is the spreadsheet due? 0 Do the results make sense? 0 Is the work correct? 18. Lola is creating a spreadsheet for a school project in Microsoft Excel. She shades cell A1 with yellow and cell B]. with blue. She wants to continue this pattern across the row to cell 21. What Is the fastest way to do this? 0 Lola should highlight the pattern then use the Fill Down feature. 0 Lola should copy the pattern and paste it until she gets to cell 21. O Lola should use the Table option to create the pattern. Then, she can select the cells and apply the table to the cells. 0 Lola should highlight the two-cell pattern, hover over the square in the bottom right of the highlighted selection, and then click and drag to the right to ll the pattern across the row to 21. 20. Saba Lin is trying to figure out how to minimize his costs. He has created the following spreadsheet. How would this spreadsheet be more beneficial to Saba? D E G Lin's Lawn Care Service Date Client Address Mileage Time (hrs) Cost Reason AW 1-Feb Clifford Beula 1392 Keystone Dr, Monro, VA, 20149 12 1.25 $0.00 New client estimate 1-Feb Major Phillips 362 Reynoldane, Ashley, VA, 20134 16 $0.00 Second treatment 1-Feb Rayna Key 441 Birchbend Ave, Richland, VA, 20291 6 1.75 $1.50 Toll charge; second treatment 1-Feb Steven Depot 7552 Loughman Circle, Richland, VA, 2029 19 1.25 $0.00 Pick up payment; consultation with potential new client 1-Feb Doug Chin 2629 Skyline Dr, West Bend, VA, 29130 8 1.75 $1.50 Toll charge; third treatment 2-Feb Teresa Laverne 1402 Briton Road, Harrison, VA, 29123 15 2 $1.50 Toll charge; new client estimate 10 2-Feb Kev Turisi 429 Avenue A, River Springs, VA, 29304 9 IN $0.00 First treatment 11 2-Feb Reggie Lewis 336 Mortimer Ave, Richland, VA, 20291 5 1.75 $1.50 Toll charge; second treatment 12 2-Feb Asia Sun 528 West Fifth St, Ashley, VA, 20134 15 2 $0.00 Third treatment 13 2-Feb Sean Simmons 16 Soo St, North Country, VA, 20421 8 1 $0.00 Second treatment O Street, city, and state, as well as tolls and reasons, should be separated into their own columns. O The dates and travel times are not necessary and should be removed. O The mileage, time, and cost columns should be totaled at the bottom. This spreadsheet is formatted to clearly show everything needed to analyze the required information.17. James is working on a spreadsheet in Microsoft Excel and wants to change the data from row to column format. What is the best way to do this? O by selecting each cell and pasting each one in the new spot of the column O by selecting the new column then choosing Paste by selecting Paste Special and then Transpose O by selecting the new column then choosing Keep Source FormattingAll changes saved 24. Use the following Microsoft Excel spreadsheet to answer the question below. A B C D 1 Student Exam 1 Score Pass/Fail Comments 2 Tom 85 3 Ryan 59 4 Latisha 92 5 Kate 88 What wlll be the result If the formula :IF(B2>80,\" Well done!\14. Answer the question below. Use the rubric in materials for help if needed. Evaluate the Microsoft Excel spreadsheet below. Identify the column(s) that could benefit from using an IF formula. Then, choose one column and explain how applying the IF formula would benefit that column. Use details to support your answer. D E F G Lin's Lawn Care Service Date Client Address Mileage Time (hrs) Cost Reason 1-Feb Clifford Beula 1392 Keystone Dr, Monro, VA, 20149 12 1.25 $0.00 New client estimate 16 un 1-Feb Major Phillips 362 Reynoldane, Ashley, VA, 20134 $0.00 Second treatment 1-Feb Rayna Key 441 Birchbend Ave, Richland, VA, 20291 6 1.75 $1.50 Toll charge; second treatment 1-Feb Steven Depot 7552 Loughman Circle, Richland, VA, 2029 19 1.25 $0.00 Pick up payment; consultation with potential new client 1-Feb Doug Chin 2629 Skyline Dr, West Bend, VA, 29130 8 1.75 $1.50 Toll charge; third treatment 1 00 2-Feb Teresa Laverne 1402 Briton Road, Harrison, VA, 29123 15 2 $1.50 Toll charge; new client estimate 10 2-Feb Kev Turisi 429 Avenue A, River Springs, VA, 29304 2 $0.00 First treatment 11 2-Feb Reggie Lewis 336 Mortimer Ave, Richland, VA, 20291 1.75 $1.50 Toll charge; second treatment 12 2-Feb Asia Sun 528 West Fifth St, Ashley, VA, 20134 15 2 $0.00 Third treatment 13 2-Feb Sean Simmons 16 Soo St, North Country, VA, 20421 8 1 $0.00 Second treatment19. Percy wants to create a new range In a spreadsheet In Microsoft Excel. where In Excel would he go to do this? 0 He should highlight the selection, right-click it, and then choose Format Cells. 0 He should go to the Formulas tab and then Name Manager. 0 He should go to the Data mb and then click on Get Data. 0 He should go to the Review tab and then Allow Edit Ranges. All changes saved 21. Marvel has been asked to prep a spreadsheet in Microsolt Excel for a presentation with a client. She wants the client to see the final numbers but not the calculations. How should she manipulate the spreadsheet? 0 She should use images to cover the calculations. 0 She should hide the rows and columns that contain calculations. 0 Marvel's best option is to retype the data in a new spreadsheet without the calculations. 0 Marvel should delete the rows and columns that contain the calculations
