WorksheetsExcel Foundations Quiz 1.30
Total questions: 35
Worksheet time: 40mins
What is the main purpose of Microsoft Excel?
Writing essays
Creating spreadsheets and organizing data
Making videos
Sending emails
Which cell is located in Column A and Row 1?
A2
B1
A1
C1
What does a column represent in Excel?
Horizontal data
Vertical data
A single file
A worksheet
What does a row represent in Excel?
Vertical data
A workbook
Horizontal data
A formula
What is a cell?
A worksheet
A chart
The intersection of a row and column
A file
Which cell is best used for a header?
Any random cell
Cells in the first row
Cells in the last column
Worksheet tabs
What is the correct header order based on the lesson?
Quantity, Item, Price
Item, Quantity, Price
Price, Item, Quantity
Item, Price, Quantity
Which column should contain text only?
Item
Quantity
Price
Header
Which column should contain whole numbers?
Item
Quantity
Price
Worksheet
Which column should contain dollar amounts?
Item
Quantity
Price
Row
What happens when you highlight cells?
They are deleted
You can format them together
The worksheet closes
The file saves
Which formatting tool makes headers stand out?
Italics
Underline
Bold
Zoom
Why is it important to place data in the correct column?
It looks nicer
Excel works correctly
It saves time typing
Teachers require it
If you type an item name, which column should it go in?
Quantity
Price
Item
Any column
If you type $4.99, where should it go?
Quantity
Item
Price
Header
Which row usually contains headers?
Last row
Middle row
First row
Random row
What does Row 2 usually contain?
Headers
File name
Data entries
Charts
What should you check before formatting headers?
The file name
Correct columns
Internet connection
Font size
Which action helps keep data organized?
Mixing text and numbers
Leaving cells blank
Using clear headers
Random entry
Why is Excel useful for businesses?
It plays music
It organizes information
It sends texts
It designs logos
If data is entered in the wrong column, what could happen?
Nothing
Excel may not work correctly
The file deletes
The computer shuts down
Which skill is being practiced in this task?
Typing essays
Data organization
Photo editing
Coding
In your own words, explain what a row is.
In your own words, explain what a column is.
In your own words, explain what a cell is.
Why do we use headers in a data table?
What type of data should be entered in the Quantity column?
What type of data should be entered in the Price column?
Why should headers be bolded?
How does organizing data correctly help a business?
Which cell contains the word 'Pens'?
(a)
Which column shows numbers only?
(a)
Which column shows dollar amounts?
(a)
Which cells would you highlight to bold the headers?
(a)
Explain one mistake that could happen if data is entered in the wrong column.
