Page 402 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

Related Exercises:
Question 1: Sales Commission Calculation

Suppose you work as a sales representative and earn a commission based on the total sales amount. Your
commission rate is 5% of total sales. You have a table with sales data for different months.

Month Sales Amount ($) Commission Earned ($)
January $5,000
February $7,500

March $6,200
April $8,000
May $9,500
Calculate the commission earned for each month using a formula with absolute references?

Question 2: Product Inventory Management
Suppose you run a small retail store and want to track the inventory levels of different products. You have a table
with the product names and their current inventory counts:

Product Inventory Count

Product A 100
Product B 50
Product C 75
Product D 120
Product E 80

Calculate the percentage of inventory remaining for each product using a formula with absolute references?
Solution: You can calculate the percentage of inventory remaining as (Inventory Count / Total Inventory) * 100%.
Question 3: Monthly Expense Analysis

Suppose you are analyzing your monthly expenses and want to calculate the percentage of each expense
category relative to the total expenses. You have a table with the expense categories and their amounts:

Category Amount ($)
Groceries $300
Dining Out $200
Utilities $150

Transportation $100
Entertainment $150

Calculate the percentage of each expense category relative to the total expenses using a formula with relative
references?
Solution: You can calculate the percentage of each expense category relative to the total expenses by dividing
the amount of each category by the total expenses, multiplied by 100. Here’s the formula you can use in the
“Percentage of Total Expenses (%)” column:

= (B2 / SUM(B$2:B$6)) * 100

387
CITS : IT & ITES - Computer Software Application - Exercise 66 CITS : IT & ITES - Computer Software Application - Exercise 66