Excel Exercises

MS Excel Day 1

SOOPRO Pathshala Exercises

Day 1

1. What is Excel?

2. When it was initially released?

MS Excel Day 2

SOOPRO Pathshala Exercises

Day 2

1. Write short notes on worksheet in Excel?

1. Write short notes on workbook in Excel?

MS Excel Day 3

SOOPRO Pathshala Exercises

Day 3

1. Excel 2.0 was released in which year?

2. Excel 3.0 was released in which year?

MS Excel Day 4

SOOPRO Pathshala Exercises

Day 4

1. What is header and footer in MS Excel?

2. What is the use of Find and Replace in MS Excel?

MS Excel Day 5

SOOPRO Pathshala Exercises

Day 5

1. Write steps for password protection on your worksheet.

2. What is Data Filtering?

MS Excel Day 6

SOOPRO Pathshala Exercises

Day 6

1. What is Data Sorting?

2. What is Chart in Excel?

MS Excel Day 7

SOOPRO Pathshala Exercises

Day 7

1. What is row in Excel?

2. What is column in Excel?

MS Excel Day 8

SOOPRO Pathshala Exercises

Day 8

1. What is cell in Excel?

2. What is cell reference?

MS Excel Day 9

SOOPRO Pathshala Exercises

Day 9

1. What is active cell in Excel?

2. What is worksheet tab in Excel?

MS Excel Day 10

SOOPRO Pathshala Exercises

Day 10

1. What is formula?

2. What is formula bar?

MS Excel Day 11

SOOPRO Pathshala Exercises

Day 11

1. What is formula bar?

2. What is address bar?

MS Excel Day 12

SOOPRO Pathshala Exercises

Day 12

1. What is Ribbon Start Button?

2. What is Ribbon Tabs?

MS Excel Day 13

SOOPRO Pathshala Exercises

Day 13

1. Steps to launch Excel?

2. What is the use of SUM() function?

MS Excel Day 14

SOOPRO Pathshala Exercises

Day 14

1. Create Student Report Card in Excel

MS Excel Day 15

SOOPRO Pathshala Exercises

Day 15

1. Create Sales Data Report in Excel

MS Excel Day 16

SOOPRO Pathshala Exercises

Day 16

1. Create Attendance sheet in Excel

MS Excel Day 17

SOOPRO Pathshala Exercises

Day 17

1. Create Salary Slip in Excel

MS Excel Day 18

SOOPRO Pathshala Exercises

Day 18

1. Create Maintain Stock in Excel

MS Excel Day 19

SOOPRO Pathshala Exercises

Day 19

1. Create Stock Register with profit and loss in Excel

MS Excel Day 20

SOOPRO Pathshala Exercises

Day 20

1. Create Bill in Excel

MS Excel Day 21

SOOPRO Pathshala Exercises

Day 21

1. Create Employee attendance with salary slip in Excel

MS Excel Day 22

SOOPRO Pathshala Exercises

Day 22

1. Create Overtime in Excel

MS Excel Day 23

SOOPRO Pathshala Exercises

Day 23

1. Create Multiple work sheet calculation in Excel

MS Excel Day 24

SOOPRO Pathshala Exercises

Day 24

1. Create Filter in Excel

MS Excel Day 25

SOOPRO Pathshala Exercises

Day 25

1. Create Filter in other sheet in Excel

MS Excel Day 26

SOOPRO Pathshala Exercises

Day 26

1. Create Conditional Formatting in Excel

MS Excel Day 27

SOOPRO Pathshala Exercises

Day 27

1. Create Advanced Conditional Formatting in Excel

MS Excel Day 28

SOOPRO Pathshala Exercises

Day 28

1. Create Tax Invoice in Excel

MS Excel Day 29

SOOPRO Pathshala Exercises

Day 29

1. Create Daily Expenses in Excel

MS Excel Day 30

SOOPRO Pathshala Exercises

Day 30

1. Create LCM and PMT in Excel

MS Excel Day 31

SOOPRO Pathshala Exercises

Day 31

1. Create Invoice in Excel

MS Excel Day 32

SOOPRO Pathshala Exercises

Day 32

1. Convert upper case and lowercase of list of fruits name.

MS Excel Day 33

SOOPRO Pathshala Exercises

Day 33

1. Freez Top row of excel.

MS Excel Day 34

SOOPRO Pathshala Exercises

Day 34

1. Freez First column of excel.