NEW
Font size
WorksheetsSUMMATIVE TEST IN COMPUTER 5
Total questions: 20
Worksheet time: 10mins
A teacher uses a spreadsheet to track student ages. Today is October 20, 2025. A student's birthday is 12/15/2025. Which formula best calculates the number of days remaining until their birthday, requiring the use of a function to process the dates?
=12/15/2025 - TODAY()
=TODAY() - DATEVALUE("12/15/2025")
=DATEVALUE("12/15/2025") - DATEVALUE(TODAY())
=DATE(2025, 12, 15) - DATE(2025, 10, 20)
You have a column of sales figures. You want to total only the sales that are greater than $500 to determine high-value transactions. Which function should you use?
SUMIF
COUNTIF
IF
ROUNDDOWN
You are tracking how many times a certain condition is met in a large data set (e.g., how many students scored over 90). Which is the most appropriate and efficient Excel function?
SUMIF
IF
COUNTIF
DATEVALUE
You are writing an =IF(C5>100, "High", "Low") statement. If the output is "Low," which of the following is definitely true about the value in cell C5?
C5 is greater than 100
C5 is less than or equal to 100.
C5 is equal to 100.
C5 is less than 99
The formula in cell A2 is =ROUND(A1, 0). If you enter the value 99.49 into A1, what is the value of A2, and if you change A1 to 99.51, what is the new value of A2?
100, then 99.
99, then 100.
99, then 99
100, then 100.
A Scratch project uses a sprite that is partially hidden behind a tree backdrop. To make the sprite walk in front of the tree, what must you modify in the sprite's script?
A. The sprite’s Motion blocks to change its direction.
B. The sprite’s Looks blocks using a change size block.
C. The sprite’s Costume to make it semi-transparent.
D. The sprite’s Script to use the 'go to front layer' or 'go forward layers' block.
To create a unique, original sprite that is not in the Scratch library, the first step is to hover over the 'Choose a Sprite' icon and click on which option?
paint
upload
surprise
edit
Which of the following is NOT listed as a type of Fill color gradient available for backdrops in Scratch?
Linear Gradient Color - Vertical
Circular Shading
Radial Gradient Color
Solid Color
The Backdrops tab in the Viewing Area of Scratch is where you edit the background. This tab is most similar in function to which other tab used for editing a sprite?
Sounds
Scripts
Costumes
Motions
You have a sprite made of grouped shapes. If you want to change the color of only one specific shape within that group, what is the necessary first step?
Click the Group icon again
Click the Ungroup icon
Delete the entire sprite and start over.
Select a new Fill color and it will automatically apply to all parts
You want a variable named Score to increase by 5 every time a sprite touches an apple. Which block is the most appropriate to manage this value change?
Set (Score) to (5)
Set (Score) to (Score + 5)
Change (Score) by (5)
Show Variable (Score)
A script uses the If () then, else block. If the condition inside the block is false, which set of blocks is executed?
The blocks in the 'If () then' section.
The blocks immediately following the 'If () then, else' block.
The blocks located in the 'else' section.
The script stops running completely.
The () and () block returns what value only if all conditions inside it are true?
true
false
The value of the first condition
The value of the second condition
What is the primary difference between a Clone and a regular Sprite?
A Sprite can only move, while a Clone can only change costumes.
A Clone must be drawn using the Paint tool, while a Sprite must be chosen from the library.
A Clone is a copy created during the script's execution and is activated by the 'When I start as a clone' block.
A Sprite is permanent, and a Clone can never be deleted.
You use a script that uses the Show Variable (Score) block. If you later use the Hide Variable (Score) block, where will the variable Score and its value be displayed?
It will be hidden from the Stage but will appear on the Sprite Pane.
It will be hidden from the Sprite Pane but will appear on the Stage.
It will not be displayed on the Stage, but its value is still active in the script.
The script will produce an error because the variable cannot be hidden once shown.
True or False: The TODAY() formula in Excel is an example of a date formula.
true
false
True or False: The formula =ROUND(9.4, 0) in Excel will return the value 10.
true
false
True or False: A Conditional Statement is a statement that answers if something is true or false.
true
false
True or False: You must hover over the Choose a Sprite icon to access the Paint option for drawing a new sprite.
true
false
True or False: The If () then block is used when a program needs to choose one of two paths or statements.
true
false
