SPREADSHEETS & DATA
PRESENTATIONS OA ACTUAL EXAM
PAPER 2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ Currency.
Answer: Used to define a number as money; currency values will be
displayed with the monetary symbol appropriate for the currency described
in two decimal places
◍ Bold.
Answer: A feature in the font group, that thickens and darkens the font face,
making it stand out
◍ Table filters.
Answer: A feature that allows users to display table rows based on values in
a specific column
◍ Landscape orientation.
Answer: A page layout in which documents are printed across the length of
a page, making the page wider than it is tall
◍ Duplicate Data.
Answer: Data that are entered more than once, when all elements of the data
are the same
◍ Cell.
Answer: Small box that stores an individual piece of data or a calculation in
a worksheet
, ◍ Formulas.
Answer: The calculations performed in a spreadsheet.
◍ Find and Replace.
Answer: An Excel tool that finds values and replaces them with other
specified values
◍ Formulas.
Answer: Group of menu items used to perform calculations using excels
built in functions
◍ Max.
Answer: The function that displays the largest cell value in a data set
◍ Window.
Answer: View of the current workbook
◍ Expression.
Answer: The calculation prescribed by a formula in a spreadsheet.
◍ Draw.
Answer: Group of menu items used to insert freehand sketches into
worksheets
◍ Column Chart.
Answer: a chart that uses bars of varying height to illustrate values in a
worksheet
◍ Clip art.
Answer: Electronic artwork available on the computer.
◍ LIne Chart.
Answer: A chart that uses points connected by a line to illustrate values in a
worksheet
◍ Column Headings.
Answer: The first row in a data set that contains labels, describing the
information in the data set