wayground logo

Bảng tính có thể in miễn phí

MỚI

Cỡ chữ

S
M
L
XL
bảng tính

P4 MICROSOFT EXCEL QUIZ 1

Total câu hỏi: 21

Worksheet time: 20mins

Tên
Lớp học
Ngày
1.

A cell is a...

a)

area where columns and rows intersect

b)

grid made of columns and rows

2.

How are rows designated?

a)

By numbers

b)

By letters

3.

The highlighted region of the picture below is a:

a)

row

b)

column

c)

label

d)

sheet

4.

How are columns designated?

a)

By numbers

b)

By letters

5.

The highlighted region of the picture below is a ...

a)

column

b)

row

c)

label

d)

sheet

6.

The highlighted region of the picture below is a:

a)

Active Cell

b)

Cell Name

7.

In a cell reference, for example A1, what does the letter refer to?

a)

The row the cell is in

b)

The column the cell is in

8.

Which of the following tasks would a spreadsheet be best used for?

a)

Keep track of money you have

b)

Creating posters and flyers

9.

What is the name of this cell?

a)

D1

b)

1D

c)

DD

d)

11

10.

In a cell reference, for example D23, what does the number refer to?

a)

The row the cell is in

b)

The column the cell is in

11.

What is a value?

a)

text or a word in a spreadsheet

b)

a number and a calculation in a spreadsheet

12.

What is a label?

a)

text or a word in a spreadsheet

b)

a number and a calculation in a spreadsheet

13.

What is the label in this active cell?

a)

ABC

b)

DEF

c)

GHI

14.

What tool is in number 3?

a)
b)
c)
d)
15.

What tool is in number 6?

a)

Copy

b)

Center

c)

Font

d)

Wrap text

16.

What tool is in number 2?

a)

Picture

b)

Chart

c)

Table

17.

What tool is in number 3?

a)
b)
c)
18.

What tool is in number 1?

a)

Font

b)

Copy

c)

Center

d)

Paste

19.

In Excel, all FORMULAS must begin with what symbol?

a)

@

b)

-

c)

+

d)

=

20.

What function can be used to find a total number in a range of numbers?

a)

+

b)

ADD

c)

SUM

21.

=C5-C1 is a ...

a)

range

b)

cell

c)

formula