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?
If cell T10 contains the formula =T1+T$2. what formula is entered if this formula is copied and pasted into cell U20?
If cell V10 contains the formula =AVERAGE(U1:$U5) What formula is entered if this formula is copied and pasted into cell W20?
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?
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?
What formula with functions can you enter to calculate the ratio of the maximum value in the range Z1:Z10 to the minimum value?
Want to see the other 8 Flashcards in Tutorial 3.1 Quick Check?JOIN TODAY FOR FREE!