Business Applications

Not a Learning.com customer? Learn More

Type:Quiz

Estimated Time:15 minutes

Score Type:Auto Score

This quiz automatically provides a score to your gradebook

Available Languages: English, Spanish


Vocabulary: absolute reference, cell address, chart, data, data analysis, format cell, formula, function, graph, relative reference, sort tool, spreadsheet, summation function


Objectives:

  • Student demonstrates knowledge of the difference between absolute and relative cell address references and how to use each in formulas.
  • Student demonstrates the ability to format cells and pages.
  • Student demonstrates the ability to interpret data in charts and graphs.
  • Student demonstrates the ability to sort data.
  • Student demonstrates the ability to use operators in formulas.
  • Student demonstrates the ability to use the auto sum tool.

Subjects:

Data Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Digital Literacy > Student Use > Data Collection for Decision Making 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

Parts

Mathematics > Statistics Probability > Graphs and Charts > Parts

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Information Technology > Software Applications > Spreadsheets 

Symbols

Mathematics > Number Operations > Operations > Symbols
Show More

Teacher Notes:

  • Students will benefit from using a range of menu and toolbar commands to manipulate data in sorted lists or to generate graphs. Emphasis is placed on the special features of spreadsheet software.

Standards:

S.5.b Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards
Feedback