Grantham University Week 3 Google Sheets Assignment Google Sheet Assignment. please see attachment CS165 W3 Google Sheets Assignment You are a leader of a

Grantham University Week 3 Google Sheets Assignment Google Sheet Assignment. please see attachment CS165
W3 Google Sheets Assignment
You are a leader of a 6-person team in the accounting department of a
mortgage 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 will
demonstrate your understanding of Google Sheets basics by creating a
sheet, entering data, creating multiple sheets, and styling your team
spreadsheet.
1)
2)
3)
4)
Open a new Google Sheet
Name it LastNameFirstName_GoogleAssignment3
Rename the first tab “Team Contacts”
Paste the following information into the first sheet:
Name
Phone
Email
Daniel
202-555-0117
daniel@initech.com
Ming
202-555-0187
ming@initech.com
Brandon
202-555-0133
brandon@initech.com
Tamia
202-555-0187
tamia@initech.com
George
202-555-0143
george@initech.com
5) Format the column headers with with a green background fill, center the
text both horizontally and vertically, and bold the text.
6) Create two more worksheet tabs
7) Rename the second one “Q4 Team Expenses”
8) Copy and paste the following information into the Team Expenses tab:
October
November
December
Contracted Work Wages
1,920.00
2138
1562
Office Supplies
257.12
183.76
202.88
Hotel Fees
549.87
767.01
189.21
Mileage
225.00
378.00
112.50
Per Diems
320.00
560.00
80.00
Publication/Software
Subscriptions
80.00
80.00
80.00
9) Bold all the text in column A and the months in Row 1 and center within
the cell
10) All data should be left justified in the cell
11) Use the number formatting tool to style the expense amounts as
Currency
12) Finally, you will need to select your data range and protect it. Set your
data protection permissions to restrict everyone except you from editing
that 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 relevant
URL 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 suggest
using the word “Staff”
17) Select A17:G31 and merge the cells into a second box
18) Define this range with the name “BudgetRevisions”
19) Find empty space below your Budget Revisions range and enter the
column headers in four adjacent cells. Your team will use this table setup
as 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 your
columns back to the top
Strengths
Weaknesses
Opportunities
Threats
22) Share your workbook and set to “anyone with a grantham.edu address
can EDIT”. Copy and paste the link into your W3 assignment dropbox.

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
Grantham University Week 3 Google Sheets Assignment Google Sheet Assignment. please see attachment CS165 W3 Google Sheets Assignment You are a leader of a
Just from $13/Page
Order Essay
Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.

Essays

Essay Writing Service

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.

Admissions

Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.

Reviews

Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.