Study Guides (247,995)
Canada (121,213)
Administration (1,201)
ADM1370 (78)

Module II (Ruhi).docx

2 Pages
134 Views
Unlock Document

Department
Administration
Course
ADM1370
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

Related notes for ADM1370

Log In


OR

Join OneClass

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

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit