Spreadsheet Basic Functions! Trivia Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Mistercarver
M
Mistercarver
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,115
Questions: 10 | Attempts: 1,119

SettingsSettingsSettings
Spreadsheet Basic Functions! Trivia Quiz - Quiz

Do you have a perfect understanding of basic spreadsheet functions? Spreadsheets are mostly used to create budgets, produce graphs and charts, and for storing and sorting data in many organizations. This quiz is designed to assess mastery in the area of spreadsheet fundamentals. Do give it a try and get to see if you might need a refresher course when it comes to using this software application.


Questions and Answers
  • 1. 

    What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25% and her daily work count 50%?

    • A.

      Average

    • B.

      If

    • C.

      Max

    • D.

      Min

    Correct Answer
    A. Average
    Explanation
    Eva should use the average function to calculate her final grade because it takes into account the weightage of each component (exam, test grades, and daily work) and calculates the overall average. This ensures that each component contributes proportionally to the final grade.

    Rate this question:

  • 2. 

    What function will display the word “Yes” when the value in cell A1 is greater than the value in Cell B1 and “No” when otherwise?

    • A.

      If

    • B.

      Lookup

    • C.

      Max

    • D.

      Min

    Correct Answer
    A. If
    Explanation
    The correct answer is "If." The IF function in Excel allows you to test a condition and return different values based on the result. In this case, the condition is whether the value in cell A1 is greater than the value in cell B1. If the condition is true, the function will display "Yes," and if the condition is false, it will display "No."

    Rate this question:

  • 3. 

    Which function can an accounting department use in Cell A2 that will result in the current date?

    • A.

      Count

    • B.

      CountA

    • C.

      DAYS360

    • D.

      NOW

    Correct Answer
    D. NOW
    Explanation
    The accounting department can use the NOW function in cell A2 to display the current date. The NOW function returns the current date and time, and can be used to automatically update the date whenever the spreadsheet is opened or recalculated.

    Rate this question:

  • 4. 

    What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost?

    • A.

      Average

    • B.

      Max

    • C.

      Min

    • D.

      Sum

    Correct Answer
    D. Sum
    Explanation
    The function "Sum" will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost. This function adds the total merchandise cost with the tax amount to give the final total cost.

    Rate this question:

  • 5. 

    Which function can a credit card company use to determine the time that has elapsed since a customer’s payment was received?

    • A.

      Count

    • B.

      CountA

    • C.

      DAYS360

    • D.

      NOW

    Correct Answer
    C. DAYS360
    Explanation
    The DAYS360 function can be used by a credit card company to determine the time that has elapsed since a customer's payment was received. This function calculates the number of days between two dates based on a 360-day year. It is commonly used in financial calculations where a 30-day month and a 360-day year are assumed. By using this function, the credit card company can accurately track the time passed since the payment was received and manage customer accounts accordingly.

    Rate this question:

  • 6. 

    A spreadsheet is created with drop-down items that a user can select from. This is an example of which function?

    • A.

      Count

    • B.

      Fill Series

    • C.

      List

    • D.

      Lookup

    Correct Answer
    C. List
    Explanation
    A spreadsheet with drop-down items that a user can select from is an example of the "List" function. This function allows the user to create a list of predefined options for data entry, making it easier to input and organize information in the spreadsheet. The drop-down menu restricts the user to selecting only the options provided in the list, ensuring data consistency and accuracy.

    Rate this question:

  • 7. 

    What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?

    • A.

      Count

    • B.

      CountA

    • C.

      Fill Series

    • D.

      If

    Correct Answer
    D. If
    Explanation
    The "If" function should be used by a sales manager to indicate whether a salesperson met the goal of $6,000 sales this month. The "If" function allows the manager to set a condition and specify what action should be taken if the condition is met. In this case, the condition would be whether the salesperson's sales for the month reached or exceeded $6,000. If the condition is met, the "If" function can be set to display a message or value indicating that the goal was met.

    Rate this question:

  • 8. 

    What operation will Eve use to keep rows and columns visible so that they don’t scroll off the screen as she moves around the worksheet?

    • A.

      Embed

    • B.

      Fill Series

    • C.

      Freeze Panes

    • D.

      Link

    Correct Answer
    C. Freeze Panes
    Explanation
    Eve will use the "Freeze Panes" operation to keep rows and columns visible as she moves around the worksheet. This operation allows her to lock specific rows or columns in place so that they remain visible even when she scrolls through the rest of the worksheet. This is useful when working with large datasets or when comparing data in different parts of the worksheet.

    Rate this question:

  • 9. 

    What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation?

    • A.

      Embed

    • B.

      Import

    • C.

      Link

    • D.

      Target

    Correct Answer
    A. Embed
    Explanation
    To ensure that an object does not change in a word processing document when it is edited in the spreadsheet of its original creation, the procedure that should be followed is to embed the object. Embedding allows the object to be inserted directly into the document, making it independent of the original spreadsheet. This means that any changes made to the object in the spreadsheet will not affect its appearance or content in the word processing document.

    Rate this question:

  • 10. 

    Mr. Evans sorted the student-athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?

    • A.

      Ascending

    • B.

      Descending

    • C.

      Primary

    • D.

      Secondary

    Correct Answer
    C. Primary
    Explanation
    The GPA is an example of the primary part of the sort operation because it is the most important factor used to determine the order of the student-athletes. It takes precedence over the last name, first name, and homeroom in determining the sorting order.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.