Case EX 4-2Ben is copying some formulas and wants to make sure he has the cell references correct.Ben wants to copy a formula that is the sum of five rows.  He wants the formula to change as he copies it so that it shows the sum of five rows for each column.  What type of cell reference should Ben use?

A. Absolute
B. Relative
C. Mixed
D. None of the above


Answer: B

Computer Science & Information Technology

You might also like to view...

A format string has the form:

a) {X[:FormatString][,Y]} b) {X[,Y][:FormatString]} c) {[FormatString:]X[,Y]} d) None of the above

Computer Science & Information Technology

What are the disadvantages of using onscreen windows?

What will be an ideal response?

Computer Science & Information Technology

When using the ____________________ tool, you can change the shield color and opacity of the area outside the crop using the Color and Opacity settings on the Options bar.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The Translate tool translates selected text from one language to another

Indicate whether the statement is true or false

Computer Science & Information Technology