Microsoft Excel Trivia 3

Question 1

Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?

Accepted Answer

AutoFill

Answer

AutoFill uses the fill handle (small square at the bottom-right of a selection) to extend a series automatically.

Question 2

What is the correct syntax to look up a value in the first column of a table and return a value from another column using VLOOKUP?

Accepted Answer

VLOOKUP(value, table_array, col_index_num, range_lookup)

Answer

VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

Question 3

In Excel, what symbol is used to make a cell reference absolute?

Accepted Answer

$

Answer

The dollar sign ($) locks a row or column reference so it does not change when a formula is copied.

Question 4

What Excel function calculates the internal rate of return for a series of cash flows?

Accepted Answer

IRR

Answer

IRR (Internal Rate of Return) calculates the discount rate that makes the net present value of a series of cash flows equal to zero.

Question 5

Which of the following paste options preserves only the calculated values, not the formulas?

Accepted Answer

Paste Values

Answer

Paste Values (or Paste Special > Values) pastes only the displayed result of a formula, not the formula itself.

Excel Practice Test