MS EXCEL

PRACTICAL

MS EXCEL PRACTICAL

PRACTICAL - 1

CREATE A SHEET, WRITE YOUR FULL NAME IN CELL A1, APPLY FONT – TIMES NEW ROMAN, SIZE – 14, COLOR – RED, FILL COLOR – YELLOW, BOLD EFFECT. WRITE YOUR VILLAGE NAME IN CELL A2, APPLY FONT – IMPACT, SIZE – 12, FONT COLOR – WHITE, FILL COLOR – BLACK AND UNDERLINE EFFECT. SAVE WORKBOOK INSIDE DOCUMENT FOLDER.

PRACTICAL - 2

WRITE YOUR NAME IN CELL A1 OF SHEET-1 WITH FONT – TOHOMA, SIZE – 14 AND YOUR AGE IN CELL B1 WITH FONT – ARIAL, SIZE – 12. COPY BOTH A1:B1 AND PASTE IN CELL RANGE A1:B1 IN SHEET-2. USE COPY SERIES OPTION TO COPY YOUR NAME UPTO A100 AND USE FILL SERIES OPTION TO FILL YOUR AGE INCREMENTALLY UPTO B100.

PRACTICAL - 3

WRITE CWIT IN CELL A1:A50 OF A NEW SHEET, APPLY CENTER ALIGNMENT TO CELL RANGE A10:A30, RIGHT ALIGNMENT TO CELL RANGE A40:A50. INSERT A ROW ABOVE ROW ONE, WRITE YOUR FULL NAME IN CELL A1, KEEP YOUR NAME AT CENTER OF CELL RANGE A1:D1. APPLY FONT COLOR – RED, SIZE – 14, FILL COLOR GREEN. APPLY A2:A10 TO CLOCKWISE AND A32:A40 TO COUNTER CLOCKWISE.

PRACTICAL - 4

CREATE A SHEET AS GIVEN BELOW, CONVERT A1:E1 TO TWO LINE TEXT (WRAP TEXT), A2:A5 TO DATE FORMAT, B2:B5 TO TIME FORMAT, C2:C5 TO TEXT FORMAT, D2:D5 TO CURRENCY FORMAT, E2:E5 TO FRACTION FORMAT. USE CTRL + ; COMMAND TO ENTER TODAY’S DATE IN CELL A2, USE CTRL + SHIFT + ; COMMAND TO ENTER CURRENT TIME IN CELL B2, ENTER 00908920 IN CELL C 2, ENTER 5500 IN CELL D2, ENTER 4/5 IN CELL E2. FILL DATA UPTO A5:E5 AND APPLY TABLE STYLE TO CELL RANGE A1:E5.

PRACTICAL - 5

CREATE A SHEET AS GIVEN BELOW, APPLY CONDITIONAL FORMATTING WITH ICON SETS, UP – 60, DOWN – 30, NUMBER ONLY, HIDE ROW 2, INSERT A ROW BETWEEN 4, 5 AND A COLUMN BETWEEN A, B. UNHIDE ROW 2 AND DELETE BOTH NEWLY ADDED ROW AND COLUMN. REMOVE CONDITIONAL FORMATTING FROM CELL RANGE B2:F5.

PRACTICAL - 6

INSERT A PICTURE, RECOLOR – RED, PICTURE STYLE, ARTISTIC EFFECT AND SIZE 4×5 CM. INSERT A FACE SHAPE EMOJI WITH FILL COLOR – YELLOW, LINE COLOR – GREEN AND THICKNESS – 3PT. INSERT A PRCESS CHART SMART ART. JOIN EACH OBJECT BY ARROW SHAPE.

PRACTICAL - 7

CREATE A LINE CHART AND BAR CHART USING DATA GIVEN BELOW. APPLY CHART TITLE AS SARASWATI SISHU MANDIR, DATA LEBEL AND CHART DESIGN TO EACH CHART.

PRACTICAL - 8

WRITE YOUR FULL NAME IN MIDDLE SECTION OF HEADER AND EMAIL ADDRESS IN MIDDLE SECTION OF FOOTER. INSERT PAGE NO IN RIGHT SECTION AND TODAY’S DATE IN LEFT SECTION OF HEADER. MODIFY MARGIN TO NARROW, PAPER SIZE TO A4, ORIENTATION TO POTRAIT AND CHANGE BACKGROUND BY AN IMAGE.

PRACTICAL - 9

BREAK FIVE FRIEND’S FULL NAME TO TWO PART, REMOVE DUPLICATE CELL CONTENT, USE DATA VALIDATION TO CRAETE A LIST OF NAMES AND TEXT LENGTH WITH ERROR MESSAGE.

PRACTICAL - 10

APPLY PASSWORD PROTECTION TO SHEET. APPLY CELL COMMENT AND FREEZ PANES OPTION IN SHEET.

PRACTICAL - 11.

WRITE DIFFERENT NUMBERS IN CELL A1, B5, D8, F9,H10,J12,L13, N14, APPLY FONT COLOR RED,SIZE 20, FILL COLOR YELLOW TO CELL A1. COPY FORMATTING FROM CELL A1 AND APPLY TO B5, D8, F9, H10, J12, L13, N14.

PRACTICAL - 12

CHANGE ROW HEIGHT OF ALL CELL OF SHEET TO 20 AND COLUMN WIDTH OF ALL CELL TO 10. RENAME SHEET 1 TO ABC PVT. LTD. AND CHANGE SHEET TAB COLOR TO RED.

PRACTICAL - 13

ENTER DATA 34,67,12,56,78,98,23,45,68,45 IN CELL RANGE A1: A10 AND ARRANGE DATA IN A TO Z, COPY A1:A10 AND PASTE IN B1:B10 AND SORT DATA IN Z TO A.

PRACTICAL - 14

INSERT CWIT-01 IN CELL A1, FILL DATA FROM A1 TO A50 AND CHANGE CWIT TO CYBER. APPLY FILL COLOR GREEN AND FONT COLOR YELLOW TO CELL RANGE A1:A50, REMOVE ALL FORMATTING EFFECT FROM CELL RANGE A1:A50.

PRACTICAL - 15

INSERT AN EQUATION IN A NEW SHEET AS GIVEN BELOW.

EXCEL FORMULA PROJECT - 01

CREATE ASHEET WITH FORMATTING AS GIVEN BELOW AND USE SUM/ AVERAGE/ MAXIMUM/MINIMUM/ COUNT/ PERCENTAGE/ SUBTRACT/ DIVIDE FORMULA TO CALCULLATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET FOR PGDCA/HDCA

PROJECT- 01 REVISION

EXCEL FORMULA PROJECT- 02

CREATE A SHEET WITH FORMATTING AS GIVEN BELOW AND USE IF / ELSE / CONCATENATE / LEFT / RIGHT / TRIM / UPPER / LOWER / PROPER FORMULA TO CALCULATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET - 02

PROJECT- 02 REVISION

EXCEL FORMULA PROJECT - 03

CREATE ASHEET WITH FORMATTING AS GIVEN BELOW AND USE VLOOKUP / RANK / SUMIF / AVERAGEIF / COUNTIF / CONVERT / REMAINDER / LCM / GCD PROPER FORMULA TO CALCULLATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET - 03

PROJECT- 03 REVISION

EXCEL FORMULA PROJECT - 04

CREATE ASHEET WITH FORMATTING AS GIVEN BELOW AND USE MONTH VALUE / WEEKDAY / TODAY’S DATE / DATE WITH TIME / DATE & TIME ADDITION-SUBTRACTION / DATEDIF FORMULA TO CALCULLATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET - 04

QUESTION ANSWER PRACTICE

PROJECT- 04 REVISION

EXCEL FORMULA PROJECT - 05

CREATE ASHEET WITH FORMATTING AS GIVEN BELOW AND USE PMT (PER MONTH TOTAL) / FV (FUTURE VALUE) / PV (PRESENT VALUE) / SLN (STRAIGHT LINE) / NPER (NO OF PERIOD) / FORMULA TO CALCULLATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET - 05

QUESTION ANSWER PRACTICE

PROJECT- 05 REVISION

EXCEL FORMULA PROJECT - 06

CREATE ASHEET WITH FORMATTING AS GIVEN BELOW AND USE TREND/FORECAST/HLOOKUP/SUMIFS/AVERAGEIFS/SUMPRODUCT ETC FORMULA TO CALCULLATE CELL CONTENT AND DISPLAY RESULT.

FORMULA SET - 06

PROJECT- 06 REVISION

16. CREATE A SHEET AS GIVEN BELOW AND GENERATE PIVOT TABLE AND CHART WITH COUNTRY IN FILTER, PRODUCT IN ROWS AND SUM SMOUNT IN VALUES.

COMMAND-:

17. USE SCENARIO MANAGER TO MAKE MULTIPLE PLANS AND CREATE A SUMMARY REPORT

18. PREPARE BELOW SHEET USING PMT FORMULA IN CELL B6 AND USE GOAL SEEK TO FIND LOAN AMOUNT IF MONTHLY PAYMENT IS CHANGED TO 5000.

19. USE VBA CODE TO GENERATE A MODULE TO FORMAT A CELL RANGE.

Sub Format ()

Range(“A1:A10”).Font.Bold = True

Range(“A1:A10”).Font.Size = 20

Range(“A1:A10”).Font.Name = “Arial”

Range(“A1:A10”).Font.Color = vbred

End Sub

PRACTICAL - 01 QUESTION ANSWER PRACTICE

Where to write your full name.

Which font style to apply on full name

Which font size to apply on full name

Which font and fill colour to apply on full name

Where to write village name

What is the font style and size to be applied on village name

What is the fill and font color to be applied on village name

How to resize column width

How to resize row width

Where you saved your file

What is the full name of your document

What is the file extension of your document

Save ctrl+ i

open ctrl+ u

bold ctrl+ a

underline ctrl+ s

Italic ctrl+ b

Select all. ctrl+ o

Rectify command to save document

Click document >click save> select document folder> right file and click open

Rectify command to apply fill color yellow

select cell>open front color>click yellow

PRACTICAL - 02 QUESTION ANSWER PRACTICE

What is to be written in cell A1

Which font style and size to be applied in cell A1

What is to be written in cell b1

Which font style and size to be applied on b1

Write cell range name to be copied

Write seat name where you should place copied data

Which cell range to be applied with copy series option

Which cell range to be applied with fill series option

Command to apply copy-series

Hold button right corner of _____>______

Command to apply fill series option

Hold button right corner of______>open_____>select____

PRACTICAL - 03 QUESTION ANSWER PRACTICE

Which cell range is to be applied with Central alignment option

Which cell range is to be applied with right alignment option

Which cell range is to be applied with left alignment option

Above which row a new row is to be added

What is to be written in cell A1 in new row

Which cell range is to be selected to apply merge cell option

Which font colour and size is to be applied on your name

Which cell range is to be applied with clockwise option

Which cell range is applied with counter clockwise option

What effect does merge cell option applies to cell range

What effect does clockwise option applies to cell range

what effect does counter clockwise option applies to cell range

Command to apply merge cell

Select_________> open_________ click merge cell

Command to apply clockwise option

select ________>open _________>click clockwise

Command to apply unmerge cell

select ________>open _________>select unmerge cell

PRACTICAL - 04 QUESTION ANSWER PRACTICE

To make a sentence to multiple lines _______option to be used

Write keyboard comment to enter current date

Write keyboard comment to enter current time

________ format is used to enter 0010

_______format is used to enter 3/4/2020

_________format is used to enter 3:30:00

_____format is used to enter rupees 2500

_____format is used to enter ⅚

Write cell range where you applied wrap text option

write cell range where you applied date format

write cell range where you applied time format

write cell range where you applied currency format

write cell range where you applied text format

write cell range where you applied fraction format

before applying fill series which cell you selected

write cell range to be applied with table format style

Text 3/8

currency. 4/6/90

time ₹59.89

date 00234

fraction. 3:50

Command to apply wrap text

select cell range> click________

command to apply current format

select cell range> open number format select ________

rectify command to apply fields series select cell range> hold top right corner >drag below

PRACTICAL - 05 QUESTION ANSWER PRACTICE

Where to apply conditional formatting

what type of conditional formatting are available

which icon set conditional formatting to be applied

________ option is used to change up and down value

which row is to be hidden

Write new row name to be added between 4 and 5 row

Write new column name to be added between A and B

which option to be used to remove conditional formatting

which row and column are to be deleted

Command to hide row 2

right click on row 2> click _________

Command to unhide row 2

Select row _____and _____>click_____

right different conditional formatting effects available

PRACTICAL - 06 QUESTION ANSWER PRACTICE

What is the name of picture to be added

Which style, effect and size are to be applied on image

which fill, line colour and thickness to be applied on emoji shape

what is the smart art name you used in sheet

which connector are used to join all

right command to apply picture style

Select______> click______> open style> select________

Right command to apply picture size

Select _______>open _____>deselect ___>Change width and height

Command to add smart art

Click _______>click ________>select ____

Select circle arrow process >click ok

PRACTICAL - 07 QUESTION ANSWER PRACTICE

PRACTICAL - 08 QUESTION ANSWER PRACTICE

PRACTICAL - 09 QUESTION ANSWER PRACTICE

PRACTICAL - 10 QUESTION ANSWER PRACTICE

PRACTICAL - 11 QUESTION ANSWER PRACTICE

PRACTICAL - 12 QUESTION ANSWER PRACTICE

PROJECT - 01 QUESTION ANSWER PRACTICE

QUESTION ANSWER PRACTICE

Which formula you used to find purchase total ____________

which formula you used to find sale total

which formula you use to find sale discount

which formula you used to find profit in case of equal sale and purchase quantity

which formula is used to find balance quantity

write formula for total purchase price

Write formula for average purchase price

Write formula for maximum purchase price

write formula to find minimum purchase price

write formula to find square of total purchase price

Write formula to find 1/10 of total sale price

Write formula for 30% of total sale price

Write formula for 10 less from 25% of average price

Write formula for 50 more than 10% of maximum price

Write formula for maximum between total and average price

Write formula for average between maximum and minimum price

Write formula for half of sum and average price

If A1 = 30 & a2 = 20

Sum. 30

average. 10

maximum 50

minimum 1

count 2

subtract 3/2

division 20

2% of sum. 25

If A1=35 & b1=75 what is the formula to add both number and value for it

if A1 = 65 and b1= 95 what is the formula to find maximum between sum and average and value for it

PROJECT - 02 QUESTION ANSWER PRACTICE

Write formula to find full name

write formula to find discount on purchase

write formula to find special discount

Write formula to display two letter from left of full name

Write formula to display 3 letter from right of full name

Write formula to display contact number without extra space

Write formula to display full name in capital letter

write formula to display full name in small letter

write formula to display full name with first letter as capital

write formula to find no of character in full name

If A1 = cwit & b1 = 2024

Concatenate(b1,A1)=__________

Left(b1,3)=_______

Right(a1,2)=_______

Upper(left(A1,2))=_______

Proper(right(a1,3))=_______

If A1 equal to Ramesh and b1 equal to Sahu then right formula to display Mr Ramesh Sahu in cell c1

If A1 equal to Sunita and A2 equal to Mishra then right formula to displace SUNITA MISHRA in A3

If A1 equal to Rakesh and b1 equal to Das then write formula to display rakeshdas01 in cell c1

If gold price is above 80,000 then discount is 10% else 5% right formula to display final price in b1 if gold price in A1 is 85000

PROJECT - 03 QUESTION ANSWER PRACTICE

PROJECT - 04 QUESTION ANSWER PRACTICE

PROJECT - 05 QUESTION ANSWER PRACTICE

PROJECT - 06 QUESTION ANSWER PRACTICE

ADVANCE PRACTICAL FOR FORMULA SHEET - Q16-Q20

Page updated

Google Sites

Report abuse