Chapter 1 1 What is the meaning of each of the following error messages Insufficient Width NAME Unrecognized text in formula N A No Answer REF Invalid Cell Reference Wrong argument type or operation VALUE NUM Invalid numeric values in a formula or function DIV 0 Division by zero 2 If you enter 1 149 25 in a cell exactly as shown without an equal sign what value would result 1 149 25 3 If you enter 2 4 10 in a cell exactly as shown what value would result 42 4 List each of the following operations in order of precedence from 1 to 4 first to last Multiplication and division Parentheses Addition and subtraction Exponentiation Parenthesis Exponentiation Multiplication and division Addiction and subtraction PEMDAS 5 When writing formulas why is it preferable to use cell references rather than typing in values It allows the worksheet to automatically update the formulas if any changes are made 6 In the worksheet below cell A3 contains the formula A1 A2 Explain the most likely reason the value calculated appears incorrect I think this had to do with the precision of the number and rounding Not 100 sure 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 I got 11 8 What formula would you write to do each of the following Add a range of numbers in cells A2 X2 SUM A2 X2 Find the largest value in cells C2 C8 MAX C2 C8 Find the smallest values in cells B2 through Z12 MIN B2 Z12 Find the average value in cells C1 through C10 assuming blank cells will be ignored AVERAGE C1 C10 Find the total number of values listed in cells C1 through C10 excluding any that contain text COUNT C1 C10 9 Define the following terms Syntax The specific format of a function including the function name and the order of the arguments Arguments A function input Algorithm A rule that governs how a function works A systematic set of procedures that the computer always steps through to calculate the results of a function 10 cell C10 what is the resulting formula If the formula B 4 SUM C1 C5 is copied from A9 to B 4 SUM E2 E6 11 12 Refer to the following worksheet What formula would you write in cell B2 that can be copied down the column and across the row to complete the multiplication table A2 B 1 What new formula results for each of the following if the formula is copied from cell C10 to cell E13 A1 A2 C4 C5 A 1 A2 A 1 C5 A1 A2 A3 C5 A 1 A2 13 C 1 C5 What formula could you use to add up cell B1 from Sheet1 Sheet2 and Sheet3 assuming the worksheets are contiguous and in the same workbook Sheet1 B1 Sheet2 B1 Sheet3 B1 Sheet4 B1 14 Cell B1 has been given the range name discount How would you write a formula in cell C1 that multiplies discount by cell A1 What new formula results if you copy this formula into cell C2 I think this is asking to subtract the discount but I m not entirely sure I got A1 B 1 A1 A2 B 1 A2 Chapter 2 1 What formula could you write to calculate the mean of the following data set 2 5 4 3 1 2 7 AVERAGE 2 5 4 3 1 2 7 2 What is the median values of the data set give in Question 1 MEDIAN 2 5 4 3 1 2 7 3 What is the mode of the data set given in Question 1 MODE 2 5 4 3 1 2 7 4 The data set give in Question 1 has a standard deviation of 1 58 as compared with another data set that has the same mean but a standard deviation of 2 5 What general differences would you expect to find between the two sets of data The second dataset may have a wider range of values from the mean Standard deviation is a measure of the range of data away from the center mean Standard deviation is a measure of how widely the data values are dispersed from the arithmetic mean In a normal distribution the mode and median are the same as o PAGE 90 the mean In a NOT normal distribution the mode and median are not the same as the mean 5 In the chapter the original labor rate for inspectors was given as 35 per hour However due to a contract renegotiation this value is now 37 50 What algebraic expression could you use to determine the percent increase in labor costs PAGE 94 37 50 35 35 Current Value Historical Value Historical Value 6 When using the Increase Decimal button on the toolbar the precise values in the cell are modified True of False FALSE Increase Decimal button as NO effect on the precision of the value 7 This formula ROUND 345 43 0 results in what precise value PAGE 96 TABLE 2 2 345 0 rounds the value to the nearest whole number 8 Write a formula to round up 63 34 to the nearest percent ROUND 63 34 2 2 rounds value to the nearest hundredth or nearest percent 9 What is the symbol for the greater than or equal to relational operator in Excel operator in Excel 10 What is the symbol for the not equal to relational 11 Review the following worksheet and then use the COUNTIF function to write a formula that determines the number of GM cars on this list COUNTIF A2 A10 A3 COUNTIF AS A10 GM OR 12 Using the worksheet shown in Question 11 write formula to determine the number of cars that cost less than 20 000 COUNTIF B2 B10 20000 13 Using the worksheet shown in Question 11 write a formula to determine the total value of all Ford cars SUMIF A2 A10 FORD B2 B10 14 15 17 18 Explain the difference between a what if analysis and Goal Seek by gibing an example based on the worksheet shown in Question 11 What If Analysis lets you determine the outcome of Goal Seek lets you specify an outcome you want and which Example How much would you price the Lexus car to attain a changing one of more values and evaluate the recalculated results input value you want to vary or change total of 200 000 Using the worksheet shown in Question 11 write a formula to determine the value of the third most expensive car LARGE B2 B10 3 16 If each car shown in Question 11 is 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 B2 RANDBETWEEN 50 250 The formula RAND gives what result Returns a random value between 0 and 1 What formula could you write to average the values in cells A10 through A20 excluding blank cells rounded to the nearest 10 …
View Full Document
Unlocking...