MS Excel Basics: Creating Spreadsheets, Data Entry, Formulas & Functions

1. Week 7 • Why We MS Excel • Creating Spread Sheets • Excel Basic and Data Entry • Formulas & Functions

2. Which Commands or Buttons to type the below Document I Abdallabearning Roll No. 1234567 student of Prince SattamBinAbdul Aziz University registered the Course CS 1101 G(315). Write which tabs useful to do below tasks • Bold & Italic • Font Size & Font Type • Copy , Cut Paste to another file. • Insert shapes and Figures

3. Why we use MS Excel • Store and organize data, • Analyze data, and • Represent data graphically (e.g., in bar graphs, histograms, and scatterplots)

4. Excel Basics Excel spreadsheets organize information (text and numbers) by rows and columns: This is a row. Rows are represented by numbers along the side of the sheet. This is a column. Columns are represented by letters across the top of the sheet.

5. Excel Basics A cell is the intersection between a column and a row. Each cell is named for the column letter and row number that intersect to make it.

6. Data Entry 1. Type directly into the cell. Click on a cell, and type in the data (numbers or text) and press Enter. 2. Type into the formula bar. Click on a cell, and then click in the formula bar (the space next to the ). Now type the data into the bar and press Enter. There are two ways to enter information into a cell:

7. Data Entry 1. Type directly into the cell. Click on a cell, and type in the data (numbers or text) and press Enter. 2. Type into the formula bar. Click on a cell, and then click in the formula bar (the space next to the ). Now type the data into the bar and press Enter. There are two ways to enter information into a cell:

8. Formulas and Functions • Formulas are equations that perform calculations in your spreadsheet. Formulas always begin with an equals sign (=). When you enter an equals sign into a cell, you are basically telling Excel to “calculate this.” • Functions are Excel-defined formulas. They take data you select and enter, perform calculations on them, and return value(s).

9. Functions for Descriptive Statistics Below are several functions you will need to learn for this class. Try them out with the practice data set. =AVERAGE(first cell:last cell): calculates the mean =MEDIAN(first cell:last cell): calculates the median =MODE(first cell:last cell): calculates the mode =VARP(first cell:last cell): calculates the variance =STDEVP(first cell:last cell): calculates the standard deviation • You may directly write the functions for these statistics into cells or the formula bar, OR • You may use the function wizard ( in the toolbar)

10. Functions for Descriptive Statistics • Your Excel spreadsheet should now look like this:

11. Excel’s arithmetic operators Arithmetic operations, symbols and description of their use. New Perspectives on Microsoft Excel 2002 Tutorial 1

12. Know the order of precedence The order of precedence rules must be considered when creating expressions. The chart below illustrates Excel’s order of precedence and shows sample expressions and the result of each expression. New Perspectives on Microsoft Excel 2002 Tutorial 1

13. Examine the Insert Function dialog box This dialog box appears when you click the Insert Function button. It can assist you in defining your function. New Perspectives on Microsoft Excel 2002 Tutorial 1

14. Chart Wizard dialog box 1 Choose a chart type and view examples of that type in dialog box 1. Choose which type of chart you want in this pane. Select a sub-type of that chart in this pane. Click and hold this button down to see a preview of your chart. New Perspectives on Microsoft Excel 2002 Tutorial 1