1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
QveST [7]
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]3 years ago
7 0

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.

You might be interested in
Assume that the array arr has been defined and initialized with the values {4, 2, 5, 3, 1}. What are the values in the array arr
Murrr4er [49]

Answer:

arr = [4, 2, 5]

Explanation:

The while loop will remove the array elements from the back.

5 0
3 years ago
Assume that ip has been declared to be a pointer to int and that enrollment has been declared to be an array of 20 elements . As
Vitek1552 [10]

Answer:

ip = enrollment + section;

Explanation:

The variable ip has been declared to be a pointer to int.

int * ip;

The variable enrollment has been declared as an array of 20 elements .

int enrollment[20];

The variable section has been declared as an int.

int section;

In order to make ip point to the element in the array indexed by section, we can use the following statement :

ip = enrollment + section;

This will make ip point to enrollment[section].

5 0
3 years ago
A network administrator is configuring an ACL with the command access-list 10 permit 172.16.32.0 0.0.15.255. Which IPv4 address
lord [1]

Answer:

For this wild card mask 0.0.15.255 the ACE IP address will be 172.16.47.254

Explanation:

ACL is the access control list that is used to enlist the ip addresses that allowed or restricted to access the network. ACE is an IP address from the list ACL that has all rules and regulations related to access of network. The ACE could be in the range of IP address in ACL. ACL can be calculated with the help of initial IP address adding with wild card mask.

So

Initial IP address is = 172.16.32.0

Wild card mask =0.0.15.255

by adding above values we can find the last IP address of ACL.

after addition

Final IP address is = 172.16.47.255

The options that are available with question, Only option between the range is  172.16.47.254. So we can say that This is the only ACE IP address in options.

7 0
3 years ago
What is the full form of html​
zepelin [54]

Answer:

Hypertext Markup Language

Explanation:

Hypertext Markup Language

5 0
2 years ago
Read 2 more answers
_______ an embedded Word table to activate the Word features.
Bess [88]
The answer is C. double-click
3 0
3 years ago
Other questions:
  • Chdtp aoxophg gr72 ae9&gt;3 zqqz
    12·1 answer
  • What benefit does internet have​
    11·1 answer
  • What three steps Name a group??
    14·1 answer
  • _____ separation strategies (e.g., attacking and sabotaging others) are used by those for whom co-cultural segregation is an imp
    5·1 answer
  • Which is an advantage of programming with a procedural language?
    12·2 answers
  • An attacker compromises the Washington Post's web server and proceeds to modify the homepage slightly by inserting a 1x1 pixel i
    12·1 answer
  • Which table attributes would this code produce?
    15·1 answer
  • A=1/2h(a+b) solve for h
    6·1 answer
  • Which of these is NOT an example of a GUI?
    7·1 answer
  • Bryan's company is new and has limited funds to work with. He has been tasked with finding a telecommunications technology that
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!