Unit 4: Basic Introduction to Excel, tabulation and graphical presentation - Practice Quiz

1 In Microsoft Excel, what is a workbook?

2 What is the default file extension for an Excel workbook in modern versions?

3 In Excel, a cell is best described as:

4 What does the cell reference B3 indicate?

5 In an Excel worksheet, rows are identified by:

6 In an Excel worksheet, columns are labelled using:

7 In Excel, every formula must begin with which symbol?

8 Which function is used to add a range of numbers in Excel?

9 Which Excel function returns the arithmetic mean of a group of numbers?

10 In Excel, an add-in is best described as:

11 Which Excel add-in is commonly used for statistical data analysis?

12 Which of the following is an example of discrete data?

13 Which of the following is an example of continuous data?

14 In a frequency distribution, the frequency of a value refers to:

15 The main advantage of representing data using diagrams and graphs is that they:

16 A bar diagram represents data using:

17 A pie-chart displays data as:

18 The total angle of all sectors in a pie-chart equals:

19 A line chart is most suitable for showing:

20 A key feature that distinguishes a histogram from a bar diagram is that a histogram has:

21 In Excel, if the active cell reference shown in the Name Box is D7, what does this indicate about the cell's position?

22 A cell contains the formula =B2+B3*B4. If B2=2, B3=3, and B4=4, what value is displayed?

23 Which formula correctly uses an absolute reference so that copying it down keeps referring to cell C1?

24 In a single Excel file, what is the correct relationship between a workbook and a worksheet?

25 Which function should be used to count only the cells in range A1:A10 that contain numbers?

26 Which Excel add-in must typically be enabled to perform statistical procedures such as regression and ANOVA?

27 The Solver add-in in Excel is primarily used for which purpose?

28 Which of the following is an example of continuous data?

29 For the class interval in a frequency distribution, what is the class mark (mid-point)?

30 In a continuous frequency distribution with class intervals , the class width (size) of each interval is:

31 Which type of diagram is most appropriate to compare the total sales of five different products in a single year?

32 A bar diagram that shows each bar divided into segments representing sub-categories is called a:

33 In a pie chart, an item that accounts for of the total will occupy a sector of what angle?

34 A category represents a value of 50 out of a total of 200. What central angle should its slice occupy in a pie chart?

35 A line chart is most suitable for displaying which kind of information?

36 What is the key difference between a histogram and a bar diagram?

37 When class intervals in a histogram are of unequal width, what should be plotted on the vertical axis to keep areas proportional to frequency?

38 A frequency polygon is constructed by plotting frequencies against which value on the x-axis?

39 The point where the 'less than' ogive and the 'more than' ogive intersect gives the value of the:

40 To plot a 'less than' ogive, cumulative frequencies are plotted against which values?

41 In Excel, cell B3 contains the formula =A$1*$A2. If this formula is copied to cell D5, what will the resulting formula be?

42 A dataset has values in A1:A10. Which formula correctly returns the number of cells whose value is strictly greater than the average of the range, excluding any text or blank entries?

43 For a continuous frequency distribution with class intervals of unequal width, the correct height of each histogram bar should be proportional to which quantity?

44 The point where the 'less than' ogive and the 'more than' ogive intersect, when a perpendicular is dropped to the x-axis, gives which statistical measure?

45 In a pie chart representing a budget, the 'Housing' category has a sector angle of . If total expenditure is , what amount corresponds to Housing?

46 You want to run a regression analysis with residual plots directly in Excel without writing formulas. Which built-in add-in provides this functionality, and where must it be enabled?

47 Which statement best distinguishes a histogram from a bar diagram?

48 When constructing a frequency polygon directly (without a histogram), each point is plotted using which pair of coordinates?

49 A user enters =IF(A1>0,SQRT(A1),"NA") in cell B1. If A1 contains -4, and then A1 is changed to text "9", what does B1 display in each case respectively?

50 For discrete data such as the number of children per family, which graphical representation is most appropriate?

51 A worksheet has data in rows 1–1000. You define a named range Sales referring to =Sheet1!$B$2:$B$1000. Which formula correctly returns the last non-empty numeric value in that column, assuming no gaps affect it?

52 A dual-axis (secondary axis) chart is most appropriate in which situation?

53 A class interval is stated as in an inclusive (discrete) presentation. When converting to continuous class boundaries for a histogram, what does this interval become?

54 In a percentage (100%) stacked bar diagram comparing three regions, one bar's segment for 'Product A' appears larger than another region's 'Product A' segment. What can you definitively conclude?

55 You have a large table and want to summarize sales by region and month interactively, with drag-and-drop reconfiguration. Which Excel feature is designed for this, and what is a key requirement of the source data?

56 A line chart plots monthly values but has missing data for two months. Excel's default 'Show empty cells as' setting for a line chart is 'Gaps'. What visual result does this produce, and which alternative connects the line across the gap?

57 A formula in Sheet2 reads =SUM('Jan Data:Mar Data'!B2). What kind of reference is this, and what does it compute?

58 Which of the following is a fundamental limitation of diagrammatic representation compared to tabulation?

59 When drawing a frequency polygon over a histogram, two extra points are added at each end of the distribution. Why?

60 A frequency table for a discrete variable shows values 0–5 with frequencies. To find the proportion of observations at value , you compute the cumulative frequency up to 2 divided by . If frequencies for 0,1,2 are 5, 8, 7 and , what is this proportion?