Premium Essay

Mt Excel Gfwuihvl

In: Other Topics

Submitted By mojojojo1
Words 607
Pages 3
Instructions- 1. There are 2 deliverables for this assignment- a) An excel file with the necessary computations. b) A word doc with the corresponding explanations. (For the question involving macro, a separate file could be submitted. However, a single excel file is preferred). 2. Solve each question in a separate sheet in one excel file. 3. You’re required to state all your assumptions in the first sheet of the excel file. These assumptions should be written for all the sub-parts separately, however in the same sheet, wherever applicable. 4. Maintain uniformity in structure and formatting. The assignment would be penalized for lack of hygiene. 5. Name all your sheets appropriately. 6. Naming Convention for the file Name_Roll_No_Section.doc/.xls. Example- Hermione_Granger_91023_G.xls
Assignment-
i) Use column V to create a new character variable of length 10- ABCDEFGHIJ where AB=Region, CD=Province, E=Product Category, FG=Customer Segment, H=Ship Mode, I=Order Priority, J=Product Container. (You’re free to use your own nomenclature. Specify the same in the assumptions sheet. Eg- Use initial 1(or 2) characters of the corresponding variable.) ii) Summarize the data using a pivot table by region and province. Subsequently, find the province with highest profit per shipment and highest profit per Unit. iii) Create a pivot table where you provide a summary of sales, cost and profit statistics. How will you summarize? State the variables used as row labels, column labels and filters. Justify your selections. Do you think it would make sense to use some of the statistics variables in percentage terms? If yes, create those variables in the pivot table. (Note: The new variables are to be created in the pivot table itself. You’re not supposed to create the variable in the raw dataset and then using it in the pivot table). iv) Find…...

Similar Documents

Free Essay

Digi Excel

...EXCEL DIGI LAB Hemant Yashwant Satpute Electronic Science Department, Fergusson College, Pune 4 [Affiliated to University of Pune] India (Maharashtra) hys0671@rediffmail.com Abstract Being a teacher, my aim is to always encourage students and other colleague teachers to make optimum use of PC machine which one has purchased and full functionality of the softwares available with that machine. As an example, here I am illustrating use of EXCEL to learn Digital Electronics. One can verify Truth tables and study the working of various logic gates (AND, OR, NOT, EXOR, EXNOR, NAND, NOR), Various combinational logic circuits like Half Adder, Full Adder, Controlled Inverter, Multi bit adder, Multi bit subtractor, Multi bit adder Subtractor, Multiplexers, Demultiplexers, Shift Registers, Flip flops, Counters, Parity Generators and checkers using EXOR gates, Encoders, Decoders, Controlled Inverter using EXOR gates and their uses and many more, by entering inputs directly and verifying outputs at various intermediate stages. One can also study use of universal gates to build various logic functions with the help of this tool. These outputs are derived by using various functions built in EXCEL. This was demonstrated to teachers and students. This idea helps teachers to make subject more illustrative and interesting. It has been proved to be an excellent tool for innovative class room teaching. This can be used as a learning material for open source learning and......

Words: 2004 - Pages: 9

Premium Essay

Excel Project

...where we have the highest market share. We identified the sales rep and have commended her for the job well done, promoting her to Regional Sales Manager. Graphic Recommendation The Regional Sales Manager will work closely with our Global HR Director, leveraging her extensive years of experience to identify training needs across our organization. The scope is to improve our sales tactics by implementing initiatives to increase customer satisfaction, for both existing customers and for new ones. One immediate decision is to incorporate account managers to assist in our customer support centers, due to both constant complaints from our customer and also feedback obtained by our top sales rep. SELF ASSESSMENT From completing the Excel project, I learned … * How to manipulate Pivot Tables to obtain a specific data set. * Incorporate a Chart, choosing the type of values to show (percentages, numbers) * Apply formatting to a table...

Words: 489 - Pages: 2

Premium Essay

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

Free Essay

Excel

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

Premium Essay

Mt. Rundle

...Mt. Rundle Mt. Rundle is a hotel found in a popular tourist city in Canada. This particular hotel is rather small with a little over sixty rooms. Price was it is on the higher side of hotels and is listed as a boutique hotel. All of the rooms in Mt. Rundle are different as far as accommodations and design which could be considered as adding to the hotel’s character. Because there are numerous sources of accommodation and places to stay in this tourist city, Mt. Rundle does not have a monopoly on living spaces. This also means that there will always be other places for tourists to stay if the hotel receives poor reviews. Steve Mckenzie is a disgruntled tourist who stayed at Mt. Rundle. He had been planning a three week vacation in Canada with his wife who is very busy as well so the vacation meant a lot to him, so one can only expect that he wanted everything to be well done with such planning. They were staying at a number of hotels with Mt. Rundle being one of them. Their stay was less than perfect but it was more of the handling of the money that pushed him over the edge. His room was above the kitchen, which led to a variety of cooking aromas seeping into their room. He also complained that the cleaning staff would stock the room improperly if at all. The customer service as a whole seemed inept because calling the front desk for soap did not work so he had to go down to the storage room himself to get it for him. The real issue began over four months after...

Words: 487 - Pages: 2

Free Essay

Excel Financiero

...Excel Financiero 2010 Funciones para Amortizaciones Técnicas Objetivos de la Unidad Al finalizar la presente unidad el participante será capaz de: a) Usar las funciones de Excel para el cálculo depreciaciones. b) Diferenciar los diferentes métodos de amortización, para depreciaciones. c) Identificar las fórmulas de Excel correspondientes a un método y otro. 1 Unidad 2 Excel Financiero 2010 Se define como amortización económica o técnicas proceso de la depreciación de un bien. Las causas de la depreciación son: Depreciación física, ocasionada por el paso del tiempo, aunque el bien no sea utilizado en ninguna actividad productiva. Depreciación funcional, causada por el uso del bien. Depreciación económica, generalmente motivada por avances e innovaciones tecnológicas que hacen que el bien se vuelva ineficiente u obsoleto para el proceso productivo. Existen variados métodos para el cálculo de la depreciación, de los activos inmovilizados (cuotas fijas, crecientes, decrecientes,...). Lingüísticamente la palabra depreciación es más apropiada para definir la pérdida de valor de los activos materiales (también llamados bienes). Sin embargo, el lenguaje contable de algunos países utiliza la expresión amortización. A. Función = AMORTIZ.LIN(costo;fecha_compra;primer_período;costo_residual;período;tasa;base) =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) Devuelve la amortización lineal de un bien al final de un ejercicio fiscal......

Words: 1849 - Pages: 8

Premium Essay

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Premium Essay

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Free Essay

Microsoft Excel

...↑ up Arrow ফা ↓ down Arrow তত রিক করয অ঩নায ঩ড়ায ঳ু রফধা ঄নু ঳ারয স্ক্রর স্পীড রিক করয রনন। Microsoft Excel ঴রে একরি Spreadsheet তরাগ্রাভ। আ঴া Microsoft Office এয একরি ঄ং঱। এরি একরি Worksheet Analysis তরাগ্রাভ঑। ভূ রতঃ এরেররয ঳া঴ারমে ডািা এরি এফং ঄োনারাআর঳঳ উবয় ঳ু রফধা ঩া঑য়া মায়। অভারদয ঩যীক্ষায Marksheet এয ঳ারথ অভযা ঳ফাআ ঩রযরচত। Spreadsheet ঴রে ভাকক঱ীরিয ভত এক ধযরণয ছক। Microsoft Word খুররর তমভন কা঳কয঳঴ একরি ঳াদা ঩াতা ঩া঑য়া মায় এফং কী-তফাডক তথরক ররখরত শুরু কযরর ঳াদা ঩াতায় তরখা শুরু ঴য়। ততভরন Excel খুররর ঳াদা ঩াতায ঩রযফরতক তিরফররয ভত একরি ছক ঩া঑য়া মায় এফং ররতরি ঘরয করয়করি ঄ক্ষয তরখা মায়। এছাড়া এরি ভাকক঱ীরিয ভত করাভ (Column) এফং ঳ারযরত (Row) রফবক্ত থারক। A, B, C, D এবারফ করারভয নাভকযণ কযা থারক এফং 1, 2, 3, 4 এবারফ ঳ারযয নাভকযণ কযা থারক। এআ ঳ভস্ত ঘরয ঄ফরিত গারণরতক ঳ংখোরক উ঩য, রনচ, ডান ফা ফাভ, তম তকান রদক তথরক তমাগ, রফরয়াগ, গুণ, বাগ আতোরদ কযা মায়। ঳াধাযণত তমাগ, রফরয়াগ, গুণ, বাগ আতোরদ঳঴ জরির গারণরতক ঳ভ঳োয ঳ভাধান, ডািায উ঩য রবরি করয রফরবন্ন ধযরণয গ্রাপ ততযী, ডািারক ঳াজারনা঳঴ রফরবন্ন ধযরণয ডািা ভোরনজরভন্ট, ঩রয঳ংখোরনয রফরবন্ন কাজ Excel রদরয় কযা ঴য়। ঄োকাা্ন্টর঳য রফরবন্ন কাজ, তমভন- তরজায, রাব ক্ষরত র঴঳াফ, Balance Sheet আতোরদ কাজ঑ Excel রদরয় কযা ঴রয় থারক। এজনে Microsoft Excel তক Accounting Package ProgramI ফরা ঴য়। facebook /gmail/skype: - http://tanbircox.blogspot.com Want more Updates  http://facebook.com/tanbir.ebooks রনরচয উদা঴যণ রক্ষে করুন। Excel ফেফ঴ায করয একরি ডািারফজ এফং ঳ংরিষ্ট চািক তদ঑য়া অরছ। ঳঴জবারফ তফাঝারনায জনে একরি ররতষ্ঠারনয PC, Disk এফং......

Words: 4815 - Pages: 20

Premium Essay

Excel

...P rate and y = T P rate. Possible values range from (0, 0) to (1, 1). The “classification” that assigns “Test Negative” to every score has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability:......

Words: 4475 - Pages: 18

Premium Essay

Mt. Aso

...the walls of the gardens, it seems as if life is on hold, as if time has been paused to allow the traveler more time to explore the unbelievable beauty of the gardens. You won’t believe the amount of gardens that are in Japan. Trust me they don’t even let a rose petal fall to the floor. But overall, my journey was just full of color and filled with life. Mount Aso is the largest active volcano in Japan, and is among the largest in the world. It stands in Aso Kujū National Park in Kumamoto Prefecture, on the island of Kyushu. Its peak is 1592 m above sea level. Mt. Aso has a fairly large caldera (25 km north-south and 18 km east-west) with a circumference of around 120 km (75 mi). The central cone group of Aso consists of five peaks: Mt. Neko, Mt. Taka, Mt. Naka (also called Nakadake or Naka-Dake), Mt. Eboshi, and Mt. Kishima. The highest point is the summit of Mt. Taka, at 1592 m above sea level. The crater of Mt. Naka, the west side of which is accessible by road, contains an active volcano which continuously emits smoke and has occasional eruptions. The 24-km-wide Aso caldera was formed during four major explosive eruptions from 300,000 to 90,000 years ago. These produced voluminous pyroclastic flows that covered much of Kyushu. The last of these, the Aso-4 eruption, produced more than 600 cu km of airfall tephra and pyroclastic-flow deposits. A group of 17 central cones was constructed in the middle of the caldera, one of which, Naka-dake, is one of Japan's most active......

Words: 1194 - Pages: 5

Premium Essay

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

Premium Essay

Excel

...Operator: <= / Constraint entry: d9*32% 3. Laser Imaging machines (D7) should be greater than or equal to 28% of the total machines produced (d9*28%); also enter a constraint for less than or equal to 32% (d9*32%) 4. Magnes machines (D8) should be greater than or equal to 38% of the total machines produced (d9*38%); also enter a constraint for less than or equal to 42% 5. Number to make (D6:D8) must be whole units (use int) Verify that all parameters have been entered (set objective, changing cells and constraints), Solve and create an Answer Report. Resave your practice exam. This will still be a macro-enabled file. If you want feedback on your practice exam, please upload your file to Oncourse / Assignment 2 / Excel Case Practice link. On test day you will submit your completed exam to the Oncourse Assignment2 link....

Words: 1218 - Pages: 5

Premium Essay

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2

Premium Essay

Microsoft Excel

...Using Microsoft Excel Getting Started Using Microsoft Excel About Excel What is a Spreadsheet? Microsoft Excel is a program that’s used for creating spreadsheets. So what is a spreadsheet? Before personal computers were common, “spreadsheet” referred to large sheets of lined paper, which were used by people in various businesses to record facts and figures in rows and columns, and then make calculations based on the information. When personal computers first began appearing, one of the first applications was a program released in 1979 called VisiCalc. It was used as a tool for performing spreadsheet style calculations that would have been to difficult to do on a calculator. The program quickly became so popular that people began buying personal computers for their businesses just so they could use VisiCalc. VisiCalc Since then, many other spreadsheet programs have been popular over the years, such as Quattro Pro and Lotus 123. Microsoft Excel was first released in 1985 with newer versions being released every couple of years. The most recent version is Excel 2003 (version 11). © Stephen O’Neil 2005 Page 1 Of 17 www.oneil.com.au/pc Using Microsoft Excel Getting Started How Do Spreadsheets Work? Computer spreadsheets are based on their old paper formats. A spreadsheet on a computer uses rows and columns to record information such as text and numbers, such as the example below. Graduates from University 1996 1997 1998 1999 2000 2001......

Words: 4397 - Pages: 18