MCQ Of Microsoft Excel Set-1st
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)
Correct Answer
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)
Correct Answer
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
Correct Answer
A. A. 2 Rows will be inserted after Row 4Explanation
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.
If 4/6 entered in a cell without applying any formats, Excel will treat this as
- A.
Fraction
- B.
Number
- C.
Text
- D.
Date
Correct Answer
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
Correct Answer
C. C. =A1 & “@” & B1Explanation
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
Correct Answer
B. Use the Wrap Text option in the Format -> Alignment menuExplanation
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
Correct Answer
D. XLSTART FolderExplanation
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
Correct Answer
B. There is an absolute reference to cell A1Explanation
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
Correct Answer
C. Double Click on the Worksheet tab and type new nameExplanation
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 + -
Correct Answer
C. CTRL + 9Explanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Jan 06, 2013Quiz Created by
Gupta_gourav763
Back to top