Use the data in Sheets 7a and 7b to answer the following questions: a. Sheet 7a worksheet contains two lists of names. U
Posted: Thu Jun 02, 2022 7:59 am
Use the data in Sheets 7a and 7b to answer the following questions:
a. Sheet 7a worksheet contains two lists of names. Use an array formula to count the number of names appearing on both lists.
b. Sheet 7b worksheet contains some calculations. Use an array formula to count the number of cells containing errors. Hint: Use the ISERROR function in your array formula.
t 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 37 38 29 40 41 42 43 44 45 46 47 48 49 50 x 0 :6 Jon J Bob Ann Annie Erica Adam Tad Brooke Archie Peyton Ron Erica Dirk Brooke Tracy Tad Derek Sheet 7a - 3 I - Sheet 7b 2 +
1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 B 6 с D Game At Bats 10 11 12 13 Sheet 7a 2 25555NNSSAO E Hits 02220 1 1 2 0 2 1 0 F ............. Sheet 7b G +
a. Sheet 7a worksheet contains two lists of names. Use an array formula to count the number of names appearing on both lists.
b. Sheet 7b worksheet contains some calculations. Use an array formula to count the number of cells containing errors. Hint: Use the ISERROR function in your array formula.
- Use The Data In Sheets 7a And 7b To Answer The Following Questions A Sheet 7a Worksheet Contains Two Lists Of Names U 1 (34.3 KiB) Viewed 16 times
- Use The Data In Sheets 7a And 7b To Answer The Following Questions A Sheet 7a Worksheet Contains Two Lists Of Names U 2 (34.7 KiB) Viewed 16 times
1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 B 6 с D Game At Bats 10 11 12 13 Sheet 7a 2 25555NNSSAO E Hits 02220 1 1 2 0 2 1 0 F ............. Sheet 7b G +