...Instructions Excel Exercise – 2 Note: Whenever you insert a text box in excel, it should contain a brief description of how you APROACHED THE PROBLEM, the STEPS YOU CARRIED OUT, THE TOOLS YOU USED and the CONCLUSION YOU REACHED (as mentioned in the instructions of this assignment). Q – 1: Follow the printing instructions as given in the workbook (Remember, you have access to a printer ) Q – 2: Follow the printing instructions as given in the workbook Q – 3: Print the Text Box only. Q – 4: Print the Text Box and the filtered Data Extra Credit Question: Print the Text Box only. Q – 5: Follow the printing instructions as given in the workbook Q – 6: Print the Text Box and your calculator’s final layout. Here the Text Box should contain the steps you followed in creating a fully functional button (7 – 8 Steps); you are NOT required to write the functionality of each button in the Text Box. Q – 7: Before printing this question, check the “Show Formula” button under the Formulas tab. Print the Text Box, Chart, Calculations Area Table and Equation of Straight Line Table. Q – 8: Follow the printing instructions as given in the workbook Q – 9: Take a print out of Text Box and 5 Charts only. Q – 10: Take a print out of your final word file named as MEMO_XXX, no need to insert or print Text Box for this question. Extra Credit Questions: Q # 1: Save your file as E2ECQ1_XXX. Print the Text Box and the Pie Chart only. Q # 2: Save your file as E2ECQ2_XXX. Print the 3 Charts only,...
Words: 358 - Pages: 2
...Question 5 Add, enter, or delete records in an Access database table by using the Select one: a. Relationship view b. Import view c. Design view d. Datasheet view Question 6 Field properties are shown in Select one: a. Design view b. Datasheet view c. Both Design and Datasheet views d. Neither Design nor Datasheet view Question 7 Given a single data series, what kind of chart visually indicates the relative size of each entry? Select one: a. line chart b. bar chart c. pie chart d. histogram chart Question 8 Given the function =VLOOKUP(C6,D12:F18,3) Select one: a. the entries in cells D12 through D18 are in ascending order b. the entries in cells D12 through D18 are in descending order c. the entries in cells F12 through F18 are in ascending order d. the entries in cells F12 through F18 are in descending order Question 9 Goal Seek is a feature in Excel, where Select one: a. The computer will search for a value that makes a certain cell's value equal to a specified value. b. The certain cell must contain a formula that uses the value Excel will be changing. c....
Words: 1789 - Pages: 8
...tool bar. * Choose ‘Chart’ and select ‘Bar’ diagram on the fourth option and click ok. * An excel sheet will open with dummy values. Insert the required values and close the excel sheet * The graph is ready with the values as shown above 2. Draw a component bar diagram for the following data released to the number of branches of a nationalized bank. Year | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | Rural | 50 | 125 | 200 | 225 | 240 | 240 | 250 | 260 | 280 | Semi Urban | 75 | 100 | 110 | 125 | 125 | 130 | 130 | 140 | 160 | Urban | 50 | 50 | 50 | 75 | 75 | 75 | 80 | 90 | 100 | Metropolitan | 75 | 75 | 75 | 80 | 80 | 100 | 115 | 125 | 135 | Steps * Go to word document and choose the ‘Insert’ option from the tool bar. * Choose ‘Chart’ and select ‘Column’ diagram and click ‘Clustered Column’. * An excel sheet will open with dummy values. Insert the required values and close the excel sheet * The graph is ready with the values as shown above. 3. The following represents data related to the distribution of advances to various sectors by a nationalized bank for the year 2008. Present this data in a pie diagram. Sector | Amount (Rs. In crores) | Priority Sector | 100.5 | Food | 58.75 | Non-Food | 16.84 | Others | 181.48 | Steps: * Go to word document and choose the ‘Insert’ option from the tool bar. * Choose ‘Chart’ and select ‘pie chart and click ok. * An excel sheet will open with dummy...
Words: 748 - Pages: 3
...Contents 1. Introduction 2 1.1 Background 2 1.2 Purpose 2 1.2.1 Project 2 1.2.2 Report 3 1.3 Scope 3 1.4 Methodology 4 2 Literature Review 4 2.1 My SQL 4 2.2 Business Process Management 14 2.3 Dashboard 20 2.4 Hyper Text Markup Language (HTML) 27 3 Problem Recognition 34 4 Feasible Study 35 4.1 Operational Feasibility 35 4.2 Economic Feasibility 35 4.3 Technical Feasibility 35 5 Analysis and User Requirements 36 6 Design 37 6.1 Website Design 37 6.2 Excel Design 37 7 Evaluation 38 7.1 Website 38 7.1.1 Website Strength 38 7.1.2 Website Weakness 38 7.2 Excel 39 7.2.1 Excel Strength 39 7.2.2 Excel Weakness 39 8 Recommendations 40 8.1 Recommendations for Website 40 8.2 Recommendations for Excel 40 9 Conclusion 41 10 Bibliography 42 11 Appendixs 44 1. Introduction 1.1 Background This report was written to document the work done for the Major Project entitled to Kate, Jack, Han Wei and Yao Seng in collaboration with Bedok North Secondary School (BNSS). BNSS strives to develop their students holistically through quality programs within a nurturing environments. BNSS place emphasis on their student’s character and citizenship education, inculcating sound values and building good character in their students. It is BNSS vision for their students to become leaders for the future, who are creative lifelong learners, morally upright, caring and loyal. Bedok North Secondary...
Words: 12424 - Pages: 50
...BCAP 106 – FINAL EXAM Student Name: __________________________________ Date:_________________________ EXERCISE 1 – MS Excel 40 Points You work at a small Orthopedics clinic as a Medical Assistant. Your manager wants you to take a day to do inventory of all medical supplies in the office. She would like to know the profit potential for their inventory based on the categories of inventory in Table 1. Table 1 contains the format of the desired report. The required formulas are shown in Table 2. Please create the table using MS Excel and incorporate the formulas requested in Table 1. Save the files as: “Your Name – Final Exam Exercise 1” Table 2 | | | FORMULAS | Formula A = Units on Hand * Average Unit Cost | Formula B = Average Unit Cost * (1 / (1-.58)) | Formula C = Units on Hand * Average Unit Price | Formula D = Total Value - Total Cost | Formula E = "SUM" of required cells | Formula F = AVERAGE function | Formula G = MIN function | Formula H = MAX function | EXERCISE 2 – MS Excel 20 Points Open the “Final Exam – Exercise 2” file. Bold, Center, Underline, and add color to the Headings in this document. Expand the cells so all of the information can be seen. Add Borders around all the cells containing information. Filter the data. Place all information in alphabetical order by Last Name. Save the file as “Your Name – Final Exam Exercise 2”. EXERCISE 3 – Test Questions 40 Points 1. The view in which all of the slides...
Words: 828 - Pages: 4
...The exercises below are to introduce concepts and features of a spreadsheet program such as Excel. Please note that there are alternative ways of creating a solution and your solution may be different from others. Single argument and user developed functions The table lists some functions that are commonly used in basic spreadsheet applications function | purpose | =sum(B12:B18) | Add contents of range in B12 to B18 | =average((B12:B18) | Average the range | =count((B12:B18) | Count non zero values | =max(B12:B18) | Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 | Exercise 1 Using appropriate formulae, complete the table below in Excel. Item Name | price | Commission | Camera | $150.00 | $ 15.00 | Omega | $120.00 | | Kodak | $130.00 | | Sony | $140.00 | | F | $95.00 | | Canon | $150.00 | | JVC | $210.00 | | Total | $845.00 | | | | | Commission Rate: | 10% | | Exercise 2 Complete the personal budget worksheet for the period indicated. Add your own figures where there are spaces. Extend the table to include a full calendar year. Personal Budget | | | | Monthly Expenses | Jan | Feb | Mar | Rent | $850.00...
Words: 2177 - Pages: 9
...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 whithin a single cell. Sparkline ...
Words: 423 - Pages: 2
...India: Largest in the world Question 1: Construct a bar, line, and histogram charts indicating demand of tractors from the data given in Table below. Demand for tractors in post years | Year | Demand (in thousands) | 1990-1991 | 139 | 1991-1992 | 148 | 1992-1993 | 148 | 1993-1994 | 138 | 1994-1995 | 163 | 1995-1996 | 202 | 1996-1997 | 245 | 1997-1998 | 278 | 1998-1999 | 273 | 1999-2000 | 280 | 2000-2001 | 286 | 2001-2002 | 250 | 2002-2003 | 215 | 2003-2004 | 215 | 2004-2005 | 220 | Answer: Bar Graph Line Chart Question 2: Construct a Pie chart of leading players from Table below. Answer: Leading Players in Market | | | share by hp (%) | Company | Total | 21-30 | 31-40 | 41-50 | Bajaj Tempo | 5.4 | 0.3 | 2.6 | 2.5 | Eicher | 29.6 | 24 | 5.6 | - | Escorts | 55.1 | 11.4 | 9.2 | 34.5 | MGTL | 3.6 | 1.7 | 0.9 | 1 | HMT | 7 | 2 | 4.2 | 0.8 | M&M | 89 | 32.6 | 27.1 | 29.3 | PTL | 29.1 | 10.5 | 18.6 | - | TAFE | 38.1 | 7.3 | 21.7 | 9.1 | LTJD | 10.2 | - | 0.6 | 9.6 | Int Wac | 32.9 | 10.2 | 9.5 | 13.2 | Pie Chart Question 3: Construct a pie chart of product variation from table below: Answer: Product Variations in terms of horse power | Type (hp) | Share (%) | Upto 20 hp | 0.3 | 21-30 hp | 21 | 31-40 hp | 56 | 41-50 hp | 14 | > 50 hp | 7 | Pie Chart Question 4: Construct a bar, histogram and pie chart of market segmentation from table below: Answer: Market Segmention on the basis...
Words: 1286 - Pages: 6
... a) T F If kurtosis is > 1, then the data must be exponential. b) T F The Interquartile Range (IQR) is Q3-Q1. c) T F There is no built-in Excel function for the range of a data set. d) T F Outliers have to be outside both the 6-sigma and Tukey limits. e) T F Pivot Tables are limited to a maximum of 10 rows and 10 columns. f) T F Frequency graphs can determine the mode, Box & Whiskers does not. g) T F The birth data from the Anaheim Ducks and Los Angeles Kings proved Outliers was correct. h) T F For the Hypergeometric distribution the value of p changes each time an object is selected. i) T F Heights of adult males is a good example of the Poisson distribution. j) T F When children give their age, it’s continuous; for adults it’s integer. k) T F If a LUMAT template cell is colored, you can enter data or labels. l) T F The Box and Whiskers template gives indicators of data being normal, uniform or exponential. m) T F Goodness of Fit templates use the Chi-square distribution to give the probability of a fit. n) LUMAT stands for: Learning to Use Managerial Analysis Templates. o) The name of our Excel Training program is ExcelEverest. p) If the pieces of a pie chart in Excel add up to only...
Words: 1158 - Pages: 5
...Section A. A1. There are two types of statistics that are often referred to when making a statistical decision or working on a statistical problem. Descriptive statistics utilize numerical and graphical methods to look for patterns in data set, to summarize the information revealed in a data set and to present information in a convenient form that individuals can use to make decisions (Singpurwalla, 2013).Descriptive statistics main goal is to describe a data set, hence the class of descriptive statistics include both numerical measures and graphical displays of data. Inferential statistics utilizes sample data to make estimates, decisions, predictions, or other generalizations about a larger set of data (Singpurwalla, 2013).The main goal of inferential statistics is to make a conclusion about a population based off a sample of data from the population. A2. The population is the whole set of values, or individuals, that the information collector is interested in. The sample is a subset of the population, and is the set of values that are actually use in estimation. For example, if a person wants to know the average height of the residents of India, that will be the population, i.e., the population of India. As India population is quite large a number, and we wouldn't be able to get data for everyone there. So the collector draw a sample, to get some observations, or the height of some of the people in India (a subset of the population, the sample) and do the inference...
Words: 959 - Pages: 4
...Using Engagor, Excel and SPSS Statistical 22, we analyzed the e-business process support of Caterpillar on three social media platforms: Facebook, Twitter and LinkedIn. Next pie chart shows how much firm generated content had been analyzed, setting up a certain time frame. In the following, both quantitative and qualitative insights are provided. Number of analyzed firm generated content Processes supported on social media In order to give a brief overview of the business processes supported by Caterpillar on several social media platforms, we used SPSS Statistics 22. The following pie charts and frequency tables result from our statistical deceptive analysis. Facebook - Caterpillar Inc. Looking at the pie chart and the frequency table of the Facebook page ‘Caterpillar Inc.’, we can conclude that the overall presence of Trade Processes (Authentication, Customer Service and Search) is rather obvious. With 66.7% of the business processes, content regarding Authentication Processes are most likely to be generated by Caterpillar on this social media platform. The fact that this page is the main Facebook page of this company can be a logical explanation for its Trade Process focused nature. Since these processes are rather customer oriented, it is wise to reach their customers via their established brand name and the most well-known social media platform. Furthermore, we also recognize a small amount of Decision Support Processes. In light of the previous explanation...
Words: 919 - Pages: 4
...FOP Programming The commands from A to Z ______________________________________________________________________________________ Contents FOP Programming (1) Commands from A to Z .ACTION - Transaction .ACTION ABORT .ADD – Loading an additional record .ASSIGN – Assignment of values .ATEXT – Select abbreviation text .BOX – Multi-line messages .BROWSER – Internet browser .BUDGET – Summation of accounts .CHART – Displaying charts Options of .CHART –INIT, always in one line .COLOUR – Setting colors in screens .COMMAND – Running abas ERP commands .COMMAND - PARALLEL .COMMAND -WAIT .COMMAND -WINDOW .COMMAND -LOADER Command syntax if abas ERP commands .CONTINUE – Return to the called FOP .CONTINUE LABEL .COPY – Copying from database buffers Constant texts and .COPY Creating type conversions .CURSOR – Cursor control .DDE - Command .DELETE – Deleting records .DOWN - Footers .EDIT – System calls .END - FOP end .ERROR – Error message .FILE – File input .FORMAT – HTML output .FORMAT XML – XML generation .FORMULA – Assigning values to variables .HELP – Help chapter .INPUT – FOP program .JUSTIFIED – Text formatting .LEFT – Left margin .LENGTH – Page length .LINE – Line length .LOAD – Loading contents ©ABAS Software AG 2005 4 4 6 7 8 9 11 13 13 15 15 28 32 32 34 35 37 38 39 39 40 41 42 42 44 47 47 48 49 50 51 56 57 57 58 59 62 62 63 63 64 Page 1 February 2006/2006r2n01 Know how using abas Business Software FOP Programming The commands from A to Z ____________________________...
Words: 31215 - Pages: 125
...summarizing data. Furthermore, you were shown how crosstabulations and scatter diagrams can be used to summarize data for two variables simultaneously. The terms that you should have learned from this chapter include: A. Qualitative Data: Data that are measured by either nominal or ordinal scales of measurement. Each value serves as a name or label for identifying an item. B. Quantitative Data: Data that are measured by interval or ratio scales of measurement. Quantitative data are numerical values on which mathematical operations can be performed. C. Bar Graph: A graphical method of presenting qualitative data that have been summarized in a frequency distribution or a relative frequency distribution. D. Pie Chart: A graphical device for presenting qualitative data by subdividing a circle into sectors that correspond to the relative frequency of each class. 23 24 Chapter Two E. Frequency Distribution: A tabular presentation of data, which shows the frequency of the appearance of data elements in several nonoverlapping classes. The purpose of the frequency distribution is to organize masses of data elements into smaller and more manageable groups. The frequency distribution can present both qualitative and quantitative data. F. Relative Frequency Distribution: A tabular...
Words: 6692 - Pages: 27
...CHAPTER 2—DESCRIPTIVE STATISTICS: TABULAR AND GRAPHICAL DISPLAYS MULTIPLE CHOICE 1. The minimum number of variables represented in a bar chart is a.|1| b.|2| c.|3| d.|4| ANS: A PTS: 1 2. The minimum number of variables represented in a histogram is a.|1| b.|2| c.|3| d.|4| ANS: A PTS: 1 3. Which of the following graphical methods is most appropriate for categorical data? a.|ogive| b.|pie chart| c.|histogram| d.|scatter diagram| ANS: B PTS: 1 4. In a stem-and-leaf display, a.|a single digit is used to define each stem, and a single digit is used to define each leaf| b.|a single digit is used to define each stem, and one or more digits are used to define each leaf| c.|one or more digits are used to define each stem, and a single digit is used to define each leaf| d.|one or more digits are used to define each stem, and one or more digits are used to define each leaf| ANS: C PTS: 1 5. A graphical method that can be used to show both the rank order and shape of a data set simultaneously is a a.|relative frequency distribution| b.|pie chart| c.|stem-and-leaf display| d.|pivot table| ANS: C PTS: 1 6. The proper way to construct a stem-and-leaf display for the data set {62, 67, 68, 73, 73, 79, 91, 94, 95, 97} is to a.|exclude a stem labeled ‘8’| b.|include a stem labeled ‘8’ and enter no leaves on the stem| c.|include a stem labeled ‘(8)’ and enter no leaves on the stem| d.|include a stem labeled ‘8’ and enter...
Words: 6861 - Pages: 28
...Grade 8 Second Term Pre-Exam Exercise A Multiple-choice Questions Choose the best options and write down the letter corresponding to the option A, B, C, D given in the questions in the appropriate box. 1. What kind of software does Excel belongs to? A. Spreadsheet C. Web design and authoring tool B. Word processing D. Database 2. is a series of ordered commands. A. Program C. Code B. Software D. Process 3. is a process of finding and reducing the number of defects in a computer program. A. Coding C. Encoding B. Programming D. Debugging 4. Programs process data depending on the of the data. A. value C. type B. number D. name 5. are the labels on the computer's memory. A. Numbers C. Values B. Variables D. Codes 6. A computer game is a program in which one or more players make decisions through the control of game objects and resources, in pursuit of a goal. A. software C. assembly B. hardware D. debugging 7. Which of the following is NOT the three main parts to a Game Maker? A. Sprites C. Buttons B. Rooms D. Objects 8. In Game Maker, describe when actions are to be performed. A. Actions C. Classes B. Events D. Objects 9. In Game Maker, are what to do when an event occurs. A. Actions C. Classes B. Events D. Objects 10. Business-to-Consumer (B2C)...
Words: 1087 - Pages: 5
