BStat Prep questions and answers graded A+
already passed
1. You can insert formulas by All of the options
Clicking on formulas and then insert
function Typing = and function name
If the formula bar is enabled in the view
settings, typ- ing directly in it
2. Additional functions and their usage can be All of the options
found in
Lookup & reference tab within
formulas Help for Microsoft Excel
3. To compute the standard deviation of a data sample Use
STDEV.S
4. You can choose which numbers to add/subtract/multi- True
ply/divide by selecting the cell.
5. In Excel, in a formula, the asterisk character (*) is used multiplying
two numbers
for .
6. In Excel, in a formula, the character for computing the ^
power of a number is
7. When is scientific notation useful? When working with
data sets that have a
wide range of values.
8. In scientific notation, the number 1.234E+10
12,340,000,000 is represented in Excel as .
9. We have a number, 4.38E-02, in scientific notation. How 0.0438
1/
3
already passed
1. You can insert formulas by All of the options
Clicking on formulas and then insert
function Typing = and function name
If the formula bar is enabled in the view
settings, typ- ing directly in it
2. Additional functions and their usage can be All of the options
found in
Lookup & reference tab within
formulas Help for Microsoft Excel
3. To compute the standard deviation of a data sample Use
STDEV.S
4. You can choose which numbers to add/subtract/multi- True
ply/divide by selecting the cell.
5. In Excel, in a formula, the asterisk character (*) is used multiplying
two numbers
for .
6. In Excel, in a formula, the character for computing the ^
power of a number is
7. When is scientific notation useful? When working with
data sets that have a
wide range of values.
8. In scientific notation, the number 1.234E+10
12,340,000,000 is represented in Excel as .
9. We have a number, 4.38E-02, in scientific notation. How 0.0438
1/
3
