Spreadsheets - C268 Exam|115
Complete Q’s and A’s
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
- Account - -menu items allow you to manage users.
- Help Area - -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 - -It is is limited by the memory resources of your computer
- provides a way to specifically define and refer to cells - -Addressing
Scheme
- values stored in another cell of a worksheet - -referencing a cell
- refers to more than one cell at a time as long as the cells are in a
continuous block - -referencing a range of cells
- To reference a range of cells - -you specify the upper left cell in the range
followed by the ":" character and the lower right cell in the range
- How to enter data in a cell - -select the cell you would like to use (by
clicking on the cell) and type in the data you would like to store in the cell
Complete Q’s and A’s
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
- Account - -menu items allow you to manage users.
- Help Area - -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 - -It is is limited by the memory resources of your computer
- provides a way to specifically define and refer to cells - -Addressing
Scheme
- values stored in another cell of a worksheet - -referencing a cell
- refers to more than one cell at a time as long as the cells are in a
continuous block - -referencing a range of cells
- To reference a range of cells - -you specify the upper left cell in the range
followed by the ":" character and the lower right cell in the range
- How to enter data in a cell - -select the cell you would like to use (by
clicking on the cell) and type in the data you would like to store in the cell
