Question 28: In Excel, suppose cell D4 has the following formula: = HLOOKUP(A4, A10:D12, 5, TRUE) which part is incorrect? A. Component 1. B. Component 2. C. Component 3. D. The 4th component. OLD is the correct answer =============== Link Hoc va de thi 2021
Question 25: In Excel, cells A1 = 30, A2 = 30, A3 = “AQ”, A4 = 2. Please indicate the result of the following formula: =COUNTIF(A1:A4, “30”) A. 1 B. 2 C. 3 D. 4 A is the correct answer =============== Link Hoc va de thi 2021
Question 21: The result of the function: LEFT(“12AB012”, 3) A. 012 B. 12A C. 12 D. The above sentences are all wrong A is the correct answer =============== Link Hoc va de thi 2021
Question 17: Suppose A3 = “A01B2”, Indicate the return result of the following function =IF(mid(A3,2,2)= “01”, “ABC”, “DEF”) A. ABC B. DEF C. AB D. The above sentences are all wrong A is the correct answer =============== Link Hoc va de thi 2021
Question 13: In Excel to get n characters to the right of the string m we use? A. LEFT(n,m) B. RIGHT(m,n) C. LEFT(m,n) D. RIGHT(n,m) REMOVE is the correct answer =============== Link Hoc va de thi 2021
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