NEW
Font size
WorksheetsSpreadsheet Basics Quiz
Total questions: 50
Worksheet time: 25mins
What is a spreadsheet used for?
Playing games
Drawing pictures
Organizing and calculating data
Watching videos
Which program is used to make spreadsheets?
Microsoft Word
Google Sheets
Paint
Notepad
What is the intersection of a row and a column called?
Cell
Box
Grid
Square
What is the name of the first cell in a spreadsheet?
1A
A1
A0
Cell1
What is the bar where you type your data in a cell called?
Data bar
Formula bar
Menu bar
Tool bar
Which of the following is a column label in Excel/Sheets?
5
C
12
20
What is the default alignment for text in a cell?
Center
Right
Left
Justify
What is the default alignment for numbers in a cell?
Right
Center
Left
Justify
What symbol is used to start a formula?
#
$
=
&
Which function is used to add numbers?
ADD()
TOTAL()
PLUS()
SUM()
What does =SUM(A1:A3) do?
Multiplies A1 to A3
Adds A1 to A3
Divides A1 by A3
Subtracts A1 from A3
What does formatting a cell mean?
Changing how data looks
Deleting a cell
Copying a cell
Saving a cell
How do you make text bold in Sheets?
Press Ctrl + U
Click on the Bold (B) button
Press Delete
Press Enter
How do you change the font color of text in a cell?
Use the paint bucket
Use the font color tool
Use the insert tool
Use the filter tool
What happens when you sort numbers in ascending order?
From biggest to smallest
From smallest to biggest
From random order
From largest to middle
Which button is used to change the background color of a cell?
Fill color
Text color
Insert
Format painter
How do you center text in a cell?
Use the underline tool
Use the center alignment button
Use the font tool
Use the wrap text tool
What does it mean to 'wrap text'?
Hide the text
Make the text disappear
Fit all text inside the cell
Move the text to another cell
What do rows use for labels?
Letters
Colors
Numbers
Symbols
What happens if you type in a cell and press Enter?
Moves to the next column
Moves to the cell below
Deletes the text
Formats the text
What is the shortcut to add a new sheet?
Ctrl + N
Shift + A
Click + icon
Alt + Tab
Which key helps you move from one cell to the next on the right?
Shift
Arrow Left
Tab
Ctrl
Which button do you use to sort data from A to Z?
Filter
Sort Ascending
Zoom
Edit
Where can you see the active cell name?
Bottom bar
Toolbar
Name box
Menu bar
What is the maximum number of rows in Google Sheets (as of now)?
1,000
10,000
50,000
10 million
If you want to add numbers in cells A1, A2, and A3, which formula should you use?
=ADD(A1, A2, A3)
=A1+A2+A3
=A1A2A3
=SUMM(A1:A3)
What does sorting help you do?
Delete data
Organize data
Share data
Print data
What does the Undo button do?
Repeats your action
Hides the row
Erases the last action
Adds new rows
Which of these is NOT a valid formatting option?
Bold
Italic
Sort
Underline
Which menu has the 'Insert function' option?
File
Data
Format
Insert
What is the shortcut to save in Google Sheets?
Ctrl + S
Ctrl + P
Ctrl + T
Ctrl + C
What does =SUM(B1:B5) do?
Adds values in cells B1 to B5
Adds only B1
Copies B1 to B5
Subtracts B1 from B5
What tool do you use to change the size of the text?
Zoom
Font Size
Fill
View
What happens when you drag the fill handle from a cell?
Deletes the cell
Copies data or formulas
Formats the cell
Prints the sheet
What is the name of the small square at the bottom right of a selected cell?
Corner tool
Fill handle
Copy tool
Resize box
Which key combination lets you copy a cell?
Ctrl + P
Ctrl + C
Ctrl + Z
Ctrl + B
Which function gives the total of numbers in a range?
COUNT
SUM
AVERAGE
TOTAL
Which of these can be formatted in a spreadsheet?
Cell color
Font size
Border
All of the above
What does the term 'range' mean in Excel/Sheets?
A single cell
Text content
A group of selected cells
Cell color
What is the formula to add values from A1 to A10?
=A1+A10
=SUM(A1 to A10)
=SUM(A1:A10)
=TOTAL(A1:A10)
What is used to highlight certain parts of a spreadsheet?
Sorting
Formatting
Merging
Zooming
What type of data can be entered into a spreadsheet?
Text
Numbers
Formulas
All of the above
How do you delete data in a cell?
Press Delete
Press Space
Click Format
Use Filter
What does clicking and dragging over cells do?
Deletes them
Selects multiple cells
Hides them
Moves them
How do you resize a column?
Use the Insert menu
Use Format > Column Width
Drag the line between column letters
Press Delete
Which menu option allows you to change text alignment?
File
View
Format
Insert
What is the use of the Sort Z to A option?
Sorts in reverse order
Sorts from smallest to biggest
Sorts by date
Hides text
How do you move to the next row in the same column?
Press Enter
Press Tab
Press Backspace
Press Ctrl
What happens when you double-click on the edge of a column letter?
Deletes the column
Hides the column
Auto-fits the width
Copies the column
How can you find the sum of two cells, A1 and B1?
=A1xB1
=A1+B1
=A1-B1
=A1B1
