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

View solution

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

View solution

Q. Edit >> Delete command

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Which of the following action removes a sheet from workbook?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Comments put in cells are called .....

View solution

Q. Comments can be added to cells using ......

View solution

Q. Which menu option can be used to split windows into two?

View solution

Q. Getting data from a cell located in a different sheet is called ......

View solution

Q. Which of the following is not a valid data type in Excel?

View solution

Q. Which elements of a worksheet can be protected from accidental modification?

View solution

Q. A numeric value can be treated as label value if ...... precedes it.

View solution

Q. Concatenation of text can be done using

View solution