Excel

10 Questions

Settings
Please wait...
Excel Quizzes & Trivia

.


Questions and Answers
  • 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)

  • 2. 
    Which of the following is correct?
    • A. 

      POWER(2^3)

    • B. 

      POWER(2,3)

    • C. 

      POWER(2#3)

    • D. 

      POWER(2*3)

  • 3. 
    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

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

      A1 + “@” + B1

    • B. 

      A1 # “@” # B1

    • C. 

      A1 & “@” & B1

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