QUESTION 1

1. The format painter tool will

   		change the color of the cell's background to red
   		change the color of the cell's font to red
   		change the look of the cell contents to match that of another cell
   		change the size of the cell's content to 14pt

2.5 points

QUESTION 2

1. If you place the cursor on column D and insert a column you will have a blank column in column D and the data will shift to the

   		right
   		left
   		top
   		the data will not move

2.5 points

QUESTION 3

1. The formula =(A1*B1) + C3 would be an example of

   		absolute cell referencing
   		relative cell referencing
   		direct cell referencing
   		indirect cell referencing

2.5 points

QUESTION 4

1. The proper way to write the sum formula to add cells A1 to B5 in Excel is

   		=sum(A1B5)
   		=sum(A1 to B5)
   		@sum(A1..B5)
   		=sum(A1:B5)

2.5 points

QUESTION 5

1. Which of the following best describes exponential smoothing?

   		Type of weighted average where smallest weight is given to the most recent observation
   		Type of weighted average where largest weight is given to the most recent observation
   		Type of weighted average where largest weight is given to the oldest observation
   		Type of weighted average where no weight is given to the oldest observation

2.5 points

QUESTION 6

1. The unadjusted cash balance is what the cash balance would be if the firm did not have any short-term borrowing during the month.

   True

   False

2.5 points

QUESTION 7

1. Which of the following functions will calculate an average using criteria?

   		ROW(REFERENCE)
   		AVERAGEIF(RANGE,CRITERIA,AVERAGE_RANGE)
   		SUMROW(RANGE,CRITERIA)
   		AVERAGEIF(REFERENCE)