Which step is not part of planning a worksheet design?
Give this one a try later!
Enter labels, values, and formulas.
Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%. Cell C3
contains =A2*(1-B2) to calculate the sale price of $85. Which of the following formulas
produces the same result?
Give this one a try later!
=A2-(A2*B2)
, A local police chief wants to create a rule that a person will be ticketed if an officer
pulls over a person for exceeding the speed limit by at least five miles per hour or if
that person has two or more speeding violations on record. Which function should be
used?
Give this one a try later!
OR
Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the
following is not a method for going to cell B10?
Give this one a try later!
Type B10 in the Formula Bar and press Enter
What is the difference between a sample and a population?
Give this one a try later!
A population contains all data you want to evaluate, while a sample
contains a portion of the data.
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You
can insert a code for all of the following except:
Give this one a try later!
Give this one a try later!
Enter labels, values, and formulas.
Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%. Cell C3
contains =A2*(1-B2) to calculate the sale price of $85. Which of the following formulas
produces the same result?
Give this one a try later!
=A2-(A2*B2)
, A local police chief wants to create a rule that a person will be ticketed if an officer
pulls over a person for exceeding the speed limit by at least five miles per hour or if
that person has two or more speeding violations on record. Which function should be
used?
Give this one a try later!
OR
Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the
following is not a method for going to cell B10?
Give this one a try later!
Type B10 in the Formula Bar and press Enter
What is the difference between a sample and a population?
Give this one a try later!
A population contains all data you want to evaluate, while a sample
contains a portion of the data.
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You
can insert a code for all of the following except:
Give this one a try later!
