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:
A set of instruction given to computer
Explanation:
Answer:
Please find the code in the attached file.
Output:
Please find the attached file.
Explanation:
In this code a "num" variable is declared that use while loop that check num value greater than equal to 0.
Inside the loop we input the "num" value from the user-end and use if the value is positive it will define a for loop that calculates the quotient value as integer part, and use the asterisks to print the value.
If input value is negative it print a message that is "Goodbye".
Please find the code link: https://onlinegdb.com/7MN5dYPch2
Answer:
Line graphs allow us to see overall trends such as an increase or decrease in data over time. Bar graphs are used to compare facts.
