2023 You are a leader of a 6 person team in the accounting department of amortgage brokerage You are responsible | Assignment Collections

Computer Science 2023 Wk3 Google Sheet Assignment. Team Expense

2023 You are a leader of a 6 person team in the accounting department of amortgage brokerage You are responsible | Assignment Collections

 

You are a leader of a 6-person team in the accounting department of amortgage brokerage. You are responsible for, among many other things,maintaining a report of your team’s quarterly spending on office supplies,trainings, travel, and professional development. This week you willdemonstrate your understanding of Google Sheets basics by creating asheet, entering data, creating multiple sheets, and styling your teamspreadsheet.1)Open a new Google Sheet2)Name it LastNameFirstName_GoogleAssignment33)Rename the first tab “Team Contacts”4)Paste the following information into the first sheet:Name Phone EmailDaniel
202-555-0117
daniel@initech.comMing
202-555-0187
ming@initech.comBrandon
202-555-0133
brandon@initech.comTamia
202-555-0187
tamia@initech.comGeorge
202-555-0143
george@initech.com

 5) Format the column headers with with a green background fill, center thetext both horizontally and vertically, and bold the text.6) Create two more worksheet tabs7) Rename the second one “Q4 Team Expenses”8) Copy and paste the following information into the Team Expenses tab:October November DecemberContracted Work Wages 1,920.00 2138 1562Office Supplies 257.12 183.76 202.88Hotel Fees 549.87 767.01 189.21Mileage 225.00 378.00 112.50Per Diems 320.00 560.00 80.00Publication/SoftwareSubscriptions80.00 80.00 80.009) Bold all the text in column A and the months in Row 1 and center withinthe cell10) All data should be left justified in the cell11) Use the number formatting tool to style the expense amounts asCurrency12) Finally, you will need to select your data range and protect it. Set yourdata protection permissions to restrict everyone except you from editingthat range.13) Open your third tab and rename it to “Upcoming Project Notes”14) Select A1:G15 and merge the cells into one large box.15) With the cell range still selected, define the range with the name“UpcomingStaffingNeeds”16) Use the link tool to search suggested links and choose one relevantURL to include in this range.
Note: You will need to input text into the

 box first before using the link tool to add the link.
I would suggestusing the word “Staff”17) Select A17:G31 and merge the cells into a second box18) Define this range with the name “BudgetRevisions”19) Find empty space below your Budget Revisions range and enter thecolumn headers in four adjacent cells. Your team will use this table setupas a barebones SWOT analysis template.20) Name this range “StrategicPlanning”21) Shade each column of this table a different color.NOTE: you will need to format your text to move it from the bottom of yourcolumns back to the topStrengths Weaknesses Opportunities Threats22) Share your workbook and set to “anyone with a grantham.edu addresscan EDIT”. Copy and paste the link into your W3 assignment dropbox.

 

We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.

Place Order Now

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational