SET A
Question 1
No. of ITEM TOTAL PRICE TOTAL PRICE
ITEM No. TAX RATE
ITEMS PRICE BEFORE TAX AFTER TAX
C1001 115 30 ? ? ? ?
C1002 256 12 ? ? ? ?
C1003 49 56 ? ? ? ?
C1004 23 150 ? ? ? ?
C1005 840 5 ? ? ? ?
C1006 200 56 ? ? ? ?
C1007 294 300 ? ? ? ?
C1008 4 90 ? ? ? ?
C1009 197 134 ? ? ? ?
C1010 149 174 ? ? ? ?
C1011 168 47 ? ? ? ?
C1012 149 135 ? ? ? ?
Count of Items ?
Average of Tax ?
Min ITEM PRICE ?
MAX ITEM PRICE ?
Create the worksheet shown above.
For the given table find the following:
1. TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100).
2. TOTAL PRICE BEFORE TAX =NO. OF ITEMS * ITEM PRICE.
3. TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX + TAX.
4. RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise
it is REASONABLE.
5. Find Count of Items, Average of Taxes, Min Item PRICE and Max Item PRICE.
6. Use AutoFill to put the ITEM Numbers into cells A4:A9.
7. Create a header that includes your name in the left section, and your Roll number in
the right section. Create the footer that includes the current Date in the center.
8. Save file as “Your Roll No.” “Name” “Mobile No”.
Objectives:
Number, Commas and Decimal numeric formats.
Working with Formulas (Maximum, Minimum, Average, Count
and Sum).
Numeric Formats.
Question 2. Decorate word document with page border, content border, add pattern
and write beautiful text in it.
Monthly Sales Report -February 2023
Emp No. Name Salary Sales Amount Commission Total Salary
S101 Raghav 1,600.00 3,300.00 ? ?
S102 William 1,800.00 2,500.00 ? ?
S103 Nupur 1,500.00 3,000.00 ? ?
S104 Johm 2,000.00 2,400.00 ? ?
S105 Rahul 1,700.00 4,500.00 ? ?
S106 Rrijesh 1,500.00 3,500.00 ? ?
S107 Arvind 1,600.00 2,500.00 ? ?
S108 Ankur 1,900.00 2,200.00 ? ?
Total ? ? ? ?
Average ? ? ? ?
Highest ? ? ? ?
Lowest ? ? ? ?
Count ? ? ? ?
SET B
Question 1
Save the file with name
a) Create the worksheet shown.
b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15,
Columns E & F: 14.
c) Enter the formula to find COMMISSION for the first employee. The commission rate is
2.5% of sales, COMMISSION = SALES * 2.5% Copy the formula to the remaining employees.
d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY =
SALARY + COMMISSION Copy the formula to the remaining employees.
e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy
the formula to each column.
f) Format numeric data to include commas and two decimal places.
g) Align all column title labels horizontally and vertically at the center.
h) Create a Header that includes your name in the left section, page number in the center
section, and your ID number in the right section.
i) Create footer with DATE in the left section and TIME in the right section.
j) Save the file with your name/ roll no..
Question 2. Decorate word document with page border, content border, add pattern and write
beautiful text in it.
SET C
A furniture shop sells furniture to customers on credit. The credit terms request thecustomer to
make a deposit of 25%. The balance after the total deposit is paid in monthlyinstallments over 24
months without [Link] shop customers & furniture credit values are:
Furniture Monthly
Si No. Name Deposit Balance
Value Installment
Chair ₹ 5,000.00 ? ? ? ?
Table ₹ 23,000.00 ? ? ? ?
Single Bed ₹ 27,000.00 ? ? ? ?
Double bed ₹ 50,000.00 ? ? ? ?
Almirah ₹ 35,000.00 ? ? ? ?
Book Shelf ₹ 12,000.00 ? ? ? ?
1. Design a spreadsheet of the data above& save it as Furniture
2. Make all titles bold and shade the cell background for titles in light grey color
3. Format the furniture value to zero decimal point.
4. Use formulae to calculate values for deposit, balance & monthly installments.
5. Sort the sheet in alphabetical order of names. .
6. Insert borders on all entries & save the sheet as Furniture2
ON A NEW SHEET, Create a fully labeled,
1. Column graph
2. Bar Chart
3. Pie Chart
Using the name and value of furniture columns & SAVE IT AS GRAPHS.
Show formulas you have used for deposit, balance & monthly installment in a new sheetand save it
as formulas
All your field names or cells must fit on one page otherwise marks will be deducted. Use your
print preview regularly.
Question 2. MS-WORD
Microsoft Word is a word processor developed by Microsoft. It was firstreleased in 1983 under
the name Multi-Tool Word for Xenix systems. MSWord is a popular word-processing program
used primarily for creatingdocuments such as letters, brochures, learning activities, tests,
quizzes andstudents' homework assignments. There are many simple but useful featuresavailable in
Microsoft Word to make it easier for study and work. That's why so many people would prefer to
convert the read-only PDF to editable Wordand edit PDF in Word.
Type the paragraph above as it is using “Calibri font” , font size 12.
Change the font type to “Lucida Calligraphy” and size to 14
Alignment to your paragraph to right margin.
Save this file as [Link] in “my documents” folder using save as option