Quản lý dữ liệu trong máy tính ( nâng cao )

Home Lớp 7 Tin học lớp 7 - Sách kết nối tri thức Bài 3: Quản lí dữ liệu trong máy tínhBài tập nâng cao

{"common":{"save":0,"post_id":"9581","level":3,"total":10,"point":10,"point_extra":0},"segment":[{"id":"11279","post_id":"9581","mon_id":"1160119","chapter_id":"1160120","question":"N\u1ebfu em \u0111ã l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng tính và mu\u1ed1n hi\u1ec3n th\u1ecb l\u1ea1i t\u1ea5t c\u1ea3 các dòng, em nên ch\u1ecdn l\u1ec7nh nào?<\/p>","options":["A. Hi\u1ec7n t\u1ea5t c\u1ea3 (Show All)","B. L\u1ecdc nâng cao (Advanced Filter)","C. B\u1ed9 l\u1ecdc t\u1ef1 \u0111\u1ed9ng (AutoFilter)","D. Ch\u1ecdn t\u1ea5t c\u1ea3 (Select All)"],"correct":"1","level":"3","hint":"L\u1ec7nh “Hi\u1ec7n t\u1ea5t c\u1ea3” (Show All) giúp em b\u1ecf l\u1ecdc và hi\u1ec3n th\u1ecb l\u1ea1i toàn b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng tính.<\/p>","answer":"\u0110áp án \u0111úng: A. Hi\u1ec7n t\u1ea5t c\u1ea3 (Show All)<\/strong><\/span> Trong ch\u01b0\u01a1ng trình b\u1ea3ng tính Excel, khi em s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng l\u1ecdc (Filter), ch\u1ec9 m\u1ed9t s\u1ed1 dòng phù h\u1ee3p v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u1ecdc s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, còn các dòng khác s\u1ebd b\u1ecb \u1ea9n t\u1ea1m th\u1eddi. N\u1ebfu sau \u0111ó em mu\u1ed1n hi\u1ec3n th\u1ecb l\u1ea1i t\u1ea5t c\u1ea3 các dòng nh\u01b0 ban \u0111\u1ea7u, em c\u1ea7n xóa b\u1ed9 l\u1ecdc, hay còn g\u1ecdi là hi\u1ec7n t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u. L\u1ec7nh “Hi\u1ec7n t\u1ea5t c\u1ea3” (Show All) giúp em b\u1ecf l\u1ecdc và hi\u1ec3n th\u1ecb l\u1ea1i toàn b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng tính.<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-02 10:53:28","option_type":"txt","len":2},{"id":"11280","post_id":"9581","mon_id":"1160119","chapter_id":"1160120","question":"Trong Excel \u0111\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong c\u1ed9t theo th\u1ee9 t\u1ef1 t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf, em th\u1ef1c hi\u1ec7n:<\/p>","options":["A. Nháy A–Z trên thanh công c\u1ee5 Data","B. Nháy Z–A trên thanh công c\u1ee5 Data","C. Ch\u1ecdn ô b\u1ea5t k\u1ef3, sau \u0111ó nh\u1ea5n Insert","D. Nháy vào bi\u1ec3u t\u01b0\u1ee3ng Home"],"correct":"2","level":"3","hint":"Trên thanh công c\u1ee5 Data (D\u1eef li\u1ec7u) có 2 bi\u1ec3u t\u01b0\u1ee3ng th\u01b0\u1eddng g\u1eb7p: A–Z: s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n (t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn, t\u1eeb A \u0111\u1ebfn Z); Z–A: s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n (t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf, t\u1eeb Z \u0111\u1ebfn A)<\/p>","answer":"\u0110áp án \u0111úng: B. Nháy Z–A trên thanh công c\u1ee5 Data<\/strong><\/span> Trong ph\u1ea7n m\u1ec1m Excel, khi em mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong m\u1ed9t c\u1ed9t t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf (ví d\u1ee5: \u0111i\u1ec3m s\u1ed1 t\u1eeb cao xu\u1ed1ng th\u1ea5p), em c\u1ea7n dùng công c\u1ee5 Sort (S\u1eafp x\u1ebfp). Trên thanh công c\u1ee5 Data (D\u1eef li\u1ec7u) có 2 bi\u1ec3u t\u01b0\u1ee3ng th\u01b0\u1eddng g\u1eb7p: A–Z: s\u1eafp x\u1ebfp t\u0103ng d\u1ea7n (t\u1eeb nh\u1ecf \u0111\u1ebfn l\u1edbn, t\u1eeb A \u0111\u1ebfn Z); Z–A: s\u1eafp x\u1ebfp gi\u1ea3m d\u1ea7n (t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf, t\u1eeb Z \u0111\u1ebfn A) Vì v\u1eady, khi mu\u1ed1n s\u1eafp x\u1ebfp t\u1eeb l\u1edbn \u0111\u1ebfn nh\u1ecf, em ch\u1ecdn Z–A.<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-02 10:55:02","option_type":"txt","len":3},{"id":"11281","post_id":"9581","mon_id":"1160119","chapter_id":"1160120","question":"Mu\u1ed1n s\u1eafp x\u1ebfp danh sách d\u1eef li\u1ec7u trong b\u1ea3ng tính theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n, ta vào d\u1ea3i l\u1ec7nh nào?<\/p>","options":["A. Công c\u1ee5 \/ S\u1eafp x\u1ebfp & L\u1ecdc","B. T\u1ec7p \/ S\u1eafp x\u1ebfp & L\u1ecdc","C. D\u1eef li\u1ec7u \/ S\u1eafp x\u1ebfp & L\u1ecdc","D. \u0110\u1ecbnh d\u1ea1ng \/ S\u1eafp x\u1ebfp & L\u1ecdc"],"correct":"3","level":"3","hint":"S\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (A → Z, nh\u1ecf → l\u1edbn); Ho\u1eb7c theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (Z → A, l\u1edbn → nh\u1ecf) Em s\u1ebd s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng "S\u1eafp x\u1ebfp & L\u1ecdc" (Sort & Filter) n\u1eb1m trong d\u1ea3i l\u1ec7nh "D\u1eef li\u1ec7u" (Data).<\/p>","answer":"\u0110áp án \u0111úng: C. D\u1eef li\u1ec7u \/ S\u1eafp x\u1ebfp & L\u1ecdc<\/strong><\/span> Trong ph\u1ea7n m\u1ec1m b\u1ea3ng tính (nh\u01b0 Microsoft Excel ho\u1eb7c Google Trang tính), khi em có m\u1ed9t danh sách s\u1ed1, tên, \u0111i\u1ec3m,... và mu\u1ed1n: S\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (A → Z, nh\u1ecf → l\u1edbn); Ho\u1eb7c theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (Z → A, l\u1edbn → nh\u1ecf) Em s\u1ebd s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng "S\u1eafp x\u1ebfp & L\u1ecdc" (Sort & Filter) n\u1eb1m trong d\u1ea3i l\u1ec7nh "D\u1eef li\u1ec7u" (Data).<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-02 10:57:04","option_type":"txt","len":2}]}