Spreadsheet Basics and Functions

This video tutorial covers the basics of spreadsheets, including reading data, understanding cell references, and data types. It uses Olympic Games data to teach data analysis and challenges students to apply formatting techniques to make tables clearer. The lesson encourages independent work with available support and resources.

How many medals did Great Britain win in total during the 2016 Summer Olympic Games?

• 67

• 56

• 70

• 42

Which country won the most gold medals in the 2016 Summer Olympic Games?

• Russia

• China

• Great Britain

• United States

What is a cell reference in a spreadsheet?

• A unique identifier for a cell, consisting of a column letter and row number

• The color of a cell

• The data type of a cell

• The formula used in a cell

Which of the following is NOT a data type in spreadsheets?

• Text

• Date

• Image

• Number

What type of data is contained in cell E12 if it shows £80,577.90?

• Currency

• Text

• Number

• Percentage

What is the purpose of adding borders to a table in a spreadsheet?

• To merge cells

• To change the data type

• To make the table look better and easier to read

• To delete rows

How can you add a new row below row 5 in a spreadsheet?

• Right-click on row 5 and select 'Insert'

• Double-click on row 5

• Right-click on row 6 and select 'Insert'

• Click on the 'Add Row' button

What is the first step to change the cell color in a spreadsheet?

• Type the color name in the cell

• Select the cells you want to change

• Click on the 'File' menu

• Right-click on the spreadsheet

What should you do if you make a mistake while formatting a spreadsheet?

• Press Control Z to undo

• Call technical support

• Delete the entire spreadsheet

• Restart the computer

What is the main goal of the lesson on spreadsheets?

• To learn programming languages

• To create a new spreadsheet from scratch

• To memorize all spreadsheet formulas

• To learn how to read data, identify spreadsheet components, and use formatting techniques