Cos Exam Questions And Right Answers

COS EXAM QUESTIONS AND RIGHT ANSWERS An array formula can be identified as the formula is surrounded by characters... - ANSWER-{ } .Assume a worksheet has a multiple columns of data related to a payroll. The column heading Salaries is in cell F1. In the next 500 rows are data values representing 500 salary values. Which technique should be used most quickly select these data values? - ANSWER-Click in cell F2, and press the key combination Ctrl+Shift+(down arrow) .Assume cell A1 contains an original labor rate with value $35.00 and cell A2 contains an increased labor rate of #37.50. Which formula computes the percent increase in labor rate? - ANSWER-=(A2-A1)/A1 .Assume cell A1 contains the formula =B1+$C2+D$3+$E$4. Which statement is correct if this formula is copied to cell A2? - ANSWER-The formula is adjusted to =B2+$C3+D$3+$E$4 .Assume cell A3 contains the formula =A1+A2. Attempting to copy it to which of the following cells will generate a #REF! error? - ANSWER-D2 .Assume cell B1 contains the formula =C8*D5. How will this formula appear if it is copied to C2? - ANSWER-=D9*E6 .Assume cell C2 has been given the name Hours. Which of the formulas below could be used to add the value in cell C2 to the value in cell C3? - ANSWER-- =C2+C3 - =Hours+C3 .Assume cell D5 is selected. Which of the following formulas/functions will generate a Circular Error message? - ANSWER-=D4*3+D5*2 .Assume range A1:A50 contains the results of a formula. Which Paste command option should be used if you wish to copy the results only to range B1:B50? - ANSWER-Values