Crear Tablas en Excel

Grade 1045 min

Learning Objective

Pudeo crear convertir un rango de datos en una tabla estructurada con funciones avanzadas y visualmente atractiva en Excel

Lesson Flow

Watch Video

5 min

Como Dar Formato Tabla en Excel

Unknown Channel

Practice

14 min

7 questions • Short answer

Exit Ticket

5 min

You have a list of student names and their test scores in an Excel sheet. Describe the steps you would take to format this data as a table with a blue, medium-style design, including headers. After formatting the student names and test scores as a table, explain how you would use the filter function to display only the students who scored 85 or higher. You have an existing Excel table with student names, test scores, and attendance records. You want to add a new column for "Homework Completion". Describe the steps you would take to add this new column to the existing table, ensuring it is included in the table's formatting and functionality.

Teacher Guide

Get the complete package:

  • Answer keys for all questions
  • Differentiation strategies
  • Extension activities
  • Printable student handouts