What are the differences among relative, absolute, and mixed references?

Performing Calculations with Formulas and Functions

Questions:
– What is a series?
-How do you create a series using AutoFill?
-What are the differences among relative, absolute, and mixed references?
-What is a logical function?
-What does the following function mean? =IF(A1=B1,100,50)
-If cell Q3 is greater than cell Q4, you want to display the text “OK”; otherwise, display the text “RETRY”. Write the formula that
accomplishes this.
-What is a lookup function?

Last Completed Projects

topic title academic level Writer delivered