Question 21: Find the value of the cell C3 after the formula $=MAX(A1:C3)$ is inserted into cell C3. The range A1:C3 includes the following values: 5, 4, 6, 4, null, 5, 3, null, *formula*. The $MAX$ function returns the largest value in the given range. Question 22: Determine which of the given spreadsheet formulas A, B, and C are valid given the spreadsheet structure. Question 23: Determine which of the statements regarding electronic databases are correct.

1. Problem Description

Question 21: Find the value of the cell C3 after the formula $=MAX(A1:C3)$ is inserted into cell C

3. The range A1:C3 includes the following values: 5, 4, 6, 4, null, 5, 3, null, *formula*. The $MAX$ function returns the largest value in the given range.

Question 22: Determine which of the given spreadsheet formulas A, B, and C are valid given the spreadsheet structure.

Question 23: Determine which of the statements regarding electronic databases are correct.

2. Solution Steps

Question 21:

The formula in C3 is $=MAX(A1:C3)$. Before the formula is evaluated, C3 is empty.

The range A1:C3 contains the values 5, 4, 6, 4, "null" (or blank), 5, 3, "null" (or blank), and C3 (the cell where the formula is being entered).

The $MAX$ function finds the largest numerical value in the specified range. The largest number in the range A1:C3 is

6. Therefore, after the formula is evaluated, C3 will contain the value

6.

Question 22:

A. $=Sum(B2$,$B3,B5)$. This formula appears to be valid. $B2$ is a cell reference, $B3 is a cell reference, and$B5 is a cell reference. This formula calculates the sum of the values in cells B2, B3, and B

5.

B. $=Average(B2:B5, C5)$. This formula appears to be valid. However, cell B4 is empty (denoted as "null"), and B5 is empty. The Average function is used with a range (B2:B5), which includes cells B2, B3, B4, and B

5. $C5$ is outside of the given table. Note that Excel calculates the average of numerical entries, ignoring text or null (blank) values. This gives an average.

C. $=Sum(B2:B8, C5:C10)$. $B2:B8$ includes the cells B2, B3, B4, B5, B6, B7, and B

8. $C5:C10$ includes cells C5, C6, C7, C8, C9, and C

1

0. Since the spreadsheet only has data up to row 3 and row 2 in the B and C column respectively, many of these cells are likely empty, or

0. Sum function will add those ranges.

Therefore, formulas A, B, and C are valid.

Question 23:

A. The field which enables to identify a record uniquely in a table is called the primary key. This statement is correct. A primary key uniquely identifies each record in a database table.

B. Efficiency can be increased by increasing the data redundancy of a relational database. This statement is incorrect. Increased data redundancy generally leads to decreased efficiency in relational databases because it wastes storage space and can lead to inconsistencies.

C. A collection of fields of data which is relevant to one object or person is called a record. This statement is correct. A record is a collection of related fields representing a single entity (object or person).

Therefore, only statements A and C are correct.

3. Final Answer

Question 21: (3) 6

Question 22: (4) Correct all A, B and C

Question 23: (3) Only A and C