515-MV – Microsoft EXCEL Lab 1 | My Assignment Tutor

199410-515-MV – Microsoft EXCEL Lab 1 (30%)1) Download the Excel file named Excel Assignment 1_Starting File from Lea or Teams2) Rename the workbook as Excel Lab 1_YourName_StudentID3) Write the following entries into the specified cells:▪ C1: Market Shares of Major Phone Providers in the United States▪ C2: Five Years Cellular Phones Sales▪ A4 to A8 as follow: VerizonATTAll-TelSprintT-Mobile ▪ B3 to B8 as follow: 2016213554323154402513186545152231 ▪ C3 to C8 as follow: 2017655487421325521325199844251325 2▪ D3 to D8 as follow: 2018754665512312521145256455321123 ▪ E3 to E8 as follow: 2019884657554654564879384564564458 ▪ F3 to F8 as follow: 2020922354864458587546584654654854 ▪ G3 : Total Sales▪ A10 : Yearly Sales▪ A11 : Max▪ A12 : Min▪ A13 : Average34) Merge the cells from A1 to G1. Apply the following changes to the title line: I)II)III)Change the horizontal and vertical text alignments as center.Change the row height of row 1 as 35.Change the font, font size, font style and font color as Century, 14, Italic,green/Accent 6/Darker 25%. 5) Merge the cells from B1 to G1. Apply the following changes to the title line: I)II)III)Change the horizontal and vertical text alignments as center.Change the row height of row 2 as 35.Change the font, font size, font style and font color as Century, 14, Italic,Blue/Accent 1/Darker 25%. 6) Using range selection, select the cells from B3 to F3. Then select the cells from A4 to A8.Now change the font, font size and font style of the selected cells as Book Antiqua, 12, bold.7) Using the Sum feature, find and write the sum of cells from B4 to B8 into cell B10.Then copy this cell to C10 through F10.8) Using the Sum feature, find and write the sum of cells from B4 to F4 into cell G4.Then copy this cell to G5 through G8.9) Using the Max function find and write the highest sales of cellphones for 2016 intocell B11. Then copy this cell to C11 through G11.10) Using the Min function find and write the lowest sales of cellphones for 2016 in cell B12.Then copy this cell to C12 through G12.411) Using the Average function find and write the average sales of cellphones for 2016 intocell B13. Then copy this cell to C13 through G13.12) Select the cells from B4 to F8. Change format of the selected cells to Currency withSymbol USD and 0 decimal.13) Change the column width of Column A such that all the texts on this column can fitinto the cells.14) Add a new row above the 3rd row (that is between rows 2 and 3).15) Add outside and inside borders to your table. For the outside border choose athicker line.16) Select the first title (select the merged cell in row 1) and change the cell color togreen/Accent 6/Lighter 80%.17) Select the second title (select the merged cell in row 2) and change the cell color toblue/accent 1/lighter 80%.18) Select the cells B4 to G4 and A5 to A9 (Use Ctrl key). Change the cell color as orange/accent2/lighter 40%.19) Select the cells B4 to G4 and A5 to A9 (Use Ctrl key). Change the cell color as lightgray/background 2/darker 10%.20) Select the cells from B5 to G9. Change the cell color as orange/accent 2/lighter 80%.21) Rename your sheet (Sheet 1) to DATA.522) Create a new sheet and call it SUMMARY.23) Move the sheet SUMMARY as the first sheet in your workbook.24) Link cells A11 to G14 in your DATA sheet to the SUMMARY sheet in cells A3 to G6 (Do NOTuse the copy and paste function).25) Link cells B4 to G4 in your DATA sheet to the SUMMARY sheet in cells B2 to G2 (Do NOT usethe copy and paste function).26) Add the following title in cell C1 in your SUMMARY sheet: Summary of Major Provider Salesin the United States from 2016 to 2020

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

Leave a Reply

Your email address will not be published. Required fields are marked *