Q. When a row of data is to be converted into columns

View solution

Q. Ctrl + D shortcut key in Excel will

View solution

Q. The short cut key Ctrl + R is used in Excel to

View solution

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

View solution

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

View solution

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