11
AssignmentMultiple Choice

Spreadsheet Basics

Question 11 • AL-Career Preparedness

You have a spreadsheet of x values that need to be entered into the following formula to calculate y values:y = 5x + 19 - 7Which of the following is the quickest way to accomplish this task?

Answer
A
Use a calculator to find the y value for each x value, then enter those results into the spreadsheet.
B
Enter the formula into the spreadsheet to calculate the y value for each x value.

Explanation

Enter the formula in a spreadsheet cell, using the cell reference for each x value, and copy it down the column. The spreadsheet will calculate y = 5x + 19 − 7 for every x value automatically, which is quicker than calculating and entering each result separately. The correct choice is “Enter the formula into the spreadsheet to calculate the y value for each x value.”

AI-written and checked against the verified answer.

Previous
Next