quiz02-Reviewer.docx

Spreadsheet software- is commonly used across all areas of business and is standard om nearly every employee computer. two type of Cell Referencing: Relative references - change when a formula is copied to another cell. Absolute References - remain constant no matter where they are copied. Mixed...

Spreadsheet software- is commonly used across all areas of business and is standard om nearly every employee computer. two type of Cell Referencing: Relative references - change when a formula is copied to another cell. Absolute References - remain constant no matter where they are copied. Mixed Reference -- need a combination of relative and absolute reference (Mixed Reference) Function -- predefined formula that perform calculations using values in a particular order. Function must be written in a specific way called **syntax** Basic syntax for a function is the **equals sign** **Function name (**ex. Sum, Ave**)** **Arguments -** Contain the information you want to calculate. **AutoSum --** Allows you to automatically insert the most common function into your formula.  **CountIF -** count cells based on one criteria.  **IF -** checks whether a condition is met, and returns one value of true and another value is false. **VLOOKUP -** looks for value in the leftmost column of the table and return a value in the same row from another column you specify. **HLOOKUP -**In a similar way, you can use the HLOOKUP (Horizontal lookup) function. **MATCH -** The MATCH function returns the position of a value in a given range. **Index -**The INDEX function below returns a specific value in a two-dimensional range. **CHOOSE -** The CHOOSE function returns a value from a list of values, based on a position number. **Excel Pivot tables** - is a great feature available in Excel that lets us summarize data in the spreadsheet. Using this, you can reorganize, sort, count, total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table what is the called "**pivot table"** **What-If analysis -** is the process of calculating backward to find out an input by providing a specific output. What- analysis tools **-- "Data Tables" "Scenario Manager" "Goal Seek"** **Scenario** is a set of values that Excel saves and can substitute automatically in cells on a worksheet. A scenario can have multiple variables, but it can accommodate only up to **32 values.** You can also create **a scenario summary report**, which combines all the scenarios on one worksheet**.** **Scenario Manager** is a dialog box that allows you to save the values as a scenario and name the scenario. **Goal Seek** requires a formula that uses the input value to give result in the target value. **Data Table** is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. **one-variable Data Table** can be used if you want to see how different values of one variable in one or more formulas will change the results of those formulas. **two-variable Data Table** can be used if you want to see how different values of two variables in a formula will change the results of that formula.