Spreadsheet Basics and Functions

The video tutorial guides students through setting up a class role in a spreadsheet, using tricks like freezing panes, managing data by deleting and inserting rows, calculating averages with formulas, and applying conditional formatting to visualize data. The teacher demonstrates these techniques using Microsoft Excel, emphasizing practical applications and encouraging students to experiment with different formatting options.

What is the first step in setting up a new spreadsheet for the class role?

• Enter the heights of students

• List the names in alphabetical order

• Calculate the average height

• Apply conditional formatting

Which tab in the spreadsheet software allows you to freeze panes?

• Data

• Home

• Insert

• View

How can you delete a row in a spreadsheet?

• Select the row and press 'Delete' on the keyboard

• Right-click the row number and choose 'Delete'

• Select the row and press 'Backspace'

• Double-click the row number

What happens to the data when you delete a row in a spreadsheet?

• The data is permanently removed and other rows shift up

• The data is hidden but not deleted

• The data is moved to another sheet

• The data is copied to the clipboard

Which of the following is NOT a method to insert a new row in a spreadsheet?

• Right-click a row number and select 'Insert'

• Select a row and press 'Insert' on the keyboard

• Use the 'Insert' tab in the ribbon

• Press 'Ctrl + I'

What formula is used to calculate the average of a set of numbers in a spreadsheet?

• SUM

• AVERAGE

• COUNT

• MAX

How do you select multiple cells using the keyboard?

• Hold 'Shift' and use arrow keys

• Hold 'Ctrl' and click each cell

• Double-click each cell

• Press 'Alt' and drag the mouse

What is the purpose of conditional formatting in a spreadsheet?

• To sort data alphabetically

• To calculate the sum of numbers

• To visually differentiate data based on conditions

• To freeze the top row

Which color scale option would you use to highlight higher values in a darker shade?

• Yellow to Red

• Dark Green to White

• White to Green

• Red to Blue

What does the 'Data Bars' option in conditional formatting do?

• Adds a bar chart to the cell

• Changes the font color

• Displays a bar within the cell proportional to the value

• Highlights the cell with a border