Excel Formulas

What’s inside

• Which formula correctly calculates the total of cells B2 through B10?
• Which formula returns the value in cell C2 multiplied by 15%?
• Which formula uses an absolute reference for the tax rate stored in cell F1 while calculating tax on A2?
• Which formula returns "Pass" when the value in D2 is at least 50, and "Fail" otherwise?
• Match each Excel function with its primary purpose.
• Match each reference style with its behavior when a formula is copied.
• Match each lookup function with its characteristic use.
• Match each error value with its usual cause.