Class 6 Exam  >  Class 6 Videos  >  Computer Science for Class 6  >  MS Excel 2010: Cells, Rows & Columns

MS Excel 2010: Cells, Rows & Columns Video Lecture | Computer Science for Class 6

49 videos|20 docs|6 tests

Top Courses for Class 6

FAQs on MS Excel 2010: Cells, Rows & Columns Video Lecture - Computer Science for Class 6

1. What is the purpose of cells, rows, and columns in MS Excel 2010?
Ans. Cells, rows, and columns in MS Excel 2010 are used to organize and store data in a tabular format. Cells are the basic unit of data storage, rows are horizontal collections of cells, and columns are vertical collections of cells. They allow users to input and manipulate data in a structured manner, making it easier to perform calculations, analyze data, and create charts and graphs.
2. How do I insert a new row or column in MS Excel 2010?
Ans. To insert a new row in MS Excel 2010, select the row below which you want to insert the new row. Right-click on the selected row and choose "Insert" from the context menu. A new row will be inserted above the selected row. To insert a new column, select the column to the right of which you want to insert the new column, right-click, and choose "Insert" from the context menu. A new column will be inserted to the left of the selected column.
3. Can I change the width or height of a row or column in MS Excel 2010?
Ans. Yes, you can change the width of a column or the height of a row in MS Excel 2010. To change the width of a column, move your cursor to the right border of the column header until it changes to a double-headed arrow. Click and drag the border to adjust the width. To change the height of a row, move your cursor to the bottom border of the row header until it changes to a double-headed arrow. Click and drag the border to adjust the height.
4. How can I merge cells in MS Excel 2010?
Ans. To merge cells in MS Excel 2010, select the cells you want to merge. Right-click on the selected cells and choose "Merge Cells" from the context menu. The selected cells will be merged into a single cell, with the content aligned to the top-left cell. Note that merging cells only retains the content of the top-left cell, discarding the content of other merged cells.
5. Is it possible to apply formatting to cells, rows, and columns in MS Excel 2010?
Ans. Yes, MS Excel 2010 allows you to apply formatting to cells, rows, and columns. You can change the font style, size, and color, apply borders and shading, and format numbers and dates. To apply formatting, select the cells, rows, or columns you want to format, right-click, and choose the desired formatting options from the context menu. Additionally, you can access the formatting options from the Home tab in the Excel ribbon.
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

MCQs

,

Objective type Questions

,

Important questions

,

ppt

,

practice quizzes

,

video lectures

,

Rows & Columns Video Lecture | Computer Science for Class 6

,

study material

,

Sample Paper

,

MS Excel 2010: Cells

,

Exam

,

pdf

,

Extra Questions

,

MS Excel 2010: Cells

,

Rows & Columns Video Lecture | Computer Science for Class 6

,

Summary

,

MS Excel 2010: Cells

,

shortcuts and tricks

,

mock tests for examination

,

Previous Year Questions with Solutions

,

Free

,

Rows & Columns Video Lecture | Computer Science for Class 6

,

Semester Notes

,

Viva Questions

,

past year papers

;