Class 6 Exam  >  Class 6 Videos  >  How to become an Expert of MS Excel  >  MS Excel: Basics

MS Excel: Basics Video Lecture | How to become an Expert of MS Excel - Class 6

94 videos|62 docs|15 tests

Top Courses for Class 6

FAQs on MS Excel: Basics Video Lecture - How to become an Expert of MS Excel - Class 6

1. What is MS Excel and what are its basic functions?
Ans. MS Excel is a spreadsheet software developed by Microsoft. It is used for organizing, analyzing, and manipulating data. Its basic functions include entering and editing data, performing calculations using formulas, creating charts and graphs, and sorting and filtering data.
2. How can I enter data in MS Excel?
Ans. To enter data in MS Excel, select the cell where you want to enter the data and type it directly on the keyboard. Press Enter or Tab to move to the next cell. You can also copy and paste data from other sources, such as a website or another spreadsheet.
3. How do I calculate the sum of a range of cells in MS Excel?
Ans. To calculate the sum of a range of cells in MS Excel, select the cell where you want the sum to appear. Then, use the SUM function by typing "=SUM(" followed by the range of cells you want to add. For example, "=SUM(A1:A10)" will calculate the sum of cells A1 to A10.
4. How can I create a chart in MS Excel?
Ans. To create a chart in MS Excel, select the data you want to include in the chart. Then, go to the Insert tab and click on the desired chart type, such as a column chart or a pie chart. Excel will generate a chart based on the selected data, which you can customize further using various formatting options.
5. How do I sort and filter data in MS Excel?
Ans. To sort data in MS Excel, select the range of cells you want to sort. Then, go to the Data tab and click on the Sort button. Choose the column you want to sort by and select the sorting order (ascending or descending). To filter data in MS Excel, select the range of cells you want to filter. Then, go to the Data tab and click on the Filter button. Excel will add filter arrows to the headers of the selected range. Click on the filter arrow of a specific column to choose the desired filter criteria.
94 videos|62 docs|15 tests
Explore Courses for Class 6 exam
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

Important questions

,

Sample Paper

,

Objective type Questions

,

MS Excel: Basics Video Lecture | How to become an Expert of MS Excel - Class 6

,

mock tests for examination

,

shortcuts and tricks

,

MS Excel: Basics Video Lecture | How to become an Expert of MS Excel - Class 6

,

study material

,

Extra Questions

,

Viva Questions

,

MCQs

,

MS Excel: Basics Video Lecture | How to become an Expert of MS Excel - Class 6

,

Free

,

ppt

,

pdf

,

Summary

,

video lectures

,

Previous Year Questions with Solutions

,

Exam

,

past year papers

,

Semester Notes

,

practice quizzes

;