Multiple Choice
Mary has been tasked with reviewing a large data file. She wants to begin by first inspecting the number of values in each cell, both numeric and non-numeric, for any blank entries. The plan is to first find the blank or missing values for first review. Using Excel, what function(s) should she use to complete this task?
A) COUNT
B) COUNTA
C) COUNTIF
D) Both COUNT and COUNTA
Correct Answer:
Verified
Correct Answer:
Verified
Q2: To view only a portion of the
Q3: Henry wants to analyze income, but the
Q4: The following table contains 2 variables with
Q5: In a data set with 18 variables,
Q6: Molly wants to view observations with missing
Q7: Mary in the accounting department has been
Q8: Using the omission strategy, what value would
Q9: The following table contains 2 variables with
Q10: Michael is examining a data set and
Q11: The function that provides a natural logarithm