The program running is Excel.

Please provide formulas relating to the questions. Thank you.

Worksheet Seminars: 2. Use Data / Filter to turn on filters. You should see small arrows in each field heading cell. Apply the following filters on worksheet Seminars and write the answers into provided cells worksheet Database. Be sure to clear each filter the entire data set is used each time. After applying the filter, look at the bottom of the screen on left hand side to get the count. a. How many records with Topic values Marketing or Accounting? b. How many records with Type Undergrad in Location Beltway? c. How may records have a Cost over $1000? d. How many records have a Max value between $25 and $30 (inclusive)? e. Clear all filters in preparation for the next task. 3. Use the Data/Subtotal command to display sums of Cost by Type. Be sure to first sort the range by Type. a. Display in Level 2 showing only subtotals. Worksheet Database: 4. Range A1:H67 has been named Data. It includes the row of field names followed by all records. a. Use Data / Sort command to sort the data by field Topic. Sort duplicates by descending Cost. b. Fill in the provided criteria ranges to answer the questions using the database functions. Use range name Data in the computations. All database functions have the same set of arguments. The criteria range includes the row of field names and row(s) of criteria values. =DCOUNT(name of table, field name to be counted, criteria range) =DSUM(name of table, field name to be summed, criteria range) =DAVERAGE(name of table, field name to be averaged, criteria range) Seminar ID 101 102 103 104 105 10 109 110 112 114 116 117 118 18 119 19 120 20 121 123 124 126 127 27 128 28 129 29 130 30 131 31 133 32 134 33 135 34 136 35 137 36 138 37 139 38 140 39 141 40 143 Topic Marketing Accounting Information Systems Marketing Information Systems Management Marketing Management Finance Management Information Systems Management Marketing Management Management Marketing Marketing Accounting Information Systems Accounting Information Systems Information Systems Finance Marketing Marketing Management Marketing Marketing Finance Information Systems Accounting Management Finance Accounting Management Marketing Marketing Management Marketing Marketing Management Information Systems Management Marketing Management Marketing Marketing Marketing Marketing Accounting Marketing Information Systems Information Systems Finance Management Management Management Management Management Management Finance Management Accounting Finance Finance Marketing DEF GH Type Instructor Length Location Cost Max Undergrad Wheeler 3 Beltway 300 30 Graduate Connor 5 Beltway 1000 30 Undergrad Ginder 2.5 Main 250 25 Generalinterest Wheeler Beltway 525 30 Graduate Ginder 3.5 Main 700 25 Post Grad Moir 4 Beltway 1200 30 Generalinterest Vinson 3 Main 525 25 Post Grad Nguyen 4 Main 1200 25 Graduate Welker 5 Downtown 1000 20 Generalinterest Moir Beltway 525 30 Undergrad Conn 2.5 Main 250 25 Undergrad Moir Beltway 300 30 Undergrad Vinson Main 300 25 Post Grad Teague 4 Downtown 1200 20 Graduate Moir 4 Beltway 800 30 Post Grad Vinson Main 1200 25 Generalinterest Wheeler 3 Beltway 525 30 Graduate Hamilton 5 Main 1000 25 Graduate Conn 3.5 Main 700 25 Undergrad Connor 3 Beltway 300 30 Undergrad Flores 2.5 Main 250 25 Graduate Flores 3.5 Main 700 25 Post Grad Welker 5 Downtown 1500 20 Post Grad Parker 4 Downtown 1200 20 Graduate Parker 4 Downtown 800 20 Post Grad Teague 4 Downtown 1200 20 Generalinterest Vinson Main 525 25 Post Grad Wheeler Beltway 1200 30 Post Grad Suiter Beltway 1500 30 Post Grad Ginder Main 900 25 Generalinterest Hamilton Main 525 25 Undergrad Nguyen Main 300 25 Undergrad Welker Downtown 300 20 Post Grad Connor Beltway 1500 30 Graduate Nguyen 4 Main 800 25 Post Grad Vinson Main 1200 25 Undergrad Wheeler Beltway 300 30 Graduate Teague Downtown 800 20 Generalinterest Vinson Main 525 25 Post Grad Parker Downtown 1200 20 Undergrad Moir 3 Beltway 300 30 Post Grad Conn Main 900 25 General Interest Nguyen Main 525 25 Post Grad Parker Downtown 1200 20 Post Grad Moir Beltway 1200 30 Graduate Vinson 4 Main 800 25 Post Grad Wheeler 4 Beltway 1200 30 Graduate Parker 4 Downtown 800 20 Post Grad Vinson Main 1200 25 Graduate Hamilton Main 1000 25 Graduate Wheeler Beltway 800 30 Generalinterest Flores Main 350 25 General Interest Ginder Main 350 25 Graduate Suiter Beltway 1000 30 General Interest Nguyen Main 525 25 Generalinterest Teague Downtown 525 20 Post Grad Teague Downtown 1200 20 Post Grad Moir Beltway 1200 30 General Interest Teague Downtown 525 20 Post Grad Moir Beltway 1200 30 Graduate Suiter Beltway 1000 30 General Interest Teague Downtown 525 20 Generalinterest Connor Beltway 525 30 Generalinterest Welker Downtown 525 20 Post Grad Suiter 5 Beltway 1500 30 Graduate Parker 4 Downtown 800 20 5 146 147 4 5 M 45 149 46 150 47 151 48 152 49 153 50 154 51 155 52 156 157 158 159 160 57 161 58 163 59 164 60 165 169