# www.TestsTestsTests.com ## Microsoft Excel FREE Resources Index Page Formulas in Excel – Functions in Excel – Basic Excel Formulas Test – Excel 2010 Test – Formulas & Functions – Free Online Microsoft Excel Test

# Formulas in Excel – Functions in Excel Basic Excel Formulas Test

## Excel 2010 Test – Formulas & Functions Free Online Microsoft Excel Test

### * Understanding Cell References in Excel * Add in Excel – SUM Function in Excel – Adding Values in Excel * Subtract in Excel – Subtracting Values in Excel * Multiply in Excel – Multiply Values – Divide in Excel – Divide Values

***GO TO THE TEST ANSWER EXPLANATIONS PAGE

### Excel Formula Basics Test 1) Study the screenshot above.  James wishes to work out the total for the weekly grocery bill for himself and his roommate.  The total should display in cell B16 (highlighted in green).  Which of the following methods will successful in displaying the total?
a) Select cells B3:B15, press AutoSum and then press enter.
b) In cell B16 type the formula:  =Sum(B3:B15) and press enter.
c) In cell B16 type the formula:  =B3+B4+B5+B6+B7+B8+B9+B10+B11+B12+B13+B14+B15
d) All of the above options are correct.

2) What does the cell reference: A10:A13 mean?
a) It refers to a range of cells located in column A rows 10 to 13 (inclusive).
b) It refers to two cells located in column A, namely A10 and A13.
c) It refers to a range of cells located in row A, columns 10 to 13 (inclusive).
d) It refers to a range of cells located in column A rows 1 to 10 and 10 to 13 (inclusive).

3) Which of the following option(s) represent the correct formula to multiply two values located in cells A1 and A2 with each other?
a) Entering the formula: =A1xA2
b) Entering the formula:  =MULTIPLY(A1:A2)
c) Entering the formula: =A1*A2
d) All of the above options are correct. 4) Study the orange highlighted cells in the screenshot above.  Which of the following options best represent the cell reference(s) which includes all of the highlighted cells?
a) The reference:  A3:A12
b) The reference: A3:C12
c) The reference: A3:A12, B3:B12, C3:C12
d) The reference: A3:C3

5) Which of the following options does NOT represent a step in using the AutoSum function?
a) Select all the cells you wish to add together.
b) Select non-adjacent cells by holding down the Ctrl key and clicking on cells to include in the formula.
c) Press Enter on your keyboard to accept/finalize the formula and display the result.
d) Press the AutoSum button located under the Formulas tab in the Function Library group.

6) Study the formulas listed below.  Which of the formulas contain an error that will prevent it from working?
a) =Sum(A1, A4)
b) =B26-M13
c) =C4/C1
d) B4=A1+A5 7) Study the screenshot above.  Which of the following options represent what will be displayed in the selected cell (A3) after the Enter key is pressed?
a) The following formula will be displayed in the cell: =A1/A2
b) An error will be displayed in the cell as the formula is incorrect.
c) The following value will be displayed in the cell: 5
d) The following value will be displayed in the cell: 125 8) Study the screenshot above.  What will happen to the formula and/or the result (total) in cell C13 if a value is entered into the highlighted cell (C5)?
a) The total in C13 will automatically update to include the amount entered.
b) Nothing will happen.  The formula will have to be reinserted to include the new value.
c) The formula will return an error message as the numbers that were included in the original formula are not the same any longer.
d) Cell C13 will display the formula instead of the total amount.

9) Is it possible to use Excel as you would a calculator?  For example, what happens if you enter:  =1+10 in a cell?
a) The formula above is incorrect.  It will not return any value.
b) The formula above is incorrect and will return the values of numbers in cells A1 and A10.
c) The formula above is correct and will return the SUM value of cells in A1 to A10.
d) The cell will return the value of 1 plus 10 (i.e. 11) as if you entered it into a calculator. 10) Study the formula in the cell A5 in the screenshot above.  Carefully review the cells included in the formula and the symbols included.  Based on your observations, which of the following options represent the result of this formula?
a) The result will be: 40
b) The result will be: 22
c) The result will be:  0
d) The formula contains errors and will not return any result.