Practical Exam on M S Office
Q-1 Make a folder on desktop your name and Roll & Save your all question in this folder. [05 marks]
Q-2 Make the table in MS Word & give the end not below table. [10 marks]
|
Product |
Dealer |
Customer |
Dealer Discount |
Customer Discount |
|
Samsung Galaxy j2 |
Rs. 7,458 |
Rs. 8999 |
10 to 40% |
Less price |
|
Samsung Galaxy j5 |
Rs. 10,990 |
Rs. 15,990 |
Less Price |
5 to 15% |
|
Samsung Galaxy s7 |
Rs. 30,000 |
Rs. 35000 |
Less Price & 5 to 10% Discount |
Less Price & 10 to 20% Discount |
|
Samsung Galaxy j7 |
Rs. 12,750 |
Rs. 15,850 |
No Discount |
Manually Set discount for sale |
Q-3 Type below letter & sent 3 people using mail merge.
Dear Participant
As you may be aware we have been
running a variety of courses at the college
Ranging from 1 to 12 weeks. We are
now happy to inform you that we are
Introducing a number of 2-day
courses, which will be held both at weekends and
Mid-week to suit the varying needs
of potential students.
Please find enclosed an application
form and a program schedule. We look forward
to your participation.
Yours truly,
Morgan Reilly
Course Director
Q-4. Type the following paragraph in MS Word & change the Paragraph below sentence [10 marks]
Computer is an advanced electonic device that takes raw data as an input from the user and processes it under the control of a set of instructions (called program), produces a resut (output), and saves it for future use. This tutorial explins the foundational concepts of coputer hardware, software, operating systems, peripherals, etc. along with how to get the most value and impact from computer technology.
1. Give Bold italic & under line for title.
2. Check the Spelling & Correct it.
3. Paragraph font size 14 & Font type Times New Roman.
Q-5 Write formulas for the operations (i) – (iv) based on the spreadsheet
given below along with the relevant cell address:
|
|
A |
B |
C |
D |
E |
F |
G |
|
1 |
SNO |
Name |
Science |
Maths |
Computers |
Total |
Average |
|
2 |
1 |
Swati |
70 |
80 |
87 |
-- |
-- |
|
3 |
2 |
Shruti |
90 |
98 |
89 |
-- |
-- |
|
4 |
3 |
Neelu |
90 |
90 |
98 |
-- |
-- |
|
5 |
4 |
Rosy |
60 |
76 |
79 |
-- |
-- |
|
6 |
5 |
Shreya |
50 |
45 |
67 |
-- |
-- |
|
7 |
Max |
|
|
|
-- |
|
|
|
8 |
Total |
|
-- |
|
|
|
|
a) To calculate the
Total Marks as sum of Science, Maths & Computers for each student and
display them in column F.
b) To calculate the
average marks for each student and display them in column G.
c) To calculate the
highest marks in Computers and display it in cell E7.
d) To calculate the total number of students appearing for the Science test and display it in cell C8.
Q-6 In a poultry farm, the percentage of eggs sold month wise from January to May is given below. Use this table & Make a pie Chart.
|
Month |
Percentage of eggs |
|
January |
40% |
|
February |
12% |
|
March |
23% |
|
April |
15% |
|
May |
10% |
Q-7 below the table shows the sales figure for AC’s sold in for major cities of Gujarat from year 2010 to 2013. Based on this data write the formula to calculate the following: [10 marks]
(i) Total Sales in the year 2012.
(ii)
Total Sales in Ahmadabad
from 2010 to 2013.
(iii)
Total Sales in Surat
& Baroda during 2012-2013.
(iv)
Average sales in Rajkot
from 2010 to 2013.
|
Year |
Ahmedabad |
Surat |
Baroda |
Rajkot |
|
2010 |
1200 |
750 |
800 |
850 |
|
2011 |
600 |
500 |
900 |
750 |
|
2012 |
900 |
300 |
700 |
950 |
|
2013 |
600 |
400 |
400 |
550 |
Q-1 Make a folder on desktop your name and Roll an change folder Icon
Q-2. Type the following in MS Word and save the file by the name table.doc in your folder created on the desktop of your computer.
|
SALES
SHEET FOR THE MONTH OF MARCH 2007 |
|||||
|
Sr.
No. |
Sales
Person |
Product |
Price |
Quantity |
Amount |
|
1 |
A |
Mobile |
15000 |
10 |
150000 |
|
2 |
S |
Camera |
1200 |
20 |
24000 |
|
3 |
D |
Calculator |
200 |
30 |
6000 |
|
Total
Sales |
180000 |
||||
Notes:
- Page orientation as “Landscape” Top and Bottom
margin of the page should be
- Display Header =SALES SHEET and Footer= Page
No, both should be center aligned.
Q-3. Make the following table using MS Excel as mentioned below.
|
Name |
Basic
Salary |
HRA |
CLA |
Gross |
PF |
Net Salary |
|
Z |
Rs. 8500.00 |
|
|
|
|
|
|
Y |
Rs. 9350.00 |
|
|
|
|
|
|
X |
Rs.
11000.00 |
|
|
|
|
|
|
W |
Rs.
10500.00 |
|
|
|
|
|
Notes:
o
HRA is 10% of Basic Salary, CLA for all
employees is Rs.250.00
o
Gross is Basic Salary + HRA + CLA
o
Find PF
using Condition as per the following slab
IF Basic
Salary is less than Rs. 10000.00 then PF=700 and
IF Basic
Salary is greater than Rs. 10000.00 then PF=1000
o
Net Salary is Gross – PF
o
Save the
Q-4.
Create a following
|
Budget Provision for the year
2006 – |
||||||
|
Company |
1ST Qtr. |
2nd Qtr |
3rd Qtr |
4th Qtr |
Total |
Average |
|
ABCL |
300 |
250 |
435 |
480 |
|
|
|
IPL |
200 |
350 |
500 |
1000 |
|
|
|
BCCI |
450 |
750 |
900 |
1200 |
|
|
|
ICCI |
750 |
820 |
1200 |
1380 |
|
|
Notes:
- Find
- Find Average of all the department using formula
or function
- Rename the worksheet as Budget
Q-5 Make he following mark sheet using MS Excel as per below mentioned notes and save the file by the name mark sheet in your folder on the desktop of your computer.
|
No. |
Student Name |
Hindi |
Gujarati |
English |
|
|
Status |
|
1 |
A |
45 |
68 |
90 |
|
|
|
|
2 |
X |
65 |
98 |
65 |
|
|
|
|
3 |
B |
55 |
33 |
67 |
|
|
|
|
4 |
Z |
54 |
87 |
78 |
|
|
|
Note
- Calculate
- Calculate
Average using
- Calculate Status using condition or lookup as per
the following slabs
Status = PASS if
student has scored more than 34 marks in all three subjects otherwise Status
= FAIL
- Filter data for all student whose Status = “PASS”
- Change Font Color Marks More than 35 Font Color
Green and Less Than 35 Font color Red Using Conditional Formatting
Q-6. Prepare a MS Word document to send the
following letter to six different candidates for the interview using mail
merge option in MS Word save the final merged file by the name interview
in your folder located on the desktop of your computer.
To,
<<Name>>
<<Area>>
<<City>>
Dear
<<Name>>,
This
is to inform that you have been short listed for the post of Asst. Manager
based on the 1st round of interview. You are instructed to join duty
from 1st Feb 2023.
For,
CBI Computers
Manager
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें
Thanks for Your Comment !!!