Bird
Raised Fist0
Excelspreadsheet~15 mins

AutoSum shortcut in Excel - Real Business Scenario

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Scenario Mode
👤 Your Role: You are a sales assistant at a retail store.
📋 Request: Your manager wants you to quickly find the total sales for each product category using the AutoSum shortcut.
📊 Data: You have a list of product categories and their sales amounts for the week.
🎯 Deliverable: Create a column that shows the total sales for each category using the AutoSum shortcut.
Progress0 / 5 steps
Sample Data
CategoryMondayTuesdayWednesdayThursdayFriday
Electronics120150130160170
Clothing80908595100
Groceries200210190220230
Books5060556570
1
Step 1: Select the cell next to the first product category's Friday sales (cell G2).
No formula yet, just select cell G2.
Expected Result
Cell G2 is selected.
2
Step 2: Press the AutoSum shortcut key (Alt + =). Excel will automatically select the range B2:F2 to sum.
=SUM(B2:F2)
Expected Result
Formula =SUM(B2:F2) appears in cell G2, showing the sum of Monday to Friday sales for Electronics.
3
Step 3: Press Enter to confirm the formula in cell G2.
Confirm formula =SUM(B2:F2)
Expected Result
Cell G2 shows 730 (120+150+130+160+170).
4
Step 4: Copy the formula in cell G2 down to cells G3 to G5 by dragging the fill handle.
Formulas in G3: =SUM(B3:F3), G4: =SUM(B4:F4), G5: =SUM(B5:F5)
Expected Result
Cells G3 to G5 show totals for Clothing (450), Groceries (1050), and Books (300).
5
Step 5: Rename the header of column G to 'Total Sales'.
Type 'Total Sales' in cell G1.
Expected Result
Cell G1 shows 'Total Sales'.
Final Result
Category   Monday  Tuesday  Wednesday  Thursday  Friday  Total Sales
Electronics 120     150      130        160       170     730
Clothing    80      90       85         95        100     450
Groceries   200     210      190        220       230    1050
Books       50      60       55         65        70      300
✓AutoSum shortcut quickly sums rows of sales data.
✓Total sales per category are calculated without typing formulas manually.
✓This saves time and reduces errors in adding numbers.
Bonus Challenge

Use the AutoSum shortcut to calculate the total sales for each day (column totals) below the Friday sales.

Show Hint
Select the cell below the Friday sales column (e.g., B6), then press Alt + = to sum the column.

Practice

(1/5)
1. What does the AutoSum shortcut Alt + = do in Excel?
easy
A. It deletes the selected cells.
B. It quickly adds a range of numbers above or to the left of the selected cell.
C. It copies the selected cells to another location.
D. It formats the selected cells as currency.

Solution

  1. Step 1: Understand the AutoSum shortcut purpose

    The shortcut Alt + = is designed to quickly sum numbers in a range.

  2. Step 2: Identify the range it sums

    It sums numbers above or to the left of the selected cell automatically.

  3. Final Answer:

    It quickly adds a range of numbers above or to the left of the selected cell. -> Option B

  4. Quick Check:

    AutoSum shortcut = quick sum [OK]
Hint: Press Alt + = to sum numbers fast [OK]
Common Mistakes:
  • Thinking it deletes cells
  • Confusing it with copy shortcut
  • Assuming it formats cells
2. Which of these is the correct way to use the AutoSum shortcut in Excel?
easy
A. Select the cell below the numbers and press Ctrl + +
B. Select the cell to the right of numbers and press Ctrl + =
C. Select the cell below the numbers and press Alt + =
D. Select the numbers and press Alt + Enter

Solution

  1. Step 1: Identify the correct shortcut keys

    The AutoSum shortcut is Alt + =, not Ctrl + + or others.

  2. Step 2: Identify the correct cell selection

    You must select the cell below (or to the right) of the numbers to sum.

  3. Final Answer:

    Select the cell below the numbers and press Alt + = -> Option C

  4. Quick Check:

    AutoSum = Alt + = [OK]
Hint: Select cell below numbers, press Alt + = [OK]
Common Mistakes:
  • Using Ctrl instead of Alt
  • Pressing wrong keys like Enter
  • Selecting wrong cells
3. Given numbers in cells A1 to A4 as 5, 10, 15, and 20, what will be the result if you select cell A5 and press Alt + =?
medium
A. 20
B. Error
C. 15
D. 50

Solution

  1. Step 1: Identify the numbers to sum

    Cells A1 to A4 contain 5, 10, 15, and 20.

  2. Step 2: Apply AutoSum shortcut in A5

    Pressing Alt + = in A5 sums A1:A4 automatically: 5+10+15+20 = 50.

  3. Final Answer:

    50 -> Option D

  4. Quick Check:

    Sum(5,10,15,20) = 50 [OK]
Hint: Alt + = sums above numbers automatically [OK]
Common Mistakes:
  • Choosing last number instead of sum
  • Expecting error instead of sum
  • Confusing sum with average
4. You pressed Alt + = in cell B5 but the sum formula includes unwanted cells. What is the best way to fix this?
medium
A. Manually adjust the formula range to correct cells.
B. Press Ctrl + Z to undo and try again.
C. Delete the entire column and re-enter data.
D. Restart Excel to reset formulas.

Solution

  1. Step 1: Understand AutoSum formula range

    AutoSum guesses the range but sometimes includes extra cells.

  2. Step 2: Fix the formula manually

    Edit the formula in the formula bar to select only the correct cells to sum.

  3. Final Answer:

    Manually adjust the formula range to correct cells. -> Option A

  4. Quick Check:

    Fix formula range manually [OK]
Hint: Edit formula range after AutoSum if incorrect [OK]
Common Mistakes:
  • Undoing without fixing range
  • Deleting data unnecessarily
  • Restarting Excel instead of fixing
5. You have numbers in cells A1:A3 and C1:C3. You want to sum all six numbers using AutoSum. What is the best approach?
hard
A. Select cell A4, press Alt + =, then manually edit formula to include C1:C3.
B. Select cell B4 and press Alt + = to sum both ranges automatically.
C. Select cell C4 and press Alt + = to sum only C1:C3.
D. Use AutoSum twice, once below A3 and once below C3, then add results manually.

Solution

  1. Step 1: Use AutoSum on one range first

    Select cell A4 below A1:A3 and press Alt + = to sum A1:A3.

  2. Step 2: Edit formula to include second range

    Manually add C1:C3 to the formula, e.g., =SUM(A1:A3,C1:C3).

  3. Final Answer:

    Select cell A4, press Alt + =, then manually edit formula to include C1:C3. -> Option A

  4. Quick Check:

    Combine ranges by editing AutoSum formula [OK]
Hint: Edit AutoSum formula to add multiple ranges [OK]
Common Mistakes:
  • Expecting AutoSum to sum non-adjacent ranges automatically
  • Selecting wrong cell for sum
  • Adding sums manually instead of formula