Study Guides (247,995)

# Module II (Ruhi).docx

2 Pages
134 Views

School
Department
Course
Professor
Craig Kuziemsky
Semester
Winter

Description
Range: a rectangular group of cells in a worksheet Precedence: a set of pre-defined rules used to determine the sequence in which operators are applied in calculation. Absolute cell references: cell addresses that stay fixed and are not adjusted as a formula is copied.  =Average (Num1,num2) Excel sums the values in the range and then divides by the number of non- blank cells in the range.  =CountIF (range, criteria)  FV(rate, nper,pmt,pv,type) Condition functions: result may be a specified value or a calculated value E.g. IF, COUNTIF, SUMIF, AVERAGEIF, COUNTIFS,SUMIFS,AVERAGEIFS. Nested if: when one IF function is placed inside another IF function to test an addition condition. Number of IF function in total would be one less than the number of possible outputs. Dashboards: quick distilled snapshots, highlighting the key includes, for instant decision making. Operational Dashboards: for monitors operations in real-time What-If Analysis: the study of how the uncertainty in the output of a model can be attributed to different sources of uncertainty in the model inputs. Using a spreadsheet, what-if analysis involves changing the values in cells to see how these changes will affect the outcome of formulas on the worksheet What if analysis tools in excel include: Scenarios, Goal seek, Data Tables Example of an absolute cell reference: \$G\$5 What are the advantages of using an Excel Table instead of a simple range of columns and rows (flat table)?  Excel Tables provide easier sorting and filtering  Excel Tables facilitate instant formatting and presentation What is NOT an example of what-if analysis: Solver  Solver is a separate program that must be installed or added in to Excel  Once added, it appears in the Analysis group on the Data tab as shown in Figure Solver Example: Optimal Product Mix  an add-in program that searches for the best solution to a problem with several variables Requires thre
More Less

Me

OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.