Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Computer literacy - Lecture 16: Spreadsheet

After studying this chapter you will be able to understand: What is spreadsheet? Differentiate between Save and Save As. Why formula bar is used? What is a cell address? Adding and working with information, changing the look of information with spreadsheet. | Spreadsheet ADE100- Computer Literacy Lecture 16 Knowledge test What is spreadsheet? Differentiate between Save and Save As. Why formula bar is used? What is a cell address? 2 Topics covered Adding and working with information Formatting cells Adding comments Inserting hyperlinks Changing the look of information with spreadsheet Cell alignment Changing font face and size Adding background color to cells and rows Inserting pictures 3 3 Entering data in the cells Entering data in a cell Select the cell where you want to insert data Type the data Press Enter from keyboard 4 Types of data Text Also called Labels because it is often used to identify the information in columns or rows Include any letters, numbers and symbols on the keyboard Up to 32,000 characters may be entered in a cell Values Numeric entries; used in calculations Numbers can be displayed in different formats like with or without currency symbol Numbers that contain too many digits for the width of column are displayed as | Spreadsheet ADE100- Computer Literacy Lecture 16 Knowledge test What is spreadsheet? Differentiate between Save and Save As. Why formula bar is used? What is a cell address? 2 Topics covered Adding and working with information Formatting cells Adding comments Inserting hyperlinks Changing the look of information with spreadsheet Cell alignment Changing font face and size Adding background color to cells and rows Inserting pictures 3 3 Entering data in the cells Entering data in a cell Select the cell where you want to insert data Type the data Press Enter from keyboard 4 Types of data Text Also called Labels because it is often used to identify the information in columns or rows Include any letters, numbers and symbols on the keyboard Up to 32,000 characters may be entered in a cell Values Numeric entries; used in calculations Numbers can be displayed in different formats like with or without currency symbol Numbers that contain too many digits for the width of column are displayed as hash symbols (####) This problem can be solved by resizing the width of column 5 Types of data Dates The values that can be used in calculations to calculate time interval like your age. May be displayed in different formats For example, dd-mm-yy, mm-dd-yyyy Formula The instructions that perform calculations May be very simple or complex The result may be a number, date or a message Begins with equal (=) sign For example, =A1+A2, =a1/a3, =Sum(a1,a2) and =sum(a1:a100) 6 Types of data 7 Fill Handle Fill handle A time saving tool that automatically fills a series of words like days, number patterns and formulas AutoFill feature makes data entry fast and efficient Filling in a common series Select the initial cell for the series Place the mouse over the fill handle, your mouse pointer appears like a black plus sign (called crosshairs) Drag the handle over the cells that are to be filled Release the mouse button. Excel fills the cells. 8 Examples of Fill handle series Initial selection .