UBND HUYỆN CHÂU ĐỨC TRƯỜNG THCS PHAN BỘI CHÂU
ĐỀ KIỂM TRA HỌC KỲ II NĂM HỌC 2021 – 2022 Thời gian: 45 phút
Điểm
Nhận xét của GV
Giám thị
Họ và tên: …………………............
Lớp: ……….
I-Trắc nghiệm: Hãy chọn đáp án đúng
Câu 1:Để làm cho chữ trong ô tính vừa in đậm vừa in nghiêng ta sử dụng các nút lệnh?
A.
B.
C.
D.
Câu 2:Để tô màu chữtrong ô tính ta sử dụng nút lệnh nào dưới đây ?
C.
D.
C. In trang tính
D. Thiết đặt lề in
A. B. Câu 3: Mở dải lệnh View chọn lệnh Page Break Preview để: A. Xem ngắt trang B. Xem trước trang in Câu 4: Để xem trước khi in, ta sử dụng nút lệnh nào sau đây?
A. Print B. Page Break Preview C. Fill Color D. Print Preview
D. Sắp xếp dữ liệu theo thứ tự giảm dần
B. Data/Sort Descending D. View/Filter
B. line.
C. Charts.
D.Pie.
D. Cả A, B, C đều đúng.
Câu5: Nút lệnh dùng để làm gì? A. Sắp xếp dữ liệu theo thứ tự tăng dần B. Lọc dữ liệu C. Tô màu chữ. Câu 6: Thao tác để lọc dữ liệu là A. Data/Filter trong nhóm Sort& Filter C. Data/Sort Ascending Câu 7:Nhóm lệnh để tạo biểu đồ trong chương trình bảng tính là A. Column. Câu 8: Xem trang tính trước khi in nhằm mục đích A. cho phép kiểm tra trước những gì sẽ in ra.B. kiểm tra việc trình bày đã hợp lý chưa. C. để xem việc điều chỉnh ngắt trang có hợp lý chưa. Câu 9:Trong hộp thoại Page Setup, để chọn hướng giấy ngang ta thực hiện lệnh nào sau đây? A. Chọn trang Margins và chọn Landscape. B. Chọn trang Margins và chọn Portrait. C. Chọn trang Page và chọn Landscape. D. Chọn trang Page và chọn Portrait. Câu 10: Để thêm hoặc ẩn tiêu đề của biểu đồ ta thực hiện: A. vào dải lệnh Layout, chọn lệnh Chart Title trong nhóm Labels B. vào dải lệnh Layout, chọn lệnh Axis Titles trong nhóm Labels C. vào dải lệnh Layout, chọn lệnh Legend trong nhóm Labels D. vào dải lệnh Layout, chọn lệnh Data labels trong nhóm Labels II- Tự luận: Câu 11. (2,5điểm) Em hãy trình bày các bước để tô màu nền và kẻ đường biên của các ô tính? Câu 12. (1 điểm) Sắp xếp dữ liệu là gì? Trình bày các bước để sắp xếp dữ liệu? Câu 13. (1 điểm) Em hãy trình bày các bước vẽ biểu đồ trên trang tính? Câu 14. (0,5 điểm) Cho Bảng Điểm Lớp 7A như sau:
Hãy nêu các bước để lọc ra 3 bạn có Điểm trung bình nhỏ nhất ?
BÀI LÀM
I. Trắc nghiệm:
Câu 1 Câu 2 Câu 3 Câu 4 Câu 5 Câu 6 Câu 7 Câu 8 Câu 9 Câu 10
II. Tự luận: .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. ......................................................................................................................................................
.................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ..................................................................................................................................................
.................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ......................................................................................................................................................
.................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ..................................................................................................................................................
.................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. .................................................................................................................................................. ...................................................................................................................................................... ...................................................................................................................................................... UBND HUYỆN CHÂU ĐỨC TRƯỜNG THCS PHAN BỘI CHÂU
HƯỚNG DẪN CHẤM ĐỀ KIỂM TRA HỌC KỲ II NĂM HỌC 2021 – 2022 Môn: Tin học – Lớp7 Thời gian: 45 phút
I.Trắc nghiệm:
Câu 1 Câu 2 Câu 3 Câu 4 Câu 5 Câu 6 Câu 7 Câu 8 Câu 9 Câu 10
B B A D D A C D C A
II.Tự luận:
NỘI DUNG
ĐIỂM
CÂU
1
Các bước để tô màu nền: - Chọn các ô cần tô màu nền - Nháy chuột tại mũi tên ở lệnh Fill Color - Chọn màu nền
Các bước để kẻ đường biên ô tính:
Câu 11 (2,5điểm)
0,5+0,5+0,5
- Chọn các ô cần kẻ đường biên - Nháy chọn mũi tên ở lệnh Borders - Nháy chọn kiểu đường biên
