MS Excel -07

01. What is the short cut key to replace a data with another in sheet?

  • 1Ctrl + R
  • 2Ctrl + Shift + R
  • 3Ctrl + H
  • 4Ctrl + F
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

02. You can move a sheet from one workbook into new book by

  • 1From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
  • 2From Edit menu choose Move of Copy then choose (Move to end) and click OK
  • 3From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
  • 4None of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

03. Which of the following is not true about Find and Replace in Excel

  • 1You can search for bold and replace with italics
  • 2You can decide whether to look for the whole word or not
  • 3You can search in formula too
  • 4You can search by rows or columns or sheets
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

04. While Finding and Replacing some data in Excel, which of the following statement is valid?

  • 1You can Find and Replace within the sheet or workbook
  • 2Excel does not have option to match case for find
  • 3Both are valid
  • 4None are valid
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1Right click on Sheet Tab of third sheet and choose Delete from the context menu
  • 2Click on Sheet 3 and from Edit menu choose Delete
  • 3Both of above
  • 4None of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1From Edit menu choose Clear and then Formats
  • 2From Edit menu choose Delete
  • 3Click on Remove Formatting tool on Standard Toolbar
  • 4Double click the Format Painter and then press Esc key in keyboard
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1Edit >> Clear >> Contents
  • 2Edit >> Clear >> All
  • 3Edit >> Delete
  • 4All of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1Edit >> Delete
  • 2Edit >> Clear >> Contents
  • 3Edit >> Clear >> All
  • 4Data >> Delete
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1Square
  • 2Percentage
  • 3Goal Seek
  • 4Divide
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

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

  • 1Validation
  • 2Formats
  • 3Formulas
  • 4All of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

Page 1 Of 2
Test
Classes
E-Book