Category: MS-Excel Mcqs

Correct Answer: B. 2 Columns will be Inserted after Column D

By Selecting columns E and F then choosing the inserting column will insert 2  Column after D Column.

Correct Answer: B. The Settings tab under the menu Data -> Validation

In MS Excel, in Settings tab under the menu Data – Validation is used to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

Correct Answer: C. Contents Only

In MS Excel, Click a cell then press Delete key or Backspace, you clear the cell contents without removing any cell formats or cell comments.

Correct Answer: B. Alt + Enter

In MS Excel, Alt + Enter key is often used to insert a new line in a Microsoft Excel.

Correct Answer: D. Click on the rectangle box on the upper left corner where column headings and row headings meet

Click on the Rectangle Box on the upper left corner where column headings and row heading meet is the quickest way to select entire worksheet, In Microsoft Excel.

Correct Answer: A. The Data in the cell is Changed or Deleted

In MS Excel, A small tag is a small button that appears as data is entered or selected on a spreadsheet. This button provides actions based on the data in the cells.

Correct Answer: B. =Power(3,3)

Power Function in MS Excel returns a number raised to a given power. The Power function is an alternative to the Exponent Operator (^) =Power(3,3)

Correct Answer: A. XFD

In Microsoft Excel 2007 and earlier or newer versions the last columns header is XFD.

Correct Answer: B. Review

In MS Excel, New Comment option can be found under Review tab, In which you can add a comment about selected text.

Correct Answer: A. Right Aligned

In MS Excel numeric values appears Right Aligned by default. Numerical values contains date, time, exponential number Security codes etc.