computer lec1.pdf

??What is Excel It is a program that processes calculations and solves mathematical problems ?What does the Excel program consist of It consists of tables in the form of columns and...

??What is Excel It is a program that processes calculations and solves mathematical problems ?What does the Excel program consist of It consists of tables in the form of columns and rows that are cells /  ?What is a cell It is the intersection of columns and rows ??What meaning H8 H=COLOMN, 8=ROW H8 =CELL ?What can we put into the cells We can enter letters, numbers, symbols and equations Mathematical formulas, date ?Advantages of Excel The Excel program has many features that help the user to work on it. It provides the user with a  database that analyzes and stores information, filters.it, merges it, and prints it in the easiest ways Among its most prominent features Analyze and store data\1 Get work in the easiest way\2 Through existing tools, we help reduce effort and time Recovering data and spreadsheets: When data is\3 deleted, it is easy to recover it Various mathematical formulas: finding the most\4 accurate results Accessibility via the Internet: to facilitate work\5 easily ‫؟؟؟‬Steps to run the program > Microsoft Office >>>>> Excel  ?Excel screen components Title Bar The menu bar Toolbars Formula bar Column titles Row titles Cells ?What does the menu bar contain in Excel it contains file/Home/ insert/ page layout/ formulas/ data/Review/ view ?What does the file list consist of Consisting of open/ save/ /saveAs/ Print Send The Home menu is one of the important main menus in Excel through which we enter data ? The Home menu consists of All the tools we use ((font)) to format the writing in terms of color,.enlarge and reduce the font, and center the writing And color it Add to  Create a ready-made table from format tabal ((cell)) And insert a row or column Delete a row or column The directive ((editing)) is used for filtering and other modification Add a single row, column, or cell Select a row, column, or cell. Right-click on the row, column, or cell. From the menu that appears, choose Insert row, column, or cell on.the left, right, top, or bottom ?How to insert a row or column open excel pro>>Home>>insert>>insert(column). OR((Row) >>> ??How to delete a row or column open excel pro delete>>>delete (column). OR. (Row  ( You can use the Flash Fill feature to separate first and last names from one column or combine first and last names from two different columns  Insert tabal.Select a cell within your data.Select Format > Main as Table.Choose a style for the table In the Create Table dialog box, set the cell.range.Mark whether the table contains headers.Select OK