wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Intermediate Test 2

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

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

a)

cell

b)

chart

c)

sum

d)

worksheet

2.

A group of cells is called a ________.

a)

chart

b)

cell cluster

c)

multicell

d)

cell range

3.

You can click the tabs at the bottom of a workbook to switch between ________.

a)

permissions

b)

worksheets

c)

formulas

d)

number formats

4.

True or False: You can use the function of daily changeable date by using the Following function =now()

a)

True

b)

False

5.

Which of the formulas below are valid? Select all that apply.

a)

=R2*D2

b)

A3+100

c)

=5B+6B

d)

=F2+F3+F4-53

6.

What are the shortcut keys for Printing?

a)

ALT and S

b)

CTRL and P

c)

ALT and =

d)

CTRL and =

7.

You can link 2 sheets in the same Excel sheet or Outside the Excel sheet file by using the Following Function.

a)

Pivot Table

b)

Hyperlinks

c)

=Now()

d)

Data Validation

8.

What are the keyboard shortcut keys to edit formula in a cell?

a)

F2

b)

F4

c)

CTRL + 1

d)

CTRL + F

9.

What are the keyboard shortcut keys to create a table?

a)

ALT + T

b)

ALT + N + C

c)

ALT + N + V

d)

ALT + N + T

10.

If you want to Merge and Center the Cell, you can select the relevant function below:-

a)

Center

b)

Merge & Center

c)

Bold

d)

Underline

11.

If you want to creat list of Data Validation, You will use the following Function: -

a)

Data Validation

b)

Formating

c)

Painting

d)

Merge and Center

12.

Which button allows you to copy cell formats from one cell to another?

a)

Enter

b)

Autofit

c)

Format painter

d)

Esc

13.

You can complete a cell entry by pressing:

a)

Enter

b)

Tab

c)

Shift+tab

d)

An arrow key

e)

All of above

14.

All formulas in Excel begin with the following symbol.

a)

+

b)

=

c)

/

d)

*

15.

Excel is a program that is used to prepare a

a)

Slide presentation

b)

Spreadsheet

c)

Text document

d)

Database