End Of Term Assessment

23 Questions | Total Attempts: 69

SettingsSettingsSettings
Please wait...
Assessment Quizzes & Trivia

Questions and Answers
  • 1. 
    How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?
    • A. 

      The equal sign (=) signals it.

    • B. 

      The division (/) sign signals it.

    • C. 

      Dates cannot be shown that way.

    • D. 

      It would not know.

  • 2. 
    It is best to write formulas using cell references so that a spreadsheet
    • A. 

      Has no hidden information.

    • B. 

      Has all correct values.

    • C. 

      Can be updated easily.

    • D. 

      Can be more easily graphed.

  • 3. 
    When working with statistics, a spreadsheet application is often preferred to electronic calculators because
    • A. 

      It allows the user to create graphs to represent data

    • B. 

      Formulas used in a spreadsheet are re-usable which makes spreadshets very efficient

    • C. 

      One's work can be saved for future use and even future editing

    • D. 

      All of the above are true

  • 4. 
    What would B5 represent?
    • A. 

      Active Cell

    • B. 

      Cell Reference

    • C. 

      Formula

  • 5. 
    Which symbol does every formula start with?
    • A. 

      +

    • B. 

      /

    • C. 

      =

  • 6. 
    What would a formula look like?
    • A. 

      2.38+3.588.25

    • B. 

      (C12:B12)

    • C. 

      =3.65+ (3.65*0.03)

    • D. 

      *A9+B9+C9=

  • 7. 
    Which symbol is used to divide to values?
    • A. 

      -

    • B. 

      /

    • C. 

      =

  • 8. 
    What icon appears when you are about to Auto Fill
    • A. 

      Black plus sign

    • B. 

      White plus sign

    • C. 

      Question mark

    • D. 

      Hand

  • 9. 
    What formula would you use to add A1 and A2 together?
  • 10. 
    Which is an example of an appropriate field name?
    • A. 

      Patent's fist name and bithdate

    • B. 

      Name/Last

    • C. 

      Patient's fist name and ID

    • D. 

      First name

  • 11. 
    In Computer Science, what is Java?
    • A. 

       A type of coffee

    • B. 

      A type of programming language

    • C. 

      An island

  • 12. 
    What is the main function of any variable ?
    • A. 

       To add numbers together

    • B. 

       To keep track of data in the memory of the computer

  • 13. 
     Booleans are _______.
    • A. 

       True or False

    • B. 

       Single characters

  • 14. 
    It is the process of removing errors found in the program.
    • A. 

      Editing

    • B. 

      Compiling

    • C. 

      Debugging

    • D. 

      Running

  • 15. 
    Which of the following is the data type used for a single character?
    • A. 

      Byte

    • B. 

      Char

    • C. 

      Long

    • D. 

      Short

  • 16. 
    Which of the following are examples of data types?
    • A. 

      Byte

    • B. 

      Boolean

    • C. 

      Parse

    • D. 

      Int

  • 17. 
    What is an algorithm?
    • A. 

      A set of steps in order approach to solve a problem

    • B. 

      Written in english or code

    • C. 

      Rules of the language

  • 18. 
    A comment in programming is when you document your code explaining what is happening in each line of code.
    • A. 

      True

    • B. 

      False

  • 19. 
    It is the rules of a programming language.
    • A. 

      Format

    • B. 

      Logic

    • C. 

      Object

    • D. 

      Syntax

  • 20. 
    Which of the following is an invalid variable declaration in Java?
    • A. 

      Int NumberOfStudents = 250;

    • B. 

      Double Salary =0.0;

    • C. 

      String NAME =

    • D. 

      Char CivilStatus =

  • 21. 
    What is the purpose of the COUNTIF function?
    • A. 

      It counts the numbers entered in a cell

    • B. 

      It counts if a cell has been selected

    • C. 

      It counts how many times a declared value is true

  • 22. 
    The purpose of the use of buttons on a homepage is to
  • 23. 
    What is the name of the formatting used in cells that informs you of the answer being right and wrong in this worksheet?
    • A. 

      Formatting

    • B. 

      Colour Format

    • C. 

      Conditions

    • D. 

      Conditional Formatting

Back to Top Back to top