Data Presentations OA ACTUAL EXAM COMPLETE
QUESTIONS WITH CORRECT DETAILED ANSWERS
Workbook
An excel file that stores all the information, previous calculations, and analyses
that you may have already completed. Must contain at least one worksheet.
Worksheet
A collection of cells arranged in the form of a table that contains the actual data
and calculations.
Cell
Small box that stores an individual piece of data or a calculation in a worksheet
Value
The content within a cell.
,Column
A stack of cells arranged vertically from the top to the bottom of a worksheet -
labeled with a letter.
Row
Collection of cells arranged horizontally from left to right of a worksheet- labeled
with a number of
Function
Built in method for performing a calculation in excel
File
A group of menu items used to manipulate workbooks
Home
A group of menu items used to format the appearance of data in cells
Insert
, Group of menu items that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes
Draw
Group of menu items used to insert freehand sketches into worksheets
Page layout
Group of menu items used to format the appearance of worksheets when they
are printed
Formulas
Group of menu items used to perform calculations using excels built in functions
Data
Group of menu items used to aid in importing and working with data
Review
Group of menu items that help in sharing an excel workbook with colleagues