Spreadsheet Basic Functions! Trivia 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.
- 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. AverageExplanation
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. IfExplanation
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. NOWExplanation
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. SumExplanation
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. DAYS360Explanation
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. ListExplanation
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. IfExplanation
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 PanesExplanation
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. EmbedExplanation
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. PrimaryExplanation
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 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 15, 2010Quiz Created by
Mistercarver
Back to top