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
5. Create a vector called to20 that goes from 1 to 20 (use the range notation). Now create a variable called end that goes from
Lady_Fox [76]

Answer:

creating vector:

code:  

to20 <-c(1:20) #creating to20 vector

end <-c(40:50) #creating end vector

to50 <-c(to20,21:30,end) # creating to50 vector

print(to50) # printing to50 vector

Explanation:

8 0
3 years ago
What two things should you do before starting the design process
Charra [1.4K]

Answer: B and C

Explanation: Analyze the audience

                      Identify the problem

8 0
3 years ago
Write the definition of a method powerto, which receives two parameters. the first is a double and the second is an int. the met
mihalych1998 [28]
       
The case of x⁰=1 is one you shouldn't overlook!

double powerto(double f, int exponent)
{
            if (exponent < 0) { return 0; }
            if (exponent == 0) { return 1.0; }          
            while (--exponent > 0) { f *= f; }
            return f;
}
5 0
4 years ago
What browser is included with windows?
alexandr402 [8]
Internet Explorer and the its version is dependent on the version of windows you are using.
7 0
3 years ago
What is the cheapest type of printer to buy and run?
myrzilka [38]
It depends solely on how much you will use it. For example, laser printers are more suitable for offices, schools, and environments, where the printer is used almost constantly. If it's used a lot, you're probably looking at a laser printer, since the cartridges have a slightly higher price, but a much higher yield. If you can't afford a laser printer, and you're only going to use it at home, you're probably looking at an inkjet. If you need to print off something for school, ask your teacher, or someone that works at your school. Some secondary/high schools might allow you to use their printers at a lower price
7 0
4 years ago
Read 2 more answers
Other questions:
  • An _____ is a set of directions for carrying out a task.
    14·1 answer
  • ASAP ε=ε=ᕕ(°□°)ᕗ<br> Sorry if you can't see it but please help me if you can!
    6·1 answer
  • you want to enhance your Website visitors' experience. To do this, you need to know the type of browser that each visitor to you
    11·1 answer
  • In this project you will demonstrate your knowledge of decision making blocks such as if statements. Objectives Building on ever
    11·1 answer
  • A systems administrator is designing a directory architecture to support Linux servers using Lightweight Directory Access Protoc
    11·1 answer
  • PLEASE HELP ASAP!!
    6·2 answers
  • Which results are expected in a personality test but not a skills assessment?
    13·1 answer
  • 1. It is a set of integrated devices that input, output,
    11·1 answer
  • Please help me, i need help
    15·2 answers
  • You are creating a program that can add up the amount of money the user spent that day. Right down to the penny! What kind of va
    12·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!