GE ELEC 1 MS EXCEL.pdf

GE ELEC 1: LIVING IN THE IT ERA Spreadsheet Application MS Excel NAME BOX / NAME BAR → A spreadsheet program which is used to → Part of the MS Excel environment where save and analyze numerical data....

GE ELEC 1: LIVING IN THE IT ERA Spreadsheet Application MS Excel NAME BOX / NAME BAR → A spreadsheet program which is used to → Part of the MS Excel environment where save and analyze numerical data. you can find the address of name of → A spreadsheet program where one can your active or selected cell. record data in the form of tables. Uses: WORKSHEET Companies with large staff and workers → It refers to every page on your excel file use MS Excel in saving employee that has a collection of cell. information. Hospitals use excel in saving patient’s records. ROW Benefits of MS EXCEL: → A collection of cells aligned horizontally ✓ Easily to store data in your spreadsheet. ✓ Easy to recover data ✓ Application of formulas ✓ More secure COLUMN ✓ Data at one place → A collection of cells aligned vertically in ✓ Neat and clear information your spreadsheet. CELL FORMULA → Every rectangular box at the intersection point between rows and columns → It refers to a user defined function or intersects. expression to calculate data in your spreadsheet. CELL ADDRESS → The name by which is cell can be FUNCTIONS addressed. → Are predefined formulas and are already available in Excel. XLSX / xlsx SUM – Add individual values, cell → The filename extension of your references or ranges or a mix of all three. Spreadsheet file created or compatible SUMIF – Sum the values in a range that for latest versions of MS Excel application. meet criteria that you specify. IF – Allows you to make logical XLS / xls comparisons between a value and what → The filename extension of your spreadsheet file created or compatible you expect. for lower versions of MS Excel IFS – Check whether one or more application. conditions are met and returns a value that corresponds to the first TRUE WORKBOOK condition. XLOOKUP – Find things in a table or range → A collection of one (1) or more excel sheet that made up your excel file. by row.  GE ELEC 1: LIVING IN THE IT ERA CIRCULAR REFERENCE COLUMN CHART – Compares values → An error on your formula where it refers across categories using vertical bars. back to its own cell address. BAR CHART – Compares values using horizontal bars, ideal for long labels. CONDITIONAL FORMATTING LINE CHART – Displays trends over time with data points connected by lines. → A feature of Excel that enables user to highlight data using color or any other PIE CHART – Shows proportions of a formatting based on criteria specified. whole using pie slices. DOUGHNUT CHART – Like a pie chart but FILTER allows for multiple data series. AREA CHART – Emphasizes the → A feature of Excel that enables user to magnitude of change over time, with search and display only specific data in filled areas. the table. SCATTER CHART – Displays relationships between two variables as data points. SLICER → A feature of Excel that provides user a EQUAL SIGN (=) button to filter data. → The symbol for starting a formula. SORT SYMBOLS TO LOGICAL OPERATOR → A feature of Excel that enables user to + addition organize data in increasing to decreasing order. - subtraction * multiplication DATA VALIDATION / division = equal to → A feature of Excel that enables user to make sure data entered in a cell is  more than accurate.  less than = more than or equal to → can be used to organize data like !> not equal to categories, terms, and their meanings or numerical values. CHART → graphical representation of data that helps visualize trends, comparisons, and patterns in a dataset. GE ELEC 1: LIVING IN THE IT ERA