AA2 - Christie Hardwick BSBITU304A Produce Spreadsheets(AA2 QUESTION 1 What are spreadsheets used for Spreadsheets are used for many different purposes

AA2 - Christie Hardwick BSBITU304A Produce Spreadsheets(AA2...

This preview shows page 1 - 4 out of 5 pages.

Christie Hardwick – BSBITU304AProduce Spreadsheets(AA2) – QUESTION 1 What are spreadsheets used for?Spreadsheets are used for many different purposes; to orgainse data, make simple and complex calculations and analyse information. Excel spreadsheets are generally used for accounting or numerically based information organisation, In accounting, spreadsheets can be used for a variety of purposes; budgeting, charting/graphing, financial analysis, scientific applications and simple records for any type of calculation.QUESTION 2How many work sheets are contained in a new excel file? By default (until they are changed)what are the worksheets called?There are 3 Worksheets contained in a new excel file and they are by default cal Sheet 1, Sheet 2 and Sheet 3. These can be renamed. (AA3) – QUESTION 1
Complete these tasks: 1.Create a simple plan (in sketch form) for a working spreadsheet using this information:a.Sales report of the month of July indicating red wine sales for Jack’s wine Store.b.Wine names should be input to Column A, with week’s 1-4 also in columnsc.Include a total column and row for each wine and each week.
Christie Hardwick – BSBITU304AProduce SpreadsheetsASSESSMENT TOOL 2QUESTION 1.Explain the difference between an Excel Worksheet and a Workbook. The basic difference between an Excel Worksheet and an Excel Workbook is that a

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture