Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Budget Allocation and Sales Data for July 2020, Exercises of MS Microsoft Office skills

Vietnam Maritime University (VMU)MS Microsoft Office skills

A detailed breakdown of budget allocations and expenses for various categories, teams, and operations during July 2020. It includes spending on people, infrastructure, travel & entertainment, and IT distributions, as well as sales data and product information. The document also includes calculations for total spending, average spending, maximum spending, and minimum spending.

What you will learn

  • What is the average spending in July 2020?
  • What is the maximum spending in July 2020?
  • What is the total spending in July 2020?

Typology: Exercises

2021/2022

Uploaded on 04/06/2022

linhntd.2001
linhntd.2001 🇻🇳

1 document

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Team Category Type Line Item Fiscal Month
Operations People Infrastructure WW IT Distributions July 2020
Marketing People Infrastructure WW IT Distributions July 2020
Marketing Shared Operations Allocated Azure Compute July 2020
Engineering People Infrastructure WW IT Distributions July 2020
Engineering Shared Operations Allocated Azure Storage July 2020
Engineering Shared Operations Allocated Azure July 2020
Sales People Infrastructure WW IT Distributions July 2020
General Mana
Shared Operations Allocated Azure Compute July 2020
Satellite Opera
Shared Operations Allocated Azure Compute July 2020
Operations People Other People Travel & Entertainment July 2020
Marketing People Other People Travel & Entertainment July 2020
Sales People Other People Travel & Entertainment July 2020
Support People Other People Travel & Entertainment July 2020
Hardware People Other People Travel & Entertainment July 2020
IT People Other People Travel & Entertainment July 2020
Question 1: What is the total spending in July 2020?
Question 2: What is the average spending in July 2020?
Question 3: What is the maximum spending in July 2020?
Question 4: What is the minimum spending in July 2020?
Question 5: What is the average between the maximum and the minimum?
pf3
pf4
pf5

Partial preview of the text

Download Budget Allocation and Sales Data for July 2020 and more Exercises MS Microsoft Office skills in PDF only on Docsity!

Team Category Type Line Item Fiscal Month Operations People Infrastructure WW IT Distributions July 2020 Marketing People Infrastructure WW IT Distributions July 2020 Marketing Shared Operations Allocated Azure Compute July 2020 Engineering People Infrastructure WW IT Distributions July 2020 Engineering Shared Operations Allocated Azure Storage July 2020 Engineering Shared Operations Allocated Azure July 2020 Sales People Infrastructure WW IT Distributions July 2020 General ManaShared Operations Allocated Azure Compute July 2020 Satellite OperaShared Operations Allocated Azure Compute July 2020 Operations People Other People Travel & Entertainment July 2020 Marketing People Other People Travel & Entertainment July 2020 Sales People Other People Travel & Entertainment July 2020 Support People Other People Travel & Entertainment July 2020 Hardware People Other People Travel & Entertainment July 2020 IT People Other People Travel & Entertainment July 2020 Question 1: What is the total spending in July 2020? Question 2: What is the average spending in July 2020? Question 3: What is the maximum spending in July 2020? Question 4: What is the minimum spending in July 2020? Question 5: What is the average between the maximum and the minimum?

Spend

Value 1 Value 2 Value 3 Value 4 Value 5 Result 1 2 3 4 5 7 1 9 9 6 5 4 6 2 3 2 7 5 2 7 0 4 5 2 3 -5 6 5 A B C 5 4 2 3 8 9 5 1 6 6 9 -4 -2 6 -5 2 1/2 5 3/4 1/2 10 Fill in Result column by multiplying all values.

Category Product Area Retail Price in $ Sale in $ Hardware Keyboard California 20 2500 Hardware Mouse Tennesse 15 3000 Software Mother-board New York 100 12000 Software CPU Ohio 700 70000 Hardware Cables Utah 70 3000 Hardware Monitor Colarado 500 5000 Product Sale in $ Keyboard 2500 Cables CPU Monitor Mouse Mother-board Fill in Sale in $ column based on the first table.

Sales Person Total Sales Rank of Sales

  • $ 4,
  • $ 5,
  • $
    • $ 61,
  • $
    • $ 5,
    • $ 4,
      • $
      • $
    • $ 1,
    • $ 35,
    • $ 1,
    • $ 3,
    • $ 18,
    • $ 3,
    • 5.7845 Number Digits Result Fill in Result column based on Number and Digits column.
    • 5.7845
    • 5.7845
  • 23542.5
  • 23542.5 -
  • 23542.5 -
  • 23542.5 -
  • 23542.5 -
  • Mike Peterson $ 1,569.
  • Jacob Webber $ 987.
  • Linda Max $ 1,340.
  • Lily Rose $ 1,209.
  • John Smith $ 879.
  • David Jacobs $ 987.
  • Ian Douglas $ 1,126.
  • Samantha Finn $ 956.