SSCEXAMFORUM.COM QUESTION 1
8 9
F
G
SC 100 105 123 85
ST OBC 25 225 45 230 133 412 39 362
Gen Total 556 852 965 475
O
Year 2000 2001 2002 2003 Average
RU
10 11
E
.C
7
D
M
6
C
Category wise list of candidates
4 5
B
M
A 1 Name 2 Roll No 3
SS C
EX
A
M FO
By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Portrait and margin to ‘Normal’ or according to given measurement. 3. Change font size of cell to ‘14’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of category and year (content of row 5 and column A) Centre aligned and figures (data entered in concerned cell) Right aligned. 6. Change the Background colour of Total and Average to given colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this Worksheet.
SSCEXAMFORUM.COM QUESTION 2 A 1 Name 2 Roll No 3
C
D
E
F
Hindi 66 42 78 80 85
English 98 66 95 93 99
Total
Average
O
Maths 97 44 68 98 79
.C
Class 1 A B C D E
RU
By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Portrait and margin to ‘Normal’ or
M FO
according to given measurement. 3. Change font size of cell to ‘14’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of Subject and student (content of row 5 and column A)
A
Centre aligned and figures (data entered in concerned cell) Right aligned. 6. Change the Background colour of Total and Average to given colour (as
CE X
shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this
SS
Worksheet.
M
Subject wise Marks of students
M
4 5 6 7 8 9 10 11
B
SSCEXAMFORUM.COM
D
E
F
School Name
sarvodaya Vidyalya Delhi Public School Lko Govt School Loreto convent Total Marks
Marks in Test
2678.75 3242.35 3424.77 5336.75
Marks in practical Exam 435.7 345.5 234.75 432.5
Total student
.C
Scoresheet of class XII
Total marks
RU M
6 7 8 9 10 11
C
FO
4 5
B
O
A 1 Name 2 Roll No 3
M
QUESTION 3
Average per student
345 368 789 234
SS CE
X
A
M
By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘Normal’ or according to given measurement. 3. Change font size of cell to ‘14’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of Marks and schools (content of row 5 and column A) Centre aligned and figures (data entered in concerned cell) Right aligned. 6. Change the Background colour of Total and Average to given colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this Worksheet.
Sheet 5
SSCEXAMFORUM.COM
C
D
E
G
H
I
.C
Net Salary of Emloyee Sl.no. Name suresh abhinav himanshu abhishek Ramesh`
Basic Salary
Clerk Peon Saleman Gardener Guard
17000 12500 14500 7500 9000
House Rent Allowance
FO
1 2 3 4 5
Designation
Medical Travel Allowance Provident Fund Net Salary Allowance
RU M
4 5 6 7 8 9 10
F
O
A B Name 1 2 Roll No 3
M
QUESTION 4
SS CE
X
A
M
House Rent Allowancw = 9% of Basic Salary Medical Allowance = 6% of Basic Salary Travel Allowance = 7% of Basic Salary Provident Fund = 5% of Basic Salary Net Salary = Basic Salary + House Rent Allowance + Medical Allowance + Travel Allowance - Provident Fund By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘Narrow’ or according to given measurement. 3. Change font size of cell to ‘14’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of content of row 5 and column A Centre aligned and figures (data entered in concerned cell) Right aligned. 6. Change the Background colour of Allowance and Net Salary to given colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. Save your Workbook with the name in given format and also Print this Worksheet.
M
SSCEXAMFORUM.COM QUESTION 5 B
C
D
E
F
G
O
A
NAME
AGE
HINDI
ENGLISH
MATH
6
HEMA
18
85
95
75.65
7
SHILPA
19
75.65
45
56
8 AMRITA
17
56
33
58
RITU
19
58
75.65
45
10
PINKU
21
95
56
33
18
45
58
58
18
33
85
RAVI
MAX
95
A
11 PAWAN
PER(%)
M
9
TOTAL
FO
5
RU M
SCORESHEET OF CLASS XII
4
12
.C
1 NAME 2 ROLL NO. 3
By following the given steps, you have to design the above worksheet using
SS CE
X
MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘NARROW’ or according to given measurement. 3. Change font size of cell to ‘13’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 18 and make it Bold, Underlined and Center aligned. 5 CENTER aligned. 6. Change the Background colour of Total,PER, MAX, MIN to given colour (as shown in above worksheet) and used appropriate function of excel to get
MIN
SS CE
X
A
M
FO
RU M
.C
O
M
these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this
27.11.2014
M
SSCEXAMFORUM.COM
B
C
D
E
F
G
1 NAME 2 ROLL NO. 3
AGE 18 19 17 19 21 18 18
SALARY -1 5000 7000 5600 5800 9500 4500 3300
RU M
CALCULATE HRA FOR THE YEAR,2013-2014 SALARY-2 SALARY-3 TOTAL SALARY 9500 7656 4500 5600 3300 5800 7565 4500 5600 3300 5800 5982 8500 9500
HRA-1
FO
4 5 NAME 6 ABHI 7 VIN 8 SAHU 9 ARJ 10 PRI 11 PAWAN 12 RAVI
.C
A
O
QUESTION 6
SS CE
X
A
M
HINT: IF SALARY IS MORE THAN 5000 THAN HRA IS PAID 1500 REST 800 By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘Narrow’ or according to given measurement. 3. Change font size of cell to ‘13’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of (content of row 5 and column A) Centre aligned and figures (data entered in concerned cell) CENTER aligned. 6. Change the Background colour of Total and HRA 1,HRA 2, HRA 3 to given colour and used appropriate function of excel to get these values.
HRA-2
HRA-3
IF(D7>5000,1500,800)
TOTAL HRA
27.11.2014
SS CE
X
A
M
FO
RU M
.C
O
M
7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this 10 HEDER AND FOOTER
M
SSCEXAMFORUM.COM
A
B
C
D
E
F
O
QUESTION 7 G
NAME A B V B N Q R
AGE 18 19 17 19 21 18 18
STATUS
AGE
STATUS
AGE 35 65 55 25 45 18 44
15 16 12 13 17 11 10
RU M
CALCULATE THE AGE OF STUDENT
STATUS
AGE
14 78 25 65 32 22 31
FO
4 5 6 7 8 9 10 11 12
.C
1 NAME 2 ROLL NO. 3
SS CE
X
A
M
HINT: IF(B >20,"YOU ARE MAJOR","YOU ARE MINOR") By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘Narrow’ or according to given measurement. 3. Change font size of cell to ‘13’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5.Centre aligned and figures (data entered in concerned cell) LEFT aligned. 6.Change the Background of AGE and STATUS in different colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet.
STATUS
SS CE
X
A
M
FO
RU M
.C
O
M
8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this 10 HEDER AND FOOTER
SSCEXAMFORUM.COM QUESTION 8 C
D
E
F
G
CALCULATE LATE FEE OF STUDENT A-DATE 05.01.2014 06.02.2014 07.03.2014 08.04.2014 09.05.2014 10.06.2014 11.07.2014
F-DATE DIFF-DAYS 08.02.2014 09.03.2014 11.05.2014 08.06.2014 11.05.2014 11.06.2014 11.09.2014
HINT:
IF(G7>60,20000, IF(G7>30,15000, IF(G7<30,10000,)))
FINE
M
COURSE MBA MBBS CAT MAT CA CS MA
O
AGE 18 19 17 19 21 18 18
.C
NAME ABHI VIN ASHOK SHILPA RAVI ASHU RAHUL
RU
5 6 7 8 9 10 11 12
B
M
1 2 3 4
A NAME ROLL NO.
FINE 1 0.5 FINE
0 ABHI VIN ASHOK SHILPA RAVI ASHU RAHUL
SS
CE X
A
M FO
By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to PORTRAIT and margin to ‘Narrow’ or according to given measurement. 3. Change font size of cell to ‘13’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5.Centre aligned and figures (data entered in concerned cell) CENTER aligned. 6. Change the Background colour of Name and Fine to given colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required. 9. Save your Workbook with the name in given format and also Print this 10 HEDER AND FOOTER & Make a CHART OF NAME AND FINE
SSCEXAMFORUM.COM
D
E
CITY
Population in year 2001
delhi mumbai Lucknow Allahabad Total
2,247,365 1,825,368 1,935,754 2,824,156 8,832,643
Population In Different Cities Population in year 2002 Increase in population 2,512,458 2,258,745 2,569,784 3,245,878 10,586,865
.C
O
C
FO
5 6 7 8 9 10
B
percentage increase in population
RU M
1 2 3 4
A NAME ROLL NO.
M
QUESTION 9
A
M
By following the given steps you have design the above worksheet using MS-Excel:1. Open new workbook of Excel. 2. Set paper size to'A4' orientation Landscape and margin to "Narrow" or according to given measurement. 3. Change font size of cell to "13.5" and font name to "Arial". 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and center aligned. 5. Change the Background colour of "City" and "Percentage increase in Population " to given colour (as shown in
SS CE
X
above worksheet) and used appropriate function of excel to get these values. 6. Create a border as given in above worksheet. 7. Adjust height and width of cell as required. 8. Make Graph and Header & Footer. Save your Workbook with the name in given format and also Print this Worksheet.
SSCEXAMFORUM.COM QUESTION 10 Q1. Create athe following table Subject 1 Subject 2 Subject 52 53 26 74 83 92 25 35 62 42 24 41 48 86 92
M
Last Name Gender Mishra Mehra Manchanda Sinha Kashyap
O
Frist Name Neha ritu hema Pawan shilpa
SS C
EX
A
M FO
RU
M
.C
1. Compute the table marks and percentage of each student. 2. Give status by using following conditions if the total manks>100 so "Pass" if the total manks>100 so "Fail" 3. Table field bold itlics shade green center aling 4. Apply heading on the table 'Delhi Public School' font size "20" style com 5. Insert new row above 'Ankit' and fill up entry menu Mehra 42 66 73 6.Total colum width should be "25" 7. set the table data in ascending oder 8. find the "Heena" and convert it to "Heena"
SSCEXAMFORUM.COM QUESTION 11 Q2. Create this table in MS-Excel
SS C
EX
A
M FO
RU
M
.C
O
M
Online Application Offline Application States 15620 Delhi 45000 up 15820 12600 jharkhand 25000 13500 Maharashtra 35600 14800 i Compute the total number of application ii. Compute the total average made to each states iii Compute total nunber of online application and offline application bellow the colum iv Compute v 1. Page size should be "A4". 2. Set Margin top :0.53, left:0.5,right:0.43,Bottam:0.59 3. Apply your name and current date in header. 4.Apply page number in footer. 5. Set Title "2013 APPLICATION FORMS" in Algerian, font 15,Center Align Throught "Word Art". 6.Create a bar graph represent total number of applications. 7. Apply conditional formating on total application less than 60000 colour red more than 60000 green. 8. Set column width of total 10.0.
SSCEXAMFORUM.COM QUESTION 12 Q3. Create a new table in ms-excel and fill up entries.
Ist Year
REG FEE
NAME OF HEAD Boys/SC.SC. Minority st
Boys/SC.SC. Minority
IIIed Year
Boys/SC.SC. Minority Ist Sem IInd Sem
OTHERS Boys/SC.SC. Minority OTHERS
Ist Sem IInd Sem
M FO
IVTh Year
M
Ist Sem IInd Sem
OTHERS
RU
IInd Year
EX
A
i .Compute the total number of fees. ii .Table Headings font size 13pt. iii. Apply All Border on Table. iv. Title fonts size 14.bold second line too and center align. 1. Create a pie chart representing Total Fee against S No. 2. Type your Name and Roll Number in header. 3. Completed table should be print in single page. 4. Apply accounting number format on total fee. 5. Margin size form Top:0.59.bottam :0.64, right : 0.35, left:0.85. 5. Margin size form Top:0.59.bottam :0.64, right : 0.35, left:0.85.
SS C
1500 1600 0 1800 1400 0 1800 1300 0 1750 1360 0
0 32600 32890 0 33600 34600 0 32560 35690 0 32560 12566
.C
I Sem IInd Sem
OTHERS
TUTION FEE
O
S.NO
M
SITAPUR SANSTHAN (SSS Technical Campus) Fee Structure (session 2012-13) EXAM FEE 3550 3550 0 3550 3550 0 3456 3596 0 3256 2150 0
SSCEXAMFORUM.COM QUESTION 13 Q4. Create a table as given bellow
100 100 100 100
Education 61 53 72 83
SS C
EX
A
M FO
RU
M
.C
1. Compute total marks and percentage by using avreage formula. 2. Apply all border on table. 3. Apply grades by using condition given belllow:GRADE 'A'--More than 300 GRADE 'B'--More than 200 GRADE 'C'--More than 100 GRADE 'D'--Less than 100 4. Create pie chart representing total marks. 5. Insert a new row at the top of 'Pooja' and fill up new entry. 6. Insert title "THIS YEAR RESULT" font size 20,style 'Impact' colour "Red". 7. Apply duble line border around the title. 8.Insert your name in header ,roll name and page number in footer. 9. your page size should be Standard. 10. All columns width 15.
Globalization 53 65 61 93
M
Hindi-A 85 55 56 68
O
Frist Name Last Name shilpa Mishra amrita Khandelwal Pooja Mehra sona Shukla
Political Scince 81 53 62 75
SSCEXAMFORUM.COM QUESTION 14 Q5. Create the following table and fill up all entries:
ELIGIBILITY
O .C M RU M FO
EX
A
15 85 32 25 41 8 65 52 32 12 52 32 2 15 32 52 86 62 25 5 61 16 18 59 18 26
M
AGE
SS C
Name Ram Sham Sunita Yatin Nitin Kanika Gagan Naveen Mehar Sita Lakshman Anil Tanya Yatin Atin Nikita Arun Tarun Neha Ravi Vevan Vikram vikek Kannu Aman Heena
1. Apply Formula to get the eligible age for rvoting. 2. Count the number of eligible and not eligible persons. 3. Apply Margin from top 0.7 & right 0.53 4. Page size should be Letter. 5.Apply All Border on table. 6. Filed size 16 font stlye impact.
SSCEXAMFORUM.COM QUESTION 15 ASIA PACIFIC MAN GEMENT STUDITS Institution Area. allahabad-211001
M
Scholarship Subject Offered
O
Monthly Income Gread 14000 A 22000 B 13000 A 9500 C 7500 D 8000 B 19000 C
.C
Name ramu dinu sudhir ravi deepu shalu prity
M
S No. 1 2 3 4 5 6 7
Conditions Scholarship and subject offered which is on the following criteria:-
M FO
RU
Gread Name of student 'A' Financial Accounting 'B' Offical Management 'C' Business Marketing 'D' Reading Gandhi Sholarship is given on the basis of Monthly income on the following conditions:50 per cent for those who having monthaly income up to 10,000 and 100 per cent for those who having more than 10,000 with a condition that students having monthaly income of more 10,000 get a maximum of scholarship 15,000.
A
And apply fomating as mentioned below:-
SS C
EX
1. Sort entre list in Ascending order time. 2. Set colum width of scholarship and subject offered 18. 3. All figures in center align. 4.Set margins left:0.75,size 20,center align through "Word Art" 6.Give all Boundary lines on your table.
SSCEXAMFORUM.COM
M
QUESTION 16
Basic 4000 Than:-
DA
HRA
Income
PF
I Tax
Deductions
Net Salary
.C
6000 9000 5000 3000 7000
RU M
Formula Condlitions:If Basic 8000 than:-
Basic
IF(cell>8000,cell*50%,IF(cell>4000,cell*40%,cell*30%)) DA 50% of Basic HRA 40% of Basic PF 6% of Basic I Tax 4% of Basic DA 40% of Basic
FO
Name shadab pawan pihu pulkit ankit
M
SNO. 1 2 3 4 5
O
Q7. Create a salary satement for the following format and date details using Ms-Excel.
SS CE
X
A
By following the given steps, you have to design the above worksheet using MS-Excel: 1. Open new Workbook of Excel. 2. Set paper size to ‘A4’, orientation to Landscape and margin to ‘Narrow’ or according to given measurement. 3. Change font size of cell to ‘14’ and font name to ‘Arial’. 4. Merge the cells of row 4, change the font size to 16 and make it Bold, Underlined and Center aligned. 5. Make the title of marks and sl.no. (content of row 5 and column A) Centre aligned and figures (data entered in concerned cell) Right aligned. 6. Change the Background colour of Total and Average to given colour (as shown in above worksheet) and used appropriate function of excel to get these values. 7. Create border as given in above worksheet. 8. Adjust Height and Width of cells as required.
SS CE
X
A
M
FO
RU M
.C
O
M
9. Save your Workbook with the name in given format and also Print this Worksheet.
