COMPUTER SKILLS DEPARTMENT EXCEL WEB APP

Exploring the Excel Window:

1. A spreadsheet is an electronic file used to organize related data and perform calculations. Example- Microsoft Excel.

2. A worksheet is a single spreadsheet that contains formulas, values, text, and graphical representations of data. Each worksheet is identified by a sheet tab

3. A workbook is a file containing related worksheets. By default, new workbooks have one worksheet.

4. A cell is the intersection of a row and column

- A cell is the basic unit in the table(The area in Excel where we write on) - The name of a cell: Letter of column + Number of row

5. The active cell is the current cell.

6. Text is any combination of letters, numbers, symbols, and spaces not used in calculations.

7. Values are numbers that represent a quantity or a measurable amount.

Operations on Worksheet:

a. Sheet Tab  Right click  Insert. b. Sheet Tab  Click on plus sign.

c. Home Tab  Cells group  Insert  Insert Sheet.

2- Delete sheet:

a. Sheet Tab  Right click  Delete.

b. Home Tab  Cells group  Insert  Delete Sheet.

3- Rename sheet:

a. Sheet Tab  Right click  Rename. b. Double click on the sheet in sheet tab.

1- Undo Group:

Undo: Delete the last action. Redo: Restore the last action.

2- Clipboard Group (Operations on text) :

Cut: Used to move the text from one location to another location.

1- Home Tab  Clipboard Group  Cut. 2- Right Click  From the menu select Cut. 3- Press Ctrl + X

Copy: Used to make an extra copy of the text in a different location

(Multiple copies).

1- Home Tab  Clipboard Group  Copy. 2- Right Click  From the menu select Copy. 3- Press Ctrl + C

Paste:

1- Home Tab  Clipboard Group  Paste. 2- Right Click  From the menu select Paste. 3- Press Ctrl + V

3- Font Group + Alignment Group (Formatting the Text):

Font Name or Font Type Font Face. Font Size

Font Color

Font Style ( Bold , Italic , underline , Double Underline)

Alignment:

[Vertical Align(Top, Middle, Bottom)]

[Horizontal Align(Left, Center, Right)]

Wrap text:when the text is too long, and at the same time it should be inside one cell without changing the width of the column (This button wraps extra-long text into multiple lines so we can see all of it without

changing the cell width.

Merge and Center:joins the selected cells into one large cell and centers the contents in the new cell.

4- Font Group (Formatting the Table):

5- Number Group (Formatting the Number):

Decimal Places: Increase decimal places, Decrease decimal places.

Currency: The currency format includes an optional dollar sign placed immediately to the left of a number.

(Home Tab Number Group Number Format Currency).

Percentage:The value as it would be multiplied by 100, with the percent sign.

(Home Tab Number Group Number Format Percentage).

6- Cells Group (Operations on Spreadsheet):

Insert:

1- Insert Rows. 2- Insert Columns.

3- Insert Cells & Shift Right. 4- Insert Cells & Shift Down. 5- Insert Sheet.

Delete:

1- Delete Rows. 2- Delete Columns.

3- Delete Cells & Shift Left. 4- Delete Cells & Shift Up. 5- Delete Sheet.

7-Editing Group:

AutoSum:This button in Excel is responsible for calculating the Total of a cell range.

Note:

You can insert the rest of functions by click on small arrow.

Clear: This Button have three choices:

Clear All: this choice will clear content and format

Clear Formats: this choice will clear the format only, and keep content

Clear Content: this choice will clear the content only, and keep format

Sort:Sort button is used to arrange the selected data into Ascending (From A to Z) order. (يدعاصت بيترت)

Or descending (from Z to A) order. (يلزانت بيترت)

8-Change the Column With and Row Height:

AutoFit: Is used to adjust the row height and column width according to the size of the text.

AutoFit the Column With AutoFit the Row Height

Put the pointer between two columns then Double-Click on it.

Put the pointer between two rows then Double-Click on it.

Insert Chart:

Chart:Is used to transfer the data in to graphical form(OR Is a visual representation of numeric data)

Charts Types:

Formatting the Chart:

• A Chart Title is the label that describes the entire chart.

• An Axis Title is a label that describes either the category or value axis. • A Legend is used to distinguish data points in a pie chart or data series

in a multiple series chart.

Legend

Chart Title

Data Table Vertical Axis Title Horizontal Axis Title

Data Label

A calculation in Excel is called a Formula -There are two types of formula:

a. Manual Calculation (Operation)

Subtraction[Difference] ( - ) حرطلاةيلمع

Multiplication ( * ) برضلاةيلمع Division ( / ) ةمسقلا ةيلمع

-Steps to Insert any Manual Calculation: 1) Select the cell that will show the result. 2) Write the Equal Sign. (=)

3) Write the name of cell one.

4) Write the Calculation (- or * or /). 5) Write the name of cell two.

6) Press Enter key.

b. Electronic Calculation (Function)

1.SUM: function is used for calculating the Total of a cell range

2. AVERAGE: function in Excel is responsible for calculating the sum of a range of values then dividing them by the number of values.

3. MAX: function in Excel is responsible for calculating the Maximum of a cell range.

5. COUNT: function is used to count the number of cells in a range that contains only numbers.

The function ignores empty cells or those cells that contains text. If a number is later added to an empty cell, the function will be automatically updated.

Note: Dates, Time, Functions, and Formulas are stored as numbers in Excel.

6. IF (Logical Function):

function checks whether a condition is met,

and returns one value if TRUE, and another value if FALSE.

-Logical Test (Condition): Name of cell [Operation] Number

( > ,>= , < , <= , = , < > )

-Logical test in IF Function (Condition):

> Greater Than (More Than) نم ربكأ

>= Greater Than or equal (More Than or equal ) يواسي وأ نم ربكأ

< Less Than نم لقأ

<= Less Than or equal يواسي وأ نم لقأ

= Equal يواسي

< > Not Equal يواسي لا

-There are two ways to insert any function: i. From Formula Bar  fx

ii. From Home Tab  Editing Group  AutoSum

-Steps to Insert any Electronic Calculation: 1) Select the cell that will show the result. 2) Insert the Function.

3) Select the Range. 4) Press Enter key.

Note:

1- Range is a group of adjacent or contiguous cell. Two cell

addresses separated by a colon ( : )

2- The Formula Bar is Displays the formula or contents of an active cell.

3- AutoFill is Enables you to copy the contents of a cell or cell range