Spreadsheet Form 1

Question 1

Each cell in a spreadsheet is identified by a unique address known as a cell reference.

Accepted Answer

True

Question 2

What is the main purpose of conditional formatting?

Accepted Answer

To change the appearance of a cell based on its value

Question 3

The formula =SUM(A1:A5) adds all the values from cell A1 to A5.

Accepted Answer

True

Question 4

Which function is used to find the total of a set of numbers in a spreadsheet?

Accepted Answer

SUM

Question 5

What symbol must all spreadsheet formulas begin with?

Accepted Answer

=

Question 6

Spreadsheets are only used in schools and not in real-world industries like health or retail.

Accepted Answer

False

Question 7

The AVERAGE function in a spreadsheet is used to count the number of cells in a range.

Accepted Answer

False

Question 8

What is a "range of cells" in a spreadsheet?

Accepted Answer

A group of adjacent cells

Question 9

Conditional formatting can only be used with text values in a spreadsheet.

Accepted Answer

False

Question 10

Which of the following is a spreadsheet software?

Accepted Answer

Google Sheets

Questions 10