CGS 2518- EXAM #1 FSU QUESTIONS
WITH COMPLETE SOLUTIONS
Algorithm - Answer-A rule that government=s how a function works
The formula =$B$4-SUM(C1:C5) is copied from cell A9 to C10, what is the resulting
formula? - Answer-=$B$4-SUM(E2:E6); shift right 2 down 1
Set up a multiplication table, what formula can be dragged across all rows and columns
In cell B2? - Answer-=SUM($A2:B$1)
What formula can you use to add up cell B1 across sheets 1,2,&3? - Answer-
=SUM(Sheet1!B1,Sheet2!B1,Sheet3!B1)
Cell B1 has been given the range name "discount", write a formula in cell C1 that
multiplies "discount" by cell A1. What new formula results when u copy the formula into
cell C2? - Answer-=discount*A1
=discount*A2
How do you calculate the mean for a set of data? - Answer-=AVERAGE(1,2,3,..)
Median of data set? - Answer-=MEDIAN(1,2,3,..)
Mode of a data set? - Answer-=MODE(1,2,3,...)
Two data sets have the same mean, and differing standard deviations, what does this
tell us about the data sets? - Answer-Since standard deviation is a measure of range
and distribution, the larger deviation would result in a larger range of values.
In what algebraic expression do you use to determine the percent increase? - Answer-
(New value-original)/original
When using the increase value button in the toolbar the precise value in the cell is
modified. T or F - Answer-False
=ROUND(345.43,0) results in - Answer-345
Write a formula to round 654.32 to the nearest percent - Answer-
=ROUNDUP(654.32%,2)
Write a formula that determines the number of ford cars - Answer-
=COUNTIF(A2:A10,"Ford")
, Write a formula to count the number of cars costing greater than $20,000 - Answer-
=COUNTIF(B2:B10,">20000")
Find the total value of all GM cars - Answer-=SUMIF(A2:A10,"GM",B2:B10)
What If 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
Write a formula to determine the third least expensive car - Answer-=SMALL(B2:B10,3)
What function could be used to randomly assign the amount added to each car, 100 or
200? - Answer-=B2+RANDBETWEEN(100,200)
The formula =RAND() results... - Answer-And random number between 0 and 1
Write a formula to average the values between B2:B10, excluding blank cells, rounded
to the nearest whole number. - Answer-=ROUND(AVERAGE(B2:B10,0)
Write a formula to determine the average price of only GM vehicles - Answer-
=AVERAGE(IF(A2:A10,"GM",B2:B10)
Tufte's 5 data graphics principles - Answer-Above all else show the data
Maximize the dark-ink, ratios within reason
Erase non-data-ink within reason
Erase redundant data ink
Revise and edit
How do sparklines differ from charts - Answer-Spark lines are small word-sized charts
or graphics embedded in words/numbers/images.
Charts summarize information and are large to be presented easily
3 steps involved in using the insert tab to create a chart - Answer-Select data
Clic insert
Click recommended chart group
Ex of low data ink in a chart - Answer-Line graph
How do you change the chart type of an existing chart? - Answer-Click desired chart
Go to design ribbon and click change chart type
Choose type or subtype, then ok
What charting limits des excel have in terms of data points and series? - Answer-
Require at least one numeric data series and one label data series, number of data
series is limited to computer memory and capacity
WITH COMPLETE SOLUTIONS
Algorithm - Answer-A rule that government=s how a function works
The formula =$B$4-SUM(C1:C5) is copied from cell A9 to C10, what is the resulting
formula? - Answer-=$B$4-SUM(E2:E6); shift right 2 down 1
Set up a multiplication table, what formula can be dragged across all rows and columns
In cell B2? - Answer-=SUM($A2:B$1)
What formula can you use to add up cell B1 across sheets 1,2,&3? - Answer-
=SUM(Sheet1!B1,Sheet2!B1,Sheet3!B1)
Cell B1 has been given the range name "discount", write a formula in cell C1 that
multiplies "discount" by cell A1. What new formula results when u copy the formula into
cell C2? - Answer-=discount*A1
=discount*A2
How do you calculate the mean for a set of data? - Answer-=AVERAGE(1,2,3,..)
Median of data set? - Answer-=MEDIAN(1,2,3,..)
Mode of a data set? - Answer-=MODE(1,2,3,...)
Two data sets have the same mean, and differing standard deviations, what does this
tell us about the data sets? - Answer-Since standard deviation is a measure of range
and distribution, the larger deviation would result in a larger range of values.
In what algebraic expression do you use to determine the percent increase? - Answer-
(New value-original)/original
When using the increase value button in the toolbar the precise value in the cell is
modified. T or F - Answer-False
=ROUND(345.43,0) results in - Answer-345
Write a formula to round 654.32 to the nearest percent - Answer-
=ROUNDUP(654.32%,2)
Write a formula that determines the number of ford cars - Answer-
=COUNTIF(A2:A10,"Ford")
, Write a formula to count the number of cars costing greater than $20,000 - Answer-
=COUNTIF(B2:B10,">20000")
Find the total value of all GM cars - Answer-=SUMIF(A2:A10,"GM",B2:B10)
What If 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
Write a formula to determine the third least expensive car - Answer-=SMALL(B2:B10,3)
What function could be used to randomly assign the amount added to each car, 100 or
200? - Answer-=B2+RANDBETWEEN(100,200)
The formula =RAND() results... - Answer-And random number between 0 and 1
Write a formula to average the values between B2:B10, excluding blank cells, rounded
to the nearest whole number. - Answer-=ROUND(AVERAGE(B2:B10,0)
Write a formula to determine the average price of only GM vehicles - Answer-
=AVERAGE(IF(A2:A10,"GM",B2:B10)
Tufte's 5 data graphics principles - Answer-Above all else show the data
Maximize the dark-ink, ratios within reason
Erase non-data-ink within reason
Erase redundant data ink
Revise and edit
How do sparklines differ from charts - Answer-Spark lines are small word-sized charts
or graphics embedded in words/numbers/images.
Charts summarize information and are large to be presented easily
3 steps involved in using the insert tab to create a chart - Answer-Select data
Clic insert
Click recommended chart group
Ex of low data ink in a chart - Answer-Line graph
How do you change the chart type of an existing chart? - Answer-Click desired chart
Go to design ribbon and click change chart type
Choose type or subtype, then ok
What charting limits des excel have in terms of data points and series? - Answer-
Require at least one numeric data series and one label data series, number of data
series is limited to computer memory and capacity
