Microsoft Excel Questions And Answers 1

Question 1

What is the keyboard shortcut to insert the current date in an Excel cell?

Accepted Answer

Ctrl + ; (semicolon)

Answer

Ctrl + ; inserts the current date as a static value into the active cell. It does not update automatically like the TODAY() function would.

Question 2

Which function in Excel returns the number of cells in a range that contain numeric values?

Accepted Answer

COUNT

Answer

COUNT counts only cells that contain numbers. COUNTA counts all non-empty cells regardless of data type, while COUNTIF counts cells meeting a specific condition.

Question 3

What does the $ symbol do when placed before a column letter or row number in a cell reference, such as $A$1?

Accepted Answer

It makes the reference absolute so it does not change when copied

Answer

The $ sign makes a cell reference absolute, meaning the row, column, or both remain fixed when the formula is copied to other cells. Without it, references are relative and shift automatically.

Question 4

Which Excel feature automatically completes a data entry based on values already in the same column?

Accepted Answer

AutoComplete

Answer

AutoComplete suggests the rest of a text entry based on existing entries in the column. Flash Fill recognizes patterns to fill a series, while AutoFill extends a series by dragging the fill handle.

Question 5

What is the purpose of the VLOOKUP function in Excel?

Accepted Answer

To search for a value in the leftmost column of a table and return a value in the same row from a specified column

Answer

VLOOKUP (Vertical Lookup) searches the first column of a range for a match and returns a value from a specified column in the same row. The 'V' stands for vertical, meaning it searches down a column.

Excel Practice Test

Excel Practice Test

Microsoft Excel Questions And Answers 1