Excel Formula Programming
Unknown Grade•45 minutes
Learning Objective
I can write basic Excel formulas using cell references and mathematical operators (+, -, *, /).
Practice Questions
This lesson includes 7 practice questions to reinforce learning.
View questions preview
1. In Excel, write a formula that adds the values in cell A1 and cell B1 and displays the result in cell C1.
2. Explain how you would write a formula in Excel to subtract the value in cell B5 from the value in cell A5, then multiply the result by the value in cell C5.
3. You have the number of items sold in cell D2 and the price per item in cell E2. Write an Excel formula to calculate the total revenue in cell F2.
...and 4 more questions
Educational Video
IF Function in Excel Tutorial
Kevin Stratvert