wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

TLE_ICT 6

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.
Sum, average, count, and maximum value are examples of what?
a)
Formulas
b)
Calculations
c)
Functions
d)
Spreadsheet Data
2.
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
a)
Formulas
b)
Conditional Formatting
c)
Functions
d)
Spreadsheet Data
3.
What symbol is used to begin a formula?
a)
+
b)
=
c)
-
d)
>
4.
Which of the following formulas show the correct use of the SUM function?
a)
-SUM(G3-G10)
b)
=SUM(G3...G10)
c)
=SUM(G3:G10)
d)
+SUM(G3:G10)
5.
What result does the COUNT function show?
a)
Total number of cells containing data in the selected range
b)
Total number of cells containing numbers in the selected range
c)
Total number of cells containing text only in the selected range
d)
Total number of cells containing the TRUE value specified in a logic test
6.
What character is used in a spreadsheet formula to represent multiplication?
a)
/
b)
^
c)
*
d)
=
7.
Which of the following formulas shows the correct use of the AVERAGE function?
a)
=AVERAGE(L3..L10)
b)
=(AVERAGE(L3:L10))/7
c)
=AVERAGE(L3:L10)
d)
+AVERAGE(L3;L10)
8.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
9.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
10.
This function determines the average of the range of cells 
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
11.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
12.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
13.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
14.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
15.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
16.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
17.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
18.

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.

19.

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.

20.

What is a method of communication between two persons with personal computers who are both connected online through the Internet?

a)

E-Groups

b)

Audio Visual Conference

c)

Multimedia Conference

d)

Audio-Video Conferencing

21.

All are requirements for audio-video conferencing EXCEPT _________.

a)

Internet Access

b)

Personal Computer

c)

Smart Phones

d)

Web Camera

e)

Microphone

22.

What is an electronic communications network for the interconnection of computers to access different websites?

a)

Wi-Fi

b)

Bluetooth

c)

Internet

d)

Broadband

23.
What do you call a video blog?
a)
video blog
b)
blog
c)
vlog
d)
YouTube
24.

An example of blogging platform is ___________ .

a)

google.com

b)

microsoft.com

c)

blogger.com

d)

website.com

25.
a)
Safari
b)
Internet Explorer
c)
Mozilla Firefox
d)
Chrome

Similar Resources on Wayground

Lab Safety Test: Cyber Foundations2 _Coach Aaron

22 questions

Lab Safety Test: Cyber Foundations2 _Coach Aaron

quiz

Worksheet

•

6th - 12th Grade

Saks Final Exam - Returns

20 questions

Saks Final Exam - Returns

quiz

Worksheet

•

5th Grade

TLE 6 :Buy and Sell Products Based on Needs

20 questions

TLE 6 :Buy and Sell Products Based on Needs

quiz

Worksheet

•

6th Grade

Using Google Applications

20 questions

Using Google Applications

quiz

Worksheet

•

5th - 7th Grade

STEM Career quiz

20 questions

STEM Career quiz

quiz

Worksheet

•

6th - 8th Grade

Invention/Innovation/Shark Tank Vocabulary

20 questions

Invention/Innovation/Shark Tank Vocabulary

quiz

Worksheet

•

6th - 8th Grade

HTML Basics

20 questions

HTML Basics

quiz

Worksheet

•

6th - 8th Grade

Cars

20 questions

Cars

quiz

Worksheet

•

5th - 12th Grade