Ravindra BagaleCourses & study guides मराठी Track your progress

16. Practice Exercises with Answer Hints

16.1 Modules 1–2: Basics and Data Entry

By Last updated:

  1. Create sheets Orders, Stores, Products, Report; colour data tabs green and the report tab blue. Hint: right-click tab › Tab Color; Shift + F11 inserts a sheet.
  2. In Report!B2 calculate Amount × GST rate where the GST rate is in F1, and copy it down 10 rows so F1 stays fixed. Hint: =A2*$F$1; press F4 to add the dollar signs.
  3. Format 1250000 so it shows ₹12,50,000. Hint: custom format [>=10000000]₹##\,##\,##\,##0;[>=100000]₹##\,##\,##0;₹##,##0 (Module 1.5).
  4. Show order dates as 14-03-2026 regardless of how they were typed (real dates only). Hint: Ctrl + 1 › Custom › dd-mm-yyyy.
  5. Create a drop-down in the City column that allows only the six cities. Hint: Data › Data Tools › Data Validation › List › source =Cities (a named range or Table column).
  6. Allow only whole numbers 1–20 in Qty, with an error message "Qty must be 1 to 20". Hint: Data Validation › Whole number › between 1 and 20 › Error Alert tab.
  7. Fill Order IDs BLK-001 to BLK-100 without typing each. Hint: type BLK-001, drag the fill handle; or ="BLK-"&TEXT(ROW()-1,"000").

Ravindra Bagale's Tip

Many students skip this basic section saying "I know this" – and later get stuck on F4, custom formats and Data Validation. Do every exercise yourself at least once, even if it seems easy. Knowing where a button is also gets tested in interviews.

Loading practice tasks...

  1. Total units sold (Easy): Add up Units sold in the "Units sold" column.
  2. Average price (Easy): Average of the Price (₹) column, rounded to 2 decimals.
  3. Rows in Snacks (Easy): How many rows have Category "Snacks"?
  4. Largest units sold (Easy): The largest value in the "Units sold" column.
  5. Units sold for Snacks (Medium): Total of the Units sold column where Category is "Snacks".
  6. Snacks in Delhi (Medium): Total of the Units sold column where Category is "Snacks" and City is "Delhi".
  7. Best in Snacks (Medium): Largest value in the "Price (₹)" column where "Category" is "Snacks".
  8. Value of row 2 (Medium): Multiply the first-row Units sold by the first-row Price (₹).
  9. Look up Hannah Lee (Medium): The Units sold for "Hannah Lee" (use a lookup on the "Name" column).
  10. Total value (Hard): Sum of "Units sold" times "Price (₹)" for all rows.
  11. Share of Snacks (Hard): Share of the "Units sold" column that is "Snacks", rounded to 3 decimals.
  12. Share of the total "Price (₹)" with a locked range (Hard): Find what share of the total "Price (₹)" the first row has. Round it to 3 decimals.
  13. Above average? (Hard): "Above" if the "Price (₹)" value in the first row is above the average of the "Price (₹)" column, else "Below".

See all practice tasks in the Task Hub →

Worked example — modules 1 2 basics and data entry

Why

Neha Shah in Pune and James O'Neill abroad both need a clear, repeatable way to use modules 1 2 basics and data entry on a NovaCraft Tools sheet without breaking totals.

What

Modules 1 2 Basics And Data Entry is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for modules 1 2 basics and data entry.
  2. Enter a small made-up value for Neha Shah using £ where money appears.
  3. Add a second value for James O'Neill using £ so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for NovaCraft Tools's sample row.
Meaning: Once modules 1 2 basics and data entry is correct on one row, copy the same pattern down the column.

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Modules 1 2 Basics And Data Entry?
Card 1: What is Modules 1 2 Basics And Data Entry? · Download PNG
Revision card 2: Tiny example — Modules 1 2 Basics And Data Entry
Card 2: Tiny example — Modules 1 2 Basics And Data Entry · Download PNG
Revision card 3: Checklist — Modules 1 2 Basics And Data Entry
Card 3: Checklist — Modules 1 2 Basics And Data Entry · Download PNG