Activity – Excel 5: Using Excel formulas

Using Excel formulas

[This section should take you around 30 minutes to complete]

1. 1. Start a new Excel workbook.
   2. Click the File tab and then Save As to save the spreadsheet as YourName StudentNumber DigiPrep Excel5.xlsx in the OneDrive folder on your computer.
   3. Enter 100 in cell A1.
   4. Enter 10 in cell C1.
   5. Click in E1 and enter an equal sign ( = ) without brackets.
   6. Click A1.
   7. Type an asterisk ( * ) without brackets.
   8. Click C1.
   9. Click the tick OR press Enter key to complete the formula.
   10. Click G1 and type your full name and student number.
   11. Click in B3 and enter an equal sign ( = ) without brackets. Always use the cell reference rather than the actual value in the cell when creating formulas.
   12. Click A1.
   13. Type an asterisk (*) without brackets followed by 10%.
   14. Type a plus sign ( + ) without brackets.
   15. Click C1.
   16. Click the tick or press Enter key to complete the formula.

You can use the Excel formulas as a calculator. For example, if you want to find the answer of 278 ÷ 13, you don’t need to launch the calculator app but simply enter the formula =278/13 in any cell and then press the Enter key, you will get the answer instantly.

17. Type =278/13 in any empty cell and press Enter to see the result.

18. Type =3^2 in another empty cell and then press Enter to get a 9, which is the answer to 3².

19. Add a header with your name on the left and date on the right.

20. Add a footer with the activity name and number on the left and page number on the right.

21. Save and close the workbook.

22. Upload the completed activity document to your DigiPrep folder on OneDrive.