Homework Answers
Hi
When dollar is used in the formula then that variable gets frozen.
Here $B1*C$1
Ideally when one cell down is done then formula should have been shifted to B2*C2 but since $ is there infront of C$1 hence C$1 wont change. Hence the formula will be $B2*C$1
Hence 1 option is correct here .
Thanks
Add Answer to:
Question 9 Consider the following Excel formula: = $B1 * C$1 If this formula is copied...
2. a. To be eligible for a company bonus, an employee must earn a yearly sales...
2. a. To be eligible for a company bonus, an employee must earn a yearly sales commission over $10,000 or more and have added at least 50 new sales accounts in that same year. In a spreadsheet, the employees’ names are listed in column A, their commissions are entered in column B, and the total number of new sales accounts are entered in column C. Write an IF statement in cell D2 for the employee in row 2 to be...
3. In cell A1 of Excel, put the number 50. In cell B1, write an equation...
3. In cell A1 of Excel, put the number 50. In cell B1, write an equation that finds the total amount of the number in A1 plus 50% of the value in A1. In A2, write an equation to copy the value stored in B1. In B2, repeat the equation stored in B1. Now, drag this down to the 10th row. What is in cell B10? (a) 50 (b) 1013.45 (c) 2883.25 d 512024
1. part 2 Part 3 File Home Insert Page Layout Formulas Data Rei Arial 12 A...
1.
part 2
Part 3
File Home Insert Page Layout Formulas Data Rei Arial 12 A A X Cut LECopy Format Painter Paste BIU. A 1.1.1 Clipboard Г Font : с A Year B Cash Inflows (Outflows) 1 1 2 0 3 4 2 5 3 6 4 7 5 8 9 Annual discount rate 10 Net present value 11 Internal rate of return ($200,000) $40,000 $80,000 $38,000 $50,000 $58,000 8.00% $12,015.09 10.23% Applying Excel 8: Calculating internal rate of...
SEE AL AaBbCcDdEe AaBbCcDdEe No Spacing AaBbCcDc AaBbc Heading 1 Headi Normal 8. To hardcode the...
SEE AL AaBbCcDdEe AaBbCcDdEe No Spacing AaBbCcDc AaBbc Heading 1 Headi Normal 8. To hardcode the current time into a cell: a. Ctrl + Shift + b. Ctrl+Enter +D c. Alt +T d. Ctrl+T 9. If you have formatted a cell as %, which of the following would yield 3%? b. .03 C. - Ctrl +1+3/100 d. 3 + Ctrl + P e. a and b 10. In Excel, the default setting for numbers is: a. Right justified b. Center...
Consider the following expressions: A1: f = Fw A2: f = Fw sinθ B1: N =...
Consider the following expressions: A1: f = Fw A2: f = Fw sinθ B1: N = W 2 B2: N = W C1: ℓFw sinθ = 2Fw cosθ C2: ℓFw sinθ = ℓ W cosθ C3: ℓFw sinθ = 1 2 ℓ W cosθ, where f: force of friction between the ladder and the ground, Fw: normal force on the ladder due to the wall, θ: anglebetween theladder and theground, N: normal force on the ladder due to the ground,...
Please using giving excell formulas from this excel document :) Alanco, Inc a variety of products...
Please using giving excell formulas from this excel document
:)
Alanco, Inc a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine If the company should make or buy the output the result from cell C4, or 27,000,000 in this example Allows you to use the basic math symbols to perform...
Assume that the transition matrix from basis B = {b1, b2, b3} to basis C = {c1, c2, c3} is PC,B = 1/2*[ 0 -1 1 ; -1 1 1 ; 1 0 0 ]. (a) If u = b1 + b2 + 2b3, find [u]C. (b) Calculate PB,C. (c) Suppose...
Assume that the transition matrix from basis B = {b1, b2, b3} to basis C = {c1, c2, c3} is PC,B = 1/2*[ 0 -1 1 ; -1 1 1 ; 1 0 0 ]. (a) If u = b1 + b2 + 2b3, find [u]C. (b) Calculate PB,C. (c) Suppose that c1 = (1, 2, 3), c2 = (1, 2, 0), c3 = (1, 0, 0) and let S be the standard basis for R 3 . (i) Find...
All employees at a company will receive a salary raise equal to the cost of living...
All employees at a company will receive a salary raise equal to the cost of living increase of 3%. What is the correct formula to use in cell C3 to calculate Allen Andrew's 2019 salary? The correct formula must use absolute addressing where appropriate so that when the formula is copied down the column, it will calculate the other employees' 2019 salaries correctly. A B C 1 Cost of Living Increase 3% 2 2018 Salary 2019 Salary 3 Allen Andrews...
Consider the floor plan shown in Figure P2.4. Compute the tributary areas for (a) floor beam...
Consider the floor plan shown in Figure P2.4. Compute the tributary areas for (a) floor beam B1, (b) floor beam B2, (c) girder G1, (d) girder G2, (e) corner column C1, and (ђ interior column C2. Figure P2.4: [email protected]. = 40% C4 B2 GI B3 B4 - 2@10.=20 C2 G4 G2 G3 B1 5@8. 40 C3 C1 40 20
3. Consider the game illustrated by the payoff matrix below: Jeffrey B1 B2 -4,- 4 1...
3. Consider the game illustrated by the payoff matrix below: Jeffrey B1 B2 -4,- 4 1 ,-6 Curtis A2 -6,1 0,0 b. Suppose that the game is repeated 10 times and assume a discount factor 8 (where 0< 8 < 1). i. [2] What does each player choose to do in the 10th round of play? ii. [2] Can Curtis and Jeffrey credibly commit to playing (A2, B2) in any of the rounds that they play? c. Suppose now that...
3. In cell A1 of Excel, put the number 50. In cell B1, write an equation that finds the total amount of the number in A1 plus 50% of the value in A1. In A2, write an equation to copy the value stored in B1. In B2, repeat the equation stored in B1. Now, drag this down to the 10th row. What is in cell B10? (a) 50 (b) 1013.45 (c) 2883.25 d 512024
1.
part 2
Part 3
File Home Insert Page Layout Formulas Data Rei Arial 12 A A X Cut LECopy Format Painter Paste BIU. A 1.1.1 Clipboard Г Font : с A Year B Cash Inflows (Outflows) 1 1 2 0 3 4 2 5 3 6 4 7 5 8 9 Annual discount rate 10 Net present value 11 Internal rate of return ($200,000) $40,000 $80,000 $38,000 $50,000 $58,000 8.00% $12,015.09 10.23% Applying Excel 8: Calculating internal rate of...
SEE AL AaBbCcDdEe AaBbCcDdEe No Spacing AaBbCcDc AaBbc Heading 1 Headi Normal 8. To hardcode the current time into a cell: a. Ctrl + Shift + b. Ctrl+Enter +D c. Alt +T d. Ctrl+T 9. If you have formatted a cell as %, which of the following would yield 3%? b. .03 C. - Ctrl +1+3/100 d. 3 + Ctrl + P e. a and b 10. In Excel, the default setting for numbers is: a. Right justified b. Center...
Please using giving excell formulas from this excel document
:)
Alanco, Inc a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine If the company should make or buy the output the result from cell C4, or 27,000,000 in this example Allows you to use the basic math symbols to perform...
Consider the floor plan shown in Figure P2.4. Compute the tributary areas for (a) floor beam B1, (b) floor beam B2, (c) girder G1, (d) girder G2, (e) corner column C1, and (ђ interior column C2. Figure P2.4: 
3. Consider the game illustrated by the payoff matrix below: Jeffrey B1 B2 -4,- 4 1 ,-6 Curtis A2 -6,1 0,0 b. Suppose that the game is repeated 10 times and assume a discount factor 8 (where 0< 8 < 1). i. [2] What does each player choose to do in the 10th round of play? ii. [2] Can Curtis and Jeffrey credibly commit to playing (A2, B2) in any of the rounds that they play? c. Suppose now that...
Most questions answered within 3 hours.
-
1. Why are the advantages and disadvantages of object-oriented
databases? 2. What are data marts? How...
asked 12 minutes ago -
A Porsche challenges a Honda to a 4.00×102m race. Because the
Porsche's acceleration of 3.30 m/s2...
asked 12 minutes ago -
A sample of C3H8 has 1.60×1024 H atoms.
How many carbon atoms does the sample contain?...
asked 1 hour ago -
How many unique codes are possibly formed from two characters,
where the first character can be...
asked 35 minutes ago -
A concentration cell is built based on the reaction:
2H+ + 2e- ----> H2
The pH...
asked 30 minutes ago -
what is the ph of the following solutions?
150 g NH4CI dissolved into 10.0 mL of...
asked 42 minutes ago -
A projectile is launched with an initial speed of 40 m/s at an
angle of 25°...
asked 24 minutes ago -
1. Using a function, display the customer who has the highest
credit limit. Display the customer...
asked 33 minutes ago -
A spatially uniform electric field varies in time according
to E = Eo + 3000 t,...
asked 59 minutes ago -
An electric power station that operates at 25 kV and uses a 20:1
step-up ideal transformer...
asked 52 minutes ago -
1. If 0.02% of a 0.6 M weak acid ionizes in a solution, what is
the...
asked 38 minutes ago -
The College of Business at Northeast College is accumulating
data as a first step in the...
asked 44 minutes ago