Docsity
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

Budget Allocation and Sales Data for July 2020, Exercises of 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.