SPREADSHEETS & DATA
PRESENTATIONS OA PRACTICE
EXAMINATION 2026 QUESTIONS WITH
ANSWERS GRADED A+
◍ Groups.
Answer: Collections of related commands.
◍ Quantitive data.
Answer: numerical data
◍ Line Chart.
Answer: A chart that uses points connected by a line to illustrate values in a
worksheet.
◍ Review.
Answer: Menu items facilitating sharing Excel workbooks.
◍ Bar Chart.
Answer: A type of chart that presents data with horizontal bars.
◍ Active Cell.
Answer: The cell in the worksheet in which you can type data.
◍ Attributes.
Answer: Styling features used to change the appearance of text.
◍ Days since last.
Answer: =DATEDIF(J21,J27,"D")
◍ Years since.
, Answer: =YEARFRAC(J27,J21)
◍ Measure.
Answer: An attribute in a dataset used to classify numerical values.
◍ Mathematical Functions.
Answer: Functions that manipulate quantitative data in a worksheet.
◍ Pie Chart.
Answer: A chart displaying parts of a whole dataset, often in percentages.
◍ Number.
Answer: An option in Excel defining various number formats for display.
◍ Legend.
Answer: A visual guide that explains the data series and their corresponding
colored elements on a chart.
◍ Plot Area.
Answer: The graphical representation of all of the data series.
◍ Qualitative.
Answer: A dimension is used to classify data. (WORDS)
◍ Product.
Answer: A function multiplying a set of values in Excel.
◍ PivotTable.
Answer: A table summarizing and reorganizing data based on categories.
◍ Quantitative.
Answer: Measures are used to complete calculations. (NUMBERS)
◍ Pie Chart.
Answer: A chart that shows the relationship of a part to a whole.
◍ qualative data.
Answer: descriptive data
◍ Borders.