wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MS Excel (G7)

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.
A row is...
a)
cells that run horizontally
b)
cells that run vertically
c)
cells that run diagonally
2.
A column is...
a)
cells that run horizontally
b)
cells that run vertically
c)
cells that run diagonally
3.
A formula allows you...
a)
to paste a picture
b)
color a cell
c)
to quickly make calculations 
4.
A graph show you...
a)
a graphical representation of data
b)
collection of spreadsheets
c)
intersection of a row & a column
5.
The space on the spreadsheet where a column and a row intersect:
a)
cell
b)
name box
c)
entry bar
d)
none of the above
6.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
7.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

8.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

9.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

10.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

11.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

12.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

13.

When you open Excel you are viewing Excel in the ____ View?

a)

Backstage

b)

Frontstage

c)

Spreadsheet

d)

Template

14.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

15.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

16.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

17.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
18.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
19.
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 
20.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
21.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
22.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
23.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
24.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
25.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
26.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
27.
What setting do you use to format numbers as dollar amounts
a)
Accounting
b)
Currency
c)
Accounting and Currency
28.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
29.
Can you format text with Excel
a)
Yes
b)
No
30.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
31.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
32.
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
33.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
34.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
35.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

36.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
37.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
38.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
39.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
40.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums 
41.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
42.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
43.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
44.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
45.
You can do other functions (besides addition) with the auto sum button ∑ such as average, max, min
a)
True
b)
False
46.
You can use the Auto Sum Key ∑ to subtract numbers.
a)
True
b)
False
47.

The function that lets you add up a range of cells or values

a)

AVERAGE

b)

SUM

c)

MIN

d)

MAX

48.

What function was used to find the highest data ?

a)

AVERAGE

b)

MIN

c)

SUM

d)

MAX

49.

What function was used to find the lowest data ?

a)

AVERAGE

b)

MIN

c)

MAX

d)

SUM

50.

The function COUNT is specific for _________________

a)

Counting cells

b)

Counting text

c)

Counting number

d)

Counting tables

Similar Resources on Wayground

T.L.E. PERIODIC TEST CARPENTRY 7/8

52 questions

T.L.E. PERIODIC TEST CARPENTRY 7/8

quiz

Worksheet

•

7th Grade

Funciones excel

49 questions

Funciones excel

quiz

Worksheet

•

KG - 11th Grade

SAS GANJIL INFORMATIKA VIII 2025/2026

50 questions

SAS GANJIL INFORMATIKA VIII 2025/2026

quiz

Worksheet

•

7th Grade

Gravity Basics

50 questions

Gravity Basics

quiz

Worksheet

•

7th Grade

Soal PTS INFORMATIKA

53 questions

Soal PTS INFORMATIKA

quiz

Worksheet

•

7th Grade

Airplane Basics

50 questions

Airplane Basics

quiz

Worksheet

•

7th - 8th Grade

IDN ACE Test 1

50 questions

IDN ACE Test 1

quiz

Worksheet

•

1st - 10th Grade