Q. What is the shortcut key to hide entire column?

View solution

Q. How to specify cell range from A9 to A99 in Excel?

View solution

Q. Selecting the Column G & H then choose Insert->Columns. What will happen?

View solution

Q. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

View solution

Q. Clear the contents by pressing “DELETE” key from a keyboard will clear

View solution

Q. Which of the following shortcuts can be used to insert a new line in the same cell?

View solution

Q. What is the quickest way to select entire worksheet?

View solution

Q. A smart tag will be removed from a cell when

View solution

Q. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

View solution

Q. Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?

View solution

Q. If 4/6 entered in a cell without applying any formats, Excel will treat this as

View solution

Q. How to fit long texts in a single cell with multiple lines?

View solution

Q. If particular workbook have to open each time Excel started, where that workbook should be placed?

View solution

Q. If the cell B1 contains the formula = $A$1, which of the following statements is true

View solution

Q. Worksheet can be renamed by

View solution

Q. What is the shortcut key to hide entire row?

View solution

Q. What is the shortcut key to insert a new comment in a cell?

View solution

Q. Which option allows you to Bold all the negative values within the selected cell range:

View solution

Q. What is the shortcut key to insert new sheet in current workbook?

View solution

Q. Which one is the last column header in Excel 2007?

View solution