Lab Test 2 MS Excel CS 101 PRACTICE 3

You may use any on-line help or printed manuals you wish. You may not communicate with anyone during the test. NO TALKING IS ALLOWED.

It is assumed that you can zip files and submit files by yourself now. If you must ask for assistance with these on the lab test, it will cost you 25 points.


When you are asked to write formulas in the problems below, make sure you use cell references, NOT just typing in numbers. That is, use =B5+C5 instead of =17+15, or even 32. Use the power of the spreadsheet!




Close all Excel files before zipping. Files should be zipped as usual and submitted to Canvas. Delete your folder and all your files from the Desktop.