Font size
WorksheetsGrade 6 Computer Revision
Total questions: 21
Worksheet time: 24mins
What is this considered in the mBot2?
Skeleton
Software
Control board (brain)
Motor
Which formula in Excel multiply two cells A1 * B1:
=A1&B1
=4*5
=A1*B1
=average(A1:B1)
To hide a row that contains sensitive data we use the menu:
Home
Help
Draw
Insert
Which sequence is more logical ?
Read distance,
then only if it is less than 10 it will read the color
Read the color,
then turn right, no matter what the color is.
Turn right no matter what the value of the distance is
Always read the color,
and only if it is white turn right
The IF function in Excel contains how many main parts?
1
2
3
6
The color sensor is embedded in the CyberPi,
Yes,it is embedded in the CyberPi
No, It is an external sensor that connects to the mBot2.
When i press Enter to run this formula, what will be the value of A1 ?
=IF(B2>=10,"PASSED","FAILED")
Error
Failed
Passed
The COUNT function is used to count the number of:
digits cells
Non-empty cells
Empty cells
Errors only
The =min(c5:c11) function will find:
The smallest value within the range
The biggest value within the range
The average of the values within the range
The sum of the values within the range
To use the (mBot2 Chassis) category blocks, you need to add the .......... extension.
Pen
mBot2 shield
mBot2 & AI
SmartWorld
Formulas in Excel must begin with an equal sign (=)
True
False
Excel formulas can be written in upper or lower case
True
False
The SUM function can be written as SUM(A1;A5)
True
False
What does sheet protection do?
Deletes cells
Deletes formatting
Hides formulas
None of the options
The Format button (in the Home menu) allows you to hide rows.
True
False
Orientation is used to rotate text in the cell
True
False
The CyberPi includes a light sensor to measure the intensity of the light
True
False
What is the difference between
(and , or)
in this script
and :
must meet all conditions
or :
must have at least one of the conditions
or is better
and is better
The option that is used to combine and merge different cells in one big cell is called : Merge & Center
True
False
To count the number of empty cells, we need to use the COUNTBLANK function
True
False
the third part ( 3) in the image is :
Motor
CyberPi
Sensors
Skeleton
