wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

YEAR 1 EOTA REVISION QUIZ

Total questions: 69

Worksheet time: 45mins

Name
Class
Date
1.

1.   ___________ is used to type long sentences in capital letters.

a)

Enter

b)

Ctrl

c)

Caps Lock

d)

Shift

2.

There are ______ light indicators on the keyboard.

a)

2

b)

4

c)

5

d)

3

3.

The caps lock light is in the _______ of the light indicator.

a)

Right

b)

Left

c)

Center

d)

Middle

4.

What will happen when the caps lock light is glowing?

a)

Letters will appear in upper case

b)

Letters will appear in lower case

c)

Letters will appear in both upper case and lower case

5.

How many caps lock keys do we have on the keyboard?

a)

1

b)

2

c)

3

d)

4

6.

When the caps lock is on and you press and hold the shift key, your letters will appear in ___

a)

upper case

b)

lower case

c)

both upper and lower case

7.

When naming files what one of these is a DON'T

a)

Use lowercase

b)

Be descriptive

c)

Be consistent

d)

Special Characters !@#$%

e)

Include version numbers

8.

When structuring a design file name which title would be used

a)

Job Number

b)

Project

c)

Client

d)

Version

e)

All of the above

9.

Will you begin to use your own file naming conventions

a)

YES

b)

NO WAY

c)

I HAVE ONE ALREADY

d)

I WILL CREATE MY OWN

10.

What is the shortcut for saving a file?

a)

Ctrl+ S

b)

Ctrl+ P

c)

Ctrl+ W

d)

Ctrl+C

11.

Choose a ___________ that is appropriate to the content of the file.

a)

house name

b)

road name

c)

file name

d)

book name

12.

Which is a Folder?

a)
b)
c)
d)
13.

Which is a Word file?

a)
b)
c)
d)
14.

Which is an Image file?

a)
b)
c)
d)
15.

What is inside this Folder?

a)

Excel file

b)

Word file

c)

Folder

d)

Image file

16.

Organizing your desktop is done when you save related files in one folder.

a)

True

b)

False

17.

If you saved a paint picture, it will be stored in the _______ folder unless you choose another one.

a)

Document

b)

Music

c)

Picture

18.

If you save a WordPad file in will be stored in the ______ folder unless you choose another one.

a)

Music

b)

Document

c)

Picture

19.

It is not easy to copy or move a file from one folder to another.

a)

True

b)

False

20.

The following shows ____________icon.

a)

File

b)

Folder

21.

The following shows ____________icon.

a)

File

b)

Folder

22.

Icon for files that contain __________ .

a)

picture

b)

text

c)

sound

23.

A folder is....

a)

an object that contains data or information

b)

a container that stores books and food

c)

a container that stores files and folders

24.

A file is...

a)

a container that stores file and folders

b)

an object that contains data or information

c)

a container that stores paper

25.

Pictures, Videos, documents, etc.. are all...

a)

folders

b)

subfolders

c)

files

26.

Folders are used to...

a)

organise books

b)

organise files

c)

create a file

27.

When I delete a file or folder, it goes into...

a)

the Desktop folder

b)

the Recycle Bin

c)

the tower case

28.

What is a folder?

a)

an object that contains data or information

b)

a container that can store food

c)

a container that can store hardware components

d)

a container that can store files or folders

29.

Folders are used to...

a)

organise books

b)

create a document

c)

create a presentation

d)

organise files and folders

30.
The intersection of a row and column in a spreadsheet is called a __________.
a)
Cell
b)
Formula
c)
Label
d)
Value
31.
In spreadsheets, columns are marked with _________.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
32.
In spreadsheets, rows are marked with _____.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
33.
All spreadsheet formulas begin with which symbol?
a)
=
b)
^
c)
$
d)
#
34.
Which of the following is an example of a cell reference or cell address?
a)
C
b)
9
c)
B4
d)
=A1+A2
35.
Which symbol on the computer represents the multiplication sign?
a)
/
b)
-
c)
+
d)
*
36.
Which symbol on the computer represents the division sign?
a)
/
b)
-
c)
+
d)
*
37.
What are "words" classified as in a spreadsheet?
a)
values
b)
formulas
c)
labels
d)
cells
38.
What are "numbers" classified as in a spreadsheet?
a)
Labels
b)
Formulas
c)
Values
d)
Cells
39.
Which of the following is an example of a "function"?
a)
=A2 + A5
b)
=B7 * B9
c)
=Sum(C4:C15)
d)
= D3 / D6
40.
What are "formulas" classified as in spreadsheets?
a)
Math problems
b)
Labels
c)
Values
d)
Cells
41.
Is this a formula or a function?
=A1 + B5 + C10
a)
Formula
b)
Function
42.
Is this a formula or a function:
=Avg(C1:M1)
a)
Formula
b)
Function
43.
Is this a formula or a function:
=Sum(B3:B30)
a)
Formula
b)
Function
44.
Is this a formula or a function:
=D7 * E9
a)
Formula
b)
Function
45.
Is this a formula or a function?
=D4 / F8
a)
Formula
b)
Function
46.
Is it a formula or a function:
=Sum(E2:E25)
a)
Formula
b)
Function
47.
Gridlines are gray lines that divide the cells, rows, and columns in a spreadsheet.
a)
True
b)
False
48.
How would a telephone number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
49.
How would someone's social security number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
50.

What are the individual rectangles on a worksheet called?

a)

Rows

b)

Columns

c)

Cells

d)

Formulae

51.

A vertical line of cells in a spreadsheet is a what?

a)

Row

b)

Column

52.

A horizontal line of cells in a spreadsheet is a what?

a)

Row

b)

Column

53.

How are columns labelled on a worksheet?

a)

Letters

b)

Numbers

54.

How are rows labelled on a worksheet?

a)

Letters

b)

Numbers

55.

If you wanted to change the colour of the text inside a cell, which tool would you use?

a)

Text colour

b)

Fill colour

c)

Borders

d)

Bold

56.

If you wanted one cell or a number of cells to stand out from the rest which tool could you use?

a)

Bold

b)

Fill Colour

c)

Currency

d)

Borders

57.

If you wanted to change the size of the text inside a cell which tool would you use?

a)

Cell width

b)

Cell height

c)

Text colour

d)

Font size

58.

Something that automatically calculates something for you using the data in cells is a:

a)

Formula

b)

Formatting

59.

What do all formulae start with in a spreadsheet?

a)

+

b)

/

c)

*

d)

=

60.

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

a)

/

b)

-

c)

+

d)

=

61.

Which mathematical operator (symbol) would you use to divide the values in two cells?

a)

/

b)

-

c)

*

d)

=

62.

Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?

a)

/

b)

-

c)

*

d)

=

63.

Which mathematical operator (symbol) would you use to multiply the values in two cells together?

a)

/

b)

-

c)

*

d)

=

64.

If you wanted to add the values in four consecutive cells together which function would you use?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

65.

What is the cell reference of the cell with value Coca-Cola inside?

a)

A3

b)

3A

c)

C5

d)

D7

66.

What is the cell reference of the cell with value Sprite Lite inside?

a)

8A

b)

C5

c)

A8

d)

B8

67.

To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?

a)

Item

b)

Price

c)

Number Sold

d)

Total

68.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta

a)

£1.25 times 12

b)

C5*D5

c)

=C5*D5

69.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Walkers salt and vinegar.

a)

£0.65 times 23

b)

C10 * D10

c)

=C10 * D10

Similar Resources on Wayground

Компьютерные игры

66 questions

Компьютерные игры

quiz

Worksheet

•

5th Grade - University

Ôn tập IC3 GS6 Level 2 (4)

72 questions

Ôn tập IC3 GS6 Level 2 (4)

quiz

Worksheet

•

6th - 8th Grade

Computer Safety and Security - 2

65 questions

Computer Safety and Security - 2

quiz

Worksheet

•

7th - 8th Grade

Keyboarding Final

66 questions

Keyboarding Final

quiz

Worksheet

•

8th - 9th Grade

Unit 2: Cryptography

64 questions

Unit 2: Cryptography

quiz

Worksheet

•

8th Grade - University

yr8 class

70 questions

yr8 class

quiz

Worksheet

•

8th Grade

Word Processing Vocabulary #2

68 questions

Word Processing Vocabulary #2

quiz

Worksheet

•

6th Grade

INGLES BÁSICO PARA ORDENADORES

68 questions

INGLES BÁSICO PARA ORDENADORES

quiz

Worksheet

•

8th Grade