WorksheetsParts of a Spreadsheet Layout
Total questions: 20
Worksheet time: 15mins
Displays the names of the cells hen you click/select them.
Row
Column
Formula Bar
Name Box
Lines of data that is displayed horizontally. (Left & Right)
Column
Row
Functions
Number Format
Located at the top left corner, will display the name of the document you are working on.
Cell
Column
Document Name
Name Box
A group of features that change the format of your numbers into currency ($), percentages (%), moving decimal places, etc.
Formula Bar
Functions
Number Format
Lines of data that is displayed vertically. (Up & Down)
Columns
Rows
Functions
Number Format
When a column and a row crossover, they form a box.
Cell
Column
Row
Name Box
Help darken the lines of your cells.
Borders
Cell
Functions
Merge Cell
Located at the bottom, _____ helps you navigate the different pages on a spreadsheet.
Formula Bar
Cell
Merge Cells
Worksheet Tabs
Combines more than one cell together into one.
Borders
Cell
Functions
Merge Cell
Displays the list of calculating functions such as SUM, AVERAGE, COUNT, MAX, MIN, etc.
Formula Bar
Functions
Number Format
The ______ displays the information/formulas used to calculate numbers in a cell.
Document Name
Formula Bar
Name Box
Worksheet Tabs
Allows you to insert graphs and charts to represent your data.
Number Format
Insert Chart
Functions
Worksheet Tabs
TRUE OR FALSE:
To find the name of a Cell, you state the Row number first then the Column Letter.
TRUE
FALSE
Draw the direction of which way a Column goes.
Draw the direction of which way a Row goes.
What cell is Gold Fish in?
A4
A5
A6
A7
What is typed in cell B5?
Bananas
Strawberry
Mango
Apple
Visicalc is the first spreadsheet software created.
TRUE
FALSE
What are Columns labeled as?
Letters
Numbers
What are Rows labeled as?
Numbers
Letters
