Test Content

1. 
   
   Question 1

   2 PointsIf a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.

   1. calculation
   2. date
   3. error
   4. none of the above

2. 
   
   Question 2

   2 PointsIn a spreadsheet a number such as “12” entered into a cell represents a ____.

   1. calculated value
   2. submenu
   3. numeric value
   4. text label

3. 
   
   Question 3

   2 PointsThe Excel operator for exponent is ____.

   1. *
   2. /
   3. ^
   4. &

4. 
   
   Question 4

   2 PointsIf 5% is displayed in a cell, the actual value that is stored is ____.

   1. .005
   2. .05
   3. .5
   4. 5

5. 
   
   Question 5

   2 PointsIf a column shows the numbers 1, 2, and 3 and also the SUM equaling 6, the number “6” is a(n) ____.

   1. calculated value
   2. numeric value
   3. text label
   4. submenu

6. 
   
   Question 6

   2 PointsWhen the formulas are displayed, the worksheet column widths and formats ____.

   1. do not change
   2. are modified to accommodate the display
   3. default to a standard format
   4. all of the above

7. 
   
   Question 7

   2 Points____ is(are) second in the order of precedence rules.

   1. Addition and subtraction from left to right
   2. Exponentiation
   3. Multiplication and division from left to right
   4. Operations in parentheses

8. 
   
   Question 8

   2 PointsTwo cell references separated by a colon is referred to as a ____.

   1. cell format
   2. cell group
   3. cell range
   4. cell block

9. 
   
   Question 9

   2 PointsThe function inputs are referred to as ____.

   1. lists
   2. data
   3. arguments
   4. syntax

10. 
    
    Question 10

    2 PointsB3:D7 represents ____.

    1. noncontiguous cells and or constants
    2. a range along a column
    3. a range along a row
    4. a two-dimensional range or a block of cells