Imprimer Test: Excel Quiz ()

1.

What is the file extension for an Excel workbook?

A.

.pdf

B.

.xlsx

C.

.pptx

D.

.docx

2.

Which function is used to find the highest value in a range?

A.

SUM

B.

MAX

C.

AVERAGE

D.

COUNT

3.

What is the shortcut to insert a new worksheet in Excel?

A.

Shift + F11

B.

Ctrl + Shift + N

C.

Alt + Shift + F1

D.

Ctrl + N

4.

What does the VLOOKUP function do?

A.

Calculates the average of a range of cells

B.

Counts the number of cells that contain numbers

C.

Multiplies the values in a range of cells

D.

Searches for a value in the first column of a table and returns a value in the same row from a specified column

5.

Which chart type is best suited for comparing values over time?

A.

Scatter plot

B.

Pie chart

C.

Bar chart

D.

Line chart