Concept of Worksheets and Workbooks
Category : 9th Class
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:
To save an existing file at different locations you need to perform the following:
Opening an Existing Excel File
To open an existing file performs the following: (See Figure. 9.7.2)
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.
You need to login to perform this action.
You will be redirected in
3 sec