CGS 2518 FSU EXAM QUESTIONS WITH
COMPLETE SOLUTIONS
Find the smallest values in cells B12 through Z12 - Answer-=MIN(B12:Z12)
Find the average value in cells C1 through C10, assuming blank cells will be ignored -
Answer-=AVERAGE(C1:C10)
Find the total number of values listed in cells C1:C10, excluding any that contain text -
Answer-=COUNT(C1:C10)
Define Syntax - Answer-The specific format of function name and the order of the
arguments
Define Arguments - Answer-Function inputs
Define Algorithm - Answer-A rule that governs how a function works
If the formula =$B$4-SUM(C1:C5) is copied from cell A9 to cell C10, what is the
resulting formula? - Answer-=$B$4-SUM(E2:E6)
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? -
Answer-=SUM($A2:B$1)
What formula could you use to add up cell B1 from Sheet1!, Sheet 2!, and Sheet 3!
(assuming the worksheets
are contiguous and in the same workbook)? - Answer-=SUM(sheet1!b1,sheet2!
b1,sheet3!b1)
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? -
Answer-=discount*A1
=discount*A2
What formula could you write to calculate the mean of the following data set:
2,5,4,3,1,2,7? - Answer-=AVERAGE(2,5,4,3,1,2,7)
What is the median value of the set: 2,5,4,3,1,2,7 - Answer-=MEDIAN(2,5,4,3,1,2,7) 3
What is the mode of the data set: 2,5,4,3,1,2,7 - Answer-=MODE(2,5,4,3,1,2,7) 2
, The data set: 2,5,4,3,1,2,7, 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? - Answer-Since standard deviation is a measure of range and
distribution, the larger standard deviation would result in a larger range of values.
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? (Note that a resulting value is not required.) - Answer-(37.50-
35)/35
When using the increase decimal button on the toolbar, the precise value in the cell is
modified. True or false. - Answer-FALSE
The formula =Round(345.43,0) results in what precise value? - Answer-345
Write a formula to round up 63.34% to the nearest percent - Answer-
=ROUNDUP(63.34%,2)
What is the symbol for the greater than or equal to relational operator in Excel? -
Answer->=
What is the symbol for the not equal to relational operator in Excel? - Answer-<>
Review the following worksheet, and then use the COUNTIF function to write a formula
that determines the number of Ford cars on this list - Answer-
=COUNTIF(A2:A10,"Ford")
Using the worksheet shown in question 11, write a formula to determine the number of
cars that cost more than $20,000. - Answer-=COUNTIF(B2:B10,">20000")
Using the worksheet show in question 11, write a formula to determine the total value of
all GM Cars. - Answer-=SUMIF(A2:A10,"GM",B2:B10)
What if scenarios vs Goal Seek - Answer-What If scenarios analyze certain inputs of
functions to check what would happen if a value were to change. Goal seek aims to
work backwards by changing the input numbers for a desired outcome
Using the worksheet shown in question 11, write a formula to determine the value of the
third LEAST expensive car. - Answer-=SMALL(B2:B10,3)
If each car shown in question 11 is marked up between $100 and $200 in dollar
increments, what function could be used to randomly assign the amount to be added to
COMPLETE SOLUTIONS
Find the smallest values in cells B12 through Z12 - Answer-=MIN(B12:Z12)
Find the average value in cells C1 through C10, assuming blank cells will be ignored -
Answer-=AVERAGE(C1:C10)
Find the total number of values listed in cells C1:C10, excluding any that contain text -
Answer-=COUNT(C1:C10)
Define Syntax - Answer-The specific format of function name and the order of the
arguments
Define Arguments - Answer-Function inputs
Define Algorithm - Answer-A rule that governs how a function works
If the formula =$B$4-SUM(C1:C5) is copied from cell A9 to cell C10, what is the
resulting formula? - Answer-=$B$4-SUM(E2:E6)
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? -
Answer-=SUM($A2:B$1)
What formula could you use to add up cell B1 from Sheet1!, Sheet 2!, and Sheet 3!
(assuming the worksheets
are contiguous and in the same workbook)? - Answer-=SUM(sheet1!b1,sheet2!
b1,sheet3!b1)
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? -
Answer-=discount*A1
=discount*A2
What formula could you write to calculate the mean of the following data set:
2,5,4,3,1,2,7? - Answer-=AVERAGE(2,5,4,3,1,2,7)
What is the median value of the set: 2,5,4,3,1,2,7 - Answer-=MEDIAN(2,5,4,3,1,2,7) 3
What is the mode of the data set: 2,5,4,3,1,2,7 - Answer-=MODE(2,5,4,3,1,2,7) 2
, The data set: 2,5,4,3,1,2,7, 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? - Answer-Since standard deviation is a measure of range and
distribution, the larger standard deviation would result in a larger range of values.
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? (Note that a resulting value is not required.) - Answer-(37.50-
35)/35
When using the increase decimal button on the toolbar, the precise value in the cell is
modified. True or false. - Answer-FALSE
The formula =Round(345.43,0) results in what precise value? - Answer-345
Write a formula to round up 63.34% to the nearest percent - Answer-
=ROUNDUP(63.34%,2)
What is the symbol for the greater than or equal to relational operator in Excel? -
Answer->=
What is the symbol for the not equal to relational operator in Excel? - Answer-<>
Review the following worksheet, and then use the COUNTIF function to write a formula
that determines the number of Ford cars on this list - Answer-
=COUNTIF(A2:A10,"Ford")
Using the worksheet shown in question 11, write a formula to determine the number of
cars that cost more than $20,000. - Answer-=COUNTIF(B2:B10,">20000")
Using the worksheet show in question 11, write a formula to determine the total value of
all GM Cars. - Answer-=SUMIF(A2:A10,"GM",B2:B10)
What if scenarios vs Goal Seek - Answer-What If scenarios analyze certain inputs of
functions to check what would happen if a value were to change. Goal seek aims to
work backwards by changing the input numbers for a desired outcome
Using the worksheet shown in question 11, write a formula to determine the value of the
third LEAST expensive car. - Answer-=SMALL(B2:B10,3)
If each car shown in question 11 is marked up between $100 and $200 in dollar
increments, what function could be used to randomly assign the amount to be added to
