Spreadsheet Knowledge Quiz

What is the term for the basic component of a spreadsheet, which is the intersection of a row and a column?

• Cell

• Chart

• Tab

• Workbook

Which function in a spreadsheet adds up the numbers in a list and divides by the number of items in the list?

• Sum

• Average

• Merge

• Sort

What is the name of a graphical way to show information in a spreadsheet?

• Column

• Chart

• Row

• Range

What is the term for a shortcut to fill relative cells in a spreadsheet?

• Autofill

• Format

• Merge

• Sort

What is the term for data represented by letters and numbers that cannot perform mathematical operations?

• Numeric information

• Alpha numeric information

• Data

• Formula

What is the term for a type of chart that compares two or more things?

• Line graph

• Pie chart

• Column chart

• Bar graph

What is the term for a group of cells in a spreadsheet?

• Range

• Row

• Column

• Tab

What is the term for a predefined formula in Excel where the program has done the formula work for you?

• Function

• Formula

• Legend

• Chart

What is the term for information shown in a vertical format in a spreadsheet?

• Row

• Column

• Range

• Tab

What is the term for a type of chart that shows changes of something over time?

• Pie chart

• Column chart

• Line graph

• Bar graph