Manipulate Data
Bayani Gaba-gaba
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.
Manufura
- 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.
Takardar Darasi
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Nazarin Darasi
Barka da kammala darasi akan Manipulate Data. Yanzu da kuka bincika mahimman raayoyi da raayoyi, lokaci yayi da zaku gwada ilimin ku. Wannan sashe yana ba da ayyuka iri-iri Tambayoyin da aka tsara don ƙarfafa fahimtar ku da kuma taimaka muku auna fahimtar ku game da kayan.
Za ka gamu da haɗe-haɗen nau'ikan tambayoyi, ciki har da tambayoyin zaɓi da yawa, tambayoyin gajeren amsa, da tambayoyin rubutu. Kowace tambaya an ƙirƙira ta da kyau don auna fannoni daban-daban na iliminka da ƙwarewar tunani mai zurfi.
Yi wannan ɓangaren na kimantawa a matsayin wata dama don ƙarfafa fahimtarka kan batun kuma don gano duk wani yanki da kake buƙatar ƙarin karatu. Kada ka yanke ƙauna da duk wani ƙalubale da ka fuskanta; maimakon haka, ka kallesu a matsayin damar haɓaka da ingantawa.
- 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
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Akwai a cikin manhajar Green Bridge
Zazzage manhajar Green Bridge CBT a wayar ka ko kwamfyuta ka don samun cikakkiyar bayanan darasi, tambayoyin aiki, da ƙari.
Littattafan da ake ba da shawarar karantawa
Yi Aikin Tambayoyin Gwaji
Kana son yin aikin tambayoyin gwaji kan Manipulate Data? Sauke manhajar Green Bridge CBT don samun tambayoyin gwaji da cikakkun jarrabawa akan wannan batu.
Sauke Manhajar Daga Google Playstore
Duk abin da kake buƙata don yin fice a JAMB, WAEC & NECO.
