Y-G6 Week 1 term 3

Multiple Choice

Why is analyzing data important in today's digital world?

• It helps in making informed decisions

• It is only useful for scientists

• It is not necessary for daily life

• It is only used in mathematics

Multiple Select

Which of the following statements are true about the structure of a data table in a spreadsheet?

• Each row is a record.

• Each column is a field.

• Rows and columns organize the data.

• Each cell contains a different type of information.

Multiple Choice

What are three functions you can perform on data tables in a spreadsheet to make data easier to work with?

• Sort records, filter records, perform calculations.

• Draw pictures, write stories, play games.

• Create slides, organize paragraphs, add shapes.

• Change colors, add animations, create charts.

Multiple Choice

A spreadsheet helps to ............

• Play games

• Organize data

• Draw pictures

• write stories

Multiple Choice

Data in a table is organized into ...............

• Pages and paragraphs

• Rows and columns

• Pictures and shapes

• slides and notes

Multiple Choice

A ____________ is where a row and column meet.

• sheet
• formula
• blank
• cell

Multiple Choice

A row in a data table is .............

• A group of pictures

• A record containing information about one object

• A type of chart

• A computer program

Multiple Choice

A column in a data table is ...........

• A field containg same information for every record

• A music file

• A drawing tool

• A slide in powerpoint

Open Ended

What steps would you take to save your Excel worksheet with the correct file name and location, based on the instructions provided?

Multiple Choice

Data is presented in a table to make it

• Hard to read

• easy to read and work with

• Hide information

• Print picture

Open Ended

Explain the difference between a row and a column in a data table, using examples from the package delivery table shown.

Multiple Choice

Sorting data in a table means to ............

• Delete the data

• Change the color of the table

• Arrange records in a new order

• Add pictures

Multiple Choice

Filtering data in a table means to .........

• Shows only the records you want

• Print the table

• Delete the table

• Change the font type

Multiple Select

Which of the following actions are necessary when creating a data table in MS Excel?

• Selecting cells to include in the table

• Including column headings

• Choosing color and style for the table

• Making sure the 'My table has headers' box is ticked

Multiple Choice

Which column in the package delivery table would you use to filter for packages that have not been delivered?

• Package code

• Pick up from

• Delivered

• Courier

Open Ended

Based on the final sheet, what patterns can you observe about the locations where packages are picked up and delivered?

Multiple Choice

Which courier delivered the most packages according to the final sheet?

• Amir

• Misha

• Hasan

• Nadia

Open Ended

How do you think analyzing data in Excel can help you in your studies or daily life?

Multiple Choice

What is the purpose of the 'Analyze Data' feature in Microsoft Excel?

• To create charts

• To analyze and summarize data

• To format cells

• To print spreadsheets