Back to Subject

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

GEN532 — Research Methodology 60 Questions
0 Correct 0 Wrong 60 Left
0/60

1 In Microsoft Excel, what is a workbook?

basic introduction to sheets/workbook Easy
A. A file that contains one or more worksheets
B. A type of chart used for reports
C. A row of formatted data
D. A single cell in a worksheet

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

basic introduction to sheets/workbook Easy
A. .txt
B. .docx
C. .xlsx
D. .pptx

3 In Excel, a cell is best described as:

cell Easy
A. A horizontal line of data only
B. The intersection of a row and a column
C. A saved copy of the workbook
D. A collection of all worksheets

4 What does the cell reference B3 indicate?

cell Easy
A. Column B, Row 3
B. Row B, Column 3
C. The third workbook
D. Block number 3

5 In an Excel worksheet, rows are identified by:

row Easy
A. Letters (A, B, C, ...)
B. Roman numerals (I, II, III)
C. Symbols (@, #, $)
D. Numbers (1, 2, 3, ...)

6 In an Excel worksheet, columns are labelled using:

columns Easy
A. Dates (Jan, Feb, ...)
B. Letters (A, B, C, ...)
C. Numbers (1, 2, 3, ...)
D. Colours (Red, Blue, ...)

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

basic operations Easy
A. # (hash sign)
B. @ (at sign)
C. = (equals sign)
D. + (plus sign)

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

basic operations Easy
A. COUNT
B. AVERAGE
C. SUM
D. MAX

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

basic operations Easy
A. SUM
B. ROUND
C. AVERAGE
D. COUNT

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

use of all excel options and add-ins Easy
A. An extra program that adds features to Excel
B. A shortcut to close the file
C. A single cell containing a total
D. A saved chart template

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

use of all excel options and add-ins Easy
A. Print Preview
B. Zoom Slider
C. Analysis ToolPak
D. Spell Check

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

tabulation and graphical Presentation: discrete data, continuous data and frequency distributions Easy
A. Weight of parcels in kg
B. Height of students in cm
C. Temperature of a room
D. Number of students in a class

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

tabulation and graphical Presentation: discrete data, continuous data and frequency distributions Easy
A. Number of goals scored
B. Height of a person
C. Number of cars in a lot
D. Number of books on a shelf

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

tabulation and graphical Presentation: discrete data, continuous data and frequency distributions Easy
A. The average of all values
B. The smallest value in the data
C. The largest value in the data
D. The number of times it occurs

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

diagrammatic and graphical representation of data Easy
A. Remove all errors from the data
B. Convert qualitative data into money
C. Increase the total number of observations
D. Make data easier to understand at a glance

16 A bar diagram represents data using:

bar diagram Easy
A. Rectangular bars of equal width
B. Connected straight line segments
C. Continuous adjacent rectangles
D. Circular slices of a circle

17 A pie-chart displays data as:

pie-chart Easy
A. Points joined by a smooth curve
B. Bars arranged along a horizontal axis
C. Rows and columns of numbers
D. Slices of a circle representing proportions

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

pie-chart Easy
A.
B.
C.
D.

19 A line chart is most suitable for showing:

line chart Easy
A. Trends over time
B. Proportions of a whole
C. Comparison of unrelated categories
D. Frequency of grouped classes

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

histogram Easy
A. Bars drawn with wide gaps
B. Bars with no gaps between them
C. Bars that are always circular
D. Only one bar per chart

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

cell, row, columns Medium
A. Column 7, Row D
B. Sheet D, Cell 7
C. Row D, Column 7
D. Column D, Row 7

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

basic operations Medium
A. 20
B. 24
C. 9
D. 14

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

basic operations Medium
A. =$A2*C$1
B. =A2*$C$1
C. =A$2*$C1
D. =A2*C1

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

basic introduction to sheets/workbook Medium
A. A workbook can contain many worksheets
B. A worksheet contains many workbooks and cells
C. A workbook and worksheet are the same thing
D. A worksheet can contain many workbooks

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

basic operations Medium
A. =COUNTBLANK(A1:A10)
B. =SUM(A1:A10)
C. =COUNTA(A1:A10)
D. =COUNT(A1:A10)

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

use of all excel options and add-ins Medium
A. Solver Add-in
B. Analysis ToolPak
C. Power Query
D. Format Painter

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

use of all excel options and add-ins Medium
A. Creating pivot tables automatically
B. Importing data from web pages
C. Formatting large tables quickly
D. Finding optimal values under constraints

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

discrete data, continuous data and frequency distributions Medium
A. Height of students in cm
B. Count of defective items
C. Number of children in a family
D. Number of cars in a parking lot

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

discrete data, continuous data and frequency distributions Medium
A. 10
B. 30
C. 25
D. 20

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

discrete data, continuous data and frequency distributions Medium
A. 10
B. 15
C. 5
D. 20

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

bar diagram Medium
A. Histogram
B. Frequency polygon
C. Simple bar diagram
D. Ogive curve

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

bar diagram Medium
A. Sub-divided (component) bar diagram
B. Percentage bar diagram
C. Multiple bar diagram
D. Simple bar diagram

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

pie-chart Medium
A.
B.
C.
D.

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?

pie-chart Medium
A.
B.
C.
D.

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

line chart Medium
A. Distribution of a single continuous variable
B. Proportion of parts to a whole
C. Trend of a variable over time
D. Comparison of unrelated categories

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

histogram Medium
A. Histogram bars have gaps; bar diagram bars touch
B. Both always have gaps between bars
C. Both never have gaps between bars
D. Histogram bars touch each other; bar diagram bars have gaps

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?

histogram Medium
A. Frequency density
B. Cumulative frequency
C. Raw frequency
D. Class mark

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

frequency polygon and Ogive curves Medium
A. Class mid-points
B. Cumulative frequencies
C. Lower class limits
D. Upper class limits

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

frequency polygon and Ogive curves Medium
A. Median
B. Range
C. Mean
D. Mode

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

graphs and their presentation Medium
A. Upper class boundaries
B. Class mid-points
C. Lower class boundaries
D. Class widths

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?

cell, row, columns Hard
A. =C$1*$A4
B. =D$1*$A5
C. =A$1*$A4
D. =C$3*$A5

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?

basic operations Hard
A. =COUNTIF(A1:A10,">"&AVERAGE(A1:A10))
B. =SUMIF(A1:A10,">"&AVERAGE(A1:A10))
C. =COUNTIF(A1:A10,>AVERAGE(A1:A10))
D. =COUNTIF(A1:A10,">AVERAGE(A1:A10)")

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?

continuous data and frequency distributions Hard
A. Raw frequency of each class
B. Relative frequency as a percentage
C. Frequency density, computed as
D. Cumulative frequency up to that class

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?

Ogive curves Hard
A. The median
B. The mode
C. The geometric mean
D. The arithmetic mean

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?

pie-chart Hard
A.
B.
C.
D.

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?

use of all excel options and add-ins Hard
A. Power Query, enabled through the Data tab by default
B. Analysis ToolPak, enabled via File → Options → Add-ins → Manage Excel Add-ins → Go
C. Power Pivot, enabled automatically in all Excel versions
D. Solver, enabled via the Formulas tab under Calculation Options

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

histogram Hard
A. A histogram can only show percentages while a bar diagram shows raw counts
B. A histogram always uses vertical bars while a bar diagram uses horizontal bars
C. In a histogram bars touch each other because the variable is continuous, whereas in a bar diagram bars are separated because categories are discrete
D. A histogram requires equal class widths while a bar diagram allows unequal widths

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

frequency polygon and Ogive curves Hard
A. (class width, frequency density)
B. (lower class boundary, cumulative frequency)
C. (upper class boundary, frequency)
D. (class mid-point, frequency)

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?

basic operations Hard
A. NA then NA
B. #VALUE! then 3
C. #NUM! then NA
D. NA then 3

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

discrete data Hard
A. A line/spike chart or bar diagram with gaps between values
B. A histogram with adjoining bars
C. A smoothed frequency curve
D. A cumulative ogive with continuous class boundaries

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?

cell, row, columns Hard
A. =VLOOKUP(MAX(Sales),Sales,1)
B. =INDEX(Sales,COUNT(Sales)) only if there are no blanks anywhere
C. =LOOKUP(2,1/(Sales<>""),Sales)
D. =OFFSET(Sales,COUNTA(Sales),0)

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

graphs and their presentation Hard
A. When the data are purely categorical with no numeric measure
B. When representing parts of a single whole
C. When all data series share identical scales and units
D. When two data series have very different magnitudes or units but a related trend should be compared

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?

continuous data and frequency distributions Hard
A.
B.
C.
D.

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?

bar diagram Hard
A. Both regions have equal totals
B. Product A has a larger absolute value in that region
C. Product A forms a larger proportion of that region's total, not necessarily a larger absolute amount
D. Product A's absolute quantity is identical across the two regions

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?

use of all excel options and add-ins Hard
A. A PivotTable, which requires the source data to have a single header row with no fully blank columns
B. Data Validation, which requires the data to be in a single column
C. A regular chart, which requires the data to be pre-sorted alphabetically
D. Conditional Formatting, which requires named ranges for each region

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?

line chart Hard
A. A flat zero line across the missing points; choosing 'Gaps' bridges them
B. Duplicated last known value; choosing 'Gaps' bridges them
C. Breaks in the line at missing points; choosing 'Connect data points with line' bridges them
D. Interpolated curved segments; choosing 'Zero' bridges them

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

basic introduction to sheets/workbook Hard
A. An error, because sheet names cannot contain spaces
B. A 3-D reference summing cell B2 across all sheets positioned from 'Jan Data' to 'Mar Data'
C. A relative reference to a range on a single sheet named 'Jan Data:Mar Data'
D. An external workbook reference to three linked files

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

diagrammatic and graphical representation of data Hard
A. Diagrams give only an approximate visual impression and cannot convey precise numerical values
B. Diagrams eliminate the need for a title and source note
C. Diagrams are always more suitable for statistical computation than tables
D. Diagrams can display far more decimal precision than tables

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

frequency polygon and Ogive curves Hard
A. To convert the polygon into a cumulative ogive
B. To smooth the curve into a normal distribution
C. To increase the number of classes and improve precision
D. To anchor the polygon to the x-axis so the total area enclosed equals the histogram's area

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?

tabulation and graphical Presentation: discrete data Hard
A.
B.
C.
D.
Previous MCQ
Unit 3
Next MCQ
Unit 5