Q. Which of the following function will return a value of 8?

View solution

Q. How to restrict to run a macro automatically when starting Microsoft Excel?

View solution

Q. How to remove the unwanted action from recorded macro without recording the whole macro again?

View solution

Q. What should be add before a fraction to avoid entering it as a date?

View solution

Q. Which of the following function will use to find the highest number in a series of number?

View solution

Q. What does the NOW() function return?

View solution

Q. What value will display if the formula = “$55.00″+5 is entered into a cell?

View solution

Q. What is the shortcut key to insert current date in a cell?

View solution

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