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)
- 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 + -
Questions: 8 | Attempts: 13290 | Last updated: Jan 6, 2021
-
Sample QuestionWhich of the following covers most of the Earth's surface?
Questions: 10 | Attempts: 11872 | Last updated: Jun 19, 2020
-
Sample QuestionC language has been developed by ?
Questions: 20 | Attempts: 10910 | Last updated: Jun 19, 2020
-
Sample QuestionTwo main measures for the efficiency of an algorithm are
Back to top