- StudyBlue
- Tutorial 3.1 Quick Check

Jorge Anthony H.

You need to reference cell Q57 in a formula. What is the absolute cell reference? What are the two mixed references?

Absolute is $Q$57 mixed references are $Q57 and Q$57

If cell R10 contains the formula =R1+R2. What formula is entered if this formula is copied and pasted into cell S20?

=S11+S12

Advertisement

If cell T10 contains the formula =T1+T$2. what formula is entered if this formula is copied and pasted into cell U20?

U11+U2

If cell V10 contains the formula =AVERAGE(U1:$U5) What formula is entered if this formula is copied and pasted into cell W20?

=AVERAGE(V11,$U15)

What are optional arguments? What happens if you do not include an optional argument in a function?

They are not required for the function to return a value but can be included to provide more control over how Excel calculates the returned value. If an optional argument is not included, Excel assumes a default value for it. [arg1,arg2...]

What function formula can you use to add the numbers in the range X1:X10?

=SUM(X1:X10)

The range of a set of values is defined as the maximum value minus the minimum value. What formula with functions can you enter to calculate the range of the values in Y1:Y10?

=max(Y1:Y10)-min(Y1:Y10)

What formula with functions can you enter to calculate the ratio of the maximum value in the range Z1:Z10 to the minimum value?

=max(Z1:Z10)/min(Z1:Z10)

Advertisement

Want to see the other 8 Flashcards in Tutorial 3.1 Quick Check?
JOIN TODAY FOR FREE!

"The semester I found StudyBlue, I went from a 2.8 to a 3.8, and graduated with honors!"

Jennifer Colorado School of Mines
StudyBlue is not sponsored or endorsed by any college, university, or instructor.

© 2014 StudyBlue Inc. All rights reserved.

© 2014 StudyBlue Inc. All rights reserved.