Grade

Type of questions

IT Undergraduate

パソコン得意な方、至急お願い致します。 Q3が分からないです。 I17セルに出席番号が偶数で女子に該当したらそのまま国語の点数を反映するよう入力したつもりなのですが、全て0になってしまいます。とこが間違ってますか? ※画像荒くてすみません

遊ゴシック 11 AA 折り返して全体を表示する 標準 EB [貼り付け] BIU- 2 クリップボード フォント セルを結合して中央揃え 配置 +%⁹ 2 数値 117 A A fx =IF(AND((MOD (ROW(B17),2)=0),E17="女"),$F17,0) B C D F G H 0 1 2 3 10 11 12345678911 12 13 条件付きテーブルとしてセルの 書式設定スタイル 下の表の成績表データから、次の Q1 ~Q3の集計を行い、 結果の数値もしくは結果を計算する数式を G8:G10 に記入せよ。 以下のどちらの方法でもよい。 ・表の1列目より右側を使い、 集計用の列を適宜作った上で、最終的な結果を別途求める ・G8からG10セルにSUMPRODUCT 関数を用いた数式を入力し、元のデータから一気に求める。 Q1:A班 の男子の人数は? Q2: 数学か英語で50点未満の点数を取っている人数は? Q3: 出席番号が偶数の女子の国語の平均点 スタイル B H 挿入 削除 書式 セル WE A 2 並べ フィル J K L M N 出席番号 氏名 班 性別 国語 数学 H 英語 3 H Q3 17 4 海老原梢 C 19 6 宮本 茉莉 A 123 10 高原 C 25 12 笹森 歩美 C 27 14 山崎 凛子 A 29 16 深井 心美 B (31) 18 大井 B 33 20 谷口 絢子 B 35 22 竹本 紗季 B 37 24 長谷川 五月 C 39 26 内田 紗綾子 B 43 30 堀井 美奈 C 女女女女女女女女女女女女 63 48 63 64 18 32 55 38 65 10 64 18 30 0 59 77 40 195 44 27 77 46 35 80 41 51 70 85 17 55 71 62 68 62 26 57 32 61 000000001 44 45

Waiting for Answers Answers: 0
English Senior High

至急です。試験範囲なので教えてください🙏🙏

第1章 □ 13. My best friend and I ( ) each other since we were five. (神奈川大) ④knowing ①have known 2 know 3 knew 24. If it ( ) on Thursday, we will not go to the beach. (西南学院大) ids ①rains would rain ③rained has been rained 14. My friend from Africa ( ) snow until he came to Japan. (日本大) ago. ①has not seen 3 had never seen Joq was never seeing will have seen al ofie S 25. I don't know if our teacher ( ①camera ②come ien ( ) back next week.d( 3comes (東北薬科大) 4 will come gablem at 時制 15. When Mary was introduced to Mrs. Smith, she realized she ( ) her before. elids ③will meet was meeting 3 Dis meeting □ 16. At the end of next month, we ( ) here for three years. had met (東海大) ①leave 3. (this stone adoleft 30 (立命館大) 27. I wonder when he ( ①come ) next. ①have lived live ③will have lived will live betes 26. Turn off the lights when you (br) the room. ( ③will leave cause it ) yded ed Oleaving D (日本大) smod v②coming (nedloqa had come \I\e will come (日本大) ☐ 4.1 was nger in the shopping mall. Dspoken by 17. I really must go and see the dentist. One of my teeth ( ) for weeks. @being spoken Dached 2aches 3 has been aching is aching 18. I ( ) my homework for an hour when my mother came home. (大阪経済法科大) gile@ Dam doing 2 was doing 3 have been doing had been doing (共立女子大) D gaiblod od lliw bled ad lliw blod Hiw 9 ) noitools Intone A 20 Baiblod ai① 5. The room should ( Obe kept ) clean at all times @batept) bear of seeded over Y are gnitisqet need asdⓇ gairinger ai 6. When I came other hat the 東北福祉大) s building Obeing built .89mit in1976e 19. She ( ) in the accounting department for 10 years by the end of next month. ①has worked gatiog me 7. Michael ( ③3 will have been working has been working is working (国士舘大) gnibrawe need asd go ) 1015xib adf to bebrown ead bbw gingle Player three wensed and @has selected has been selecting trode) 1.8 810 Writing 20. When I woke up this morning, I decided I ( ) to get in shape. 杏林大) )vedT 8. C ①want ②wanted 3 will want 4 had wanted sqft 18beads ( 最頻出の項目を、もう一度書いて覚えよう。 ) awon ai dtime.eM nd that ☐ 1. I got your letter last week. I'm sorry (didn't / haven't/back/I/ written). boiling 21. Yesterday in science class, I learned that water ( ) at 100°C. ①was boiling 3 boils (大谷大) (1語不要) (武蔵大) 4 boil ☐ 2. (began / begun / the class / already / had) when I arrived. (1) 22. I will ask him about it as soon as he () back. ⑪come 2 comes bib@ ③will come (国士舘大) wen & Jdgood o 4 would have come (国士舘大) bassaid □ 3. もし天気 (the weather) が良ければ, 私たちは明日泳ぎに行く。 (1語不要) (防衛医科大) 23. I'll be back before it ( Drain ). ②rains wad nodw exey evil Tol nobno ni ( 3 will rain 4would rain ed (立命館大) We (the swimming / weather / will/be/is/tomorrow/go/if) fine. 6

Waiting Answers: 0