NEW
Font size
WorksheetsS2 Spreadsheet Basics
Total questions: 10
Worksheet time: 5mins
What is a cell in a spreadsheet?
A column of data
A row of data
The intersection of a row and column
The entire spreadsheet document
If you want to select all cells in column D, which method would be most efficient?
Press Ctrl+A
Click on the column header labeled D
Press Shift while clicking each cell
Right-click on any cell in column D
In a typical spreadsheet, rows are identified by:
Letters (A, B, C...)
Numbers (1, 2, 3...)
Colors
Special symbols
Which of the following is NOT a common text formatting option in spreadsheets?
Bold
Italic
Underline
Holographic
What happens when you apply a border to a cell?
The cell content is highlighted
A line appears around the selected cell or range
The cell automatically changes color
The text becomes centered
Cell shading refers to:
Adding a shadow effect to text
Changing the background color of a cell
Hiding cell contents
Adding a gradient effect to text
What does "text wrapping" in a spreadsheet allow you to do?
Move text to a different worksheet
Display text across multiple cells horizontally
Display all text within a cell by allowing it to continue to new lines
Protect text from being edited
If a cell contains more text than can be displayed and text wrapping is NOT enabled, what typically happens?
The text is automatically deleted
The text overflows into adjacent cells if they're empty
The spreadsheet automatically adjusts the column width
The text is truncated with "..." at the end
Which of these is a common way to adjust row height in a spreadsheet?
Double-click between row numbers
Press the "+" key while selecting a row
Use the View menu and select "Expand Rows"
Right-click and select "Row Height"
What is the standard name for the box that displays the contents of the currently selected cell?
Formula bar
Content display
Cell viewer
Text box
