FBLA: Spreadsheet Applications Quiz Questions!

7 Questions | Total Attempts: 460

SettingsSettingsSettings
FBLA: Spreadsheet Applications Quiz Questions! - Quiz

What do you know about FBLA spreadsheet applications? Do you think you can pass this quiz? Regarding this quiz, you will be required to know which function returns the integer for the current date and time, what does the word mean to refer to as it relates to numbers, what does the count function count, and which function counts the empty cells. See how much you know about the FBLA spreadsheet application by taking this quiz.


Questions and Answers
  • 1. 
    The expression _____ returs the maximum value in the range A1:A100 and then divides the value by 100.
    • A. 

      =MAX(A1:A100/100)

    • B. 

      =MAX(100)/(A1:A100)

    • C. 

      =MAX(A1:A100)/100

    • D. 

      =MAXIMUM(A1:A100)/100

  • 2. 
    The _____ function returns the integer for the current date and time.
    • A. 

      NOW()

    • B. 

      CURRENT()

    • C. 

      DATE()

    • D. 

      TIME()

  • 3. 
    The ____ is the number in the middle of a collection of numbers.
    • A. 

      Mean

    • B. 

      Average

    • C. 

      Mode

    • D. 

      Median

  • 4. 
    Which of the following calculates the smallest in a collection of numbers?
    • A. 

      LOW()

    • B. 

      MIN()

    • C. 

      SMALL()

    • D. 

      COUNT()

  • 5. 
    What does the COUNT() function count?
    • A. 

      Cell references

    • B. 

      Formulas

    • C. 

      Numbers

    • D. 

      Text

  • 6. 
    What is a predefined formula that claculates by using arguments in a specific order?
    • A. 

      Analyze

    • B. 

      Range

    • C. 

      AutoSum

    • D. 

      Function

  • 7. 
    Which function merely counts the cells that are empty?
    • A. 

      ADD

    • B. 

      COUNTBLANK

    • C. 

      COUNT

    • D. 

      SUM