Get started today!

Good to have you back!
If you've signed in to StudyBlue with Facebook in the past, please do that again.

- 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

"StudyBlue is great for studying. I love the study guides, flashcards and quizzes. So extremely helpful for all of my classes!"

Alice , Arizona State University"I'm a student using StudyBlue, and I can 100% say that it helps me so much. Study materials for almost every subject in school are available in StudyBlue. It is so helpful for my education!"

Tim , University of Florida"StudyBlue provides way more features than other studying apps, and thus allows me to learn very quickly! I actually feel much more comfortable taking my exams after I study with this app. It's amazing!"

Jennifer , Rutgers University"I love flashcards but carrying around physical flashcards is cumbersome and simply outdated. StudyBlue is exactly what I was looking for!"

Justin , LSU
StudyBlue is not sponsored or endorsed by any college, university, or instructor.

© 2016 StudyBlue Inc. All rights reserved.

© 2016 StudyBlue Inc. All rights reserved.