Tính toán tự động trên bảng tính ( dễ 2 )

Home Lớp 7 Tin học lớp 7 - Sách kết nối tri thức Bài 7: Tính toán tự động trên bảng tínhBài tập cơ bản

{"common":{"save":0,"post_id":"9644","level":1,"total":10,"point":10,"point_extra":0},"segment":[{"id":"11439","post_id":"9644","mon_id":"1160119","chapter_id":"1160128","question":"M\u1ed9t vùng g\u1ed3m nhi\u1ec1u ô li\u1ec1n nhau theo hình ch\u1eef nh\u1eadt \u0111\u01b0\u1ee3c g\u1ecdi là gì?<\/p>","options":["A. C\u1ed9t","B. Hàng","C. Ô","D. Vùng d\u1eef li\u1ec7u"],"correct":"4","level":"1","hint":"","answer":"\u0110áp án \u0111úng: D. Vùng d\u1eef li\u1ec7u<\/strong><\/span> Trong ph\u1ea7n m\u1ec1m b\u1ea3ng tính Ô (cell): là m\u1ed9t ô vuông nh\u1ecf trong b\u1ea3ng, là n\u01a1i \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u (ch\u1eef, s\u1ed1, công th\u1ee9c...). M\u1ed7i ô \u0111\u01b0\u1ee3c xác \u0111\u1ecbnh b\u1eb1ng tên c\u1ed9t + tên hàng, ví d\u1ee5: A1, B2...; Hàng (row): là dãy các ô n\u1eb1m ngang (theo chi\u1ec1u t\u1eeb trái sang ph\u1ea3i), \u0111\u01b0\u1ee3c \u0111ánh s\u1ed1: 1, 2, 3,...; C\u1ed9t (column): là dãy các ô n\u1eb1m d\u1ecdc (t\u1eeb trên xu\u1ed1ng d\u01b0\u1edbi), \u0111\u01b0\u1ee3c \u0111ánh ch\u1eef cái: A, B, C,...; Vùng d\u1eef li\u1ec7u: là m\u1ed9t nhóm các ô li\u1ec1n nhau, \u0111\u01b0\u1ee3c ch\u1ecdn cùng lúc, t\u1ea1o thành m\u1ed9t hình ch\u1eef nh\u1eadt. Ví d\u1ee5: Vùng A1: B3 g\u1ed3m các ô A1, A2, A3, B1, B2, B3.<\/p><svg height=\"127\" width=\"215\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\"> <g><title><\/title><rect fill=\"#fff\" height=\"129\" id=\"canvas_background\" width=\"217\" x=\"-1\" y=\"-1\"><\/rect> <g display=\"none\" height=\"100%\" id=\"canvasGrid\" overflow=\"visible\" width=\"100%\" x=\"0\" y=\"0\"> <rect fill=\"url(#gridpattern)\" height=\"100%\" stroke-width=\"0\" width=\"100%\" x=\"0\" y=\"0\"><\/rect> <\/g> <\/g> <g><title><\/title><image height=\"127\" id=\"svg_1\" width=\"215\" x=\"1.5\" xlink:href=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAANcAAAB\/CAIAAADzUMBhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAWjSURBVHhe7Z0BSjNJEIU9lMfJZXKMRUURRVERgqKiBIIaJRBWUM\/Q19jttivJ6O+k282UlVf7Ph6hjEEq0196ZkxPshEIsYYWEntoIbGHFhJ7aCGxhxYSe2ghsWdVC19fX6XChP3bkvtf1cKXlxepMGH\/tuT+V7VwOp1KhQn7tyX3v6qFk8lEKkzYvy25\/\/9i4dvbm1QhPD09SYUJ+7cl9\/9jC6OCl5eX8kMIDw8PUulw0NvY6B3IDwqo9Z8an7HZH8u9naO8\/cf9TXkOSsOQ+\/+ZhVnBpoWj0UgqDeJG2Oz1NhU1VOs\/WjiTr1F2jub2Ty+kRePjfl9hGHL\/P7BwrmBE7gphOBxKpUCSsD\/Ot3JX16j131BP8wnobX\/N186C3H+thU0FI3JvCLe3t1J1z2z0NEdRrf\/FIKq+ijT71zwSmpH7r7Lwi4IR+UUI19fXUnXOYvQUx1Gt\/7Q7E\/Qc1Os\/bvJfsTD3X7bwTwUj8rsQmnW3NNXT01Ct\/8YOLQmpNaKa\/f+Ghbn\/goXfKhiRX4cwGAyk6pjGXCKobBTN\/ucvnGbdMWr9\/9JkmPtfZmGbghF5RAjn5+dSdcvXgdPaKFr9N59AekFpDaha\/7ntRt8658i5\/1YLlygYkQeFcHp6KlWn\/Dl7KGmo1L+MoaA1EUbU+v8gbfQZOk8i9\/+9hcsVjMjjQjg+PpYKE\/ZvS+7\/GwuLCkbkoSEcHh5KhQn7tyX3Xzg7KbK\/vy8VJuzfltz\/qhbu7u5KhQn7tyX3v6qF29vbUmHC\/m3J\/W9Mp9PJZPL8\/Pz4+Hh\/fz8ajYbD4d3d3c3NzdXV1cXFxWAwiKfTZ2dnJycnR0dHcUceZ9G9vb2dnZ2tra2\/CFmZVefC+Cf+ef6bsQwy7+\/v8ZYW4gcZWuglyNBCL0GGFnoJMrTQS5BZbmF6M77m\/WtaaB9kWi38WEjR69ctLKWF9kGmsEeOLtJCjCBDC70EGVroJcjQQi9BhhZ6CTK00EuQoYVegkzBwkpooX2QoYVeggwt9BJkaKGXICMWrn7dydeNwvxu4kCiw7kQP8hEBeMtLcQPMrTQS5ChhV6CDC30EmRooZcg02rhePHRieWPraSF9kGmzcKD3sy9pGPJQ1poH2Qq9sgV62pooX2QqbDwoPxtA7TQPsiULKzZH9PCdQgyyyxMBtascaWF6xBkWi2sOBpcQAvtg0yLhdHB8n54AS20DzItFja\/LSZRmBZpoX2QKZ2d1EEL7YMMLfQSZGihlyBDC70EGbGQ152gJw4kOpwL8YNMVDDe0kL8IEMLvQQZWuglyNBCL0GGFnoJMq0WLt5JrlhaQwvtg0ybheN+X9bUJB251nr9g0zFHpkr\/iGCTNnCCglp4RoEmXYLZweGNatdaaF9kKmaC4snKLTQPshUHBdW7JNpoX2QabFwcYpcdSUeLbQPMm1z4eyoMML\/F0IEmZo9chlaaB9kaKGXIEMLvQQZWuglyIiFvO4EPXEg0eliLkQmbgKpMPHRPy2khZbQwgQttIUWJmihLbQwQQttoYUJWmhL0cL0hnLVKldkaKEtBQvTghpauPa4tvDjs637lSv+kaGFtiyxUD5fvbzGlRZa49bCKF9eWEgL1x+nFjbUo4Xrj0sL8znJJ5YvuKaFtri08BOcC9cfWpighbb4t7AGWmgLLUzQQltoYYIW2kILE7TQFicWrn7dSfxDhKwC50LOhZbk\/mkhLbSEFiZooS20MEELbaGFCVpoCy1M0EJbWi38tK6m9EYyLbTFs4XFRQxzaKEtbi2sWUozhxba4tnCGWUbaaEtbi2ckw4Qaz5dHRlaaEvZwvnFeEughbb8HywsHyLSQlu8WnjQm4mX9silI0NaaItfC+XUpPr7TpChhba0WfgzaKEttDBBC22hhQlaaAstTNBCW5xYyOtOiDHv7\/8CPMqz2w9KQSYAAAAASUVORK5CYII=\" y=\"-0.5\"><\/image> <\/g> <\/svg><\/span><\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:06:13","option_type":"txt","len":2},{"id":"11440","post_id":"9644","mon_id":"1160119","chapter_id":"1160128","question":"Tr\u01b0\u1edbc khi nh\u1eadp d\u1eef li\u1ec7u vào m\u1ed9t ô, em c\u1ea7n làm gì?<\/p>","options":["A. Nh\u1ea5n Enter","B. Nháy chu\u1ed9t vào ô mu\u1ed1n nh\u1eadp","C. Gõ luôn d\u1eef li\u1ec7u","D. Nháy vào vùng khác"],"correct":"2","level":"1","hint":"","answer":"\u0110áp án \u0111úng: B. Nháy chu\u1ed9t vào ô mu\u1ed1n nh\u1eadp<\/strong><\/span> M\u1ed7i ô là m\u1ed9t v\u1ecb trí dùng \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u (ch\u1eef, s\u1ed1, ngày tháng...). \u0110\u1ec3 nh\u1eadp d\u1eef li\u1ec7u vào ô, em c\u1ea7n: Nháy chu\u1ed9t vào ô \u0111ó \u0111\u1ec3 ch\u1ecdn ô (làm ô \u0111ó tr\u1edf thành ô \u0111ang \u0111\u01b0\u1ee3c kích ho\u1ea1t); Sau \u0111ó m\u1edbi gõ d\u1eef li\u1ec7u t\u1eeb bàn phím; Cu\u1ed1i cùng, em nh\u1ea5n Enter \u0111\u1ec3 k\u1ebft thúc vi\u1ec7c nh\u1eadp và chuy\u1ec3n sang ô ti\u1ebfp theo.<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:07:03","option_type":"txt","len":2},{"id":"11441","post_id":"9644","mon_id":"1160119","chapter_id":"1160128","question":"Mu\u1ed1n thay \u0111\u1ed5i ki\u1ec3u ch\u1eef ho\u1eb7c c\u0103n ch\u1ec9nh d\u1eef li\u1ec7u, em s\u1ebd ch\u1ecdn nhóm l\u1ec7nh nào?<\/p>","options":["A. Font và Alignment","B. Cell và Alignment","C. Font và Cell","D. Alignment và Editing"],"correct":"1","level":"1","hint":"","answer":"\u0110áp án \u0111úng: A. Font và Alignment<\/strong><\/span> Khi em mu\u1ed1n trang trí ho\u1eb7c c\u0103n ch\u1ec9nh d\u1eef li\u1ec7u trong ô, em s\u1ebd dùng các nhóm l\u1ec7nh (group) n\u1eb1m trên thanh công c\u1ee5 (Ribbon). Nhóm l\u1ec7nh Font dùng \u0111\u1ec3: Thay \u0111\u1ed5i ki\u1ec3u ch\u1eef (ví d\u1ee5: \u0111\u1eadm, nghiêng, g\u1ea1ch chân); Thay \u0111\u1ed5i phông ch\u1eef, c\u1ee1 ch\u1eef; \u0110\u1ed5i màu ch\u1eef ho\u1eb7c màu n\u1ec1n ô Nhóm l\u1ec7nh Alignment dùng \u0111\u1ec3: C\u0103n l\u1ec1 d\u1eef li\u1ec7u trong ô (trái, ph\u1ea3i, gi\u1eefa, trên, d\u01b0\u1edbi); G\u1ed9p ô (Merge cells); Xoay ch\u1eef trong ô<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:07:35","option_type":"txt","len":2}]}