wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

GRADE 6 EXCEL

Total questions: 20

Worksheet time: 23mins

Name
Class
Date
1.

Which of these is Microsoft Excel?

a)
b)
c)
d)
2.

What is basic file of MS Excel?

a)

Presentation

b)

Spreadsheet

c)

Worksheet

d)

Workbook

3.

Which component of MS Excel displays the address of the active cell?

a)

Formula bar

b)

Name box

c)

Row header

d)

Column header

4.

(a)   allows working with a number of cells at once.

5.

Which option will you click from borders drop-down list to see more borders?

a)

Thick Border

b)

More Borders

c)

Outside Borders

d)

Thick Box Border

6.

What is shortcut to exit Microsoft Excel?

a)

Alt + F1

b)

Alt + F2

c)

Alt + F3

d)

Alt + F4

7.

In your opinion, what is the best application to organise information?

a)

MS Excel

b)

MS PowerPoint

c)

MS Word

d)

Other

8.

To completely change the contents of a cell select the cell & type the new data & press (a)   .

9.

To select all the cells in a worksheet, press _________.

a)

Ctrl + A

b)

Ctrl + B

c)

Ctrl + Z

d)

Ctrl + Z

10.

What is action of Tab key in Excel?

a)

One cell down in the column

b)

Next cell in the row

c)

Previous cell in the row

d)

One cell up in the column

11.
In this diagram what does the selected area represent?
a)
a Row
b)
a Cell
c)
a Column
d)
a Chart
12.
Which of the following is an absolute cell reference?
a)
A2
b)
$A$2
c)
#A#2
d)
A:2
13.
In this example, why does the value in cell G1 look slightly different from the value in the formula bar?
a)
A formula is being used in this cell.
b)
It's using the Currency number format.
c)
It's using the Date number format.
14.
In this diagram the highlighted figure represents:
a)
Cell B10
b)
Row 5
c)
Cell B5
d)
Column B
15.
In this diagram the highlighted area represents:
a)
Columns
b)
a Graph
c)
Rows
d)
a Chart
16.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
17.
In the diagram a row has been selected. If we Insert a new row into the spreadsheet where will the new row appear?
a)
Beneath the heading
b)
Between row 4 and 5
c)
After row 5
d)
After row 6
18.
In the diagram a column has been selected. If we Insert a column into the spreadsheet, where will the new column appear?
a)
To the left of column C
b)
To the left of the selected column
c)
After the Email Address column
d)
To the right of the selected column
19.
What is being adjusted in this diagram?
a)
Cell A1
b)
Font Size
c)
Alginment
d)
Spacing
20.
How would we type the formula to Add the June and July Budgets?
a)
=June+July
b)
=1200+1500
c)
=D10+D11
d)
=C10+C11