#Value! Error in Microsoft Excel represents:...?

Question

Accepted Answer

Parameter provided to the function is of wrong data type

Computer MCQs

#Value! Error in Microsoft Excel represents:...?

(i) The width of the cell is less to display the answer (ii) Parameter provided to the function is of wrong data type

(iii) Value of the answer needs to be round off (iv) When Excel does not recognize the format

The formula used to perform calculations in the worksheet can be inserted with the help of:...?

(i) Insert OLE object icon (ii) Insert Formula icon

(iii) Insert Applet icon (iv) Insert Plug-in icon

Where is a list of all functions displayed:...?

(i) Text box (ii) Dialog box

(iii) Function box (iv) Category box

Main window in a computer spreadsheet is called:...?

(i) Workbook (ii) Work

(iii) Account book (iv) Worksheet

When a new row is inserted:...?

(i) All preceding rows are moved toward the top of the worksheet (ii) All following are shifted to the right

(iii) All following rows are moving towards the bottom of the worksheet (iv) Both A & C

In MS-Excel two common wildcard characters that MS Excel recognizes are:...?

(i) * and? (ii) < and >

(iii) ^ and / (iv) None of these

Which one is not the correct method of editing a cell's content:...?

(i) Press the Alt key (ii) Press the F2 key

(iii) Click the formula bar (iv) Double click

In MS Excel the command used to combine /merge the consecutively selected cells andcenter aligned is:...?

(i) Combine & Center (ii) Merge & Center

(iii) Merge Cells (iv) Combine

In MS Excel function to return one value if a condition is true and another value if it's false:...?

(i) If function (ii) Sum function

(iii) Decimal function (iv) Info function

The cell referencing that does not change when copied is:...?

(i) Absolute (ii) Comparative

(iii) Relative cell addressing (iv) Reference

Best of Luck

From ShineGk.com

Share our website's link

Shine Test Preparation Academy

Which Profession Suits You

Your Profession

Latest 1000 G.K MCQ'S

1000+ Latest MCQS

If You Are President

You President

Animal That's Match You

Your Hero Animal

Calculate Love With Family

Love Calculator

If You Have A Government

Your Government

Which Car Suits You

Your Car

(i) The width of the cell is less to display the answer

(ii) Parameter provided to the function is of wrong data type

(iii) Value of the answer needs to be round off

(iv) When Excel does not recognize the format

(i) Insert OLE object icon

(ii) Insert Formula icon

(iii) Insert Applet icon

(iv) Insert Plug-in icon

(i) Text box

(ii) Dialog box

(iii) Function box

(iv) Category box

(i) Workbook

(ii) Work

(iii) Account book

(iv) Worksheet

(i) All preceding rows are moved toward the top of the worksheet

(ii) All following are shifted to the right

(iii) All following rows are moving towards the bottom of the worksheet

(iv) Both A & C

(i) * and?

(ii) < and >

(iii) ^ and /

(iv) None of these

(i) Press the Alt key

(ii) Press the F2 key

(iii) Click the formula bar

(iv) Double click

(i) Combine & Center

(ii) Merge & Center

(iii) Merge Cells

(iv) Combine

(i) If function

(ii) Sum function

(iii) Decimal function

(iv) Info function

(i) Absolute

(ii) Comparative

(iii) Relative cell addressing

(iv) Reference