KEMBAR78
IT Project | PDF
Scribd
Upload
775 views3 pages

IT Project

The student needs to attain at least 75% overall to receive a distinction. Their previous semester marks are provided. To determine how many marks are needed in the 4th semester, their required overall score is calculated based on prior marks. A business owner wants to increase profits by 10% by either increasing sales by 5 units or raising prices by Rs 8. The effects of each option on profits must be determined. Current profit figures for various sales and cost scenarios are provided. The scenario manager should be used to show the new profit for each case. Sales data for 10 salesmen over 3 quarters is provided across multiple sheets. The sheets should be consolidated into a single sheet that displays the names, serial numbers and total sales

Uploaded by

gjiya700
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
775 views3 pages

IT Project

The student needs to attain at least 75% overall to receive a distinction. Their previous semester marks are provided. To determine how many marks are needed in the 4th semester, their required overall score is calculated based on prior marks. A business owner wants to increase profits by 10% by either increasing sales by 5 units or raising prices by Rs 8. The effects of each option on profits must be determined. Current profit figures for various sales and cost scenarios are provided. The scenario manager should be used to show the new profit for each case. Sales data for 10 salesmen over 3 quarters is provided across multiple sheets. The sheets should be consolidated into a single sheet that displays the names, serial numbers and total sales

Uploaded by

gjiya700
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

1.

A student is planning her goals about the marks she should attain in the forthcoming Semester 4
examinations in order to achieve a distinction (75%). Assuming that examination of each subject is for 100
marks, her marks of the previous semesters are given as under. Find out how many marks should she obtain in
4th semester to secure distinction.

2. A business owner wants to decide if he should try to increase the sales a product or price of an
existing product in order to increase the profit by 10%. The owner believes that he can either increase
sales by 5 units without incurring additional costs while the price can be increased by Rs 8 without
affecting the sales.
3. The current profit situation of a business owner is as follows. Using the scenario manager, find the
effect of in the new profit in case of the following situations.
a. Sales = 70 and cost = 80
b. Sales = 90 and cost = 72
c. Sales = 85 and cost = 80
d. Sales = 65 and cost = 80
4. Applying Data Consolidation in OO Calc Task: 1. Create a new file in spreadsheet software and enter
data for 10 salesmen. 2. Add two worksheets in the file and modify the data for all 3 quarters. 3.
Rename all worksheets like sheet1 - 2018, sheet2 - 2019 and sheet3 - 2020. 4. Now add one more
worksheet at the end and rename as consolidated sheet. 5. Now type the serial no and names as
displayed, use sum function to add data for 2018, 2019 and 2020 in respective cells using consolidation.

You might also like