SPREADSHEETS AND DATA PRESENTATIONS OA
COMPREHENSIVE EXAM 2026 QUESTIONS
AND ANSWERS GUARANTEED TO PASS
◉ Worksheet. Answer: A collection of cells arranged in the form of a
table that contains the actual data and calculations.
◉ Cell. Answer: Small box that stores an individual piece of data or a
calculation in a worksheet
◉ Value. Answer: The content within a cell.
◉ Column. Answer: A stack of cells arranged vertically from the top to
the bottom of a worksheet - labeled with a letter.
◉ Row. Answer: Collection of cells arranged horizontally from left to
right of a worksheet- labeled with a number of
◉ Function. Answer: Built in method for performing a calculation in
excel
, ◉ File. Answer: A group of menu items used to manipulate workbooks
◉ Home. Answer: A group of menu items used to format the appearance
of data in cells
◉ Insert. Answer: Group of menu items that includes features for
specializing elements into workbooks, such as charts, pictures, and
shapes
◉ Draw. Answer: Group of menu items used to insert freehand sketches
into worksheets
◉ Page layout. Answer: Group of menu items used to format the
appearance of worksheets when they are printed
◉ Formulas. Answer: Group of menu items used to perform calculations
using excels built in functions
◉ Data. Answer: Group of menu items used to aid in importing and
working with data
◉ Review. Answer: Group of menu items that help in sharing an excel
workbook with colleagues