can somebody please help me with this question

6) A(n) ________ helps you to evaluate the decision you are trying to make, and get the returned values correct A) decision model B) decision tree C) true/false diagram D) IF function diagram

7) The following function is an example of a(n) ________ function. =IF(SUM(H2:J7)>Total_Sales,.05,"No Commission") A) integrated B) complex C) detailed D) compound

8) A ________ IF function uses IF functions as arguments within another IF function. A) multiple B) composite C) nested D) multipart

9) AND, OR, and NOT are examples of Excel ________ functions. A) conjunction B) combination C) aggregate D) union

10) Which of the following is the correct syntax when using the AND function within the IF function? A) =IF((B3<5 and c1>7),"Pass","Fail") B) =IF(AND(B3<5,C1>7),"Pass","Fail") C) =IF(AND(B3<5 or c1>7),"Pass","Fail") D) =AND(IF(B3<5,C1>7),"Pass","Fail")

11) All of the following statements are TRUE about conjunction functions EXCEPT: A) The AND function requires all arguments to be TRUE. B) The NOT function results in the opposite or reverse of a logical statement. C) The OR function requires at least one of the arguments to be TRUE. D) The AND and OR functions cannot be used in the same IF function.

12) The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted. A) COUNT B) COUNTA C) COUNTIF D) COUNTIFS

13) The first argument of the AVERAGEIFS function is ________. A) average_range B) criteria_range C) criteria D) logical_test

14) The third argument of the HLOOKUP function is ________. A) lookup_value B) row_index_number C) range_lookup D) table_array

15) The ________ function is a useful tool for detecting an error and displaying something more user friendly than an error message. A) IFMISTAKE B) ISMISTAKE C) IFERROR D) IS ERROR

16) All of the following statements are TRUE about nested IF functions EXCEPT: A) Each nested function needs a pair of parentheses. B) Excel color codes parentheses to indicate which parentheses are paired. C) Nested IF functions permit more than two outcomes. D) The outcome of a nested IF function is limited to numeric or text values.

17) The ________ function is a database function that is great for setting up a criteria range and calculating the sum based on the filters within that criteria range. A) DBSUM B) DATASUM C) DSUM D) DTSUM

18) All of the following statements are TRUE about an Excel database EXCEPT: A) An Excel database is a way of storing data that is made up of records and fields. B) In a database, each record is one unit of data. C) All database functions are named using the format DBXXX() where XXX is the name of the corresponding nondatabase Excel function. D) All database functions include the same three arguments.

19) All of the following statements are TRUE about the DSUM function EXCEPT: A) An advantage of using the DSUM function is that you can see the criteria on the worksheet and understand the calculation much easier. B) The DSUM function is a database function that is ideal for setting up a criteria range and then calculating the sum based on the filters within that criteria range. C) The criteria can be modified on the worksheet and the result is updated automatically. D) The criteria argument of the DSUM function is optional.

20) Which of the following is NOT a database function? A) DAVERAGE B) DCOUNT C) DMIN D) DCALC True/False

21) The IF function provides two outcomes, one when its logical test is true and one when its logical test is false. (True/False) T

22) A nested IF requires one or more IF functions joined by an AND function. (True/False) F

23) AND, OR, and NEVER are all examples of conjunction functions. (True/False)

24) The NEVER function allows creation of logical statements in which it creates the opposite or reverse result. (True/False)

25) The COUNTIFS function allows for multiple criteria in multiple ranges to be evaluated and counted. (True/False) T

26) The AVERAGEIFS function expands on the AVERAGEIF function, allowing multiple criteria to determine the subset of data. (True/False)

27) VLOOKUP and HLOOKUP are two functions used to look up a value and return data that is associated with that value. (True/False)

28) The VLOOKUP function is the more commonly used LOOKUP function. (True/False)

29) The DSUM function is a database function that is great for setting up a criteria range and then calculating the sum based on the filters within that criteria range. (True/False) 30) The syntax for the IFERROR function is =IFERROR(value, value_if_true) (True/False)

31) All of the following statements are TRUE regarding raw data EXCEPT: A) Raw data may be numeric or text. B) Raw data without context is meaningless to users. C) Information is another name for data. D) Raw data is unorganized.

32) ________ is data that has context, meaning, and relevance. A) Information B) Raw data C) A data element D) A variable set

33) ________ is the name used for a collection of related sets of information that are composed of separate elements. A) Information sets B) Variable sets C) Data sets D) Field sets

34) Which of the following should NOT be performed in an effort to protect the integrity of data? A) Keep a backup of original data. B) Whenever possible, keep data and the analysis of that data on the same worksheet. C) Check data for completeness and accuracy. D) Organize data within a workbook in a meaningful manner.

35) A table can be created by selecting a range on an Excel worksheet, clicking the ________ tab, clicking the Format as Table button, and selecting a table style. A) Home B) Insert C) Data D) Design

36) To change a table back to a range of data, click ________ located in the Tools group on the Design tab. A) Convert to Data B) Convert to Range C) Convert to Information D) Convert to Cells

37) When using the ________ Filter feature in Excel, filtering criteria will be listed on the same worksheet. A) Advanced B) Enhanced C) Standard D) Additional

38) Click ________ in the Sort & Filter group on the Data tab to remove any existing filters that have been applied to a data set on the Excel worksheet. A) Delete B) Clear C) Remove D) Cancel

39) The ________ function will run calculations on data that is in a subset when a filter is applied. A) SUM B) TOTAL C) SUBTOTAL D) SUMMARY

40) Which of the following functions is NOT available as an option when selecting the SUBTOTAL function's first argument? A) IF B) SUM C) AVERAGE D) COUNT

41) ________ are interactive tables that extract, organize, and summarize data. A) DataTables B) PivotTables C) ValueTables D) VariableTables

42) Which of the following is NOT a benefit of using PivotTables? A) PivotTables are useful when working with a huge table of data. B) PivotTables are useful when looking for trends. C) PivotTables are useful for summarizing data. D) PivotTables are useful for to consolidate multi-worksheet data.

43) All of the following statements are TRUE regarding PivotTables EXCEPT: A) Multiple PivotTables are allowed on one worksheet for comparison and analysis purposes. B) Prior to creating a PivotTable, any desired calculated fields should be added. C) PivotTables can be created on a new worksheet or an existing worksheet. D) PivotTables automatically expand and contract on a worksheet as variables are added, removed, or rearranged.

44) ________ variables are fields within a data set that can be used to categorize or group for comparison. A) Aggregate B) Category C) Grouping D) Summary

45) ________ variables are data that can be aggregated by summing, counting, or averaging. A) Aggregate B) Category C) Grouping D) Summary