MCQ Of Microsoft Excel Set-1st

1. Worksheet can be renamed by

Adding ? symbol at the end of filename while saving workbook

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

Double Click on the Worksheet tab and type new name

Worksheet cannot renamed

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.

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.

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

A. =IF(LogicalTest, TrueResult, FalseResult)

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

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

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

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.

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.

3. How to fit long texts in a single cell with multiple lines?

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

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

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

All of above

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.

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.

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

There is a relative reference to cell A1

There is an absolute reference to cell A1

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

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

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.

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.

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

A. =POWER(2^3)

B. =POWER(2,3)

C. =POWER(2#3)

D. =POWER(2*3)

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

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

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

A. 2 Rows will be inserted after Row 4

B. 2 Rows will be inserted after Row 5

C. 2 Rows will be inserted after Row 6

D. 2 Rows will be inserted after Row 7

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.

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.

7. If the values in A1 is "MCQ" and B1 is "Questions", which function will return "MCQ@Questions" in cell C1?

A. =A1 + “@” + B1

B. =A1 # “@” # B1

C. =A1 & “@” & B1

D. =A1 $ “@” $ B1

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.

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.

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

Fraction

Number

Text

Date

not-available-via-ai

Explanation

not-available-via-ai

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

AUTOEXEC Folder

AUTOSTART Folder

EXCELSTART Folder

XLSTART Folder

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.

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.

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

CTRL + H

CTRL + R

CTRL + 9

CTRL + -

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.

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.