Class 6 Computer MS Excel 2010 Question and Answers

Last updated on June 28th, 2023 at 09:34 pm

The maximize button enlarges the excel window up to its standard size.[MAXIMIZE]

 

Answer the following questions: 

 

• [Q] What is a spreadsheet?
• A spreadsheet is also known as a worksheet in Excel. The first Electronic spreadsheet software was developed in 19178. It was called VisiCalc.

 

• [Q] What are rows and columns?
• The horizontal divisions on a worksheet are called rows. An excel worksheet contains 10, 48, 576 rows.Columns are the vertical divisions of a worksheet. There are 16,384 columns in an Excel worksheet.

 

• [Q] How does the auto-fill feature work?
• In MS Excel, autofill allows users to automatically fill numbers or text series.

 

 

• [Q] how to start Microsoft Excel?
• Steps:

1.   Click the start button on your desktop
2.   Then click “all programs”
3.   Go to Microsoft Office and click on it
4.   Click on Microsoft Excel 2010

Or

1.   Using windows key and r key together. The run dialog box will appear.
2.   Click OK after typing excel.

 

• [Q] In Excel 2010, what is the default name for a new workbook?
• Book1

 

• [Q] What are the extensions of Excel 2010?
• .xlsx

 

• [Q] Define title bar
• A title bar appears at the top of MS Excel 2010. It shows the name of the workbook. The minimize, maximize, and close buttons are located to the right of the title bar.

 

• [Q] Define quick access
• Quick access toolbar contains frequently used commands such as save, undo, and redo.

 

• [Q] Which options are present in file tab
• Print, save as, close, and new are all options.

 

• [Q] What is the function of the view bar?
• With the view bar, we can view the worksheets in different modes: normal view, page layout view, and page break view.

• [Q] How many rows and columns are there in MS excel 2010?
• There are 1,048,576 rows and 16,384 columns in one sheet.

 

• [Q] What is the maximum number of characters one cell can have in MS Excel?
• A cell can contain a maximum of 32,767 characters.

 

• [Q] Write down the steps to open a new workbook in MS excel 2010.

1.   Click on the file tab.
2.   Click on the new option
3.   Click on blank worksheet or a template   
4.  Or   Press ctrl + n

 

[Q] Write down the steps to save a workbook.

1.   Click on the file tab.
2.   Click on the save option. This will open the save as dialog box.
3.   Select the desired folder where you want to save this file
4.   Give the file a name
5.   Click save
6. Or Ctrl + s

 

[Q] Write down the steps to open a workbook

1.   Click on the file tab.
2.   Click on the open option. This will open the open dialog box.
3.   Browse the folder where your file is saved
4.   Click on the file or write the name of the file
5.   Click open

 

• [Q] How to close a workbook?

1.   Click on the file tab.
2.   Click on the exit option

• Or
• Go to right side on the title bar and click close
• Or
• Alt +f4

 

• [Q] How many worksheets are there by default in a workbook?
• There are 3 by default worksheets in MS excel 2010

 

• [Q] What key should he press to open a cell in edit mode?
• To open a cell in edit mode, press the F2 key.

 

Class 6 Computer More On PowerPoint 2010 Question Answer