Font size
WorksheetsICT 5 s2 revision
Total questions: 125
Worksheet time: 2hrs 31mins
The letters in Excel represent the _______?
columns
rows
data
functions
The numbers in Excel represent the _____?
columns
rows
data
functions
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.
Row Bars
Column Bars
Scroll Bars
Home Bars
What does the indicated icon do in the red box?
Apply underline
Apply italic
Make text bigger
Apply bold
Identify the Excel Icon.
An Excel file is generally called a / an :
E-Spreadsheet
Woorksheet
Workbook
Sheet
1) Which cell is selected in this picture?
B2
B3
C3
m3
1) Which formula should I use for
addition (5+2)?
A5+B2=
5+2
=C2+C3
1) Which formula should I use for multiplication (5 x 2)?
=C2*C3
5 x 2
5 x 2 =
Which formula should I use for subtraction (5 – 2)?
=5–2
=C2-C3
C2 – C3=
Which formula should I use for division (5 ÷ 2)?
=5/2
5÷2
=2÷5
What is Data?
The name for information that we type into the computer
The graph we put into the spreadsheet.
The cell reference
The first cell in excel.
1A
1
A1
A
What is this?
Ribbon
Column
Row
Worksheets
What is this?
Cell
Formula Bar
Tell Me Search Window
Name Box
Identify the name of the cell that has 2000.
(a)
Identify what we have in cell A2
(a)
Identify what we have in cell A5
(a)
1) Which cell is selected in this picture?
(a)
1) A Row goes…
across
down
cross
A Column goes…
across
down
cross
What are Value?
The words in a spreadsheet.
The numbers in a spreadsheet.
The words and the numbers in a spreadsheet.
What is the difference between a worksheet and a workbook?
A worksheet is a workbook within a workbook
A worksheet is a sheet within a workbook
A worksheet has to be inserted into a workbook
A worksheet is part of the cells in a workbook
How do you know a range of cells is active?
It is highlighted on the screen
It has a marquee around it
The data changes to bold to let me know it is active
I'm psychic and I just know!
True or False : A3 is an example of a cell's address
(a)
True or False : A formula is a combination of numbers and symbols used for calculations
(a)
What are labels?
The words in a spreadsheet
The number in a spreadsheet
The words and number in a spreadsheet
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Rows and columns in Excel create a _______.
Grid
Chart
Column
Box
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
What are Value?
The words in a spreadsheet.
The numbers in a spreadsheet.
The words and the numbers in a spreadsheet.
What is this?
Formula Bar
Cell
Row
Zoom Slider
What is this?
Formula Bar
Column
Active Cell
Zoom Slider
What is this?
Tell Me Search window
Worksheets
Excel Ribbon
Formula Bar
True or False : Rows are always numbered - 123
(a)
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
These are known as
workbooks
worksheets
formula bar
cell
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
Microsoft program that allows you to create and make a presentation is called as .............................
MS PowerPoint
MS Word
MS Excel
MS Paint
Which is the MS PowerPoint application logo?
MS PowerPoint Presentation consists of ....................
Pages
Worksheets
Slides
The ribbon consists of two parts: tabs and groups.
True
False
Which one of the programs below is the PowerPoint presentation?
You can create only 9 slides in a presentation.
True
False
In which group of the Insert Tab does shapes fall in?
Images
Text
Illustrations
To add a theme to the slide, you will click ______________________ tab.
Insert
Home
Design
_______________ key is used to stop the slide show.
Ctrl
Alt
ESC
We use PowerPoint to
Draw.
Create presentations.
To remove a slide, simply click on the slide than hit the __________ button on the keyboard.
Tab
Space Bar
Delete
Special effects used to introduce slides in a presentation are called
effects
custom animations
transitions
present animations
What does the button that is being pointed to let you do?
Change the size
Change the font
Add a new slide
Insert a picture
______________ is the shortcut to paste an object.
Ctrl + C
Ctrl + X
Ctrl + S
Ctrl + V
What is the file extension of the power point file?
Docx
Pptx
gif
What do you call a software application used to access and view web pages?
search engine
web browser
internet
none of the above
It is a global network of billions of computers and other electronic devices.
search engine
internet
web browser
all of the above
The primary means of online communication is
Texting
All of these are examples of social network sites EXCEPT
Yahoo
URL stands for
unified random location
united relay locator
uniform resource locator
unique research lab
What is the World Web usually called for short?
surfing
web
browsing
Internet
What browser is this the icon of?
Internet Explorer
Google Chrome
Mozilla Firefox
Safari
What browser is this the icon of?
Internet Explorer
Google Chrome
Mozilla Firefox
Safari
Which of these is not a search engine?
Yahoo
Explorer
Ask
Is considered as top 1 web browser?
Internet Explorer
Google Chrome
Mozilla Firefox
Safari
What the Internet stands for?
(a)
What was the Internet called before it was called the Internet?
(a)
Email stands for _________ mail.
electronic
electric
Internet
Match the icons to their proper names.
Chrome
Firefox
Gmail
Windows
YouTube
Live communication between two or more people at two or more geographically distant places via audio & video transmission.
Online chatting
Blogging
Video Conferencing
A term used for building relations with people through the medium of Internet.
Globalization
Socialization
Social Networking
News Group
What was the name of the first network connection?
ANREPTA
APARNET
NETARPA
ARPANET
The World Wide Web (also known as web) is a collection of billions of interlinked webpages.
TRUE
FALSE
Internet is a means of linking computers anywhere in the globe through telephone lines, servers, and routers.
TRUE
FALSE
Internet means _________________________
Global network of computers
Connection
Wifi
Electricity
Which of these are uses of internet?
To chat
To sweep
To dance
To drive
A secret word used to unlock a device is called ______________
Password
Key
Username
Which of these is NOT a machine that can connect to the internet?
Laptop
Ipad
Smart Phone
Microwave Oven
we can use the internet for business like online promotion, marketing, advertising services through websites
TRUE
FALSE
we can use the internet for entertainment like watching videos online, playing online games, listenig to music and videos and downloading files
TRUE
FALSE
we can use the internet for online communications like email, messaging, chat and video calls.
TRUE
FALSE
The name of this character is ?
cat
mouse
sprite
The Instructions used to control sprite in scratch is called ?
command
stage
script
backpack
where are the instruction blocks stored in scratch screen ?
stage
blocks palette
help tab
costume tab
What happens when the green flag is clicked is Scratch program?
The program stops
the program starts
the program Freeze
the program is deleted
scratch is -----------
programming Language
Computer project
A computer screen
A website
Scratch is----------
Text-base Programming
Block-Base Visual programming Language
The Scratch interface three main sections is ?
Stage, character & sprite List
Sprite , help and sprite
Stage, Script & blocks palette
to Moves sprites, changes angles and position we should use ---------------
Motion
Looks
Sound
Events
we use ------------- for Event handlers
Sensing
Control
Variables
Event
by Sensing the sprite can
Controls the visuals
interact with the surroundings
Plays audio files and effects
Operators in scratch is used for ---------
Moves sprites
change location
Sprite interaction
Mathematical operators
With Scratch, you can program your own interactive stories
Yes
No
we can use variable to store
Data
operations
movement
control
when you create a game in scratch you can keep the score in
event
Variable
If I want to move the sprite to the right, which set of blocks would I need?
Which category does the following blocks belong to?
What will happen when the green flag is clicked
the sprite will rotate 15 times
the sprite will rotate 10 times
the sprite will move 15 spaces
the sprite will move 10 spaces
What does this block do?
Repeat the code forever
Repeat the code 2 times
Repeat the code until touching the sprite
What will happen when you run this code?
Bounce everywhere
Add background music
Change scene
Play a beat
Say something
What will happen when you run this code?
Change color
Grow and shrink
Spin
Bounce
What will happen when you run this code?
Change color
Grow and shrink
Spin
Bounce
What will happen when you run this code?
Change color
Grow and shrink
Spin
Bounce
What will happen when you run this code?
Change color
Grow and shrink
Spin
Bounce
The blocks don't need to be joined, as long as they are on the script area, they will run.
True
False
What is the definition of an Algorithm?
A question to be answered
A set of instructions to perform a process.
A list of instructions
The answer to a question
Which of the following symbols means "greater than"?
<
**
/
>
