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.
Answer:
It is a prototype-based, multi-paradigm scripting language that is dynamic, and supports object-oriented, imperative, and functional programming styles. JavaScript runs on the client side of the web, which can be used to design / program how the web pages behave on the occurrence of an event.
The answer is c. Inkjet printer
What the phrase should say in Kim's SQL Query is; WHERE Customer = Sales Rep
<h3>What is SQL Query?</h3>
Structured Query Language (SQL) is defined as a standardized programming language that is used to manage relational databases and perform various operations on the data in them.
Now in SQL Query, when one SQL query is embedded in another SQL query to simulate a join, the second SQL query is embedded in the "WHERE" of the first query.
Since the query will pull a list of customers with outstanding orders and the sales rep for each order. Then, the where phrase will be;
WHERE Customer = Sales Rep
Read more about SQL Query at; brainly.com/question/10097523
websites that can backup their answers so the first one:) im just thinking logically.
