Computer Science

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 111 - 120 of 1111 Questions

Which of the following action removes a sheet from workbook?

A Select the sheet, then choose Edit >> Delete Sheet
B Select the sheet then choose Format >> Sheet >> Hide
C Both of above
D None of above
Correct Answer

Option A: Select the sheet, then choose Edit >> Delete Sheet


Discussion

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?

A Right click on Sheet Tab of third sheet and choose Delete from the context menu
B Click on Sheet 3 and from Edit menu choose Delete
C Both of above
D None of above
Correct Answer

Option A: Right click on Sheet Tab of third sheet and choose Delete from the context menu


Discussion

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

A From Edit menu choose Clear and then Formats
B From Edit menu choose Delete
C Click on Remove Formatting tool on Standard Toolbar
D Double click the Format Painter and then press Esc key in keyboard
Correct Answer

Option A: From Edit menu choose Clear and then Formats


Discussion

The Delete key of keyboard is assigned to which command in Excel?

A Edit >> Clear >> Contents
B Edit >> Clear >> All
C Edit >> Delete
D All of above
Correct Answer

Option A: Edit >> Clear >> Contents


Discussion

To remove the content of selected cells you must issue ______ command

A Edit >> Delete
B Edit >> Clear >> Contents
C Edit >> Clear >> All
D Data >> Delete
Correct Answer

Option B: Edit >> Clear >> Contents


Discussion

Edit >> Delete command

A Deletes the content of a cell
B Deletes Formats of cell
C Deletes the comment of cell
D Deletes selected cells
Correct Answer

Option D: Deletes selected cells


Discussion

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A Square
B Percentage
C Goal Seek
D Divide
Correct Answer

Option D: Divide


Discussion

Which of the following you can paste selectively using Paste Special command?

A Validation
B Formats
C Formulas
D All of above
Correct Answer

Option D: All of above


Discussion

Which of the following series type is not valid for Fill Series dialog box?

A Linear
B Growth
C Autofill
D Time
Correct Answer

Option D: Time


Discussion

The command Edit >> Fill Across Worksheet is active only when

A One sheet is selected
B When many sheets are selected
C When no sheet is selected
D None of above
Correct Answer

Option B: When many sheets are selected


Discussion



WhatsApp Support