CL 5- EXCEL

Student Name?

1. Identify the objects that perform the actions.

• Stage
• Block
• Theme
• Sprite

2. ______________ is the process of checking and ensuring the accuracy of the input data in a worksheet.

• Data Filter
• Data Validation
• Data Consolidation
• None

3. Which displays only the rows that satisfy the condition based on certain criteria?

• Formulas
• Pivot table
• validation
• Filters

4. Auto Filter and ____________ Filter are two types of filters in MS-Excel.

• Advanced
• Extreme
• Input
• Output

5. Filter by value allows data to _____________ in ascending or descending order.

• Analyse
• Sort
• Organise
• View

6. What is the text Concatenation operator?

• +
• =
• &
• @

7. Which is used to represent information in an interactive report format?

• Validation
• Pivot table
• Filters
• None of the above

8. You can turn the sprite only in clockwise direction.

• True
• False

9. _______________ is used to raise the sprite's pen in scripts to move without drawing.

• 
• 
•