Spreadsheet Basics Flashcard

Front

What is a cell in a spreadsheet?

Back

A rectangular box where a row and column intersect

Front

Which of the following best describes a formula? A way to sort data, A predefined function, An equation used to perform calculations, A type of data format

Back

An equation used to perform calculations

Front

What does the function =SUM(A1:A5) do?

Back

Adds the values in the range A1 to A5

Front

What is the purpose of the IF function in a spreadsheet?

Back

To perform conditional operations

Front

Which symbol is used to start a formula in a spreadsheet?

Back

=

Front

What is a range in a spreadsheet?

Back

A group of adjacent cells

Front

Which feature allows you to repeat a formula across multiple cells?

Back

Autofill

Front

Which of the following functions returns the highest value in a range? Options: =MAX(A1:A10), =MIN(A1:A10), =AVERAGE(A1:A10)

Back

=MAX(A1:A10)

Front

What is the purpose of a pie chart in a spreadsheet?

Back

To compare parts of a whole.

Front

What does the function =ROUND(23.567, 1) return?

Back

23.6