Manipulate Data
Gbogbo ọrọ náà
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.
Ebumnobi
- 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.
Akọmọ Ojú-ẹkọ
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ayẹwo Ẹkọ
Ekele diri gi maka imecha ihe karịrị na Manipulate Data. Ugbu a na ị na-enyochakwa isi echiche na echiche ndị dị mkpa, ọ bụ oge iji nwalee ihe ị ma. Ngwa a na-enye ụdị ajụjụ ọmụmụ dị iche iche emebere iji kwado nghọta gị wee nyere gị aka ịmata otú ị ghọtara ihe ndị a kụziri.
Ị ga-ahụ ngwakọta nke ụdị ajụjụ dị iche iche, gụnyere ajụjụ chọrọ ịhọrọ otu n’ime ọtụtụ azịza, ajụjụ chọrọ mkpirisi azịza, na ajụjụ ede ede. A na-arụpụta ajụjụ ọ bụla nke ọma iji nwalee akụkụ dị iche iche nke ihe ọmụma gị na nkà nke ịtụgharị uche.
Jiri akụkụ a nke nyocha ka ohere iji kụziere ihe ị matara banyere isiokwu ahụ ma chọpụta ebe ọ bụla ị nwere ike ịchọ ọmụmụ ihe ọzọ. Ekwela ka nsogbu ọ bụla ị na-eche ihu mee ka ị daa mba; kama, lee ha anya dị ka ohere maka ịzụlite onwe gị na imeziwanye.
- 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
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Ọ dị na ngwa Green Bridge
Budata ngwa Green Bridge CBT na ekwentị maọbụ kọmputa gị iji nweta akwụkwọ ndụmọdụ zuru oke, ajụjụ mmụta, na ndị ọzọ.
Àwọn Ìwé Tó Dáa Láti Kà
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Manipulate Data? Budata ngwa Green Bridge CBT iji nweta ajụjụ ule ọmarịcha na nyocha zuru ezu gbasara isiokwu a.
Dawunlodi Ẹpp naa lori Google Playstore.
Ihe nile ichoro iji nwee ihe ịga nke ọma na JAMB, WAEC & NECO.
