What is the meaning of this error message #DIV/0!
Give this one a try later!
Division by zero
In the worksheet below, cell A3 contains the formula =A1+A2. Explain the most likely
reason the value calculated appears to be incorrect.
Give this one a try later!
The values are rounded so we don't see the correct value
What is the meaning of this error message #NAME?
,Give this one a try later!
Unrecognized text in formula
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?
Give this one a try later!
=SUM($A2:B$1)
Define Algorithm
Give this one a try later!
A rule that governs how a function works
What are the differences and similarities between a line chart and an X Y (Scatter)
chart? When should you use each one?
Give this one a try later!
The X Y (Scatter) plots the x-axis in numeric order, the line chart plots the x-
axis based on the position of the categories in the data range
b. Both plot the y-axis the same
c. An X Y (Scatter) plot should be used instead of a line chart when
comparing sets of numerical data on both the x-axis and the y-axis
, Write a formula to round up 63.34% to the nearest percent
Give this one a try later!
=ROUNDUP(63.34%,2)
What is the median value of the set: 2,5,4,3,1,2,7
Give this one a try later!
=MEDIAN(2,5,4,3,1,2,7) 3
How do pie charts differ from doughnut charts?
Give this one a try later!
A pie chart compares the contribution of each value a numeric data series
makes to a whole, 100%.
A doughnut chart compares the contribution of each value in multiples
numeric data series makes to the whole, 100%. Values are indicated by the
size of the doughnut segments.
Add range of numbers in cells A2:X2
Give this one a try later!
Give this one a try later!
Division by zero
In the worksheet below, cell A3 contains the formula =A1+A2. Explain the most likely
reason the value calculated appears to be incorrect.
Give this one a try later!
The values are rounded so we don't see the correct value
What is the meaning of this error message #NAME?
,Give this one a try later!
Unrecognized text in formula
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?
Give this one a try later!
=SUM($A2:B$1)
Define Algorithm
Give this one a try later!
A rule that governs how a function works
What are the differences and similarities between a line chart and an X Y (Scatter)
chart? When should you use each one?
Give this one a try later!
The X Y (Scatter) plots the x-axis in numeric order, the line chart plots the x-
axis based on the position of the categories in the data range
b. Both plot the y-axis the same
c. An X Y (Scatter) plot should be used instead of a line chart when
comparing sets of numerical data on both the x-axis and the y-axis
, Write a formula to round up 63.34% to the nearest percent
Give this one a try later!
=ROUNDUP(63.34%,2)
What is the median value of the set: 2,5,4,3,1,2,7
Give this one a try later!
=MEDIAN(2,5,4,3,1,2,7) 3
How do pie charts differ from doughnut charts?
Give this one a try later!
A pie chart compares the contribution of each value a numeric data series
makes to a whole, 100%.
A doughnut chart compares the contribution of each value in multiples
numeric data series makes to the whole, 100%. Values are indicated by the
size of the doughnut segments.
Add range of numbers in cells A2:X2
Give this one a try later!
