Answer:
The formula for the given problem is given below:
= (1+B$12)×B13
Explanation:
Immediately you do one, then you can autofill the formula to the mentioned range B15:B17 and then to C14 to H17
When been done correctly, this is how the formula will look in those cells if you do it correctly.
Check the file attached below to see it.


1. The opportunity to create several equations for launching program files is called
a) creating a file
b) creating a folder
✒ <u>c) creating a directory</u>
d) creating a shortcut
2. Unless you specify otherwise most spreadsheet packages assume all cell addresses are
a) macros
b) relative cell reference
c) absolute cell reference
✒<u> d) mix cell references</u>
3. Which of the following is not a type of lcon
a) program icon
✒ <u>b) document icon </u>
c) folder icon
d) utility icon



Answer:
num = float(input("Enter a number : "))
ab = abs(num)
sqrt = float(ab ** 0.5)
print(sqrt)
Explanation:
Answer:
Create a validation rule using ISPICKVAL()
Explanation:
Solution
This can be achieved by creating a a validation rule using ISPICKVAL()
Create a Validation Rule Based on a Pick list
: The ISPICKVAL() are very important for creating validation rules that check whether a definite pick list value is chosen. for instance, say you want another person to enter a reason when they change a case's Status pick list value to increase.