Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data relat

Question

3 years ago

15

Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data relat

ed to the official budget from cell A1 through C9, and data related to actual expenditures from cell L1 through N19. How will Jason track and compare the data as he works on the spreadsheet?

Computers and Technology

1 answer:

mina [271] · Answer 1 · 2022-07-20T15:37:59+03:00

To compare the data Jason can use inbuilt function such as VLOOKUP, HLOOKUP.

<u>Explanation:</u>

Since Jason is working MS-excel spreadsheet. As he has mention cell A1 to C9 is official budget and related are stored in L1 – N19.

In MS- EXCEL has lot of inbuilt function are available such as VLOOKUP, HLOOKUP, and IF extra.

VLOOKUP: It is a inbuilt function where to use to find cell value in ranges of selected with column index. It searches value in vertical manner in ranged selected cells.

HLOOKUP: It is a inbuilt function where to use to find cell value in ranges of selected with column index. It searches value in horizontal manner in ranged selected cells.

IF: returns trued value if searched value found. It compares one to one cell values.