MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Excel table column containing data derived from other columns
A)SUMIF
B)VLOOKUP
C)COUNTIF
D)conditional formatting
E)calculated column
F)AVERAGE
G)HLOOKUP
H)COUNT
I)logical condition
J)SUM
K)AVERAGEIF
L)cell and range addresses

Question

Quizplus · Accepted Answer

A calculated column is a column in an Excel table that contains a formula that performs calculations using data in other columns of the table. It allows you to create new data based on existing data in the table.

Example: If you had columns for length and width, you could create a calculated column to calculate the area by multiplying length x width.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase