Spreadsheet Basic Functions! Trivia Quiz

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.

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.

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.

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."

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.

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.

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.

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.

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.

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.