wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction to excel 2010

Total questions: 17

Worksheet time: 9mins

Name
Class
Date
1.

You can activate a cell by

a)

Pressing the Tab key

b)

Clicking the cell

c)

Pressing an arrow key

d)

All of the above

2.

How do you insert a row?

a)

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b)

Select the row heading where you want to insert the new row and select Edit >Row from the menu

c)

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d)

All of the above

3.

Which of the following is not a basic step in creating a worksheet?

a)

Save workbook

b)

Modifiy the worksheet

c)

Enter text and data

d)

Copy the worksheet

4.

To create a formula, you first:

a)

Select the cell you want to place the formula into

b)

Type the equals sign (=) to tell Excel that you’re about to enter a formula

c)

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d)

Choose the new command from the file menu

5.

How do you delete a column?

a)

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b)

Select the column heading you want to delete and select Insert Delete from the menu

c)

Select the row heading you want to delete and select Edit>Delete from the menu

d)

Right click the column heading you want to delete and select delete from the shortcut menu

6.

When a label is too long to fit within a worksheet cell, you typically must

a)

Shorten the label

b)

Increase the column width

c)

Decrease the column width

d)

Adjust the row height

7.

Each excel file is called a workbook because

a)

It can contain text and data

b)

It can be modified

c)

It can contain many sheets including worksheets and chart sheets

d)

You have to work hard to create it

8.

Which of the following methods can not be used to edit the contents of a cell?

a)

Press the Alt key

b)

Clicking the formula bar

c)

Pressing the F2 key

d)

Double clicking the cell

9.

You can edit a cell by

a)

Clicking the formula button

b)

Double clicking the cell to edit it in-place

c)

Selecting Edit>Edit Cell from the menu

d)

None of above

10.

To save a workbook, you:

a)

Click the save button on the standard toolbar from the menu

b)

Press Ctrl+F5

c)

Click Save on the Windows Start button

d)

Select Edit>Save

11.

There are 16,384 rows and 1,048,576 columns in a worksheet.

a)

True

b)

False

12.

Two types of data can be entered in an Excel workbook.

a)

False

b)

True

13.

Data entered in a cell appears in Formula bar as well as in active cell.

a)

True

b)

False

14.

The active cell is not bordered with a black outline.

a)

False

b)

True

15.

keyboard shortcut to select entire worksheet is Ctrl+A

a)

False

b)

True

16.

Press (a)   key on the keyboard for partial modification of data.

17.
a)

Collection of worksheets

b)

Collection of excel files

c)

Collection of cells

d)

Collection of rows & columns

e)

Collection of spreadsheets