6th Class Computers Science Getting Started with Spread Sheet Inserting, Deleting and Renaming Sheets

     Inserting, Deleting and Renaming Sheets

By default Excel enables only three sheets. You can insert, add and delete sheet in existing worksheet according to your requirements. To adding a new sheet

• Click Insert  Worksheet menu.  

To delete a sheet: 

• Click Edit  Delete sheet  menu option to display message box.
• Click the Delete button to show the dialog box.  

To rename a sheet: 

• Click Format  Sheet  Rename menu.
• Specify a name such as my sheet at the base of the sheet.
• Click the OK button to accept the changed name.      

 Jack working on Excel sheet. He wants to open Conditional Formatting dialog box. Which one of the following step Jack need to perform to get same output?

(A) Format Conditional Formatting

(B) Format StyleConditional Formatting

(C) Format  Cells Conditional Formatting

(D) Format Sheet Conditional Formatting

(E) None of these

Answer: (a)

Explanation

Correct Option:

(A) Select Format Conditional Formatting to display the Conditioning Formatting dialog box.

Incorrect Options:

Rest of the options is incorrect.      

 Editing the style of text, numbers and the pages based on conditions are performed under______ option.

(A) Formatting                                                 

(B) Alignment

(C) Customize                                                   

(D) All of these

(E) None of these  

Answer: (a)

Explanation

Correct Option:

(A) Formatting option allows you to edit style of text and numbers.

Incorrect Options:

Rest of the options is incorrect.    

 An Excel file which contains several worksheets is referred as a workbook. By default Excel enables only ____ sheets.

(A) Two                                                               

(B) Three

(C) Four                                                               

(D) Five

(E) None of these  

Answer: (b)

Explanation

Correct Option:

(A) By default Excel enables only three sheets.

Incorrect Options:

Rest of the options is incorrect.