PPT-Spreadsheet Formulas

Lesson Outline Copyright Texas Education Agency 2011 All rights reserved II Relevance of Spreadsheets to Everyday Life A Purpose of a spreadsheet 1 Keep track of money 2 Keep up with statistics. Excel Formatting Rules. Numbers greater than 999 should be formatted to display a comma.. Use a consistent number of decimal places for all numbers containing decimals. If any currency values on a spreadsheet display cents (more than 0 cents), then all currency values on a spreadsheet should be formatted to display 2 decimal places.. & Simplicity. Chapter S1: Introduction to Spreadsheet Design. S2: Simplicity. All . Sections. Security. Today’s Topic. Information Quality. IS Basics. E-commerce. Access. Excel. PowerPoint. Types of IS. Lesson Outline. Created by The University of North Texas in partnership with the Texas Education Agency. UNT in partnership with TEA, Copyright © 2008. All rights reserved.. 2. II.. . Relevance of Spreadsheets to Everyday Life. Calculating the readability of a text. You have been asked to analyze a piece of writing, considering (among other things) its readability. How can you calculate the ease with which it can be read?. Prepared for SSAC by. By Catherine George. Introduction. In this PowerPoint I will be analysing the good and bad points about 2 different spreadsheets.. I will be specifically looking at the purpose, what the data shows, what data they have, features of the spreadsheet (formulae), features that would improve productivity, accuracy and usability. I will also give strengths and weaknesses of each spreadsheets and the improvements that could be made to improve these weaknesses. . ICT 2. Learning target. Student will identify the parts of a spreadsheet.. vocabulary. Cell Reference – location of a cell. Row – labeled with numbers. Formula Bar – allows users to enter a formula. Basics. What is a . Spreadsheet. ?. A . spreadsheet (or worksheet). is an arrangement of . cells. in . columns . and. rows . used to organize, analyze, calculate, and report information, usually in numerical form. . ICT 2. Learning target. Student will identify the parts of a spreadsheet.. vocabulary. Cell Reference – location of a cell. Row – labeled with numbers. Formula Bar – allows users to enter a formula. 1. Spreadsheet Operations. —. . increase. . . . . . . . the. . efficiency of data . entry. t. he . performing of calculations. , and . the . presentation of information. .. 2. Types of Spreadsheet Operatio. Computer Concepts BASICS 4. th. Edition. Wells. 2. 2. Objectives. Understand the purpose and function of a spreadsheet. Identify the parts of a spreadsheet window. Enter labels, values, formulas, and functions in a spreadsheet. Click to proceed. View this in “Slide Show” mode for the proper display of animations.. School Year Calendar. Works through 2050 -2051 school year. If you need it beyond this date, don’t call me – I’ll be 103. P2 – Develop a complex spreadsheet model to meet particular needs. Multiple worksheets. Print screen the different sheets that you have created and annotate where information is pulled from other sheets.. Abby Whitmore Spreadsheets Task 1 Spreadsheet Facts What is a Spreadsheet ? Spreadsheet software can analyze, operate and accumulate larger amounts of data precisely to present the output data in a way that is easy to understand