wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Emp. Tech. 12 - Intro to MS Excel Quiz

Total questions: 15

Worksheet time: 75secs

Name
Class
Date
1.

How many rows are there in Excel 2007 and later versions?

a)

65536

b)

1048576

c)

16384

d)

32768

2.

What is a cell in an Excel spreadsheet?

a)

The intersection of a row and a column

b)

A formula

c)

A single column

d)

A single row

3.

What does a cell reference help identify?

a)

The color of the cell

b)

The size of the cell

c)

The font style

d)

The location of the cell in formulas

4.

Which tab in Excel provides basic editing facilities?

a)

View Tab

b)

Insert Tab

c)

Home Tab

d)

Data Tab

5.

What is the function of the Data Tab?

a)

To insert images

b)

To perform operations on data sets

c)

To manage the view of the workbook

d)

To protect the workbook

6.

What is the purpose of the Insert Tab in Excel?

a)

To check spelling

b)

To insert tables and charts

c)

To change the font

d)

To save the workbook

7.

What is MS Excel primarily used for?

a)

Writing code

b)

Editing images

c)

Organizing data

d)

Creating presentations

8.

How can you create a new spreadsheet in Excel?

a)

By right-clicking on the desktop

b)

By using the Ctrl+N shortcut

c)

By clicking on a button in the lowermost pane

d)

By clicking on the File tab

9.

What is the first step to open an existing worksheet?

a)

Open the Control Panel

b)

Right-click on the desktop

c)

Click on the name of the current sheet

d)

Click on the Office Button

10.

Which shortcut is used to save a workbook?

a)

Ctrl+S

b)

Ctrl+O

c)

Ctrl+N

d)

Ctrl+P

11.

What mathematical symbol should comes first when making a formula?

a)

parenthesis

b)

equal

c)

ampersand

d)

asterisk

12.

What does the Review tab allow you to do?

a)

Insert charts

b)

Check spelling and protect the workbook

c)

Change the font size

d)

Manage the view of the workbook

13.

What is the purpose of the View tab?

a)

To create new sheets

b)

To perform calculations

c)

To manage the workbook's appearance

d)

To insert images

14.

What is an Absolute reference in Excel?

a)

A reference to another workbook

b)

A fixed reference that does not change

c)

A reference to a cell in the same worksheet

d)

A reference that changes when copied

15.

What does Ctrl+C do in Excel?

a)

Cuts the selected cells

b)

Copies the selected cells

c)

Saves the workbook

d)

Pastes the copied cells