Spreadsheet Key Words

Which of the following best describes a "cell reference" in a spreadsheet?

• The unique identifier for a cell, usually combining a column letter and row number

• The total number of rows in a worksheet

• The name of the spreadsheet file

• The sum of all values in a column

What is the main difference between a worksheet and a workbook in spreadsheet software?

• A worksheet is a single page, while a workbook contains multiple worksheets

• A worksheet is used for formatting, while a workbook is used for calculations

• A worksheet is a type of formula, while a workbook is a type of function

• A worksheet is only for text, while a workbook is only for numbers

Which function would you use to find the highest value in a range of cells?

• SUM

• AVERAGE

• MAX

• IF

If you want to combine two or more cells into one larger cell in a spreadsheet, which formatting option should you use?

• Borders

• Merge Cells

• Bold

• IF

A teacher wants to calculate the average score of students in a test using a spreadsheet. Which function should they use, and what steps should they follow to apply it correctly?

• Use the SUM function and divide by the number of students; select the range and type =SUM(range)/number

• Use the AVERAGE function; select the range and type =AVERAGE(range)

• Use the MAX function; select the range and type =MAX(range)

• Use the IF function; select the range and type =IF(range)

Which of the following is a type of chart used to represent data visually?

• Pie Chart

• Data Validation

• Filter

• Conditional Formatting

What is the main purpose of using a filter in data tools?

• To highlight specific values

• To sort data alphabetically

• To display only the rows that meet certain criteria

• To create a chart

Which feature would you use to automatically change the appearance of a cell based on its value?

• Conditional Formatting

• Axis

• Legend

• Bar Chart

Explain how a legend is useful when interpreting a chart or graph.

• It sorts the data in order

• It provides labels to help identify what different colors or symbols represent

• It filters out unnecessary data

• It validates the data entered

A teacher wants to compare the sales of three products over six months. Which type of chart would be most appropriate for this task, and why?

• Pie Chart, because it shows proportions of a whole

• Line Graph, because it shows trends over time

• Filter, because it hides unnecessary data

• Data Validation, because it checks for errors