Computer Proficiency License
(CS001)
Assignment # 03
Spring 2021
Topic Covered:
·
Module 4 (Spreadsheets):
o Introduction to
Microsoft Excel
o Saving an Excel
File
o Creating Complex
Formula
o Sorting Data
Create a single excel file with two sheets, one for Question 1 and other for Question 2
Questions No 01
Create a
worksheet with the name “Q1” with
the sample data as shown in the output.
A company named
ABC wants to award bonus to their employees based on their sales record. For
this purpose, they want bonus calculation in Microsoft Excel according to the
following criteria:
·
If the
employee Achieved meets or exceeds his/her Target, S/he receives a bonus equal
to 100 $ for each of the achieved number, otherwise s/he receives an
encouraging message (Work Hard).
·
For example,
if the achieved is 16 and target is 16, then the employee will receive $1600 as
bonus, if the achieved is less than the target, then display the message “Work
Hard”.
The desired output must match the following:
Create a worksheet with the name “Q2” with the flowing data as below:
An XYZ company is interested in the
inquiry system based on Microsoft Excel for its customers according to the
following criteria.
- Create a
table for base prices for destinations with 2 columns (Destination &
Base Price).
- Create a
second table for multipliers with 2 columns (Type & % Multiplier).
- Create a
third table for inquiry system as shown in figure-III.
- Add the sample data as shown in figure-III.
- Create a pull-down
menu for a destination inside the inquiry table as shown in figure-I.
- Create
another pull-down menu for type inside inquiry table as shown in figure-II.
- Finally
multiply base price with a multiplier to obtain the total inside inquiry table as shown in figure-III.
Note: Create an excel file with two sheets, one for Q1 and
other for Q2.
Watch the Video tutorial for the above task 👇👇👇👇
Download File in Excel sheet by click on Generate link
0 Comments
Please write us. Please write in detail that how may we help you