WGU C268 Spreadsheets Exam 115 Questions with
Verified Answers
an Excel file that stores all the information, previous calculations, and analyses
that you may have already completed - CORRECT ANSWER workbook
contains the actual data and calculations - CORRECT ANSWER worksheet
store individual pieces of data or calculations - CORRECT ANSWER cells
menu used to manipulate workbooks - CORRECT ANSWER File Menu
area includes items used in formatting the appearance of data in cells - CORRECT
ANSWER Home
include features that allow you to place specialized elements into your
workbooks, such as charts, pictures, and shapes - CORRECT ANSWER Insert Area
menu items are used to format the appearance of worksheets - CORRECT
ANSWER Page Layout Menu
menu items aid in performing calculations using Excel's built-in functions -
CORRECT ANSWER Formulas Menu
,used to aid in importing and working with large amounts of data - CORRECT
ANSWER Data Area
menu items help in sharing an Excel workbook with colleagues - CORRECT
ANSWER Review Menu
menu items are used to change how a worksheet is displayed on the screen -
CORRECT ANSWER View Menu
menu displays information about the current workbook and the users who have
contributed to the file - CORRECT ANSWER Info portion of the File
menu contains features related to creating a new workbook - CORRECT ANSWER
New portion of the File
can be particularly useful because they often contain data, formatting and
calculations that relate to common spreadsheet tasks - CORRECT ANSWER
Templates
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 -
CORRECT ANSWER Open
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. - CORRECT ANSWER Save and Save As Functions
, menu area contains items related to printing a worksheet - CORRECT ANSWER
Print Area
area displays a preview of how a particular worksheet will look once printed. -
CORRECT ANSWER Print Area
area used make the workbook available for colleagues - CORRECT ANSWER Share
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 -
CORRECT ANSWER Export Area
menu closes the open workbook - CORRECT ANSWER Close Menu
set of menu items allows you to customize the appearance and functionality of
Excel - CORRECT ANSWER Options area
menu items allow you to manage users. - CORRECT ANSWER Account
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 - CORRECT ANSWER Help Area
It is is limited by the memory resources of your computer - CORRECT ANSWER
What is the actual number of worksheets that you can store in a single workbook
Verified Answers
an Excel file that stores all the information, previous calculations, and analyses
that you may have already completed - CORRECT ANSWER workbook
contains the actual data and calculations - CORRECT ANSWER worksheet
store individual pieces of data or calculations - CORRECT ANSWER cells
menu used to manipulate workbooks - CORRECT ANSWER File Menu
area includes items used in formatting the appearance of data in cells - CORRECT
ANSWER Home
include features that allow you to place specialized elements into your
workbooks, such as charts, pictures, and shapes - CORRECT ANSWER Insert Area
menu items are used to format the appearance of worksheets - CORRECT
ANSWER Page Layout Menu
menu items aid in performing calculations using Excel's built-in functions -
CORRECT ANSWER Formulas Menu
,used to aid in importing and working with large amounts of data - CORRECT
ANSWER Data Area
menu items help in sharing an Excel workbook with colleagues - CORRECT
ANSWER Review Menu
menu items are used to change how a worksheet is displayed on the screen -
CORRECT ANSWER View Menu
menu displays information about the current workbook and the users who have
contributed to the file - CORRECT ANSWER Info portion of the File
menu contains features related to creating a new workbook - CORRECT ANSWER
New portion of the File
can be particularly useful because they often contain data, formatting and
calculations that relate to common spreadsheet tasks - CORRECT ANSWER
Templates
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 -
CORRECT ANSWER Open
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. - CORRECT ANSWER Save and Save As Functions
, menu area contains items related to printing a worksheet - CORRECT ANSWER
Print Area
area displays a preview of how a particular worksheet will look once printed. -
CORRECT ANSWER Print Area
area used make the workbook available for colleagues - CORRECT ANSWER Share
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 -
CORRECT ANSWER Export Area
menu closes the open workbook - CORRECT ANSWER Close Menu
set of menu items allows you to customize the appearance and functionality of
Excel - CORRECT ANSWER Options area
menu items allow you to manage users. - CORRECT ANSWER Account
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 - CORRECT ANSWER Help Area
It is is limited by the memory resources of your computer - CORRECT ANSWER
What is the actual number of worksheets that you can store in a single workbook
