6th Class Computers Science Getting Started with Spread Sheet How to Create New worksheet  

     How to Create New worksheet

To create a new worksheet on Excel, you required to open MS Excel, For opening an Excel sheet, you need to select Start then proceeding further to Programs then move to Microsoft Office and from there you need to select Microsoft Office Excel

   For future uses Excel provide the facilities of saving a document. Saving a new file for the first time:

• You need to click File  Save as, to open the Save As dialog box. (See Figure. 6.5.1)
• Now select the exact location where you need to save the file.
• Then provide a name to the particular file in the File name textbox place.
• Finally click Save to save the particular file.  

   To save an existing file at different location you need to follow the following:

• Firstly open an existing file.
• Then click File  Save As to display the dialog box Save As.
• Further select the location where you need to save the particular file.
• Provide another name in the File name box, if you need to save/create at the same location another copy of same document.
• Finally click Save to save/create another copy of the same file at desired location where you need it.
• Ctrl + S shortcut key can also be used to save a file.  

    How to Open a File  

    In Microsoft Excel to open an existing file we need to follow as: (See Figure)

• Firstly select File Open menu option to display Open dialog box.
• Then select location such as E: drive, where you already saved a file from the Look in list.
• Thus select a particular file.
• Finally click Open to open the desired file you want to open.  

 An Excel file which contains several worksheets is referred as a workbook. Spreadsheet helps in____.

(A) Preparing invoice                                     

(B) Creating business planning

(C) Financial accounting                                

(D) All of these

(E) None of these  

Answer: (d)

Explanation

Correct Option:

(A) Spreadsheet helps in preparing invoice.

(B) Spreadsheet helps in creating business planning.

(C) Spreadsheet helps in financial accounting.

Incorrect Options:

Rest of the option is incorrect.    

 Rows and Columns are the main component of worksheets. Maximum numbers of columns you can enter in an Excel worksheet are____.

(A) 256                                                                 

(B) 254

(C) 556                                                                 

(D) Unlimited

(E) None of these  

Answer: (a)

Explanation

Correct Option:

(A)You can insert maximum 256 columns in an excel worksheet.

Incorrect Options:

Rest of the options is incorrect.      

 Jack is working on excel sheet. He inserts number of rows in worksheet. The Maximum numbers of rows Jack can enter in an Excel worksheet are ___rows.

(A) 65536                                                            

(B) 256

(C) 6553                                                               

(D) 65534

(E) None of these  

Answer: (a)

Explanation

Correct Option:

(A) You can insert maximum 65536 rows in an excel worksheet.

Incorrect Options:

Rest of the options is incorrect.