Exact Match Retrieval: VLOOKUP Function
Retrieve the exact price of ‘Monitor’ using VLOOKUP in cell E2. Look up the item name in Table A2:B5.
Excel Exercises
Conditional Totals: SUMIF Function
Sum the sales amounts in column C for items strictly in the ‘Electronics’ category. Place the result in cell E2.
Counting Targeted Items: COUNTIF Function
Count how many regional orders achieved ‘Shipped’ status. Enter a formula in cell D2 using COUNTIF.
Calculating Test Averages: AVERAGE Function
Determine the class performance average. Calculate the arithmetic mean of all student scores in cell B6.
Summing Sales: The SUM Function
You are reviewing quarterly department sales. Use the SUM function in cell B6 to calculate the grand total for Q1 […]
Your First Formula: Basic Addition
Excel formulas always begin with an equals sign (=). Write a formula in cell A1 to compute the sum of […]