1) 1. Pentru referirea grupului de celule din domeniul E1: G3 din Foaia Elevi folosim în altă foaie : a) a) Elevi E1:G3 b) Elevi! E1:G3 c) c) !Elevi E1:G3 d) d) E1:G3 2) 2. Care dintre urmatoarele formule calculeaza suma elementelor din domeniul B2:B7? a) Sum(B2,B7) b) =Sum(B2:B7) c) =Sum(B2,B7) d) Sum(B2:B7) 3) 3. Blocul E2:G2 indică celulele: a) E2,E3 b) E2,F2,G3 c) E2,G2 d) E2,F2,G2 4) 4.Ce efect are inserarea urmatoarei formule =sum(A1;A3)+sum(B1;B3) in Excel a) =A1+A2+A3+B1+B2+B3 b) =A1+A3+B1+B3 c) =A1+A3+B1+B2+B3 d) =A1+A2+B1+B2+B3 5) 5.Ce efect are inserarea urmatoarei formule =sum(A1:A3;B6) în Excel: a) =A1+A3+B6 b) =A1*A2*A3*B6 c) =B6+A3+A1+A2 d) =A1+A2+B6

Excel

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม