wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

EXCEL

Total questions: 40

Worksheet time: 24mins

Name
Class
Date
1.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
2.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
3.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
4.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
5.

How do you always start a formula?

a)

=

b)

,

c)

+

d)

(

6.

How do you always start a function?

a)

,

b)

(

c)

=

d)

SUM

7.

In Excel, what symbol do you use for multiplication?

a)

x

b)

+

c)

/

d)

*

8.

In Excel, what symbol do you use for division?

a)

x

b)

\

c)

/

d)

*

9.

In Excel, where in a cell would you click if you wanted to drag and copy a formula to nearby cells?

a)

top left

b)

top right

c)

bottom right

d)

bottom left

10.

What cell is red?

a)

A1

b)

C1

c)

C4

d)

C5

11.

The arrangement of data in Z to A will arrange the data in __________ order.

a)

Ascending

b)

Descending

12.
An absolute cell reference means the cell value remains constant when copied to another cell or used in a formula.
a)
True
b)
False
13.
A relative cell means that the cell value changes "relative" to the cell in which it is copied.
a)
True
b)
False
14.

error which occurs when the cell reference is not valid

a)

####

b)

#REF!

c)

#NUM!

15.

error which occurs when a misspelling has occurred in a function name

a)

####

b)

#REF!

c)

NAME?

d)

NUM!

16.

error which occurs when the column is not wide enough to display the contents of a cell

a)

####

b)

#REF!

c)

#NAME?

d)

#NUM!

17.

tool which can be used to display only data which meets certain criteria

a)

Merging

b)

Concatenate

c)

Sorting

18.
After a file has been opened, the filename appears in which of the following?
a)
Title bar
b)
footer
c)
header
d)
description pane
19.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
20.
What is made up of spaces that are going across and not up and down?
a)
Column
b)
Cells
c)
Row
21.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
22.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
23.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
24.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
25.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
26.

a)

Title Bar

b)

Name box

c)

Active cell

d)

Ribbon

27.
a)

Title Bar

b)

Ribbon

c)

Active Cell

d)

File Tab

28.

a)

Worksheet Area

b)

Cell Pointer

c)

Formula Bar

d)

Ribbon

29.

a)

Worksheet Area

b)

Quick Access Toolbar

c)

New Sheet Button

d)

Tabs

30.

a)

Name Box

b)

Title Bar

c)

Ribbon

d)

Active Cell

31.

a)

Name Box

b)

Ribbon

c)

Vertical Scroll Bar

d)

File Tab

32.

a)

Pin the Ribbon

b)

Ribbon

c)

Tabs

d)

Status Bar

33.

a)

Vertical Scroll Bar

b)

Horizontal Scroll Bar

c)

Formula Bar

d)

Name Box

34.

a)

Sheets Bar

b)

Status Bar

c)

Vertical Scroll Bar

d)

Horizontal Scroll Bar

35.

a)

Sheets Bar

b)

Status Bar

c)

Vertical Scroll Bar

d)

Horizontal Scroll Bar

36.

a)

Cell

b)

Cell Pointer

c)

Worksheet Area

d)

Blank Page

37.

Identify the MS Excel Window...

a)
b)
c)
d)
38.

A computer application that displays and organizes data is called __________.

a)

PowerPoint Presentation

b)

Publisher

c)

Electronic Spreadsheet

d)

Word

39.

Displays the name or location of the active cell

a)

Formula bar

b)

Name box

c)

Column

d)

Row

40.

La forma correcta de sumar la celda A2 y la celda B2 utilizando una función es:

a)

=SUMA(A2*B2)

b)

=A2+B2

c)

=SUMA(A2;B2)

d)

=SUMA(A2:B2)

Similar Resources on Wayground

Câu hỏi ôn tập môn Tin học HK1 - Lớp 5

37 questions

Câu hỏi ôn tập môn Tin học HK1 - Lớp 5

quiz

Worksheet

•

5th Grade - University

UHA 9 DSI_2025_FN@

40 questions

UHA 9 DSI_2025_FN@

quiz

Worksheet

•

6th - 8th Grade

KT GIỮA HK2 TIN 6

40 questions

KT GIỮA HK2 TIN 6

quiz

Worksheet

•

6th Grade

KUIZ ICTL TING 2 2017

40 questions

KUIZ ICTL TING 2 2017

quiz

Worksheet

•

6th - 12th Grade

M1 2nd Term FINAL TEST 2020

45 questions

M1 2nd Term FINAL TEST 2020

quiz

Worksheet

•

6th Grade

ซอฟแวร์ (Software)

35 questions

ซอฟแวร์ (Software)

quiz

Worksheet

•

2nd Grade - University

Kuiz Komputer Online

40 questions

Kuiz Komputer Online

quiz

Worksheet

•

6th - 10th Grade

ĐỀ CƯƠNG ÔN TẬP CUỐI HK1 - TIN HỌC 6

45 questions

ĐỀ CƯƠNG ÔN TẬP CUỐI HK1 - TIN HỌC 6

quiz

Worksheet

•

6th Grade