WorksheetsSpreadsheets 1 Test
Total questions: 29
Worksheet time: 15mins
This button moves the decimal 1 place to the left for each selected cell.
Decrease decimal button
Currency button
Undo and Redo the button
Insert Chart button
named by letters (A, B, C...)
Rows
Columns
Cells
Cell grid
Copies the contents of the current cell to multiple cells below or to the right.
Merge
Cell range
Fill handle
Copy handle
Used to handle text that is too big to fit within a cell. Allows text to: overflow, wrap, or clip within the selected cell.
Text wrapping button
Vertical Align button
Font size button
Text color button
Allows users to insert a link to the selected cell.
Insert chart button
Text color button
Undo and redo buttons
Insert link button
This button opens a menu with several number formatting options (number, percent, scientific, financial).
Fill color button.
More formats button.
Text color button.
Italic button.
Used to change the text to a different font name.
Font size button.
Insert chart button
Text color button
Font style button.
The intersection of a column and a row in a table or worksheet.
cell
columns
merge
rows
Used to change the color of the text.
Vertically align button.
Text color button.
Text wrapping button.
Font style button.
Used to copy formatting from one cell to another.
Paint format button
Text color button
Merge button
Fill color button
This adds a dollar sign, a decimal, and two zeroes to the selected cells.
Currency button
Share button
Freeze button
Border button
Alerts Google Sheets that you are entering a formula or function and not text
number sign
equal sign
share button
fill handle
Allows user to insert charts to a spreadsheet and customize the charts.
Insert link button
Text color button
Comment button
Insert chart button
A spreadsheet can have multiple pages called ____. The name of each page is found on a tab at the bottom of the screen.
Merge
Cell
Columns
Sheets
A cell reference that adjusts to its new location when copied or moved
cell
relative cell reference
cell range
absolute cell reference
Used to make text slant.
Merge button
Bold button
Italic button
Undo and redo buttons
The left button removes the last action. The right button adds a removed action back to the spreadsheet.
Undo and Redo buttons
Fill handle
Rows are Named by
Columns are Named by
Displays the print dialog box that is used to print the worksheet.
Print button
Printer selection
Text color button
Functions button
Used to align text: left, right, or center within a cell.
Vertical align button
Horizontal align button
Font size button
Fill color button
Allows users to share a spreadsheet with others.
Insert link button
Share button
Merge button
Fill color button
A reference that does not change when the formula is copied or moved to a new location.
relative cell reference
cell range
absolute cell reference
mixed cell reference
Used to merge two or more cells into one.
Bold button
Italic button
Paint format button
Merge button
named by numbers (1, 2, 3, ...)
Rows
Cell
Columns
Index
Used to make the text darker.
Italic button.
Bold button.
Paint format button
Merge button
Button used to define a border.
Vertical align button
Bold button
Font style button
Borders button
Used to change the text to a larger or smaller size.
Text wrapping button
Font style button
Fill color button
Font size button
To combine multiple cells into one cell.
Cell Range
Autofit
Merge
Cell
Used to add background color to selected cells in a spreadsheet.
Merge button
Paint format button
Font size button
Fill color button
A group of adjacent cells you select to perform operations on all of the selected cells.
merge
cell range
fill handle
cell address
