Question

In: Math

Answer the following question What are some of the advanced features for modeling available in Excel?...

Answer the following question

What are some of the advanced features for modeling available in Excel? Based on what many of you have already seen of Excel in CS105, are you surprised that Excel has so many capabilities? Do you use Excel for anything other than school work today?  

Solutions

Expert Solution

Excel 2013 has powerful data analysis features. You can build a data model, then create amazing interactive reports using Power View. You can also make use of the Microsoft Business Intelligence features and capabilities in Excel, Pivot Tables, Power Pivot, and Power View.

Data model  is used for building a model where data from various sources can be combined by creating relationships among the data sources. A Data Model integrates the tables, enabling extensive analysis using Pivot Tables, Power Pivot, and Power View.

A data model  is created automatically when you import two or more tables simultaneously from a database. The existing database relationships between those tables is used to create the Data Model in Excel.

Step 1 − Open a new blank Workbook in Excel.

Step 2 − Click on the DATA tab.

Step 3 − In the Get External Data group, click on the option From Access. The Select Data Source dialog box opens.

Step 4 − Select  Database file.

Step 5 − The Select Table window, displaying all the tables found in the database, appears.

Step 6 − Tables in a database are similar to the tables in Excel. Check the ‘Enable selection of multiple tables’ box, and select all the tables. Then click OK.

Step 7 − The Import Data window appears. Select the Pivot Table Report option. This option imports the tables into Excel and prepares a Pivot Table for analyzing the imported tables. Notice that the checkbox at the bottom of the window - ‘Add this data to the Data Model’ is selected and disabled.

Step 8 − The data is imported, and a pivot table  is created using the imported tables.

You have imported the data into Excel and the data model is created automatically. Now, you can explore data in the five tables, which have relationships defined among them.

it is suprising to see that excel has so many applications but the fact is excel is now the solution to all modern problems in modelling field specially in visualisation and analysis.

off course i use excel for more than school work .it has got uses in other sectors and fields also few are given below

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

It can be programmed to pull in data from external sources such as stock market feeds, automatically running the data through formula such as financial models to update such information in real time. Like Microsoft Word, Excel has become a de facto standard in the business world, with Excel spreadsheets frequently emailed and otherwise shared to exchange data and perform various calculations.

Excel also contains fairly powerful programming capabilities for those who wish to use them that can be used to develop relatively sophisticated financial and scientific computation capabilities.


Related Solutions

You are a student who is new to the more advanced features of Excel. You have...
You are a student who is new to the more advanced features of Excel. You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option? Convert the range to a PivotChart. You are wrong; the range has as many features as any Excel alternative. Convert the range to a...
answer each question separately. How is behavioral modeling related to functional and structural modeling? How do...
answer each question separately. How is behavioral modeling related to functional and structural modeling? How do functional, structural, and behavioral models work together to describe a whole system? Think about an ATM and its functionality. If you were creating a functional model for an ATM, what would be the use cases for that system? Note: You do not need to create a functional model or diagram. You may just describe the use cases. Based on the use cases you described,...
answer the following question 1 what are the six homes Health PPS means features 2 describe...
answer the following question 1 what are the six homes Health PPS means features 2 describe the element of community benefit listed by the key policy groups 3 what are basic method of payment for healthcare firms 4 what are the general factors that will influence price in regard of Market structures 5what are the key element to be successful a major philanthropic program 7 what are the five Keys characteristics offer long-term debit financing
Cell Biology Short Answer Question: Describe some typical features of a restriction enzyme recognition sequence and...
Cell Biology Short Answer Question: Describe some typical features of a restriction enzyme recognition sequence and how blunt and staggered cuts are made.
Answer the following. Justify your answer. a) What are the 4 features of perfect competition? Using...
Answer the following. Justify your answer. a) What are the 4 features of perfect competition? Using these features, is the market for table salt perfect competition (or close to perfect competition)? Explain each point. b) What 4 outcomes will a binding minimum wage have, and what 1 outcome has 2 possibilities. c) Describe economies of scope and economies of experience. Use a house builder as an example. d) When is a perfectly competitive firm in the short run? What 3...
Problem 10-16 (Some Useful Excel Functions for Modeling) The Camera Shop sells two popular models of...
Problem 10-16 (Some Useful Excel Functions for Modeling) The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 200, Camera B Price: 300). The sales of these products are not independent of each other, but rather if the price of one increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue from these products. A study of...
Prepare the answer to the following question by either entering text directly or uploading an Excel...
Prepare the answer to the following question by either entering text directly or uploading an Excel or Word file. Do NOT upload a .pdf or .jpg file or you will receive zero credit. Show computations. The prepaid insurance account has an unadjusted balance of $46,000 at December 31, 2018, the end of Hanson Company's accounting year. Insurance expense has an unadjusted $2,000 balance at the same point in time. Some policies that were in effect have expired. Some of those...
Prepare the answer to the following question by either entering text directly or uploading an Excel...
Prepare the answer to the following question by either entering text directly or uploading an Excel or Word file. Do NOT upload a .pdf or .jpg file or you will receive zero credit. Show computations. The prepaid insurance account has an unadjusted balance of $46,000 at December 31, 2018, the end of Hanson Company's accounting year. Insurance expense has an unadjusted $2,000 balance at the same point in time. Some policies that were in effect have expired. Some of those...
Plot the following parabolic functions in Excel and then answer the discussion question below . Use...
Plot the following parabolic functions in Excel and then answer the discussion question below . Use at least 8 points for each plot: Each graph is worth 15 points and must include 8 points. 1) y=x2-6x+8 2) y=x2+4 3) y=(-1/2)(x2) 4) What is the maximum number and the minimum number of x-intercepts for a parabola? Why? (15 points) In order to obtain full credit, you will need to plot the functions in Excel or using the Open Office feature and...
Use Excel to answer the following question: The capital fund for research project investment at a...
Use Excel to answer the following question: The capital fund for research project investment at a corporation is limited to $100,000 for next year. The company uses an MARR of 15% per year. There are three independent project proposals (i.e., none, one or more can be selected) with pertinent information given in the below table. Project Initial Investment ($) Annual Net Cash Flow ($/year) Life (years) Salvage Value ($) A -25,000 6,000 4 4,000 B -30,000 9,000 4 -1,000 C...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT