Spreadsheet Knowledge Quiz Oct 21-25

What is a single box in a spreadsheet called?

• Formula

• Cell

• Chart

• Range

Answer explanation

In a spreadsheet, a single box is called a 'Cell'. It is the basic unit where data is entered, unlike a 'Formula' which performs calculations, a 'Chart' which visualizes data, or a 'Range' which refers to multiple cells.

Which term refers to a mathematical expression used to calculate values in a spreadsheet?

• Function

• Data collection

• Filter

• Sort

Answer explanation

The term 'Function' refers to a mathematical expression used in spreadsheets to perform calculations, such as SUM or AVERAGE. Other options like 'Data collection', 'Filter', and 'Sort' do not specifically denote mathematical expressions.

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

• Range

• Chart

• Formula

• Data analysis

Answer explanation

In spreadsheet terminology, a 'Range' refers to a group of cells selected together. This term is commonly used to perform operations on multiple cells at once, making it the correct choice for the question.

Which tool is used to create visual representations of data in a spreadsheet?

• Google Forms

• Chart

• Cell

• Sort

Answer explanation

The correct tool for creating visual representations of data in a spreadsheet is 'Chart'. Charts help to visualize data trends and comparisons, making them essential for data analysis.

Which tool is used to collect responses from users?

• Google Forms

• Data analysis

• Function

• Range

Answer explanation

Google Forms is a tool specifically designed to collect responses from users through surveys and questionnaires, making it the correct choice for this question.

Which function is used to add up a series of numbers?

• Count

• Sum

• Filter

• Sort

Answer explanation

The 'Sum' function is specifically designed to add up a series of numbers, making it the correct choice. 'Count' is used for counting items, while 'Filter' and 'Sort' serve different purposes.

Which type of chart uses bars to represent data?

• Line chart

• Pie chart

• Bar chart

• Filter

Answer explanation

A bar chart uses bars to represent data, making it easy to compare different categories. In contrast, line charts use lines to show trends over time, and pie charts display parts of a whole. Therefore, the correct answer is the bar chart.

What function adds up a range of numbers?

• Maximum

• Sum

• Minimum

• Count

Answer explanation

The function 'Sum' is specifically designed to add up a range of numbers, making it the correct choice. 'Maximum' and 'Minimum' find the highest and lowest values, while 'Count' tallies the number of entries.

What is a pie chart used for?

• To show numerical proportion

• To compare categories

• To display data points

• To analyze data

Answer explanation

A pie chart is primarily used to show numerical proportions, illustrating how different parts contribute to a whole. This makes 'To show numerical proportion' the correct choice, as it captures the essence of what pie charts represent.

In Google Sheets, what do formulas always start with?

• A plus sign (+)

• A minus sign (-)

• An equals sign (=)

• A dollar sign ($)

Answer explanation

In Google Sheets, all formulas must begin with an equals sign (=). This indicates to the program that the following text is a formula to be calculated, distinguishing it from regular text.