WGU C268 SPREADSHEETS FINAL OA FULL SOLUTION STUDY GUIDE

WGU C268 SPREADSHEETS FINAL OA FULL
SOLUTION STUDY GUIDE

◉ Worksheet.
Answer: A collection of cells arranged in the form of a table that
contains the actual data and calculations.


◉ Cell.
Answer: Small box that stores an individual piece of data or a
calculation in a worksheet


◉ Value.
Answer: The content within a cell.


◉ Column.
Answer: A stack of cells arranged vertically from the top to the
bottom of a worksheet - labeled with a letter.


◉ Row.
Answer: Collection of cells arranged horizontally from left to right of
a worksheet- labeled with a number of

,◉ Function.
Answer: Built in method for performing a calculation in excel


◉ File.
Answer: A group of menu items used to manipulate workbooks


◉ Home.
Answer: A group of menu items used to format the appearance of
data in cells


◉ Insert.
Answer: Group of menu items that includes features for specializing
elements into workbooks, such as charts, pictures, and shapes


◉ Draw.
Answer: Group of menu items used to insert freehand sketches into
worksheets


◉ Page layout.
Answer: Group of menu items used to format the appearance of
worksheets when they are printed


◉ Formulas.

, Answer: Group of menu items used to perform calculations using
excels built in functions


◉ Data.
Answer: Group of menu items used to aid in importing and working
with data


◉ Review.
Answer: Group of menu items that help in sharing an excel
workbook with colleagues


◉ View.
Answer: Group of menu items that are used to change how a
worksheet is displayed on the screen


◉ Help.
Answer: Group of menu items that are used to obtain assistance on
spreadsheet features


◉ Zoom.
Answer: Group of menu options that allows the user to change how
much of the worksheet appears in the window