Question 10: In Excel, cells A1=X, A2=”01”, A3=”02” A4=”03”. Give the result of the following formula: =COUNTA(A1:A4) A. 6 B. 4 C. 0 D. Will report Num REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 6: In Excel To select discretely, which key do we hold down while selecting? A. Shift B. Ctrl C. Alt D. Space REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 2: In Excel, with the data table according to the figure to count the number of warehouses, which of the following general formulas do we use? A. =SUMIF(A2:A5, “DN”) B. =COUNTA(A2:A5,”DN”) C. =SUMIF(A2:A5,”DN”,B2:B5) D. =COUNTIF(A2:A5,A2) EASY is the correct answer =============== Link Hoc va de thi 2021
Cho hình chóp (S.ABC). Mặt phẳng (left( P right)) song song với đáy cắt các cạnh (SA), (SB), (SC) lần lượt tại (D), (E), (F). Gọi ({D_1}), ({E_1}), ({F_1}) tương ứng là hình chiếu vuông góc của (D), (E), (F) lên mặt phẳng (left( {ABC} right))(tham khảo hình vẽ bên). (V) là thể tích khối […]
Question 45: In Excel, with the data table according to the figure, what is the result of the formula =COUNTIF(A1:F1,”>0”)? A. . 6 B. #Name? C. 4 D. #Value! OLD is the correct answer =============== Link Hoc va de thi 2021
Question 41: In Excel, with the data table shown in the figure, what is the return value of the formula =C2*IF(B2<22.15%,20%) cell D2? A. 52.5 B. 54 C. 350 D. 525 A is the correct answer =============== Link Hoc va de thi 2021
Question 37: In Excel, cell A1 contains the value 8, the formula =IF(A1>=5, “TB”, IF(A1>=7, “Good”, IF(A1>=8, “Good”, ““ excellent”))) how much does it return? A. Good B. TB C. Excellent D. Pretty REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 33: In Excel, what is the return value of the formula =LEN(“UTCKCN”)? A. 6 B. 7 C. 9 D. 8 REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 30: In Excel, with the data table according to the figure to calculate the average value of After Tax for Rice, which of the following formulas do we use? Question 30: In Excel, with the data table according to the figure to calculate the average value of After Tax for Rice, which of the […]
Level 26: To create/Delete the subscript we press the button or type the key combination A. Ctrl – +/= B. Format -> Font -> Subscript C. Sentences A and B are all wrong D. Sentences A and B are correct EASY is the correct answer =============== Link Hoc va de thi 2021