Font size
WorksheetsWorksheet Questions Extraction
Total questions: 38
Worksheet time: 13mins
What is a workbook, and how is it different from a worksheet in spreadsheet software?
A workbook is a single grid of cells; a worksheet is a file that holds many grids
A workbook is a file that can contain multiple worksheets; a worksheet is one sheet within it
A workbook and a worksheet are the same thing in any spreadsheet
A workbook is only for charts while a worksheet is only for text
Why is it important to adjust column width and row height when working in a workbook?
To lock the sheet from editing
To change formulas into values automatically
To make data readable and properly fit without cutting off entries
To increase the number of worksheets in the file
What does it mean to collaborate in a workbook, and why is it useful?
It means sending screenshots by email instead of the file
Only one person edits while others can only print the file
Everyone uses different files to avoid conflicts
Several people view and edit the same workbook to complete tasks faster and share updates
What are permissions in a shared workbook, and what can they allow someone to do?
They decide the sheet color only
They set who can view, comment, or edit specific parts of the workbook
They automatically fix formula errors
They remove all formatting from the sheet
What are filters and conditional formatting used for in a workbook?
Filters sort files in folders; conditional formatting changes the file name
Filters hide or show rows that meet criteria; conditional formatting highlights cells based on rules
Filters delete extra rows; conditional formatting deletes duplicates
Filters protect cells; conditional formatting locks worksheets
What is AutoFill, and how is it used to fill cells in a spreadsheet?
A feature that copies patterns or sequences to adjacent cells by dragging the fill handle
A tool that deletes blank rows automatically
A button that saves the workbook every minute
A command that converts text to speech
What is data validation, and why is it important when entering information in a spreadsheet?
It formats numbers as currency
It prints only selected cells
It limits what can be typed into a cell to reduce errors
It hides formulas from view
Give two examples of rules you can set when using data validation.
Allow only whole numbers between 1 and 10
Restrict entries to a list of choices
Accept any text of any length
Permit dates after a chosen deadline
Why might someone highlight expenses above ₦50,000 in red in a budget spreadsheet?
To lock those cells from editing
To convert the amount to dollars
To make high costs stand out for quick review and control spending
To hide the expenses from printouts
What is a sequence in programming?
A random set of actions so results vary
A repeated action that never ends
The specific order of instructions
A picture that explains a story
What is a loop, and how does it help when giving instructions to a computer?
A command that stops all code
A structure that repeats actions until a condition is met, saving time and code
A tool for drawing shapes only
A way to slow down a program
Explain what a condition is in programming and give an example of a conditional action.
A condition is a color setting; example: turn text blue
A condition is a test that is either true or false; example: if score ≥ 10 then show next level
A condition is a file name; example: save as .txt
A condition is a keyboard shortcut; example: Ctrl+C
Why are comic stories useful for understanding programming constructs like sequence, loops, and conditions?
They show events in order and repeated or branching actions in a simple visual way
They replace the need to write any code
They teach only drawing skills
They remove all mistakes automatically
In Scratch or comic-style coding, why is it important to show what happens first, next, and last in your story?
It prevents saving the project
It lets the computer guess missing steps
It makes the sprites invisible
It creates a clear sequence so the audience can follow the program's flow
What is the difference between analogue data and digital data?
Analogue is always better quality than digital
Analogue is only pictures; digital is only text
Analogue is continuous signals; digital is discrete values like 0s and 1s
Analogue is stored in the cloud; digital cannot be stored
Why do computers need to convert analogue data into digital data before using it?
Computers process discrete digital values, not continuous signals
Computers only understand handwriting
Conversion makes files larger
Conversion turns data into pictures only
Name and describe three common flowchart symbols used in algorithms.
Circle for data, Triangle for loop, Star for start
Oval for Start/End, Rectangle for Process, Diamond for Decision
Square for start, Heart for print, Cloud for stop
Arrow for process, Box for start, Diamond for storage
What are variables in algorithms?
Fixed pictures that never change
Named storage for values that can change
Only the final answer of a problem
Special arrows that replace decisions
What does it mean for a robot to work autonomously?
It runs without any code
It operates on its own using code and rules to make decisions
It only moves when pushed by a person
It ignores sensors and follows random paths
What role do sensors play in helping a robot understand its environment?
They decorate the robot
They store documents
They charge the robot's battery
They collect data like distance, light, or touch
Name two industries where robots are used today and describe one task robots perform in each.
Education and tourism; robots write novels and paint museums
Manufacturing and healthcare; robots assemble parts and assist in surgeries
Farming and banking; robots approve loans and grow money
Sports and fashion; robots win races and design clothes
What are two advantages of using robots in industries such as manufacturing or food production?
Improved precision and ability to work continuously
Guaranteed creativity and emotions
Increased safety in dangerous tasks
Automatic profit without planning
What is one challenge that might occur when robots replace human workers in certain jobs?
Instantly higher salaries for all workers
Possible job displacement requiring retraining
No need for electricity anymore
Robots always understand feelings
What is a digital artefact?
A physical statue made of stone
A created digital product like a poster or video
Only a printed document with no images
A password used to log in
How does using sound, video, or text make a multimedia project more engaging for the audience?
Multiple media appeal to senses and explain ideas more clearly
Only sound matters; video and text are ignored
It makes the file impossible to share
It removes the need for planning
What is the difference between online help and offline help when working on a digital project?
Online help only shows videos; offline help only shows text
Online help is printed in books; offline help is a phone call
They are identical and always require Wi‑Fi
Online help is accessed through the internet; offline help is built into the software and works without internet
Why is it important to keep your fingers on the home row keys when typing?
It prevents using the space bar
It makes the keyboard louder
It improves speed and accuracy by reducing hand movement
It turns letters into numbers
How does regular typing practice help improve both speed (WPM) and accuracy?
Practice makes keys larger
Practice builds muscle memory for key locations and reduces errors
Practice changes the keyboard layout
Practice removes punctuation
What are arithmetic operators in coding, and why are they important in programs like calculators?
They are pictures in a slideshow
They are symbols such as +, −, ×, ÷ used to perform calculations the program needs
They are keys for saving files
They are tools for drawing shapes like square, rectangle and circle
Explain the function of each arithmetic operator: addition, subtraction, multiplication, and division.
Add combines quantities; subtraction finds difference; multiplication finds repeated addition; division splits into equal parts
Addition removes items; subtraction doubles items; multiplication halves items; division adds items
All four do the same thing
Only addition is used in programs
What is a prototype in programming, and why do programmers create one before the final version of a program?
A hardware-only device
A finished product ready for sale
A test version used to try ideas and find problems early
A user manual for the program
How do variables help a Scratch program store and update information during execution?
Variables are pictures for sprites
Variables keep values like scores that the program can change while it runs
Variables delete blocks automatically
Variables are only used to save projects
How do conditionals and loops in block-based programming help control how a program works?
Neither affects program flow
Conditionals draw costumes; loops play music only
Both are only for decoration
Conditionals choose actions based on tests; loops repeat actions, controlling flow and efficiency
Why is block-based programming easier for beginners compared to text-based coding?
It can make real programs
It requires memorizing simple punctuation
It avoids typing syntax errors, making concepts easier to learn
It only works with a computer
What are the three main data types used in block-based programming, and give one example of each.
Number, text (string), and Boolean; examples: 7, "score", true
Image, song, and costume; examples: photo, music, hat
File, folder, and drive; examples: .txt, Documents, C:
Square, circle, triangle; examples: shapes
How do sequence, selection, and iteration control how a program works?
They are computer parts inside the CPU
Sequence orders steps, selection chooses by conditions, iteration repeats actions
They are only for making music
They are types of computer programs
Why are sub-routines (procedures) useful when creating programs in Scratch?
They group steps into reusable blocks, making programs easier to read and maintain
They slow the program and add errors
They remove the need for variables
They work only on one sprite ever
What is an algorithm, and why is it important to design efficient algorithms in block-based programming?
An algorithm is the hardware of the computer; efficiency means using bigger screens
An algorithm is any picture used in a project; efficiency means using bright colors
An algorithm is a random guess; efficiency means adding more blocks
An algorithm is a list of clear steps to solve a problem; efficiency saves time and resources when the program runs
