In the context of recording journal entries using spreadsheet software, which function can automatically return the value from cell B77 based on a reference in another cell (such as B81)?
A
VLOOKUP
B
AVERAGE
C
SUM
D
COUNTIF
0 댓글
검증된 단계별 안내
1
Understand the purpose of each function provided in the options: VLOOKUP, AVERAGE, SUM, and COUNTIF.
VLOOKUP is used to search for a value in the first column of a range and return a value in the same row from another column. This is relevant when you need to retrieve a value based on a reference.
AVERAGE calculates the mean of a range of numbers, which is not applicable for retrieving a specific value based on a reference.
SUM adds up all the values in a range, which is also not applicable for retrieving a specific value based on a reference.
COUNTIF counts the number of cells that meet a specific condition, which is unrelated to retrieving a value based on a reference. Therefore, the correct function for this scenario is VLOOKUP.