Computer Engineering Midterm | CEN 4214 - Software-Hardware Codesign, Quizzes of Computer Fundamentals

Download Computer Engineering Midterm | CEN 4214 - Software-Hardware Codesign and more Quizzes Computer Fundamentals in PDF only on Docsity! TERM 1 computer engineering is DEFINITION 1 is a discipline that integrates several fields of Electrical engineering and computer science required to develop computer hardware and software.[ TERM 2 Usual tasks involving computer engineers include DEFINITION 2 writing software and firmware for embedded microcontrollers, designing VLSI chips, designing analog sensors, designing mixed signal circuit boards, and designing operating systems. TERM 3 In many institutions, computer engineering students are allowed to choose areas of in- depth study in their junior and senior year, because the full breadth of knowledge used in the design and application of computers is DEFINITION 3 beyond the scope of an undergraduate degree. TERM 4 What is the meaning of the following error messages? a) #### b) #NAME? C)#N/A D) #REF! E) #NUM! F) #DIV/0! DEFINITION 4 ###### - Insufficient width in cell to display numerical data, or formulas that result in negative date/time (prior to 1/1/1990)#NAME? Unrecognized text in a formula#N/A No answer#REF! Invalid cell reference#NUM! Invalid numeric values in a formula or function#DIV/0! Division by zero TERM 5 2. If you enter 1,149+25 in a cell exactly as shown (without an equal ign), what value would result? DEFINITION 5 1,149+25 TERM 6 3. If you enter =2+4*10 in a cell exactly as shown, what value would result? DEFINITION 6 42 TERM 7 4. List each of the following in order of precedence, from 1 to 4 (first to last): Multiplication and division, Parentheses, Addition and subtraction, Exponentiation DEFINITION 7 Parentheses Exponentiation Multiplication and division Addition and Subtraction TERM 8 5. When writing formulas, why is it preferable to use cell references rather than typing in values? DEFINITION 8 It allows the user to easily update the spreadsheet without having to know exactly which formula or formulas contain the changed value. TERM 9 7. Referring to the preceding worksheet, if you wrote the formula =B1*110, what value would result (assuming the displayed value is the precise value)? DEFINITION 9 11 TERM 10 Formula: Add a range of numbers in cells A2:X2. i. DEFINITION 10 =SUM(A2:X2) TERM 21 1. the mean of the following data set: 2,5,4,3,1,2,7? 2. median (actual #) 3. mode (actual #) DEFINITION 21 =AVERAGE(2,5,4,3,1,2,7) TERM 22 4. Question 1 has a standard deviation of 1.58 as compared with another data set that has a standard deviation of 2.5. What general differences would you expect to find between the two sets of data? DEFINITION 22 a.The second set of data has values that occur further from the mean than those in Question 1. TERM 23 the original labor rate for inspectors was given as $35 per hour. However due to contract renegotiation, this value is now $37.50. What algebraic expression could you use to determine the percent increase in labor costs? (Note that a resulting value is not required.) DEFINITION 23 =(37.50-35)/35 TERM 24 6. When using the Increase Decimal button on the toolbar, the precise value in the cell is modified. True or False? DEFINITION 24 False TERM 25 7. The formula =ROUND(345.43,0) results in what precise value? DEFINITION 25 345 TERM 26 8. Write a formula to round up 63.34% to the nearest percent. DEFINITION 26 =ROUNDUP(63.34%,2) TERM 27 9. What is the symbol for the greater than or equal to relational operator in Excel? DEFINITION 27 >= TERM 28 10. What is the symbol for the nor equal to relational operator in Excel? DEFINITION 28 <> TERM 29 11. Review the following worksheet, nd then use the COUNTIF function to write a formula that determines the munver of GM cars in the list. DEFINITION 29 =COUNTIF(A2:A10,GM) TERM 30 12. Using the worksheet shown in Question 11, write the formula to determine the number of cars that cost less than $20,000. DEFINITION 30 =COUNTIF(B2:B10,<20000) TERM 31 13. Using the worksheet sown in Question 11, write a formula to determine the total value of all ford cars. DEFINITION 31 =SUMIF(A2:A10,Ford,B2:B10) TERM 32 14. Explain the difference between a what-if analysis and Goal Seek by giving an example based on the worksheet in Question 11. DEFINITION 32 what if analysis (total changes) you could change the some of the prices of the cars and evaluate the total Goal Seek (total stable) you could put what you want the total to be and tell excel to change the value f a certain cell to get that total. TERM 33 15. Using the worksheet shown in Question 11, write a formula to determine the value of the third most expensive car. DEFINITION 33 =LARGE(B2:B10,3) TERM 34 16. If each car shown in Question 11is marked up between $50 and $250 in dollar increments, what function could be used to randomly assign the amount to be added to the car price in this formula? =B2+______ DEFINITION 34 =B2+RANDBETWEEN(50,250) TERM 35 17. The formula =RAND() gives what result? DEFINITION 35 Each time you write it gives a different, random value TERM 46 8. What are the differences and similarities between a line chart and an X Y (Scatter) chart? DEFINITION 46 An X Y (Scatter) chart plots numeric values on BOTH the x- and y-axes based on the value of the data Line chart plots numeric values on ONE axis and category labels equidistantly on the other axis TERM 47 9. Explain the difference between the data points in a line and an X Y (Scatter) chart. DEFINITION 47 The X Y (Scatter) chart plots both the y- and x-axis data as numeric values. Line chart plots the data points along the y-axis based in the value, but the x-axis is based on position because this axis contains categories. TERM 48 10. What are the differences between a bar chart and a column chart? Give an example of when you would use each one. DEFINITION 48 A bar chart compares values across categories in a horizontal orientation and values are indicated by the length of the bars. A column chart compares values across categories in a vertical orientation and values are indicated by the height of the columns. You could use either one to compare values across categories. TERM 49 11. What are the differences between a column chart and an area chart? Give an example of when you would use each one. DEFINITION 49 A column chart compares values across categories in a vertical orientation and valuesby the height of the columns. (compare amount sales) An area chart displays trends over time by category and the values are indicated by the filled areas below the lines. (illustrate sales trends in different categories over a longer time period, while emphasizing the contribution that each category made to particular years performance) TERM 50 12. How do pie charts differ from doughnut charts? DEFINITION 50 Pie charts compare the contribution of each value in a single numeric data series and makes to the whole, or 100% and values are indicated by the size of the pie slices. A doughnut chart compares the contribution value in multiple numeric data series makes to the whole and values are indicated by the size of the doughnut segments. TERM 51 13. When should you use a stacked line, column, or area chart? How do the stacked charts differ from regular charts? DEFINITION 51 You should use them to show the totals for each category. Staked charts illustrate the cumulative effects of data in categories. TERM 52 14. When should you use a 100% stacked line, column, or area chart? How do the 100% stacked charts differ from staked charts? DEFINITION 52 They can be used as an alternative to a pie chart and can help reduce confusion as over whether the line on the charts represents the individual or cumulative contribution to the whole The 100% stacked charts illustrate the cumulative contribution for each category expressed as a percentage. TERM 53 15. What chart sub-types are available for the stock chart in Excel? Explain how you interpret the data markers in each of the sub- types. DEFINITION 53 High-Low-Close chart, Open-High-Low-Close, Volume-High-Low- Close, and Volume-Open-High-Low-Close. high-low-close chart the vertical line=range of lowest to highest stock prices; tip of arrow= closing price for the time period. Open-high-low-close chart the vertical line=range of lowest to highest stock prices, a black box=a decrease in stock value, white box=increase in the stock value; the top and bottom of the box= indicate the opening and closing prices. TERM 54 16. How does a radar chart differ from other charts? Give an example of when you would consider doing a radar chart. DEFINITION 54 a.A radar chart compares values across categories in a circular orientation and values are indicated by the distance from a center point. You would do a radar chart to show the numerical value that each category contributed to the whole. TERM 55 17. Define a bubble chart and explain what type of data is suitable for plotting on a bubble chart. DEFINITION 55 a.A bubble chart compares sets of three values and values are indicated by the sixe of the bubbles. 3-D data is suitable for plotting on a bubble chart. For example it can be used to display the relationship between the number of styles of shoes offered, sales, and market share. TERM 56 18. When should you use a dashboard chart? DEFINITION 56 a.A dashboard chart can be used to provide a quick, visual summary of performance indicators. TERM 57 1. Evaluate the following expressions: a. =AND(FALSE,TRUE,TRUE) b. =OR(3>5,TRUE) c. =NOT(OR(FLASE,FALSE,FALSE)) d. =AND(A2>6,NOT(FALSE))where A2 contains the value 25-- DEFINITION 57 False True True False TERM 58 2. Describe how you would format a cell so that is the value Is greater than 50 it would be automatically bolded DEFINITION 58 You select the cells you want to apply the conditional formatting to then click the conditional formatting button in the styles group in the home tab and then point to the highlight sells rule to display its options. Then select greater than and type in 50 and then use the format cell dialog box and select bold then click OK. TERM 59 3. What formula is used in cell E3, which can be copied down the column to determine (TRUE or FALSE) if the item is within budget? DEFINITION 59 =OR(D3<C3) TERM 60 4. Write a formula to determine if all the items are in budget. DEFINITION 60 =AND(E3:E8,TRUE) TERM 71 15. Write an excel formula in cell H3 that can be copied down the column to calculate the cost of this component for a larger sales meeting based on the following: If this item is optional as indicated in column B, then the cost will be equal to the original budgeted amount. If this item is required as indicated in column B, then the cost will be three times the original budgeted amount. DEFINITION 71 i.=IF(B3=O,C3,IF(B3=R,3*C3,C3) TERM 72 T/F: The lookup_value of a VLOOKUP function can be a contiguous cell range. DEFINITION 72 TRUE TERM 73 T/F:In a VLOOKUP formula with a TRUE lookup type, the first column of the lookup table referenced must be in ascending order to retrieve the correct value. DEFINITION 73 TRUE TERM 74 T/F:The result_vector of a LOOKUP function must be sorted in ascending order. DEFINITION 74 FALSE TERM 75 T/f: Reference and Lookup functions may not contain nested functions as arguments. DEFINITION 75 FALSE TERM 76 T/F: The default range_lookup type for the VLOOKUP and HLOOKUP functions is FALSE. DEFINITION 76 FALSE TERM 77 T/F: Excel matches the lookup_value tom with the entry TOM in a lookup table. DEFINITION 77 TRUE TERM 78 T/f: The row and column arguments in the INDEX function can be numeric values, Boolean values, or text. DEFINITION 78 TRUE TERM 79 T/F: The formula =returns the value in cell D13. DEFINITION 79 TRUE TERM 80 T/F: The formula =AVERAGE(CHOOSE(1,B12:D17,B22:D17)) averages the value 1 with the values in cells B12 to D17 and B22 to D17. DEFINITION 80 FALSE TERM 81 T/F: The Formula =MATCH(40, {10,40,50,90},0) returns the value 2. DEFINITION 81 TRUE TERM 82 11. What happens when Excel is solving a VLOOKUP formula with a FALSE range_lookup type and does not find an exact match in the lookup table? DEFINITION 82 The text #N/A is displayed in the cell. TERM 83 12. What is the difference between the LOOKUP function and the VLOOKUP or HLOOKUP function? DEFINITION 83 The LOOKUP function looks up values anywhere in a table or range and VLOOKUP can only retrieve data from a table with a vertical orientation and an HOOKUP from a table with a horizontal orientation. TERM 84 13. Which Excel function should you use when you want to look up a value from a two dimensional table, where both the columns and rows can be varied? DEFINITION 84 The INDEX function TERM 85 14. Write a formula to choose the name of the fifth day of the week from the list starting with Sunday, Monday, TuesdaySaturday. DEFINITION 85 =CHOOSE(5,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")