{"id":81,"date":"2026-01-14T06:49:01","date_gmt":"2026-01-14T06:49:01","guid":{"rendered":"http:\/\/bispcomputingtest.ddns.net\/wordpress\/?page_id=81"},"modified":"2026-01-22T07:23:07","modified_gmt":"2026-01-22T07:23:07","slug":"skill-3-basic-math-formulas","status":"publish","type":"page","link":"https:\/\/bisp-digital-literacy.com\/?page_id=81","title":{"rendered":"Skill 3 – Basic Math Formulas"},"content":{"rendered":"\n

\ud83c\udfaf The Goal<\/h3>\n\n\n\n
\n

I can write my own formulas using the equals sign (=) and math symbols (+, -, *, \/) to make the spreadsheet calculate for me.<\/p>\n<\/blockquote>\n\n\n\n

\n\n\n\n

\ud83d\udcd6 The Walkthrough: The Magic Equals Sign<\/h3>\n\n\n\n

A spreadsheet is a “Super Calculator,” but it only works if you use the magic code. Every formula must start with an Equals Sign (=).<\/strong> If you don’t type =<\/code>, the spreadsheet just thinks you are typing normal text.<\/p>\n\n\n\n

The Math Symbols<\/h4>\n\n\n\n

On a computer, math symbols look a little different than in your notebook:<\/p>\n\n\n\n

Operation<\/strong><\/td>Symbol<\/strong><\/td>Example<\/strong><\/td><\/tr><\/thead>
Addition<\/strong><\/td>+<\/code><\/strong><\/td>=A1+B1<\/code><\/td><\/tr>
Subtraction<\/strong><\/td>-<\/code><\/strong><\/td>=A1-B1<\/code><\/td><\/tr>
Multiplication<\/strong><\/td>*<\/code><\/strong><\/td>=A1*B1<\/code><\/td><\/tr>
Division<\/strong><\/td>\/<\/code><\/strong><\/td>=A1\/B1<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

\ud83d\udce5 The Starter File<\/h3>\n\n\n\n

Download the “Tuck Shop Totals”<\/strong> spreadsheet below. You will see a list of snacks and how many were sold, but the “Total” column is empty!<\/p>\n\n\n\n

\n
Download Tuck Shop Totals<\/a><\/div>\n<\/div>\n\n\n\n
\n\n\n\n

\u2705 The Checklist: Your Task<\/h3>\n\n\n\n

Open the Tuck Shop file and follow these steps:<\/p>\n\n\n\n

    \n
  1. Multiply:<\/strong> In cell D2<\/strong>, type the formula to multiply the Price by the Quantity.\n