Ù
What is Microsoft Excel?
Microsoft Excel is developed by Microsoft for windows, macOS, Android, and iOS. It uses a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations such as arithmetic operations, as do all spreadsheets. It comes with many built-in functions to address statistical, engineering, and financial requirement. furthermore, it can display data in the form of graphs, histograms, and charts, as well as a very; limited three-dimensional graphical display.
Organizations Use Microsoft Excel For the Followings:-
᥈ Data Entry and Storage.
᥈ Office Administration.
᥈ Account Management.
᥈ Performance Reporting.
᥈ Data Analysis.
᥈ Business Analysis Etc.
Excel Terminology & Components:-
Excel uses its own terminology and components, which beginners may not understand instantly. Among these terms and components are the following
೦ Cell - A user enters information into a cell, which is formed by the intersection of a column and a row.
Reference to a cell. This is the set of coordinates at which a cell can be found. Rows are horizontal and numbered, while columns are vertical and lettered.
೦ The cell that is active - The currently selected cell is denoted by a green box.
೦ Workbook - This is an Excel file with one or more worksheets.
೦ Worksheet - These are the various documents contained within a Workbook.
೦ The Worksheet tab - These are the tabs on the spreadsheet's bottom left.
೦ Headings for columns and rows - These are the cells with numbers and letters that are located just outside of the columns and rows When you select a header, the entire row or column is highlighted.
೦ Formula - Formulas are mathematical equations, cell references, or functions that can be used to generate a value when placed inside a cell. Formulas must begin with an equal sign "=".
೦ The formula bar - This is the long input bar for entering values or formulas into cells. It's near the top of the worksheet, right next to the "fx" label.
೦ The address bar - The number and letter coordinates of an active cell is displayed in this bar, which is located to the left of the formula bar.
೦ Filter - These are the rules that a user can use to determine which rows of a worksheet to display. This option can be found in the top right corner of the home bar under "Sort & Filter." To display rows that match, an auto filter option can be selected.
೦ AutoFill - This feature allows users to automatically copy data to multiple cells. A user can select two or more cells in a series and drag the bottom right corner down to autofill the remaining cells.
೦ AutoSum - Users can use this feature to enter multiple values. Users can add cells by selecting them and pressing the Alt and Equal keys. On the top right of the home page, above "Fill" and to the left of "Sort & Filter," there is also a button to enable this feature.
೦ PivotTable - This data summarization tool automatically sorts and calculates data. This can be found on the far left under the insert tab.
೦ PivotChart - This chart serves as a visual supplement to the Pivot Table.
೦ Source data - This is the data that is used to generate a Pivot Table.
Excel Unique Technologies
Excel's more advanced tools include the following:
೦ TREND function - This tool generates linear trend lines from a set of X or Y values. It can be used to analyze time series trends or to project future trends. On charts, trendlines can be used.
೦ VLOOKUP - The VLOOKUP function can be used to search for values in a larger data set and pull that data into a new table. VLOOKUP is a cell input command whose syntax is =VLOOKUP (). The data the user wants to look up, where to look for it, the column number with the value to return, and an Approximate or Exact match indicated by True or False are all enclosed in parentheses.
೦ Tables Array - This is a combination of two or more tables having connected and related data and values. This pertains to VLOOKUP.
೦ Col_index_num - Another value when creating a table array that specifies the column from where data is being pulled.
೦ Range lookup - When none of the other variables match, this value in VLOOKUP gives results that are the closest to what a user is looking for. Whether it is true or false is used to describe this. False returns the precise value that the user is seeking, but True returns result from a variable data range.
೦ MIN and MAX operations - The maximum and minimum values from particular data sets are provided by these functions. In a function tab, MAX is used to find the highest value, while MIN is used to discover the lowest value.
೦ AND function - When looking for variables, this function has multiple criteria in place. A variable's value will be returned as true if it meets the requirements; otherwise, it will be returned as false. The function's input must resemble this: =AND (logical1, [logical2], ...).
0 Comments