Tính toán tự động trên bảng tính ( trung bình )

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 trung bình

{"common":{"save":0,"post_id":"9645","level":2,"total":10,"point":10,"point_extra":0},"segment":[{"id":"11449","post_id":"9645","mon_id":"1160119","chapter_id":"1160128","question":"Khi sao chép công th\u1ee9c trong b\u1ea3ng tính, \u0111i\u1ec1u gì s\u1ebd x\u1ea3y ra?<\/p>","options":["A. Công th\u1ee9c có th\u1ec3 sao chép \u0111\u1ebfn b\u1ea5t k\u1ef3 v\u1ecb trí nào và không thay \u0111\u1ed5i.","B. Khi sao chép công th\u1ee9c, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ecba ch\u1ec9 ô theo v\u1ecb trí m\u1edbi.","C. Công th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng tính l\u1ea1i sau m\u1ed7i 10 giây.","D. Công th\u1ee9c ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng \u0111úng \u1edf ô ban \u0111\u1ea7u, không th\u1ec3 sao chép."],"correct":"2","level":"2","hint":"","answer":"\u0110áp án \u0111úng: B. Khi sao chép công th\u1ee9c, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ecba ch\u1ec9 ô theo v\u1ecb trí m\u1edbi.<\/strong><\/span> Khi em sao chép công th\u1ee9c t\u1eeb ô này sang ô khác, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ecba ch\u1ec9 ô trong công th\u1ee9c d\u1ef1a theo v\u1ecb trí m\u1edbi. \u0110i\u1ec1u này g\u1ecdi là \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i. Ví d\u1ee5 d\u1ec5 hi\u1ec3u: T\u1ea1i ô B2, em nh\u1eadp công th\u1ee9c: =A2+1; Khi sao chép công th\u1ee9c này xu\u1ed1ng ô B3, công th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng thành =A3+1<\/p><svg height=\"131\" width=\"311\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\"> <g> <title><\/title> <rect fill=\"#fff\" height=\"133\" id=\"canvas_background\" width=\"313\" 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=\"131\" id=\"svg_1\" width=\"311\" x=\"1.5\" xlink:href=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAATcAAACDCAIAAABnbMuyAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAwqSURBVHhe7Z1NTxTLGsf5Hq7ud3BzzuZsbu5HcIWJq+vWnLswGgjijXpkRYiJChoNajAqIG\/DICEhihdQBHkRQSUKyviO8R2UE+\/T3Q\/Tzcz0TA9UddUz8\/+lY6prWuap6v9vqgZkrEgBAOwGlgJgO7AUANuBpQDYDiwFwHZgKQC2A0sBsB1YCoDtwFIAbCfT0v+BIuGJ0wA\/Adg2PKFipzSHpX+DyNB08cRpAPdCCcF7JHRKYem2gKX2A0vLHVhqP7C03IGl9gNLyx1Yaj+wtNyBpXHy5s2bhYUFPokMLC13YGlsNDQ0VFVVVVdXNzY2clc0YGm5U5SlXS5eOwoR78WPHz+Wlpbm5uZWVlbW19e5dwN6dG1tjU80s7q6+uzZsy0sdwXp7Ozcv3\/\/+\/fv6+vrm5ubuTca5WPpYsvefwY4NsT9wQf8zvLBBku\/ffs2PT1NF4+MjJAkaSfJz7dv3y4uLn769Mnr0crPnz\/n5+fv3r1L+1LuUsehQ4fq6ur4pEiC9yjilOZh6FiOrBdlgXfx3pZFPo9AEZZufF33WbiYoWMbvU71JeTpf4\/+lX3wYwGCCVBO9EiRh48ePaLriYcPH3758uXDhw8PHjyYmZkhZ8gfvk4b9BSTk5Ok6Pj4OK143KuCEydO0CrqcfDgQe4tBpoTnlAFllLM9x47tndz1PNY4MgS6HAe39syFLApEluwdPPJBjk7RVNQUSKYAOUUFSny5OXLl6QK\/a379+9PTEw8efLk69ev\/LBOaNGmpyNF79279\/z5c+5VR1tbGyna19fH50USvEdFTWkOHElbFjPUC5BlQc5Li3Zli2tp1nN4LxKlJKlDfkWJYAIKomnHG4Qkob9FjI2N0U6Ye9Xx+fPnV69eBRdnUpTWT1KUXhpevHjBvUppaGggS73h0B7+8ePHXuPp06fu4wWg2eAJjTilTpY3s5FsT9JwzbItiN3SAIGnSA8p94uLePIoSgQTUBCtlq6vry8vL9+5c4f89N6mLiwsKN\/retta2kh7X3l1dZU22NRD\/fSW2LtGOdXV1YcPH6ZGfX19bW1tMpns7+8\/fvz4yZMnvQvyE7xHRU1pJgG5Mj3LsiBDGJe0ITot9b9u9ksGl1WipoYTTIByokeKFF1aWqLrSRh6R0rrm\/c2lfbAfIUiaE9LT0HMz8\/Tdnpubo7a1EnV8hWqoffVtJCeOnWK2jSclpYWOvWkjUjwHkWf0mw2ORAiWpYFTkeWFSF\/OZwtWepqmvncRT91KRBMgHIiRooUpfjSxbSQrqyseJ0kKilEPR8\/fvR6lEBm0lrtiZre6Cp\/LQjS29sbfFNKutJpc3Nz9O9RBe9RpClNL4xpnFy7Am4mRNNgt3NuyNL0WkrdGyU4V2AtzYumHe+7d+9GRkaGh4dfv37NXS5ra2u0NaUdqdqfl5Ko6RWVSO9+NUFa0o6XGrTFpR0vzcmRI0eqqqroT++CggTvUcQpzUHW\/tEPfD4LnI4sK5xOXZYG2VQVU9TzlgjBBBREk6Uk59TUVM5vrn7\/\/p22vukFViGzs7OkKC2ntMHmLtUcOHBgYmKipqYmkUjQ6ZZ\/wKPE0ly7x3RfdAsyl+mIzkS0FOSmKEuLxeZ7QTvq5eVlTd\/U9aBt7enTp3t6evh8qyix1CywdFuUraWCgKXlDiy1H1ha7sBS+4Gl5Q4stR9YWu7AUvuBpeUOLLWf0rQUFAVPnAb4CcC24QkVO6WZlgIAbAOWAmA7sBQA24GlANgOLAXAdmApALYDSwGwHVgKgO3AUgBsB5YCYDsqLZ2amuKWTJLJJA1BLlQ\/j0QmNARuyURf\/SotnZiY4JZMent73bRLhernkchEen701a\/S0rGxMW7JJJFIcN5lQvXzSGQiPT\/66ldp6ejoKLdkAkvNIj0\/+urfrqXT09Pccn8tiFsy6enp4bzLhOrnkchEen701b8tS0nR7u5uPkmlbt26xS09XKysqKi8yCcaoLFw3hVzYc\/u33bwsatmkHuVE7wXGrhdu7NiAy23QU9+nNQE2Fl7mx9Qjrb8X9y6pZ6iwWQMDg5ySwcUkp2VlTs1akpj4bwrhizdkLN1344\/6zR9kyp4L1TjZN0P+O3aWg23QU9+qPKAma6zmjKkLf9btTStKMFdqdTAwAC3NOBIWnvb+5O7VNPV1cV5V0zA0sG6P7RZWtQH5xfF5qTrQk9+smrXNhht+d+SpUFFCe5NpW7cuMEt9WzoqVPTzs5OzrtifEt7G3f90XjD7VQP1c8jUQzlWuc7jQ305CdbSl2aast\/8ZZmKErwA+7PG7mlHF9OjZp2dHRw3hUTeF+qbSElqH4eiVpoymOxVE9+4rNUW\/6LtDRbUYIfc9\/XcUs1QTX1aarT0sD70t37mtymcnRZGtdaqic\/OS3VMhxt+S\/G0pyKEvywm3JuKYamNQMts3z9+nXOu2IClm5qK4bq55EoJqbFVE9+Mi3VNxh9+Y9qaZiiBF+RSrW1tXFLLXHNc3t7O+ddMTGtpVQ\/j0Q57uukP+d6vserJz+b0uNER892l9CV\/4iW5lGU4ItSqatXr3JLKZmSatNUp6Vx\/LxUo6WEG3BGT8715Md9gUmjy1AHTfmPZGl+RQm+LpW6fPkyt2RCr4Wcd5loey2PCen50Vd\/AUsLKkrwpanUpUuXuCWT1tZWzrtMqH4eiUyk50df\/UV896ggzc3N3JIJLDWL9Pzoq1+lpefOneOWTK5du8Z5lwnVzyORifT86KtfpaVnzpzhlkz+8Z9\/ST94JDKRnh999VfMzs7Sm8\/Jycnx8fGxsbHR0dHh4eGhoaGbN28ODg4ODAz09\/cnk8lEItHV1dXR0dHW1kav2VeuXGlpaaGNOK3y58+fP3v2bFNT02nhZCRe4sEjAaWFyrWUvtwvyczMzHBLJqjfLPrqh6U+SIlZUH8YsNQHKTEL6g8DlvogJWZB\/WHAUh+kxCyoPwxY6oOUmAX1hxHFUuffK0f5V8qw1Cyo3yzGLHV\/EaKyNtovXsNSs6B+sxiz1INchaX2g\/rNAkvjACkxC+oPA5b6ICVmQf1hwFIfpMQsqD8MWOqDlJgF9YcBS32QErOg\/jBgqQ9SYhbUH0YkSyMCS82C+s0CS+MAKTEL6g8DlvogJWZB\/WHAUh+kxCyoPwzFn3tEhcrF++ggb17SnyQUPOx\/iEcCSguspT5e0IPtjEPKQ0KhOHJLJvrqh6U+JRB00cDSMGCpDyw1CywNA5b6iLa0BF5iYGkYsLREgKXGgaWgALDUOMYsve3\/17KF\/1tf7Hhj43H973RLfq9\/zOew1AJMWXqxcsNNR9dCnsLSWEj82\/EzQZ7CUqswtpb6RPi9GFgaI85qCkutwgJLL1ZiLbUJWGodpi2Nst+FpbGSaWkJAEvDKGypY2iU3wGHpbECS63DmKUR3o36wNIYwY7XOgxZSo4W3uf6SLdUFLDUOgxZ6vwHMUEKLKuwNBacn8QE8VyFpcYxZGmRYMdrEFhqHFgaB7DULLA0DFjqA0vNAkvDgKWMl\/LgEdZPh80PeZ0SgaVhVPT19SWTyV6XhEuPS3d3d5dLp0uHy3WX9vb2NpdWl2suXkSoUKGkU54+vAnK6PQOmx\/i8YASomJKEV5EvNxIRHr9hPQhUBy5JRN99cNSRnr9hPQhwNIwYCkjvX5C+hBgaRiwlJFePyF9CLA0DFjKSK+fkD4EWBoGLGWk109IHwIsDaOApU1Hf9ux2z3+rOvlvtxIj4is+p1\/a7\/5c48I6bcAloaR39IbNY0XvJaj61Fu50R6ROTUn\/tzjwjptwCWhhF5x9u6D5baRI7fApd+C2BpGFEtpbV0Tyu3cyI9ItLqh6XWYc5SWkLd96X5FSWkR0Ra\/bDUOqxYS\/N\/A0l6RKTVD0utw7ylU1MX9uze18TtHEiPiLT6Yal1GLJ0sK5mY6Pb27gLa6lNwFLrMLWW0vqJn5faRu7PPSKk3wJYGkb0HW8BpEdEev2E9CHA0jBgKSO9\/hIAloYBSxnR9XvFpw\/ulQYsDQOWMqLr94pPH9wrDVgaBj73iElHXNxBdzGjh4cESgV8hiCTEXRBR3bx3ojEQXHklkz01Q9LfeSmBJbaACyNA6TELKg\/DFjqU0opuSoTrl4msDQOSszSv6UBS8OApT6w1CywNDe\/fv0f3eLU4AJP3KIAAAAASUVORK5CYII=\" y=\"2.5\"><\/image> <\/g> <\/svg><\/span><\/p>→ Excel t\u1ef1 hi\u1ec3u r\u1eb1ng ô A2 ban \u0111\u1ea7u n\u1eb1m cùng hàng v\u1edbi ô B2, nên khi sao chép xu\u1ed1ng dòng, nó \u0111\u1ed5i A2 → A3 cho \u0111úng v\u1ecb trí.<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:19:56","option_type":"txt","len":3},{"id":"11450","post_id":"9645","mon_id":"1160119","chapter_id":"1160128","question":"Vi\u1ec7c sao chép công th\u1ee9c trong b\u1ea3ng tính có gì khác so v\u1edbi sao chép d\u1eef li\u1ec7u thông th\u01b0\u1eddng?<\/p>","options":["A. Có hai l\u1ec7nh khác nhau: m\u1ed9t cho d\u1eef li\u1ec7u và m\u1ed9t cho công th\u1ee9c.","B. Dùng chung m\u1ed9t l\u1ec7nh sao chép cho c\u1ea3 d\u1eef li\u1ec7u và công th\u1ee9c.","C. Không th\u1ec3 sao chép công th\u1ee9c \u0111\u01b0\u1ee3c.","D. C\u1ea3 A và C \u0111\u1ec1u \u0111úng."],"correct":"2","level":"2","hint":"","answer":"\u0110áp án \u0111úng: B. Dùng chung m\u1ed9t l\u1ec7nh sao chép cho c\u1ea3 d\u1eef li\u1ec7u và công th\u1ee9c.<\/strong><\/span> Trong ph\u1ea7n m\u1ec1m b\u1ea3ng tính em có th\u1ec3 sao chép c\u1ea3 ô ch\u1ee9a d\u1eef li\u1ec7u (s\u1ed1, ch\u1eef) và ô ch\u1ee9a công th\u1ee9c (nh\u01b0 =A1+B1) b\u1eb1ng cùng m\u1ed9t l\u1ec7nh: Ctrl + C \u0111\u1ec3 sao chép; Ctrl + V \u0111\u1ec3 dán Không có s\u1ef1 phân bi\u1ec7t riêng gi\u1eefa sao chép d\u1eef li\u1ec7u và công th\u1ee9c. Ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng hi\u1ec3u n\u1ed9i dung ô là gì và th\u1ef1c hi\u1ec7n sao chép phù h\u1ee3p. \u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t khi sao chép công th\u1ee9c: Khi em sao chép m\u1ed9t công th\u1ee9c, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ecba ch\u1ec9 ô theo v\u1ecb trí m\u1edbi. Ví d\u1ee5: \u1ede ô A3 có công th\u1ee9c =A1+A2; Khi sao chép công th\u1ee9c \u0111ó sang ô B3, nó s\u1ebd t\u1ef1 chuy\u1ec3n thành =B1+B2 → \u0110ây g\u1ecdi là \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i.<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:20:43","option_type":"txt","len":3},{"id":"11451","post_id":"9645","mon_id":"1160119","chapter_id":"1160128","question":"Phát bi\u1ec3u nào sau \u0111ây là \u0111úng khi s\u1eed d\u1ee5ng b\u1ea3ng tính \u0111i\u1ec7n t\u1eed?<\/p>","options":["A. B\u1ea3ng tính không ph\u1ed5 bi\u1ebfn trong cu\u1ed9c s\u1ed1ng.","B. Ch\u1ec9 b\u1ea3ng tính vi\u1ebft tay m\u1edbi tính toán \u0111\u01b0\u1ee3c.","C. Khi d\u1eef li\u1ec7u ban \u0111\u1ea7u thay \u0111\u1ed5i, k\u1ebft qu\u1ea3 tính toán s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.","D. B\u1ea3ng tính \u0111i\u1ec7n t\u1eed ch\u1ec9 làm vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1."],"correct":"3","level":"2","hint":"","answer":"\u0110áp án \u0111úng: C. Khi d\u1eef li\u1ec7u ban \u0111\u1ea7u thay \u0111\u1ed5i, k\u1ebft qu\u1ea3 tính toán s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/strong><\/span> B\u1ea3ng tính \u0111i\u1ec7n t\u1eed là ph\u1ea7n m\u1ec1m giúp em: Nh\u1eadp và l\u01b0u tr\u1eef d\u1eef li\u1ec7u (s\u1ed1, ch\u1eef, ngày tháng, v.v.); Tính toán t\u1ef1 \u0111\u1ed9ng b\u1eb1ng công th\u1ee9c; V\u1ebd bi\u1ec3u \u0111\u1ed3, l\u1eadp b\u1ea3ng th\u1ed1ng kê,... M\u1ed9t \u0111\u1eb7c \u0111i\u1ec3m r\u1ea5t hay c\u1ee7a b\u1ea3ng tính \u0111i\u1ec7n t\u1eed là: N\u1ebfu em thay \u0111\u1ed5i d\u1eef li\u1ec7u ban \u0111\u1ea7u, thì k\u1ebft qu\u1ea3 tính toán trong các ô có công th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo → Không c\u1ea7n tính l\u1ea1i th\u1ee7 công!<\/p>","type":"choose","extra_type":"classic","time":"0","user_id":"151","test":"0","date":"2025-07-10 16:21:34","option_type":"txt","len":3}]}