Which of the following performs calculations on the data in a worksheet like the one in the accompanying figure and displays the resulting value in a cell?
A) index
B) formula
C) function
D) ratio

Question

Which of the following performs calculations on the data in a worksheet like the one in the accompanying figure and displays the resulting value in a cell?
A) index 
B) formula 
C) function 
D) ratio

Quizplus · Accepted Answer

A formula can be used to perform calculations on the data in a worksheet and display the resulting value in a cell. An index is used to return the value of a specific cell in a range, a function is a predefined formula that performs a specific calculation, and a ratio is a comparison between two values.

Which of the Following Performs Calculations on the Data in a Worksheet