INF10009 Introduction to Business Information Systems MS Excel Lab 1A Instructions: SWIN BUR . NE . Pls work on the exercises alone unless it is stated that group work is required. Your tutor will discuss with you once you have completed the group exercises. Go to http://www.gcflearnfree.org/excel2016 and go through Excel Basics 1 to 8. 1. What is MS Excel Microsoft excel is a spread sheet application (software) that can run on multiple operating platforms, it allows for the manipulation, storing, organization and analysis of data in one application, some examples of commons use cases for excel are training logs, invoices, temperature data etc. Describe these objects in MS Excel Object Description Workbook A workbook is usually an entire document file consisting of 1 or more work sheets. Worksheet Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook Cell Cells are the basic building blocks of a worksheet which consist of cell content to calculate, analyze, and organize data. Formula Numerical information's using formals similar to a calculator able to add, subtract, multiply and divide in different formats to equate to one outcome A function is a predefined formula that performs calculations using specific values in a particular order Function Chart Charts are illustrated data usually in visual form to evaluate and understand comparisons and trends much easier than simply reading individual sets of data In groups of 2 or 3, discuss and answer the following questions. 2. What are the differences between MS Word and MS Excel? MS Word is primarily based on text input and MS Excel is mainly based on the manipulation and organization of data most likely numerical. What do the following people use MS Word and MS Excel for? Hint: When you open a new document in MS Word, you can see the AVAILABLE TEMPLATES. These are the documents that people use MS WORD for. You can do the same in MS Excel Role Sales Manager Finance Manager Student MS Word Staff reviews, memos Compiling sales into non-mathematical form that can be understood by a larger group of people / Quarterly earnings reports. Assignments, note taking, reports @Copyright: 2021 Swinburne University of Technology MS Excel Lab 1A MS Excel Calculating sales data/ stock data and inventory Financial Chart, profit /loss statements Recording and calculating grades, study plans, CRICOS: 073432E TOID: 3059 15/05/2024 Page 1 of 2
Your mum/dad Letters, invitations, shopping list organizing budgets Family Budgets, calculating taxes 3. Research on the Internet on Google Sheet. What is it? How is it different from MS Excel? Google sheet is a free online spreadsheet based applications similar to excel that is based around the collaboration of multiple users, which unlike MS excel can be accessed anywhere without needing to be installed on a specific device. @Copyright: 2021 Swinburne University of Technology MS Excel Lab 1A CRICOS: 073432E TOID: 3059 15/05/2024 Page 2 of 2