Create an account
You need to reference cell Q57 in a formula. What is the absolute cell reference? What are the two mixed references?
Mixed: =$Q57 or Q$57
Assume that cell R10 contains the formula =R1+R2. What formula is entered if this formula is copied and pasted into cell S20?
Assume that cell T10 contains the formula =$T1+T$2. what formula is entered if this formula is copied and pasted into cello U20?
Assume that 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...]
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 minimum value?
the interest is equal to a percentage of principle for each period that the money has been lent.
the interest is applied not only to the principle but also to any accrued interest.
How do you use AutoFill to copy a set of cell values, but not the formatting?
Drag the box to where you want to stop, then by the options bar expand it and click fill without formatting.
Is the first three selected values in a series are 3,6, and 9, what are the next three values that will be inserted using AutoFill?
If cell P5 contains the text "Mon," and then you select the cell and drag the fill handle over the range P6:P8, what text will be entered into those cells?
Tues. , Wed. , Thurs.
If cell Q3 is greater than cell Q4, you want to display "OK"; otherwise, you want to display "RETRY". Write the formula that accomplishes this.
You want to take out a loan for $130,000. The interest on the loan is 5% compounded monthly. You intend to pay back the loan in 20 years. Write the formula to calculate the monthly payment required to pay off the loan under those conditions.
=PMT(0.05/12, 20*12, 130000)
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together