1 / 12

Understanding Spreadsheet Software for Effective Administration

Spreadsheet software is an essential tool for administrators across various departments. It simplifies the processing of numerical data by organizing information into rows and columns, allowing for easy calculations and record-keeping. In finance, it aids in accounting and wage calculations, while sales departments use it to track product sales. Operations can monitor stock levels effectively. Additionally, spreadsheets facilitate the creation of charts and graphs for presentations and can seamlessly integrate with word processing tools. This guide will enhance your administrative skills with spreadsheets.

percy
Download Presentation

Understanding Spreadsheet Software for Effective Administration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ADMINISTRATION Information Technology for Administrators SPREADSHEETS Click To Continue

  2. SPREADSHEET SOFTWARE A spreadsheet package is a computer program created specifically to help in the processing of numbers. The spreadsheet stores information in rows (across the screen) and columns (down the screen) creating little boxes, known as cells.

  3. SPREADSHEET SOFTWARE Spreadsheets can be used in business within the finance department for accounting and calculating wages. Spreadsheets can be used in the sales department to keep a record of the number of products sold. Spreadsheets can be used in the operations department to keep a check on how much stock has been bought in and used.

  4. SPREADSHEET SOFTWARE Spreadsheets help with presentations - charts and graphs can be created. Spreadsheets can be copied and imported into word processed reports. Spreadsheets can update figures without the user having to do any of the maths!

  5. Formula Bar Active Cell Column Headings Row Column Cells Sheets Row Headings MAIN FEATURES

  6. SPREADSHEETS Test Your Knowledge

  7. TEST YOUR KNOWLEDGE 1 Your correct answer •  A  Excel • B Expert • C Excellence Correct Which of the following is a type of spreadsheet software? Next Question

  8. TEST YOUR KNOWLEDGE 2 • Spreadsheet software is used to: Your correct answer •  A  Contact suppliers • B Record employee details • C Record financial information Correct Next Question

  9. TEST YOUR KNOWLEDGE 3 Spreadsheet contain cells ? True or False? Your correct answer • A True • B False True Next Question

  10. TEST YOUR KNOWLEDGE 4 Which of the following is not a feature of a spreadsheet ? Your correct answer •  A  Rows • B Columns • C Lines Correct Next Question

  11. TEST YOUR KNOWLEDGE 5 Graphs and charts cannot be copied into word documents? True or False? Your correct answer • A True • B False False Next Question

  12. WELL DONE Now work through spreadsheet booklets to develop your administration skills You have the Guide to Spreadsheets document to help you. Help from the computer is also useful. End Show

More Related