Data Analytics Exam 1 Review Questions
and Answers
How would 10 raised to the power of 2 × 5 raised to the power of 3/ 100 - 73 be represented in
an Excel spreadsheet? •Formulas in Excel use common mathematical operators:
•Addition +
•Subtraction -
•Multiplication *
•Division /
•Raised to the Power of (Exponentiation) ^
10^2 * 5^ -73
Relative and absolute addressing in Excel formulas A relative address uses just the row
and column label in the cell reference
An absolute address uses a dollars sign before either the row or column or both
Using a dollar sign before a row label keeps the reference fixed to the row but allows the column
reference to change if the formula is copied to another cell
A dollar sign before both the row and column will keep the reference fixed for both the row and
column
, Copying formulas in Excel To copy a formula from a single cell or range of cells down a
column or across a row
1. first select the cell or range
2. click and hold the mouse on the small square in the lower right-hand corner of the cell
3. drag the formula to the "target" cells which you wish to copy.
Another way to copy a formula in Excel is to select the cell with the formula to be copied, and
then press Ctrl-C and then press Ctrl-V in Windows
With a MAC, use the Command key rather than Ctrl
Excel Functions The easiest way to locate a particular function is to select a cell and click
on the Insert function button (fx) which can be found under the ribbon next to the formula bar.
Some of the more common functions in Excel include:
•MIN(range) smallest value in a range of cells
•MAX(range) largest value in a range of cells
•SUM(range) sum of values in a range of cells
•AVERAGE(range) average of the values in a range of cells
•COUNT(range) # of cells in a range that contains numbers
•COUNTIF(range, criteria) # of cells within a range that meet a specified criterion
and Answers
How would 10 raised to the power of 2 × 5 raised to the power of 3/ 100 - 73 be represented in
an Excel spreadsheet? •Formulas in Excel use common mathematical operators:
•Addition +
•Subtraction -
•Multiplication *
•Division /
•Raised to the Power of (Exponentiation) ^
10^2 * 5^ -73
Relative and absolute addressing in Excel formulas A relative address uses just the row
and column label in the cell reference
An absolute address uses a dollars sign before either the row or column or both
Using a dollar sign before a row label keeps the reference fixed to the row but allows the column
reference to change if the formula is copied to another cell
A dollar sign before both the row and column will keep the reference fixed for both the row and
column
, Copying formulas in Excel To copy a formula from a single cell or range of cells down a
column or across a row
1. first select the cell or range
2. click and hold the mouse on the small square in the lower right-hand corner of the cell
3. drag the formula to the "target" cells which you wish to copy.
Another way to copy a formula in Excel is to select the cell with the formula to be copied, and
then press Ctrl-C and then press Ctrl-V in Windows
With a MAC, use the Command key rather than Ctrl
Excel Functions The easiest way to locate a particular function is to select a cell and click
on the Insert function button (fx) which can be found under the ribbon next to the formula bar.
Some of the more common functions in Excel include:
•MIN(range) smallest value in a range of cells
•MAX(range) largest value in a range of cells
•SUM(range) sum of values in a range of cells
•AVERAGE(range) average of the values in a range of cells
•COUNT(range) # of cells in a range that contains numbers
•COUNTIF(range, criteria) # of cells within a range that meet a specified criterion
