D100 Introduction to Spreadsheets Questions and
Correct Answers with Complete Solutions |
Graded A+ | New Update 2025
Workbook - ANSWER 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 - ANSWER A collection of cells arranged in the form of a table that
contains the actual data and calculations.
File - ANSWER A class of menu items used to manipulate workbooks.
Home - ANSWER A class of menu items used to format the appearance of data
in cells
Insert - ANSWER An area that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes.
Page layout - ANSWER A class of menu items used to format the appearance
of worksheets.
Formulas - ANSWER A class of menu items used to perform calculations using
Excel's Built-in functions.
, Data - ANSWER A class of menu items used to aid in importing and working
with large amounts of data.
Review - ANSWER A class of menu items that help in sharing an Excel
workbook with colleagues.
View - ANSWER A class of menu items that are used to change how a
worksheet is displayed on the screen.
Window - ANSWER A view of the current workbook.
Pane - ANSWER The area of a worksheet that is visible on the screen.
Range - ANSWER A continuous block of cells that are selected in an Excel
worksheet.
Formula - ANSWER Expressions that calculates the value of a cell; can be
either simple or complex and can be reused if the same calculation is performed
in a different cell location.
relative cell references - ANSWER cell references that automatically update
when a formula is pasted to a new cell
absolute cell reference - ANSWER A cell reference that remains constant when
a formula is pasted into a new cell: contain two "$".
Correct Answers with Complete Solutions |
Graded A+ | New Update 2025
Workbook - ANSWER 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 - ANSWER A collection of cells arranged in the form of a table that
contains the actual data and calculations.
File - ANSWER A class of menu items used to manipulate workbooks.
Home - ANSWER A class of menu items used to format the appearance of data
in cells
Insert - ANSWER An area that includes features for specializing elements into
workbooks, such as charts, pictures, and shapes.
Page layout - ANSWER A class of menu items used to format the appearance
of worksheets.
Formulas - ANSWER A class of menu items used to perform calculations using
Excel's Built-in functions.
, Data - ANSWER A class of menu items used to aid in importing and working
with large amounts of data.
Review - ANSWER A class of menu items that help in sharing an Excel
workbook with colleagues.
View - ANSWER A class of menu items that are used to change how a
worksheet is displayed on the screen.
Window - ANSWER A view of the current workbook.
Pane - ANSWER The area of a worksheet that is visible on the screen.
Range - ANSWER A continuous block of cells that are selected in an Excel
worksheet.
Formula - ANSWER Expressions that calculates the value of a cell; can be
either simple or complex and can be reused if the same calculation is performed
in a different cell location.
relative cell references - ANSWER cell references that automatically update
when a formula is pasted to a new cell
absolute cell reference - ANSWER A cell reference that remains constant when
a formula is pasted into a new cell: contain two "$".
