MCQ Of Microsoft Excel Set-1st

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Gupta_gourav763
G
Gupta_gourav763
Community Contributor
Quizzes Created: 2 | Total Attempts: 2,354
Questions: 10 | Attempts: 721

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)

A. A. =IF(LogicalTest, TrueResult, FalseResult)
Explanation
The correct syntax in Excel is A. =IF(LogicalTest, TrueResult, FalseResult). This formula is used to perform a logical test and return different results based on whether the test is true or false. The LogicalTest is the condition that is being evaluated, TrueResult is the value or expression that is returned if the condition is true, and FalseResult is the value or expression that is returned if the condition is false.

Rate this question:

• 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)

B. B. =POWER(2,3)
Explanation
The correct answer is B. =POWER(2,3). This is because the POWER function in Excel is used to calculate the result of a number raised to a specified power. In this case, the number 2 is raised to the power of 3, resulting in 8. The syntax for the POWER function is =POWER(number, power). Therefore, the correct format for raising 2 to the power of 3 is =POWER(2,3).

Rate this question:

• 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

A. A. 2 Rows will be inserted after Row 4
Explanation
Selecting Rows 5 & 6 and choosing Insert->Row will insert 2 rows after Row 4. This means that the existing Row 5 and Row 6 will shift down, and the new rows will be added after Row 4.

Rate this question:

• 4.

• A.

Fraction

• B.

Number

• C.

Text

• D.

Date

D. Date
• 5.

If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?

• A.

A. =A1 + “@” + B1

• B.

B. =A1 # “@” # B1

• C.

C. =A1 & “@” & B1

• D.

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

C. C. =A1 & “@” & B1
Explanation
The correct answer is C. =A1 & “@” & B1. This function uses the ampersand (&) operator to concatenate the values in cell A1, the "@" symbol, and the values in cell B1, resulting in the desired output "MCQ@Questions" in cell C1.

Rate this question:

• 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

B. Use the Wrap Text option in the Format -> Alignment menu
Explanation
To fit long texts in a single cell with multiple lines, the correct answer is to use the Wrap Text option in the Format -> Alignment menu. This option allows the text to wrap within the cell, automatically adjusting the height of the cell to accommodate the text. By selecting this option, the text will be displayed in multiple lines within the cell, making it easier to read and fit within the available space.

Rate this question:

• 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

D. XLSTART Folder
Explanation
The correct answer is XLSTART Folder. The XLSTART folder is a special folder in Excel that contains workbooks that are automatically opened when Excel starts. Placing the workbook in the XLSTART folder ensures that it will be opened every time Excel is launched. This is useful for workbooks that need to be accessed frequently or serve as templates for new workbooks.

Rate this question:

• 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

B. There is an absolute reference to cell A1
Explanation
The formula in cell B1 contains an absolute reference to cell A1. This means that the value in cell B1 will always refer to the value in cell A1, regardless of any changes made to the value in cell A1. Any further changes in the value of A1 will not affect the value of B1.

Rate this question:

• 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

C. Double Click on the Worksheet tab and type new name
Explanation
To rename a worksheet, you can double click on the worksheet tab and type a new name. This action allows you to directly edit the name of the worksheet.

Rate this question:

• 10.

What is the shortcut key to hide entire row?

• A.

CTRL + H

• B.

CTRL + R

• C.

CTRL + 9

• D.

CTRL + -

C. CTRL + 9
Explanation
Pressing CTRL + 9 is the shortcut key to hide an entire row in Excel. This shortcut allows users to quickly hide a row without having to go through the menu options.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 22, 2023
Quiz Edited by
ProProfs Editorial Team
• Jan 06, 2013
Quiz Created by
Gupta_gourav763

Related Topics