Manipulate Data (Spreadsheets)
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.
Nkuzi Olu
Gee ntị na nkuzi a na ngwa
Maapụ uche
E seela isiokwu a ka ị hụ otu echiche si ejikọta.
Mepee maapụ uche na ngwa
Kaadị ncheta
Omume ncheta ngwa ngwa n'ihe a na-anwale n'isiokwu a.
Mee omume kaadị ndị a na ngwa
Akwụkwọ Ọmụmụ
Ndetu Nkuzi Zuru Ezu di na Ngwa Green Bridge
Nweta ngwa Green Bridge CBT na ekwenti gi ma o bu kompiuta maka ulo akwukwo IGCSE zuru oke: akwukwo ule ndi gara aga, usoro nyocha, eserese uche, kaadi omumu na nkuzi olu.
Nnyocha Ọmụmụ
Ekele diri gi maka imecha ihe karịrị na Manipulate Data (Spreadsheets). 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
Rue ajuju ndi a n'ime ngwa ahu
Rue ajuju ndi a n'ime ngwa ahu
Akwụkwọ A Na-atụ Aro
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Manipulate Data (Spreadsheets)? Budata ngwa Green Bridge CBT iji nweta ajụjụ ule ọmarịcha na nyocha zuru ezu gbasara isiokwu a.
Budata Ngwa Ahụ Na Google Playstore
Ihe nile ichoro iji nwee ihe ịga nke ọma na JAMB, WAEC & NECO.
