Question

Instructions Part 1:For each of the following logical tests, indicate whether an IF function in Excel...

Instructions Part 1:For each of the following logical tests, indicate whether an IF function in Excel would return a value of True or False; given the following cell values: C2 = 88; H12 = 15; L3 = 24; M14 = 150; and G4 = 5.

1.C2 > H12 Returned value: _______________________

2.L3 = G4 Returned value: _______________________

3.M14 + 15 * H12 / 10 <= L3 Returned value: _______________________

4.M14 – G4 < H12 / C2 Returned value: _______________________

5.(C2 + H12) * 2 >= L3 – (C2 / 4) * 2 Returned value: _______________________

6.L3 + 300 > H12 * G4 + 10 Returned value: _______________________

7.G4 * M14 >= 2 * (H12 + 25) Returned value: _______________________

8.H12 = 10 * (C2 / 8)Returned value: _______________________

Homework Answers

Answer #1

1. Since 88 > 15, the answer is True.

2.since 24 is not equal to 5, the answer is false.

3. SinceM14+15*H12/10 = 172.5 and this is greater than 24, the answer is false

4. since M14 - G4 = 145 and H12/C2 = 0.17, the answer is false

5. Since (c2+H12)*2 = 206 and L3-(C2/4)*2 = -20, the answer is true

6. L3+300 = is 324, andH12*G4+10 is 85, the answer is true

7. Since G4*M14 = 750 and 2*(H12+25) = 80, the answer is true

8. 10*(C2/8) is 110, the answer is false

`

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Complete each of the following TVOM calculations using Excel. The assignment MUST be completed on an...
Complete each of the following TVOM calculations using Excel. The assignment MUST be completed on an excel spreadsheet and submitted through blackboard. There are 10 calculations to answer. The TVOM functions are under the Fx button in Excel. The Fx Function is located just above the actual number section of your spreadsheet, right above the C or D column in most blank spreadsheets. Click on the Fx button and search for the specific function (present value, future value, Rate, payment,...
Question 1 Please indicate whether the normal balance of each of the following accounts is a...
Question 1 Please indicate whether the normal balance of each of the following accounts is a debit or a credit: Debit Credit 1. Equipment 2. Land 3. Owner's, Withdrawals 4. Rent Expense 5. Interest Revenue 6. Prepaid Rent 7. Accounts Receivable 8. Office Supplies 9. Notes Receivable 10. Notes Payable 11. Owner's, Capital 12. Rent Earned 13. Rent Payable 14. Interest Expense 15. Interest Payable Question 2 The following transactions take place in April 2018 for Del Martin Consulting: Del...
KNAPSACK Optimization Problem using Greedy Method Problem 1: Item Weight Value 1    14 20 2...
KNAPSACK Optimization Problem using Greedy Method Problem 1: Item Weight Value 1    14 20 2     6 16 3   10 8 4     5 10 5   4 12 Allowed weight = 24 Kg Problem 2: Item Weight Value 1 6 30 2 8 40 3 15 45 4 22 88 5 25 80 Allowed weight = 60 Kg Problem 3: Item Weight Value 1     6 30 2     8 40 3    15 45 4    22 88...
Indicate whether each of the following five statements are True or False. 1) A large p-value...
Indicate whether each of the following five statements are True or False. 1) A large p-value indicates the null hypothesis must be true. 2) Increasing the confidence level decreases the sample size needed to achieve a desired margin of error. 3) Increasing the sample size decreases the power of a hypothesis test. 4) Increasing the significance level increases the power of a hypothesis test. 5) If the interaction term in a two factor experiment is significant (small p-value), the main...
The TVOM functions are under the Fx button in Excel. The Fx Function is located just...
The TVOM functions are under the Fx button in Excel. The Fx Function is located just above the actual number section of your spreadsheet, right above the C or D column in most blank spreadsheets. Click on the Fx button and search for the specific function (present value, future value, Rate, payment, etc., whatever you are trying to calculate). 1. What is the present value of each of the following single amounts: a. $20,000 to be received in 10 years...
Exercise 1 (1 point for each correct answer) For each of the following statements indicate whether...
Exercise 1 (1 point for each correct answer) For each of the following statements indicate whether it is true, false, or unknown. 1. The MIN VERTEX COVER problem is in ??. 2. The MIN VERTEX COVER problem is ??-hard. 3. The MIN VERTEX COVER problem can be solved by a 3-approximation algorithm. 4. The MIN VERTEX COVER problem can be solved by a 1-approximation algorithm.
For each of the items below, indicate whether the transaction increased equity, decreased equity, or had...
For each of the items below, indicate whether the transaction increased equity, decreased equity, or had no effect on equity. Purchased supplies for cash Sold merchandise on account Paid cash dividends Paid salaries & wages Bought equipment by issuing a 90-day note Sold 10,000 shares of common stock Place the following steps in the accounting cycle in the order in which they are performed.       -       1.       2.       3.       4.   ...
Consider the following set: A = { 1, {2,3}, 3, 4, {3,4}, 5, {5,6,7} } Indicate...
Consider the following set: A = { 1, {2,3}, 3, 4, {3,4}, 5, {5,6,7} } Indicate the truth value of the propositions below by entering either True or False The cardinality of A is 11 { 5, 6, 7} ⊆ A 3 ∈ A A - { ∅, {2,3}, {3,4}, {5,6,7}, 8 } = { 1, 3, 4, 5 } |A| = 7 { {2,3}, 5 } ⊂ A { 1, 2, 3 } ⊆ A { ∅ } ∉...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and...
Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell C22 enter the formula "= B10". Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 13B. Verify that your worksheet matches the example in the text. Check your worksheet by changing the discount rate to 10%. The net...
INSTRUCTIONS - For each of the following twenty (20) accounts of Absorka Company, indicate which financial...
INSTRUCTIONS - For each of the following twenty (20) accounts of Absorka Company, indicate which financial statement the item belongs on, the classification or sub-classification (for assets & liabilities) of the account and the account’s normal balance. The first row is an example. Financial Statements: Balance Sheet (BS), Income Statement (IS), Retained Earnings Statement (RE) Account Classification (if an account is a contra account, be sure to state "contra" in front of the account classification, i.e. contra long-term liability): Current...