Manipulate Data
Overview
A spreadsheet often holds far more data than you need to look at all at once. Manipulating data means rearranging and trimming it so the answer to a question jumps out: sorting a class list into mark order, or pulling out only the customers in one city. The data itself does not change; you simply change which rows you see and the order they appear in.
In this lesson you will learn to sort data into ascending or descending order on one column or several, and to search and filter so that only the rows matching your criteria remain. You will use the logical operators AND, OR and NOT, the comparison operators such as greater than and not equal to, and wildcards for matching partial text. These are the everyday tools that turn a wall of numbers into a clear report.
Objectives
- Sort data.
- Using a single criterion, or multiple criteria sort data into ascending or descending order.
- Search and select data.
- Using a single criterion, or multiple criteria, select subsets of data Perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <> Perform searches using wildcards.
Lesson Note
Available on the Green Bridge App
Download the Green Bridge CBT app on your phone or computer to access full lesson notes, practice questions, and more.
Lesson Evaluation
Congratulations on completing the lesson on Manipulate Data. Now that youve explored the key concepts and ideas, its time to put your knowledge to the test. This section offers a variety of practice questions designed to reinforce your understanding and help you gauge your grasp of the material.
You will encounter a mix of question types, including multiple-choice questions, short answer questions, and essay questions. Each question is thoughtfully crafted to assess different aspects of your knowledge and critical thinking skills.
Use this evaluation section as an opportunity to reinforce your understanding of the topic and to identify any areas where you may need additional study. Don't be discouraged by any challenges you encounter; instead, view them as opportunities for growth and improvement.
- To sort marks so the highest is at the top, you sort the Score column into: A. Ascending order B. Descending order C. Alphabetical order D. Random order Answer: B
- Which logical operator narrows a search so that a row is shown only when every condition is true? A. OR B. NOT C. AND D. XOR Answer: C
- The criterion to select ages between 18 and 65 inclusive is: A. Age > 18 OR Age < 65 B. Age >= 18 AND Age <= 65 C. Age > 18 AND Age < 65 D. Age = 18 OR Age = 65 Answer: B
- Which wildcard stands for exactly one character? A. * B. ? C. # D. % Answer: B
- When data is filtered, the rows that do not match the criteria are: A. Deleted permanently B. Moved to a new sheet C. Hidden but kept D. Overwritten Answer: C
Available on the Green Bridge App
Download the Green Bridge CBT app on your phone or computer to access full lesson notes, practice questions, and more.
Available on the Green Bridge App
Download the Green Bridge CBT app on your phone or computer to access full lesson notes, practice questions, and more.
Recommended Books
Practice Mock Questions
Want to practice mock questions on Manipulate Data? Download the Green Bridge CBT app to access mock questions and full practice assessments for this topic.
Download The App On Google Playstore
Everything you need to excel in JAMB, WAEC & NECO
