SPREADSHEETS AND DATA
PRESENTATIONS EXAM 2025/2026
QUESTIONS AND ANSWERS 100% PASS
Workbook - ANS An excel file that stores all the information, previous calculations, and
analyses that you may have already completed. Must contain atleast one worksheet.
Worksheet - ANS A collection of cells arranged in the form of a table that contains the actual
data and calculations.
Cell - ANS Small box that stores an individual piece of data or a calculation in a worksheet
Value - ANS The content within a cell.
Column - ANS A stack of cells arranged vertically from the top to the bottom of a worksheet -
labeled with a letter.
Row - ANS Collection of cells arranged horizontally from left to right of a worksheet- labeled
with a number of
1 @COPYRIGHT 2025/2026.
, Function - ANS Built in method for performing a calculation in excel
File - ANS A group of menu items used to manipulate workbooks
Home - ANS A group of menu items used to format the appearance of data in cells
Insert - ANS Group of menu items that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes
Draw - ANS Group of menu items used to insert freehand sketches into worksheets
Page layout - ANS Group of menu items used to format the appearance of worksheets when
they are printed
Formulas - ANS Group of menu items used to perform calculations using excels built in
functions
Data - ANS Group of menu items used to aid in importing and working with data
Review - ANS Group of menu items that help in sharing an excel workbook with colleagues
View - ANS Group of menu items that are used to change how a worksheet is displayed on
the screen
Help - ANS Group of menu items that are used to obtain assistance on spreadsheet features
Zoom - ANS Group of menu options that allows the user to change how much of the
worksheet appears in the window
2 @COPYRIGHT 2025/2026.