Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data related 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?

Question

09-12-2019
Computers and Technology

contestada

Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data related 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?

Respuesta :

Otras preguntas

Delaware corp. prepared a master budget that included $21,360 for direct materials, $33,600 for direct labor, $18,000 for variable overhead, and $46,440 for fix

P + (-q) -3 when p= -6 and q=7

Which of these sentences is written correctly? A. That dog gets fatter every day.">A. That dog gets fatter every day.B. The closet keeps getting more ful

How many liters of oxygen gas can be produced if 28.7 grams of water decomposes at 294 Kelvin and 0.986 atmospheres? Show all of the work used to solve this pro

When you are driving a motor home and are following another vehicle, you should?

Find all solutions of the equation. 5 sin x - 8 = 3 sin x- 7

The ratio of the sides of 2 cubes is 2 to 7. If the volume of the smaller cube is 32 u3, then the volume of the larger cube is _____ u3

name the 3 pollutants that decreased the most since 1990

The _____ on a map will help determine the direction of a location in relation to another location. legend compass scale color-coding

“You,” “yours,” and “your” are _______ pronouns. A. interrogatory B. second-person C. positive D. first-person

joshnajd joshnajd · Answer 1 · 2019-12-18T09:47:34+01:00

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

Explanation:

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.