wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 7 term 2 revision excel

Total questions: 75

Worksheet time: 40mins

Name
Class
Date
1.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
2.
_____ are vertical. 
a)
Rows
b)
Columns
3.
________ are horizontal
a)
Rows
b)
Columns
4.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
5.
_____ are vertical. 
a)
Rows
b)
Columns
6.
________ are horizontal
a)
Rows
b)
Columns
7.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
8.

Identify the name of the software

a)

MS Excel

b)

MS Word

9.

A blank sheet in a MS Excel is known as -----------

a)

canvas

b)

document

c)

spreadsheet

10.

Each cell has a different name.

a)

true

b)

false

11.

Identify the name of the cell

a)

A3

b)

B3

c)

C3

12.

Identify the name of the red cell

a)

A11

b)

A10

c)

A12

13.

__________ run from left to right and are identified by numbers.

a)

Rows

b)

Columns

c)

Worksheets

d)

Files

14.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
15.

Which of the images below represent Microsoft Excel work environment ?

a)
b)
c)
d)
16.
How are rows designated?
a)
Circles
b)
Letters
c)
Numbers
d)
Stars
17.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
18.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
19.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
20.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
21.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

22.

..................... are vertical

a)
Columns
b)
Rows
23.

......................... are horizontal

a)
Rows
b)
Columns
24.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
25.
What is the Formula sign for multiply? 
a)
\
b)
*
26.
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
27.

In Excel rows are labeled by

a)

Letters

b)

Numbers

28.

In Excel, columns are labeled by?

a)

Numbers

b)

Letters

29.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

30.

Excel would be the ideal program to type a book report?

a)

False

b)

True

31.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

32.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
33.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
34.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
35.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
36.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
37.
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 
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.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
43.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
44.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
45.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
46.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
47.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
48.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
49.

In an excel formula it means divide

a)

/

b)

*

c)

-

d)

+

50.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
51.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
52.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
53.

The program that we use to create spreadsheets

a)

MS Word

b)

MS Paint

c)

MS Excel

54.

MS Excel?

a)
b)
c)
d)
55.

What is this?

a)

A document

b)

A spreadsheet

c)

I don't know :D

56.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

57.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

58.
a)

Spreadsheet

b)

Cell

c)

Column headings

d)

Row headings

59.
a)

Spreadsheet

b)

Cell

c)

Column

d)

Row

60.
a)

Spreadsheet

b)

Cell

c)

Column headings

d)

Row headings

61.

What is "A1"?

a)

Cell address

b)

Cell letter

c)

Cell number

62.

Which one is a correct cell address?

a)

A1

b)

1A

c)

A

d)

1

63.

What is the cell address of the black cell?

a)

A1

b)

1A

c)

D3

d)

3D

64.

What is the cell address of the pink cell?

a)

A1

b)

1A

c)

D3

d)

3D

65.

What is the cell address of the red cell?

a)

A1

b)

1A

c)

C3

d)

3C

66.

What is the cell address of the red cell?

a)

F6

b)

6F

c)

E6

d)

F7

67.

What is the cell address of the red cell?

a)

D7

b)

7D

c)

E7

d)

D8

68.

What is the cell address of the red cell?

a)

G3

b)

3G

c)

H3

d)

G4

69.

What is the cell address of the red cell?

a)

B9

b)

9B

c)

C9

d)

B10

70.

=C4+C5

What is the result?

a)

32

b)

12

c)

17

71.

What excel function calculates the sum of values?

(a)  

72.

True or False:


The IF function tests for a true or false condition and then returns one value or another.

a)

True

b)

False

73.

Counts the number of cells in a range that match a

criteria

a)

COUNTIF

b)

SUMIF

c)

AVERAGEIF

74.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
75.

Which arithmetic operator is being used in the following formula: =T75- AA45

a)

addition

b)

multiplication

c)

subtraction

d)

format

Similar Resources on Wayground

Input/Output

75 questions

Input/Output

quiz

Worksheet

•

6th - 8th Grade

VTI - Network

70 questions

VTI - Network

quiz

Worksheet

•

6th - 8th Grade

TKJ_

80 questions

TKJ_

quiz

Worksheet

•

1st - 10th Grade

5.0 - Standard Camp Final

75 questions

5.0 - Standard Camp Final

quiz

Worksheet

•

6th - 12th Grade

Technology Exam Review

71 questions

Technology Exam Review

quiz

Worksheet

•

6th - 8th Grade

Computer architectuur

72 questions

Computer architectuur

quiz

Worksheet

•

5th - 12th Grade

latihan soal kelas 7 TIK semester 1 2022

70 questions

latihan soal kelas 7 TIK semester 1 2022

quiz

Worksheet

•

7th Grade

KS3 EOU Hardware Test

79 questions

KS3 EOU Hardware Test

quiz

Worksheet

•

7th - 11th Grade