題庫堂
檢索
題庫堂
首頁
數學
英文學習
政治學
統計學
經濟學
藥理學
中醫藥物學
財政學
法學知識
公共行政
警察學
BI規劃師
財務管理
公共衛生學
工程經濟學
電力電子學
當前位置:
首頁
47.在使用 EXCEL 過程中,若要統計出儲存格 A1 至儲存格 A1000 範圍中,有多少個儲存格的值等於100 時,可以使用下列哪一個函數?(A) VLOOKUP (B) SUMIF(C) CO
問題詳情
47.在使用 EXCEL 過程中,若要統計出儲存格 A1 至儲存格 A1000 範圍中,有多少個儲存格的值等於100 時,可以使用下列哪一個函數?
(A) VLOOKUP
(B) SUMIF
(C) COUNTIF
(D) IF
參考答案
答案:C
難度:適中0.5
統計:A(0),B(0),C(0),D(0),E(0)
上一篇 :
2. Tom’s explanation was received as a _________ story, with no one showing sympathy to his conditio
下一篇 :
12. According to the organization, its _________ conference next year will be held in Peru.(A)annual
資訊推薦
3. Many candidates resort to _________ tactics to cast a negative light on their rivals.(A)stalled (
48.在使用 EXCEL 過程中,有關小計的說明,下列何者正確?(A)能把摘要置於小計資料左方(B)能把摘要置於小計資料右方(C)能把摘要置於小計資料上方(D)能把摘要置於小計資料下方
22. Mary worked day and night in summer _________ she could save money to pay her tuition.(A)unless
13. The restaurant _________ its customers from bringing their own food or beverages.(A)complicates
4. Having won the famous contest, the young pianist has been _________ into the spotlight.(A)discard
49.在使用 EXCEL 過程中,下列何者無法用來篩選?(A)文字 (B)色彩(C)數字 (D)圖形
【題組】32. (A)prosperity (B) opportunity (C) minority(D)continuity
23. Had I known the flight to Toronto was cancelled, I _________ there.(A)will drive (B) would drive
14. You are not going to _________ my respect if you keep using that kind of rude attitude talking t
5. He is never a good communicator because he speaks in _________ sentences most of the time.(A)easy
50.王老師在期末考後想利用 Word 合併列印功能,印出大量的成績單時,需以下列何者功能完成?(A)成績資料為主文件檔(B)空白成績通知單文件為資料檔(C)空白成績通知單文件為主文件檔(D)選擇建立
【題組】33. (A)unless (B) even if (C) so that(D)only when
24. Critics of the politician say that his policies are _________ idealistic to implement in reality
15. Rumor has it that the company shuts down due to _________ conflicts between the managers.(A)arti
6. To support equality and diversity among people, the Taiwanese government has promoted gender_____
6. He has no choice but _____ to Mr. Hambrick for what he did to him yesterday evening. (A)toapologi
【題組】34. (A)major (B) majored (C) majors(D)majoring
25. _________ the document might not be complete, it is significant for historians.(A)Although (B) B
二、文法測驗【請在下列各題中選出最適當的答案】16. We are having a dinner party at Grand Hotel tomorrow evening, _________ ?
7. International food giants such as MacDonald and Pizza Hut have tried hard to _________ to the loc
26. 請依規則找出接下來的數字 1 6 9 13 17 __ 25 27 (A)19 (B)20 (C)22 (D)23
【題組】35. (A)task (B) job (C) sign(D)gap
26. Next week, my uncle and his wife, both of _________ are teaching in the U.S.A., will come back t
17. My friends from South Africa _________ many places around the island ever since they came to Tai
8. After the disaster, many people _________ both money and supplies, hoping to help the victims.(A)