# MCQ Of Microsoft Excel Set-1st

10 Questions | Total Attempts: 653  Settings  This Quiz is just as similar to IBPS and other banking exams so that it would be easy to give the exams likewise. .

• 1.
IBPS-1-1. Which of the following is correct syntax in Excel?
• A.

A. =IF(LogicalTest, TrueResult, FalseResult)

• B.

B. =IF(LogicalTest, (TrueResult, FalseResult))

• C.

C. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

• D.

D. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

• 2.
IBPS-1-2. Which of the following is correct?
• A.

A. =POWER(2^3)

• B.

B. =POWER(2,3)

• C.

C. =POWER(2#3)

• D.

D. =POWER(2*3)

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

A. 2 Rows will be inserted after Row 4

• B.

B. 2 Rows will be inserted after Row 5

• C.

C. 2 Rows will be inserted after Row 6

• D.

D. 2 Rows will be inserted after Row 7

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

Fraction

• B.

Number

• C.

Text

• D.

Date

• 5.
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “[email protected]” in cell C1?
• A.

A. =A1 + “@” + B1

• B.

B. =A1 # “@” # B1

• C.

C. =A1 & “@” & B1

• D.

D. =A1 \$ “@” \$ B1

• 6.
How to fit long texts in a single cell with multiple lines?
• A.

Start typing in the cell and press the Enter key to start another line

• B.

Use the Wrap Text option in the Format -> Alignment menu

• C.

Use the Shrink to Fit option in the Format -> Cells -> Alignment menu

• D.

All of above

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

AUTOEXEC Folder

• B.

AUTOSTART Folder

• C.

EXCELSTART Folder

• D.

XLSTART Folder

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

There is a relative reference to cell A1

• B.

There is an absolute reference to cell A1

• C.

Further changes in value of A1 will not affect the value of B1

• D.

Further changes in value of B1 will affect the value of A1

• 9.
Worksheet can be renamed by
• A.

Adding ? symbol at the end of filename while saving workbook

• B.

Click on Worksheet tab by Holding CTRL Key and type new name

• C.

Double Click on the Worksheet tab and type new name

• D.

Worksheet cannot renamed

• 10.
What is the shortcut key to hide entire row?
• A.

CTRL + H

• B.

CTRL + R

• C.

CTRL + 9

• D.

CTRL + -

Related Topics Back to top