WGU Spreadsheets C268
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
Workbook - CORRECT ANSWER-An excel file that stores all information, previous calculations,
and analyses that you may have already completed
Worksheet - CORRECT ANSWER-Contains the actual data and calculations
Cells - CORRECT ANSWER-Store individual pieces of data or calculations
File Tab - CORRECT ANSWER-Manipulates workbooks
Home Tab - CORRECT ANSWER-Includes items used in formatting the appearance of data in cells
Insert Tab - CORRECT ANSWER-Allows you to place specialized elements into workbooks
(charts/pictures/shapes)
Page Layout Tab - CORRECT ANSWER-Formats the appearance of worksheets
Formulas Tab - CORRECT ANSWER-Aids in performing calculations using Excels built in functions
, Data Tab - CORRECT ANSWER-Aid to import and work with large amounts of data
Review Tab - CORRECT ANSWER-Help share an Excel workbook with colleagues
View Tab - CORRECT ANSWER-Used to change how a worksheet is displayed on the screen
Developer/Add-in Tabs - CORRECT ANSWER-Extra features
Building Blocks of Excel - CORRECT ANSWER-Workbook, worksheet, cell
Relative Cell Reference - CORRECT ANSWER-Cell reference that automatically updates when a
formula is pasted into a new cell
Absolute Cell Refernce - CORRECT ANSWER-Cell reference that remains constant when a
formula is pasted into a new cell
$ - CORRECT ANSWER-Used to make a cell absolute. Goes in front of the part you want to
remain constant.
SUM function - CORRECT ANSWER-=SUM() when you want to add a group of numbers together
COUNT function - CORRECT ANSWER-=COUNT() Counts the number of cells in a range of cells
that contain numbers
COUNTA function - CORRECT ANSWER-=COUNTA() Counts the number of cells in a range that
are not blank
QUESTIONS AND VERIFIED
CORRECT ANSWERS
GRADED A+ [LATEST] 100%
GUARANTEED PASS
Workbook - CORRECT ANSWER-An excel file that stores all information, previous calculations,
and analyses that you may have already completed
Worksheet - CORRECT ANSWER-Contains the actual data and calculations
Cells - CORRECT ANSWER-Store individual pieces of data or calculations
File Tab - CORRECT ANSWER-Manipulates workbooks
Home Tab - CORRECT ANSWER-Includes items used in formatting the appearance of data in cells
Insert Tab - CORRECT ANSWER-Allows you to place specialized elements into workbooks
(charts/pictures/shapes)
Page Layout Tab - CORRECT ANSWER-Formats the appearance of worksheets
Formulas Tab - CORRECT ANSWER-Aids in performing calculations using Excels built in functions
, Data Tab - CORRECT ANSWER-Aid to import and work with large amounts of data
Review Tab - CORRECT ANSWER-Help share an Excel workbook with colleagues
View Tab - CORRECT ANSWER-Used to change how a worksheet is displayed on the screen
Developer/Add-in Tabs - CORRECT ANSWER-Extra features
Building Blocks of Excel - CORRECT ANSWER-Workbook, worksheet, cell
Relative Cell Reference - CORRECT ANSWER-Cell reference that automatically updates when a
formula is pasted into a new cell
Absolute Cell Refernce - CORRECT ANSWER-Cell reference that remains constant when a
formula is pasted into a new cell
$ - CORRECT ANSWER-Used to make a cell absolute. Goes in front of the part you want to
remain constant.
SUM function - CORRECT ANSWER-=SUM() when you want to add a group of numbers together
COUNT function - CORRECT ANSWER-=COUNT() Counts the number of cells in a range of cells
that contain numbers
COUNTA function - CORRECT ANSWER-=COUNTA() Counts the number of cells in a range that
are not blank
