9th Class Computers Science Microsoft Excel Concept of Worksheets and Workbooks

  Concept of Worksheets and Workbooks

A single spreadsheet page is called worksheet. A workbook is a collection of all the worksheets in a single file. Basically workbook contains worksheet, such as a magazine contains page. In other words you can say a workbook is the MS Excel file allows maintaining and storing data. A worksheet is a collection of cells on a single sheet allows manipulating data.  

 Creating New Worksheet

To create a new worksheet on Excel, you require opening 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 2003. For future uses Excel provides 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, as shown in the following figure: (See Figure. 9.7.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 locations you need to perform 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.    

  Opening an Existing Excel File

To open an existing file performs the following: (See Figure. 9.7.2)                

• Firstly select File -> Open menu option to display Open dialog box, as shown in the following figure:
• Then select location such as E: drive, where you have 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.  

 Which one of the following statements is true?

Statement A: Lotus SmartSuite is also known as Lotus SmartSuite was released in 2008.

Statement B: Lotus SmartSuite was released in 2005.

(A) Statement A is correct

(B) Statement B is correct

(C) Statement A and B are correct

(D) Neither statement A nor statement B is correct  

Answer: (A)

Explanation

Correct Option:

(A) Only statement A is true.

Incorrect Options:

Rest of the options is incorrect.    

 An Excel file which contains several worksheets is referred as a workbook. 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 Option:

Rest of the options is incorrect.        

 A column and rows are the vertical and horizontal group of cells. The Maximum numbers of rows you 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.