Join thousands of students who trust us to help them ace their exams!
Multiple Choice
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 Comments
Verified step by step guidance
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.