Spreadsheet Quiz

What is a Spreadsheet?

• A collection of icons that provides a shortcut to using a drop-down menu.

• A google sheets file that has one or more worksheets.

• A visual representation of data in a circle that shows data in percentages.

• Organize data placed into rows and columns.

What does the term 'Row' refer to in a spreadsheet?

• Spreadsheet data arranged vertically in a table.

• A rectangular box that holds data at the intersection of a row and column.

• Spreadsheet data arranged horizontally and numbered in sequential order.

• The column letter followed by the row number, used to reference a cell.

What is a Cell Address?

• A set of options presented to the user of a computer application to help them find information or execute a function.

• The column letter followed by the row number, used to reference a cell.

• A list of preset formulas that are used to solve equations.

• A visual representation of data that shows data as bars.

What is the purpose of the Fill Handle in a spreadsheet?

• To organize data placed into rows and columns.

• To add a dollar sign, a decimal, 1 place to the left for each selected cell.

• To combine multiple cells into one cell.

• To copy the content of the current cell to multiple cells below or to the right.

What does a Pie Chart represent?

• A list of preset formulas that are used to solve equations.

• A visual representation of data in a circle that shows data in percentages.

• A google sheets file that has one or more worksheets.

• The highest number in a range.

What function do you use to find the lowest number in a range in a spreadsheet?

Evaluate responses using AI:

OFF

  Is spreadsheet data arranged horizontally and numbered in sequential order.

• Row

• Column

• Active Cell

• Sheet

Spreadsheet data arranged vertically in a table

• Row

• Column

• Workbook

• Toolbar

A set of options presented to the user of a computer application to help

• Active Cell

• Toolbar

• Menu

• Sheet

A google sheets file that has one or more worksheets

• Menu

• Function

• Spreadsheet

• Workbook