MCQ Of Microsoft Excel Set-1st

10 Questions | By Gupta_gourav763 | Last updated: Mar 22, 2022 | Total Attempts: 698

Questions

Settings

Create your own Quiz

This Quiz is just as similar to IBPS and other banking exams so that it would be easy to give the exams likewise. .

Questions and Answers

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 + -