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 + Shift + D

Answer

Ctrl + D

Answer

Alt + T

Question 2

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

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

SUM

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

It formats the cell as currency

Answer

It protects the cell from editing

Answer

It links the cell to an external workbook

Question 4

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

Accepted Answer

AutoComplete

Answer

Flash Fill

Answer

AutoFill

Answer

Data Validation

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

To sort a column of values vertically

Answer

To count the number of rows in a dataset

Answer

To merge two columns of data into one

Question 6

How do you quickly apply the same formula to an entire column in Excel without typing it in each cell?

Accepted Answer

Double-click the fill handle of the cell containing the formula

Answer

Press Ctrl + C then Ctrl + V across all cells

Answer

Right-click and select 'Broadcast Formula'

Answer

Use the Merge Cells option under Format