COS Exam #1 Questions and Answers | New One | Grade A+

How would you fix the error message ###### that might appear in a cell? Ans: Widen the column so there is room to display the numeric data Which of the following is not an option on the Format Cells / Alignment tab? Ans: Add a bottom border under the cell Assume values 10,20,30, and 40 are entered in the cell range A1:A4. Cell A10 contains the formula: =A1+A2+A3+A4 and displays value 100. The user inserts a new row 2 and enters value 50 in cell A2. What formula and value now list in cell A11? Ans: =A1+A3+A4+A5 with value 100 What is the result of the math formula: =2*10+4^2 Ans: 36 Which statement is NOT true about Excel's AutoSum feature? Ans: Once AutoSum has inserted a function with its suggested range, it cannot be edited GRADE A+ What is the result of the function =SUM(A1,5,B4:B6) assuming cell A1 contains value 20, B$ contains 2, B5 contains 3 and B6 contains 4? Ans: 34 Assume cell A3 contains the formula =A1+A2. Attempting to copy it to which of the following cells will generate a #REF! error? Ans: D2 Assume cell B1 contains the formula =C8*D5. How will this formula appear if it is copied to C2? Ans: =D9*E6 The _________ is the small black cross shape that appears int he lower right corner of a cell. Ans: Fill handle What is indicated by a formula containing the formula: =$D10*5? Ans: When the formula is copied the row may alter by not the colum