End Of Term - Year 9

28 Questions | Total Attempts: 45

SettingsSettingsSettings
Please wait...
End Of Term - Year 9

.


Questions and Answers
  • 1. 
    How many sheets in the file? 
    • A. 

      5

    • B. 

      3

    • C. 

      4

    • D. 

      1

  • 2. 
    What is the result of this formula:=C2+B5+A2 
  • 3. 
    What is the font size used ?
    • A. 

      11

    • B. 

      24

    • C. 

      12

    • D. 

      8

  • 4. 
    How many rows are filled with data? 
    • A. 

      4

    • B. 

      3

    • C. 

      7

    • D. 

      1

  • 5. 
    Which sheet is the active sheet? 
    • A. 

      Test 4

    • B. 

      Test4

    • C. 

      Final

    • D. 

      Contacts

  • 6. 
    Cell C3 contain a formula that add B3, B4 and B5, what value will be there if B4 changed from 2 to 12?    
    • A. 

      27

    • B. 

      17

    • C. 

      12

    • D. 

      22

  • 7. 
    What is the function used in cell C4 ?
    • A. 

      LOWER(A3)

    • B. 

      LOWER(B3)

    • C. 

      Rajab

    • D. 

      =rajab

  • 8. 
    What is the name of this spreadsheet file?
    • A. 

      Test4

    • B. 

      Test 4

    • C. 

      Excel

    • D. 

      Contacts

  • 9. 
    What is the result of this formula:=(B2+A4)*C4 
  • 10. 
    What is the result of this formula:=(A2*B3)-C4 
  • 11. 
    What is the result of this formula:=B5/A3*B3 
  • 12. 
    Excel files are called Worksheet
    • A. 

      True

    • B. 

      False

  • 13. 
    The number of worksheet allowed in Excel file is 3 sheets only
    • A. 

      True

    • B. 

      False

  • 14. 
    Sheet’s name must be unique and at least character long. 
    • A. 

      True

    • B. 

      False

  • 15. 
    A pre-defined formula in Excel is called a function
    • A. 

      True

    • B. 

      False

  • 16. 
    AND function will return TRUE if all condition are met, otherwise it returns FALSE
    • A. 

      True

    • B. 

      False

  • 17. 
    A formula must begin with a plus sign.
    • A. 

      True

    • B. 

      False

  • 18. 
    What is the result of the following function:=PROPER(C4)
  • 19. 
    What is the result of the following function:=EXACT(B2,D5)
  • 20. 
    What is the result of the following function:=MAX(A1:A5)
  • 21. 
    What is the result of the following function:=LOWER(C3)
  • 22. 
    What is the result of the following function:=MIN(A1:A5)
  • 23. 
    What is the result of the following function:=EXACT(C2,D4)
  • 24. 
    What is the result of the following function:=UPPER(C4)
  • 25. 
    What is the result of the following function:=UPPER(C2)
Back to Top Back to top