Spreadsheet Basic Functions! Trivia Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Mistercarver
M
Mistercarver
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,226
| Attempts: 1,233
SettingsSettings
Please wait...
  • 1/10 Questions

    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%?

    • Average
    • If
    • Max
    • Min
Please wait...
About This 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.

Spreadsheet Basic Functions! Trivia Quiz - Quiz

Quiz Preview

  • 2. 

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

    • Average

    • Max

    • Min

    • Sum

    Correct Answer
    A. 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:

  • 3. 

    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?

    • Embed

    • Fill Series

    • Freeze Panes

    • Link

    Correct Answer
    A. 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:

  • 4. 

    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?

    • If

    • Lookup

    • Max

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

  • 5. 

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

    • Count

    • Fill Series

    • List

    • Lookup

    Correct Answer
    A. 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:

  • 6. 

    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?

    • Embed

    • Import

    • Link

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

  • 7. 

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

    • Count

    • CountA

    • Fill Series

    • If

    Correct Answer
    A. 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. 

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

    • Count

    • CountA

    • DAYS360

    • NOW

    Correct Answer
    A. 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:

  • 9. 

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

    • Count

    • CountA

    • DAYS360

    • NOW

    Correct Answer
    A. 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:

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

    • Ascending

    • Descending

    • Primary

    • Secondary

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 15, 2010
    Quiz Created by
    Mistercarver
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.