Enter a formula in cell C13 to look up the registration fee for the first vehicle. Use the vehicle type in cell C4 as the Lookup
1 answer:
The formula that depicts the registration fee on the computer is Formula at C13 : =VLOOKUP(C4,Data!$B$10:$C$17,2,0)
<h3>How to illustrate the information?</h3>A computer program is a sequence or set of instructions in a programming language for a computer to execute.
Computer programs are one component of software, which also includes documentation and other intangible components. A computer program in its human-readable form is called source code
In this case, enter a formula in cell C13 to look up the registration fee for the first vehicle.
Then, one can use the vehicle type in cell C4 as the Lookup_value argument and then use the RegistrationFees named range as the Table_array argument.
Learn more about computer on:
#SPJ1
You might be interested in
Answer:
C. Mean
Explanation:
Mean = (∑)/N
Median = central values when data is sorted
Mode = most repeated value
Standard deviation =
In standard deviation, formula you may see that deviation is being calculated from the mean (central location). But here we take square of the value before adding all of them.
But if we just take , it would be equal to zero.
<u>EXAMPLE</u>
Take 4, 9, 5 as data
mean = (4+9+5)/3 = 18/3 = 6
sum of deviations from mean = (4-6)+(9-6)+(5-6) = (-2)+(3)+(-1) = 0