Back to Subject

Unit 11: Excel Data Analysis - Practice Quiz

ECAP792 60 Questions
0 Correct 0 Wrong 60 Left
0/60

1 In an Excel worksheet, what is the intersection of a row and a column called?

Introduction to Excel data analysis Easy
A. A cell
B. A range
C. A formula
D. A workbook

2 What is an Excel file containing one or more worksheets called?

Introduction to Excel data analysis Easy
A. A dashboard
B. A database
C. A document
D. A workbook

3 Which symbol normally begins a formula in Excel?

Introduction to Excel data analysis Easy
A. The hash sign (#)
B. The equal sign (=)
C. The percent sign (%)
D. The plus sign (+)

4 What is the Data Analysis ToolPak in Excel?

Data Analysis ToolPak Easy
A. A statistical analysis add-in
B. A cloud storage service
C. A chart design template
D. A worksheet formatting tool

5 After the Data Analysis ToolPak is enabled, where is its Data Analysis command usually found?

Data Analysis ToolPak Easy
A. On the Home tab
B. On the Review tab
C. On the Data tab
D. On the Insert tab

6 Which ToolPak option produces a summary containing measures such as the mean and standard deviation?

Data Analysis ToolPak Easy
A. Descriptive Statistics
B. Moving Average
C. Fourier Analysis
D. Random Number Generation

7 What must usually be done before using the Data Analysis ToolPak for the first time?

Data Analysis ToolPak Easy
A. Convert cells to text
B. Create a chart
C. Enable the add-in
D. Protect the worksheet

8 Which descriptive statistic represents the arithmetic average of a dataset?

Descriptive statistics Easy
A. Mode
B. Median
C. Mean
D. Range

9 Which statistic is the middle value when data is arranged in order?

Descriptive statistics Easy
A. Variance
B. Mean
C. Range
D. Median

10 Which statistic identifies the value that occurs most frequently?

Descriptive statistics Easy
A. Median
B. Range
C. Mean
D. Mode

11 What does standard deviation describe?

Descriptive statistics Easy
A. The most frequent value
B. The largest observed value
C. The total number of values
D. The spread of the values

12 What is the main purpose of ANOVA?

Analysis of variance (ANOVA) Easy
A. To create data labels
B. To count empty cells
C. To sort text values
D. To compare group means

13 What does the acronym ANOVA stand for?

Analysis of variance (ANOVA) Easy
A. Analysis of Variables
B. Average of Variances
C. Arrangement of Values
D. Analysis of Variance

14 A small ANOVA p-value typically provides evidence against which hypothesis?

Analysis of variance (ANOVA) Easy
A. All sample sizes are equal
B. All observations are positive
C. All group means are equal
D. All variables are text

15 What is regression analysis commonly used to examine?

Regression Easy
A. Cell border thickness
B. Relationships between variables
C. Duplicate worksheet names
D. Workbook file sizes

16 In simple linear regression, which variable is being predicted?

Regression Easy
A. The categorical label
B. The dependent variable
C. The worksheet variable
D. The independent variable

17 In the equation , what does represent?

Regression Easy
A. The residual
B. The intercept
C. The slope
D. The sample size

18 What does a histogram display?

Histogram Easy
A. The sequence of worksheet formulas
B. The hierarchy of workbook sections
C. The frequency distribution of numerical data
D. The relationship between two text columns

19 What are the intervals used to group values in a histogram called?

Histogram Easy
A. Labels
B. Bins
C. Legends
D. Series

20 What does the height of a histogram bar usually represent?

Histogram Easy
A. The bin's frequency
B. The bin's text label
C. The worksheet's width
D. The chart's title size

21 A worksheet contains customer IDs, regions, and sales amounts. You want to sort sales from largest to smallest while keeping each customer's data together. What should you do?

Introduction to Excel data analysis Medium
A. Copy the sales column elsewhere and sort the copied values
B. Select the entire data range and sort by the sales column
C. Convert the sales column to text before sorting the range
D. Select only the sales column and sort values descending

22 Sales amounts imported into Excel are left-aligned and formulas such as =AVERAGE(C2:C100) ignore them. What is the most likely solution?

Introduction to Excel data analysis Medium
A. Replace the formula with the COUNTA function
B. Apply a currency format to the sales entries
C. Sort the sales entries from smallest to largest
D. Convert the sales entries from text to numeric values

23 A data table grows every week, and charts should automatically include newly appended rows. Which Excel feature is most suitable?

Introduction to Excel data analysis Medium
A. Merge the heading cells above the data range
B. Freeze the first row of the data range
C. Convert the data range into an Excel Table
D. Protect the worksheet containing the data range

24 The Data Analysis command is not visible on Excel's Data tab. What should you do first?

Data Analysis ToolPak Medium
A. Change workbook calculation to automatic mode
B. Create a PivotTable from the current worksheet
C. Install a different worksheet function library
D. Enable the Analysis ToolPak through Excel Add-ins

25 A selected input range for a ToolPak analysis includes the heading Monthly Sales in its first row. Which setting should be selected?

Data Analysis ToolPak Medium
A. Kth largest
B. Labels in first row
C. Confidence level for mean
D. Summary statistics

26 You need to keep an analysis output separate from the source worksheet and avoid overwriting existing cells. Which output choice is best?

Data Analysis ToolPak Medium
A. New Worksheet Ply
B. Labels in First Row
C. Output Range
D. Grouped By Columns

27 A salary dataset has a mean of and a median of . Which interpretation is most reasonable?

Descriptive statistics Medium
A. Several low salaries may be pulling the median upward
B. The salary values must all be close to the mean
C. The salary distribution must be perfectly symmetric
D. Several high salaries may be pulling the mean upward

28 Two datasets have means of and , with standard deviations of and , respectively. Which dataset has greater relative variability?

Descriptive statistics Medium
A. The first, because its coefficient of variation is
B. The second, because its coefficient of variation is
C. The first, because its coefficient of variation is
D. The second, because its coefficient of variation is

29 The ToolPak reports a sample variance of for a dataset. What is the sample standard deviation?

Descriptive statistics Medium
A.
B.
C.
D.

30 Excel's Descriptive Statistics output gives a mean of and a Confidence Level (95.0%) value of . What is the corresponding confidence interval?

Descriptive statistics Medium
A. to
B. to
C. to
D. to

31 A company compares the mean delivery times of four warehouses using one-way ANOVA. What is the null hypothesis?

Analysis of variance (ANOVA) Medium
A. All four sample mean delivery times are different
B. At least two population variances are equal
C. Exactly one population mean is greater than the others
D. All four population mean delivery times are equal

32 An Excel ANOVA output reports and . What is the statistic?

Analysis of variance (ANOVA) Medium
A.
B.
C.
D.

33 A one-way ANOVA produces a p-value of at . Which conclusion is appropriate?

Analysis of variance (ANOVA) Medium
A. Reject the null; every population mean must differ
B. Reject the null; at least one population mean differs
C. Retain the null; all population means are identical
D. Retain the null; the sample variances are unequal

34 A researcher studies crop yield using two fertilizer types and three irrigation levels, with several plots under each combination. Which ToolPak procedure can test both main effects and their interaction?

Analysis of variance (ANOVA) Medium
A. ANOVA: Single Factor
B. Descriptive Statistics
C. ANOVA: Two-Factor Without Replication
D. ANOVA: Two-Factor With Replication

35 A regression of weekly sales on advertising spending gives an advertising coefficient of , where both variables are measured in thousands of dollars. How should the coefficient be interpreted?

Regression Medium
A. An extra in advertising predicts more in sales
B. Advertising accounts for exactly of weekly sales
C. An extra in advertising predicts more in sales
D. Weekly sales rise by dollars for each advertising dollar

36 An Excel regression output reports . What does this indicate?

Regression Medium
A. The response increases by for each predictor unit
B. The model explains of the variation in the response
C. The model predicts the response correctly in of cases
D. The correlation between the variables must equal

37 A regression coefficient has a p-value of when tested at . What is the best interpretation?

Regression Medium
A. The predictor is not statistically significant at the level
B. The model has a prediction error equal to units
C. The predictor has a statistically significant negative relationship
D. The predictor explains exactly of the response variation

38 A residual plot from a linear regression shows a clear U-shaped pattern. What does this most strongly suggest?

Regression Medium
A. The response has no relationship with the predictor
B. The fitted intercept must be exactly zero
C. A nonlinear relationship remains unmodeled
D. The observations have been sorted incorrectly

39 For Excel's Histogram ToolPak, the bin range contains , , and . Where is an observation of counted?

Histogram Medium
A. In the bin greater than and less than or equal to
B. In the bin greater than and less than or equal to
C. In both adjacent bins because it equals a boundary
D. In the overflow bin because it equals a bin value

40 A histogram of customer waiting times has most observations in lower-value bins and a long tail toward higher values. How should the distribution be described?

Histogram Medium
A. Negatively skewed
B. Approximately uniform
C. Perfectly symmetric
D. Positively skewed

41 A worksheet is filtered, and several additional rows are manually hidden. Which formula calculates the mean of only the currently visible values in B2:B100?

Introduction to Excel data analysis Hard
A. =AGGREGATE(1,4,B2:B100)
B. =SUBTOTAL(1,B2:B100)
C. =SUBTOTAL(101,B2:B100)
D. =AVERAGE(B2:B100)

42 Excel regression produces a slope of when sales are regressed on a column of daily dates. The date cells are then reformatted from daily dates to month names without changing their stored values. How should the slope be interpreted?

Introduction to Excel data analysis Hard
A. The slope becomes invalid after date reformatting.
B. Sales increase by units per date label.
C. Sales increase by units per month.
D. Sales increase by units per day.

43 A Descriptive Statistics input range contains 11 numeric observations, beginning with 100 in its first row. The user mistakenly selects Labels in first row. What is the most likely consequence?

Data Analysis ToolPak Hard
A. Excel retains 100 and labels the output with its address.
B. Excel detects the numeric header and analyzes all observations.
C. Excel treats 100 as a label and analyzes ten observations.
D. Excel rejects the range because labels must contain text.

44 A ToolPak regression report was generated from worksheet data. Several input observations are later corrected, but the report remains unchanged after recalculation. What action is required?

Data Analysis ToolPak Hard
A. Rerun the Regression analysis with the corrected input.
B. Press F9 after converting the output into a table.
C. Enable iterative calculation for the regression output range.
D. Replace the output coefficients with array formulas.

45 A variable has mean , sample standard deviation , skewness , and excess kurtosis . For , which set of descriptive statistics is correct?

Descriptive statistics Hard
A. Mean , standard deviation , skewness , kurtosis
B. Mean , standard deviation , skewness , kurtosis
C. Mean , standard deviation , skewness , kurtosis
D. Mean , standard deviation , skewness , kurtosis

46 The ToolPak reports a sample mean of and a 95% Confidence Level for Mean of . Which interpretation is correct?

Descriptive statistics Hard
A. The probability that the sample mean equals is 95%.
B. Approximately 95% of observations lie in .
C. The population standard deviation is estimated to be .
D. The estimated 95% confidence interval is .

47 Two samples have summaries and . If the raw observations are combined, what are the combined mean and sample variance?

Descriptive statistics Hard
A. Mean and variance
B. Mean and variance
C. Mean and variance
D. Mean and variance

48 A one-way ANOVA has three groups of five observations with means , , and . The within-group sum of squares is . What is the ANOVA statistic?

Analysis of variance (ANOVA) Hard
A.
B.
C.
D.

49 Three groups have sizes , , and and means , , and , respectively. Which grand mean must Excel use when calculating the between-group sum of squares?

Analysis of variance (ANOVA) Hard
A.
B.
C.
D.

50 Why can Excel's ANOVA: Two-Factor Without Replication not provide a separate test for interaction?

Analysis of variance (ANOVA) Hard
A. Interaction can be tested only when both factors are quantitative.
B. Interaction is included automatically in each factor's main effect.
C. Interaction requires both factors to have equal numbers of levels.
D. Interaction and random error are confounded with one observation per cell.

51 A balanced two-factor experiment has levels of factor A, levels of factor B, and observations per cell. What are the interaction and within-cell error degrees of freedom?

Analysis of variance (ANOVA) Hard
A. Interaction ; error
B. Interaction ; error
C. Interaction ; error
D. Interaction ; error

52 In a replicated experiment, the cell means are and for A1, but and for A2 across levels B1 and B2. Which conclusion best reflects this pattern?

Analysis of variance (ANOVA) Hard
A. Both main effects may vanish while the interaction remains strong.
B. Both main effects must be strong while interaction remains absent.
C. Only factor A can be significant because its profiles cross.
D. Only factor B can be significant because its means are reversed.

53 An Excel regression coefficient is with standard error and residual degrees of freedom. Given , what is its 95% confidence interval?

Regression Hard
A.
B.
C.
D.

54 A predictor is added to an ordinary least-squares regression using exactly the same observations. Which outcome is mathematically possible?

Regression Hard
A. increases while adjusted decreases.
B. decreases while adjusted increases.
C. Both measures must remain unchanged after addition.
D. Both measures must increase by the same amount.

55 A categorical predictor has three regions: North, South, and West. An Excel regression includes an intercept. Which encoding avoids perfect multicollinearity while retaining regional comparisons?

Regression Hard
A. Use one dummy variable that separates all three regions.
B. Use three dummy variables and retain the model intercept.
C. Use two dummy variables and treat one region as the reference.
D. Assign region codes , , and as one predictor.

56 A residual plot from an Excel linear regression shows residuals near zero for small and large fitted values but predominantly positive residuals in the middle. What is the strongest diagnosis?

Regression Hard
A. The linear specification is missing a curved relationship.
B. The response contains only normally distributed errors.
C. The residual variance is constant across fitted values.
D. The predictors exhibit perfect pairwise multicollinearity.

57 Excel's Regression tool is run with Constant is Zero selected. Why should its reported not be directly compared with the ordinary from a model containing an intercept?

Regression Hard
A. The zero-intercept model always produces a negative residual sum.
B. The zero-intercept model may use an uncentered definition of .
C. The intercept model calculates from standardized coefficients.
D. The intercept model excludes the response mean from all calculations.

58 The data are 0, 10, 10, 20, 20, 20, 31, and the ToolPak Histogram bin values are 10, 20, 30. What frequencies will Excel report for these bins and the More category?

Histogram Hard
A. 1, 2, 3, 1
B. 3, 3, 0, 1
C. 2, 3, 1, 1
D. 3, 0, 3, 1

59 An Excel FREQUENCY formula uses three bin limits: 10, 20, and 30. Why must its output array contain four cells?

Histogram Hard
A. The fourth cell stores the total number of input observations.
B. The fourth cell counts observations greater than the largest bin.
C. The fourth cell counts observations equal to the smallest bin.
D. The fourth cell counts blank and nonnumeric input cells.

60 Two histogram classes have widths and and frequencies and , respectively. If unequal-width classes must be compared without distorting visual area, what should their bar heights be?

Histogram Hard
A. and , using raw frequency
B. and , using frequency density
C. and , using frequency area
D. and , using relative width
Previous MCQ
Unit 10
Next MCQ
Unit 12