Question

QUESTION 4 Suppose cell A1 has "=B3+C4" and you copy and paste A1 to B4. What...

QUESTION 4

  1. Suppose cell A1 has "=B3+C4" and you copy and paste A1 to B4. What does B4 have written in it?

    =C3+D4

    =C6+D7

    =B6+C7

    =B3+C4 (cutting changes cell references, not copying)

10 points   

QUESTION 5

  1. Now suppose cell A1 has "=B3+$C$4" and you copy and paste A1 to B4. What does B4 have written in it?

    =B6+$C$4

    =C6+$C$4

    =B3+$C$4  (cutting changes cell references, not copying)

    =C3+$C$7

10 points   

QUESTION 6

  1. Now suppose cell A1 has "=$B3+C$4" and you copy and paste A1 to B4. What does B4 have written in it?

    =$B3+C$7

    =$B3+D$4  (cutting changes cell references, not copying)

    =$C3+C$7

    =$B6+D$4
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A student will randomly select 5 cards from a deck of 52 cards. Each card is...
A student will randomly select 5 cards from a deck of 52 cards. Each card is uniquely identified by a label which is a combination of a letter (one of the following: A, B, C, D) followed by a number (one of the following: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13). The labels on the cards are A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, B1, B2, B3, B4,...
A student will randomly select 5 cards from a deck of 52 cards. Each card is...
A student will randomly select 5 cards from a deck of 52 cards. Each card is uniquely identified by a label which is a combination of a letter (one of the following: A, B, C, D) followed by a number (one of the following: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13). The labels on the cards are A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, B1, B2, B3, B4,...
Question 1 Which of the following spreadsheet formulas contains a syntax error? Group of answer choices...
Question 1 Which of the following spreadsheet formulas contains a syntax error? Group of answer choices =SQRT( A1 * LN( F3 / G2 + 12 * B6 ) =SQRT( A1 * LN( F3 / G2 + 12 * B6 ) ) =SQRT( A1 * LN( F3 / G2 ) + 12 * B6 ) =SQRT( A1 * LN( F3 ) / G2 + 12 * B6 ) =SQRT( A1 * LN( F3 / G2 + 12 ) * B6 )...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT