COS Exam 1 UPDATED Exam Questions
and CORRECT Answers
How would you fix the error message ###### that might appear in a cell? - CORRECT
ANSWER - 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? - CORRECT
ANSWER - 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? - CORRECT ANSWER -
=A1+A3+A4+A5 with value 100
What is the result of the math formula: =2*10+4^2 - CORRECT ANSWER - 36
Which statement is NOT true about Excel's AutoSum feature? - CORRECT ANSWER -
Once AutoSum has inserted a function with its suggested range, it cannot be edited
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? - CORRECT ANSWER - 34
Assume cell A3 contains the formula =A1+A2. Attempting to copy it to which of the following
cells will generate a #REF! error? - CORRECT ANSWER - D2
Assume cell B1 contains the formula =C8*D5. How will this formula appear if it is copied to
C2? - CORRECT ANSWER - =D9*E6
The _________ is the small black cross shape that appears int he lower right corner of a cell. -
CORRECT ANSWER - Fill handle
, What is indicated by a formula containing the formula: =$D10*5? - CORRECT
ANSWER - When the formula is copied the row may alter by not the column
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? - CORRECT ANSWER - - =C2+C3
- =Hours+C3
Assume the workbook has five worksheets named Mon, Tues, Wed, Thu, and Fri. A sixth
worksheet is added with the name summary. Which command sheet should be placed in cell A1
of the summary sheet to add the values from cells A1 of each of the five sheets? - CORRECT
ANSWER - - =Mon!A1+Tue!A1+Wed!A1+Thu!A1+Fri!A1
- =SUM(Mon:Fri!A1)
Use the Insert Function took to search for the answer to this question. Assume you need the
function to join two strings of text into one (ex. "hot" joined with "dog" forms "hotdog"). Which
function would you use? - CORRECT ANSWER - Concatenate
Which number forma adds commas in the thousands place and adds a $ symbol fixed to the left
side of the cell? - CORRECT ANSWER - Accounting
Given the values 2, 5, 4, 3, 1, 2, 7, the median is ______ and the mode is ______. - CORRECT
ANSWER - 3,2
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? -
CORRECT ANSWER - =(A2-A1)/A1
What is the result of the formula: =ROUND(SUM(8.7,9.1(,0) - CORRECT ANSWER - 18
Which function should be used if a value (ex. 2.125 or 9.798) is to rounded to the closest lower
integer (ex. 2 or 9)? - CORRECT ANSWER - ROUNDDOWN
and CORRECT Answers
How would you fix the error message ###### that might appear in a cell? - CORRECT
ANSWER - 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? - CORRECT
ANSWER - 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? - CORRECT ANSWER -
=A1+A3+A4+A5 with value 100
What is the result of the math formula: =2*10+4^2 - CORRECT ANSWER - 36
Which statement is NOT true about Excel's AutoSum feature? - CORRECT ANSWER -
Once AutoSum has inserted a function with its suggested range, it cannot be edited
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? - CORRECT ANSWER - 34
Assume cell A3 contains the formula =A1+A2. Attempting to copy it to which of the following
cells will generate a #REF! error? - CORRECT ANSWER - D2
Assume cell B1 contains the formula =C8*D5. How will this formula appear if it is copied to
C2? - CORRECT ANSWER - =D9*E6
The _________ is the small black cross shape that appears int he lower right corner of a cell. -
CORRECT ANSWER - Fill handle
, What is indicated by a formula containing the formula: =$D10*5? - CORRECT
ANSWER - When the formula is copied the row may alter by not the column
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? - CORRECT ANSWER - - =C2+C3
- =Hours+C3
Assume the workbook has five worksheets named Mon, Tues, Wed, Thu, and Fri. A sixth
worksheet is added with the name summary. Which command sheet should be placed in cell A1
of the summary sheet to add the values from cells A1 of each of the five sheets? - CORRECT
ANSWER - - =Mon!A1+Tue!A1+Wed!A1+Thu!A1+Fri!A1
- =SUM(Mon:Fri!A1)
Use the Insert Function took to search for the answer to this question. Assume you need the
function to join two strings of text into one (ex. "hot" joined with "dog" forms "hotdog"). Which
function would you use? - CORRECT ANSWER - Concatenate
Which number forma adds commas in the thousands place and adds a $ symbol fixed to the left
side of the cell? - CORRECT ANSWER - Accounting
Given the values 2, 5, 4, 3, 1, 2, 7, the median is ______ and the mode is ______. - CORRECT
ANSWER - 3,2
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? -
CORRECT ANSWER - =(A2-A1)/A1
What is the result of the formula: =ROUND(SUM(8.7,9.1(,0) - CORRECT ANSWER - 18
Which function should be used if a value (ex. 2.125 or 9.798) is to rounded to the closest lower
integer (ex. 2 or 9)? - CORRECT ANSWER - ROUNDDOWN
