WGU C268 SPREADSHEETS
EXAM and questions
answered correctly
Formulas Menu - ANSWERS>>>>>menu items aid in
performing calculations using Excel's built-in
functions
Data Area - ANSWERS>>>>>used to aid in importing
and working with large amounts of data
Review Menu - ANSWERS>>>>>menu items help in
sharing an Excel workbook with colleagues
View Menu - ANSWERS>>>>>menu items are used to
change how a worksheet is displayed on the screen
Info portion of the File - ANSWERS>>>>>menu
displays information about the current workbook
and the users who have contributed to the file
New portion of the File - ANSWERS>>>>>menu
contains features related to creating a new
workbook
,Templates - ANSWERS>>>>>can be particularly
useful because they often contain data,
formatting and calculations that relate to common
spreadsheet tasks
Open - ANSWERS>>>>>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 - ANSWERS>>>>>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 - ANSWERS>>>>>menu area contains items
related to printing a worksheet
Print Area - ANSWERS>>>>>area displays a preview
of how a particular worksheet will look once
printed.
Share Area - ANSWERS>>>>>area used make the
workbook available for colleagues
Export Area - ANSWERS>>>>>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 - ANSWERS>>>>>menu closes the open
workbook
Options area - ANSWERS>>>>>set of menu items
allows you to customize the appearance and
functionality of Excel
Account - ANSWERS>>>>>menu items allow you to
manage users.
Help Area - ANSWERS>>>>>provides access to
Microsoft's extensive online help materials,
information about how to get started with Excel,
as well as information about the version of Excel
you are using
What is the actual number of worksheets that you
can store in a single workbook - ANSWERS>>>>>It
is is limited by the memory resources of your
computer
provides a way to specifically define and refer
to cells - ANSWERS>>>>>Addressing Scheme
values stored in another cell of a worksheet -
ANSWERS>>>>>referencing a cell
EXAM and questions
answered correctly
Formulas Menu - ANSWERS>>>>>menu items aid in
performing calculations using Excel's built-in
functions
Data Area - ANSWERS>>>>>used to aid in importing
and working with large amounts of data
Review Menu - ANSWERS>>>>>menu items help in
sharing an Excel workbook with colleagues
View Menu - ANSWERS>>>>>menu items are used to
change how a worksheet is displayed on the screen
Info portion of the File - ANSWERS>>>>>menu
displays information about the current workbook
and the users who have contributed to the file
New portion of the File - ANSWERS>>>>>menu
contains features related to creating a new
workbook
,Templates - ANSWERS>>>>>can be particularly
useful because they often contain data,
formatting and calculations that relate to common
spreadsheet tasks
Open - ANSWERS>>>>>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 - ANSWERS>>>>>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 - ANSWERS>>>>>menu area contains items
related to printing a worksheet
Print Area - ANSWERS>>>>>area displays a preview
of how a particular worksheet will look once
printed.
Share Area - ANSWERS>>>>>area used make the
workbook available for colleagues
Export Area - ANSWERS>>>>>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 - ANSWERS>>>>>menu closes the open
workbook
Options area - ANSWERS>>>>>set of menu items
allows you to customize the appearance and
functionality of Excel
Account - ANSWERS>>>>>menu items allow you to
manage users.
Help Area - ANSWERS>>>>>provides access to
Microsoft's extensive online help materials,
information about how to get started with Excel,
as well as information about the version of Excel
you are using
What is the actual number of worksheets that you
can store in a single workbook - ANSWERS>>>>>It
is is limited by the memory resources of your
computer
provides a way to specifically define and refer
to cells - ANSWERS>>>>>Addressing Scheme
values stored in another cell of a worksheet -
ANSWERS>>>>>referencing a cell
