NEW
Font size
S
M
L
XL
WorksheetsYr7 All Saints Exam Mon
Total questions: 24
Worksheet time: 23mins
Name
Class
Date
1.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
reference
d)
cell
2.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
3.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
4.
When you write a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equals Sign
c)
Addition sign
d)
Division sign
5.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
6.
A spreadsheet is made of cells organised into horizontal rows and vertical?
a)
Columns
b)
Fields
c)
Records
d)
Blocks
7.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
8.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1-A6)
9.
What do you call the list of commands in Scratch?
a)
Sprite
b)
Scripts
c)
Scratch
d)
Help
10.
What do you call the characters in Scratch?
a)
Sprites
b)
Script
c)
Scratch
d)
Sprite Scripts
11.
Where do you find the images of characters on Scratch?
a)
Costumes
b)
Backdrop
c)
Gallery
d)
Script
12.
What does this code do?
a)
Makes the character spin
b)
Makes the ball bounce
c)
Start the game
d)
Adds a sprite
13.
Which direction does this script make the character go?
a)
Go Up
b)
Go Down
c)
Go Left
d)
Go Right
14.
Special effects used to introduce slides in a presentation are called
a)
effects
b)
custom animations
c)
transitions
d)
present animations
15.
A predefined set of colors, fonts, line and fill effects, and other formats that can be applied to your presentation
a)
Theme
b)
Theme Fonts
c)
Theme Effects
d)
Theme Presentation
16.
What will this button do?
a)
make a bulleted list
b)
make a numbered list
c)
indent text
d)
nothing
17.
What will this button do in PPT?
a)
Provide slide show options
b)
Allow me to rehearse timings
c)
Start the slide show
d)
Record my slide show
18.
If you want text and images to move on your slide use _____________.
a)
Animations
b)
Transitions
c)
Designs
d)
Styles
19.
What is this tool called?
a)
Quick Selection Tool
b)
Rectangular Marquee Tool
c)
Lasso Tool
d)
Move Tool
20.
What is this tool called?
a)
Magic Wand Tool
b)
Quick Selection Tool
c)
Move Tool
d)
Lasso Tool
21.
What does a gray and white checkerboard background mean?
a)
The image is broken.
b)
The background is gray and white.
c)
The background is transparent.
d)
The image will display a white box around it.
22.
A photo file type is
a)
.jpeg
b)
.mp3
c)
.doc
d)
.mov
23.
When you don't want something selected, you click this.
a)
Gradient
b)
Selection
c)
Deselect
d)
Pixels
24.
What can you do with this tool?
a)
Change the color of an object
b)
Select an object
c)
Change how transparent an object is
d)
Remove the background
Reset
