Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel Quiz

Total questions: 20

Worksheet time: 7mins

Name
Class
Date
1.

Microsoft Excel is mainly used for ________.

a)

Creating text documents

b)

Managing and analyzing numerical data

c)

Designing presentations

d)

Drawing graphics

2.

The intersection of a row and a column in Excel is called a ________.

a)

Table

b)

Field

c)

Cell

d)

Grid

3.

In Excel, columns are labeled with ________.

a)

Numbers

b)

Letters

c)

Symbols

d)

Words

4.

Rows in Excel are labeled with ________.

a)

Numbers

b)

Letters

c)

Words

d)

Dates

5.

The **active cell** in Excel is identified by ________.

a)

A bold border around it

b)

A red highlight

c)

A gray shade

d)

A blinking cursor

6.

Which of the following is the **cell address** for the intersection of column B and row 5?

a)

5B

b)

B5

c)

Row5B

d)

B-5

7.

Which tab on the Ribbon contains tools for copying, cutting, and pasting data?

a)

Home

b)

Insert

c)

Page Layout

d)

Data

8.

To select an entire column, click on ________.

a)

The column letter

b)

Any cell in that column

c)

The first cell of the column

d)

The row number

9.

To select an entire row, click on ________.

a)

The row number

b)

The first cell in that row

c)

The column letter

d)

The Name Box

10.

Which command is used to quickly copy the contents of one cell to another?

a)

Delete

b)

Copy and Paste

c)

Move

d)

Shift

11.

To make text **bold** in Excel, you can use the shortcut ________.

a)

Ctrl + I

b)

Ctrl + U

c)

Ctrl + B

d)

Ctrl + E

12.

You can change the **font size and color** using the options found on the ________ tab.

a)

Insert

b)

Home

c)

Page Layout

d)

Review

13.

Which alignment option places text evenly between the left and right sides of a cell?

a)

Left Align

b)

Right Align

c)

Center

d)

Justify

14.

The **Merge & Center** button is used to ________.

a)

Add a border

b)

Combine several cells into one and center the text

c)

Split cells

d)

Create a table

15.

To add a **border** around selected cells, you use the Border button found on the ________ tab.

a)

Insert

b)

Home

c)

Formulas

d)

View

16.

Formulas in Excel always begin with a ________.

a)

+ (plus sign)

b)

= (equal sign)

c)

- (minus sign)

d)

* (asterisk)

17.

What will the formula `=A1+B1` do?

a)

Add the values in cells A1 and B1

b)

Multiply the values in A1 and B1

c)

Subtract B1 from A1

d)

Divide A1 by B1

18.

Which of the following is the correct syntax for the **SUM** function?

a)

=SUM(A1, A5)

b)

SUM=A1:A5

c)

=SUM(A1:A5)

d)

=ADD(A1:A5)

19.

The **SUM** function is used to ________.

a)

Calculate the total of selected cells

b)

Count the number of cells

c)

Find the average value

d)

Sort data in ascending order

20.

You can use the **AutoSum** button (Σ) to quickly ________.

a)

Sort data alphabetically

b)

Add a group of numbers

c)

Merge cells

d)

Format a table