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 performs calculations on data in a worksheet and displays the resulting value in a cell. Functions, on the other hand, are pre-built formulas that perform specific calculations. Indices are used to reference specific cells or ranges of cells. Ratios are a comparison of two quantities, and do not necessarily involve calculations on data in a worksheet.

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