WGU D075 Excel Functions

D075 Excel Functions Leave the first rating Students also studied Terms in this set (7) Western Governors UniversityD 075 Save Information Technology Manageme...17 terms wtfitsmeghan11 Preview Unit 3 Module 6 Learning Checks an...18 terms sking2designPreview Introduction to Spreadsheet D100 45 terms Amanda_Ferrone5 Preview Fundam 76 terms bro for this set Learn1 / 7Study using Learn (range,criteria,[sum_range]) =SUMIF(range,criteria,[sum_range]) =AVERAGEIF+(range, criteria, [average_range]) =COUNTIF(range,criteria) =HLOOKUP(lookup_value, table_array, row_index_num, [range-lookup]) Choose an answer

1=AVERAGEIF2=SUMIF

3=HLOOKUP4=IF

Don't know?

=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) =IF(logical_test,[value_if_true],[value_if_false]) Nested Lookup=VLOOKUP(lookup_value, table_array, hlookup(lookup_value,table_array,row_index_num))