C268 Spreadsheets Prep QUESTIONS WITH
VERIFIED ANSWERS
workbook - ✔✔an Excel file that stores all the information, previous calculations, and
analyses that you may have already completed
worksheet - ✔✔contains the actual data and calculations
cells - ✔✔store individual pieces of data or calculations
File Menu - ✔✔menu used to manipulate workbooks
Home - ✔✔area includes items used in formatting the appearance of data in cells
Insert Area - ✔✔include features that allow you to place specialized elements into your
workbooks, such as charts, pictures, and shapes
Page Layout Menu - ✔✔menu items are used to format the appearance of worksheets
Formulas Menu - ✔✔menu items aid in performing calculations using Excel's built-in
functions
Data Area - ✔✔used to aid in importing and working with large amounts of data
Review Menu - ✔✔menu items help in sharing an Excel workbook with colleagues
View Menu - ✔✔menu items are used to change how a worksheet is displayed on the screen
, Info portion of the File - ✔✔menu displays information about the current workbook and the
users who have contributed to the file
New portion of the File - ✔✔menu contains features related to creating a new workbook
Templates - ✔✔can be particularly useful because they often contain data, formatting and
calculations that relate to common spreadsheet tasks
Open - ✔✔used to select a different workbook that you want to be opened in Excel or select
a workbook that has been saves on Skydive or locally on your computer
Save and Save As Functions - ✔✔allow you to (1) save the current workbook, (2) save a copy
of the current workbook with a new name or location, or (3) save a copy of the current
workbook as a different file type.
Print Area - ✔✔menu area contains items related to printing a worksheet
Print Area - ✔✔area displays a preview of how a particular worksheet will look once printed.
Share Area - ✔✔area used make the workbook available for colleagues
Export Area - ✔✔area allows you to convert your work to another file format (such as PDF)
for those colleagues who prefer to review the work in a different application
Close Menu - ✔✔menu closes the open workbook
Options area - ✔✔set of menu items allows you to customize the appearance and
functionality of Excel
VERIFIED ANSWERS
workbook - ✔✔an Excel file that stores all the information, previous calculations, and
analyses that you may have already completed
worksheet - ✔✔contains the actual data and calculations
cells - ✔✔store individual pieces of data or calculations
File Menu - ✔✔menu used to manipulate workbooks
Home - ✔✔area includes items used in formatting the appearance of data in cells
Insert Area - ✔✔include features that allow you to place specialized elements into your
workbooks, such as charts, pictures, and shapes
Page Layout Menu - ✔✔menu items are used to format the appearance of worksheets
Formulas Menu - ✔✔menu items aid in performing calculations using Excel's built-in
functions
Data Area - ✔✔used to aid in importing and working with large amounts of data
Review Menu - ✔✔menu items help in sharing an Excel workbook with colleagues
View Menu - ✔✔menu items are used to change how a worksheet is displayed on the screen
, Info portion of the File - ✔✔menu displays information about the current workbook and the
users who have contributed to the file
New portion of the File - ✔✔menu contains features related to creating a new workbook
Templates - ✔✔can be particularly useful because they often contain data, formatting and
calculations that relate to common spreadsheet tasks
Open - ✔✔used to select a different workbook that you want to be opened in Excel or select
a workbook that has been saves on Skydive or locally on your computer
Save and Save As Functions - ✔✔allow you to (1) save the current workbook, (2) save a copy
of the current workbook with a new name or location, or (3) save a copy of the current
workbook as a different file type.
Print Area - ✔✔menu area contains items related to printing a worksheet
Print Area - ✔✔area displays a preview of how a particular worksheet will look once printed.
Share Area - ✔✔area used make the workbook available for colleagues
Export Area - ✔✔area allows you to convert your work to another file format (such as PDF)
for those colleagues who prefer to review the work in a different application
Close Menu - ✔✔menu closes the open workbook
Options area - ✔✔set of menu items allows you to customize the appearance and
functionality of Excel
