This chapter is a video presentation. [hidepost=1] [flv:http://pcmech.s3.amazonaws.com/SiS1/21_cp_user_accounts.flv 610 458] [/hidepost] [hidepost=2] Download video (MOV) [/hidepost]

This chapter is a video presentation. [hidepost=1] [flv:http://pcmech.s3.amazonaws.com/SiS1/20_cp_start_menu.flv 610 458] [/hidepost] [hidepost=2] Download video (MOV) [/hidepost]

The distinguishing feature of a spreadsheet program such as Excel is that it allows you to create mathematical formulas and execute functions. Microsoft Excel has a set of prewritten formulas called Functions. A function is a small assignment that is performed to produce a result that can be reliably used without caring as to how the function works or how it was...

Click the file below to see the sample spreadsheet. [hidepost=1] Download spreadsheet example [/hidepost]

The Chart Wizard brings you through the process of creating a chart by displaying a series of dialog boxes. [hidepost=1]Enter the data into the worksheet and highlight the range for which you want to make a chart including headers.Click the Chart Wizard icon on the standard toolbar to view the first Chart Wizard dialog box or choose Chart option from the...

Charts are pictorial representation of worksheet data and make it easy for users to make comparisons, patterns, and trends in data. Charts present worksheet data in graphical or pictorial form, which is easier to read and understand. For instance, rather than having to analyze several columns of worksheet numbers, you can see at a glance whether sales are...

Mathematical & Trigonometric FunctionsAbs() :This function is used to return the absolute value of a number. Syntax : Abs(number) Example : =Abs(A1) , Abs(-54) Result : 5 54 Sqrt() : This function is used to return the square root of a number. Syntax : Sqrt(number) Example : =Sqrt(A5) , Sqrt(D1*5) Result : 5 10 [hidepost=1] Round(): This function is used...

A cell in a worksheet is identified as C5, D8 etc. When a cell is referred to in a formula, this is called cell referencing. There are three types of referencing. [hidepost=1] Relative References When you create a formula, references to cells or ranges are usually based on their position relative to the cell that contains the formula. In the following example,...

You can use borders to make entries on your spreadsheet stand out. Accountants usually place a single underline above a final number and a double underline below. The following illustrates: [hidepost=1]Select the cell A1. Choose Format ? Cells from the menu. Choose the Border tab.Click on the single underline from the Style boxClick the top of the...

The general arrangement of data is known as formatting. The contents of selected cells can be formatted in different ways. The quick way to format the data is to use the format toolbar . Font and cell attributes can be added from shortcut buttons on the formatting tool bar. If this toolbar is not already visible on the screen, select View?Toolbars?Formatting...