MCQ Of Microsoft Excel Set-1st

10 Questions | Total Attempts: 653

SettingsSettingsSettings
MCQ Quizzes & Trivia

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

Back to Top Back to top