--- title: Week 1 Lab tags: COMP1010-21T3 --- # COMP1010 # Spreadsheets Lab Book <h2>Instructions for Google Sheets</h2> <p>In order to use the Google Sheets documents below: </p> <ol> <li>Click on the link to view the document.</li> <li>Check the top-right corner of the screen for your logo, to see if you are logged in to Google. If it says 'Sign In', click the button and use it to sign in, or sign up to Google. (By the end of this step, you should be logged in, and have the spreadsheet on the screen in front of you.)</li> <li>File -&gt; Make a copy.</li> <li>Save the spreadsheet in your Google Drive folder. (You can now access this spreadsheet, and the changes you make to it, from now on, by going to <a href="https://drive.google.com/drive/my-drive">https://drive.google.com/drive/my-drive</a>.)</li> </ol> <h2>Exercise 1: Packing My Bag (2 marks)</h2> <p>An exercise using AND and OR and NOT functions. </p> <ol> <li>Create a copy of the provided spreadsheet: <a href="https://docs.google.com/spreadsheets/d/1E2n3tcCfCyFjRE0LGF4lBNIv36X4RfR8eX_XbuuH6us/edit?usp=sharing" target="_blank">Packing My Bag Spreadsheet</a></li> <li>Follow the instructions in the spreadsheet.</li> </ol> <p>A resource that might be helpful: <a href="https://infoinspired.com/google-docs/spreadsheet/combined-use-of-if-and-or-logical-functions-in-google-doc-spreadsheet/" target="_blank">Combined Use of IF, AND, OR Logical Functions</a> </p>