Y8 Excel revision quiz

What is the result of the following Excel formula: =A1+B1?

• The sum of the values in cells A1 and B1

• The difference between the values in cells A1 and B1

• The product of the values in cells A1 and B1

• The quotient of the values in cells A1 and B1

Which of the following is a correct use of the COUNTIF function?

• =COUNTIF(A1:A10, "apple")

• =COUNTIF("apple", A1:A10)

• =COUNTIF(5, A1:A10)

• =COUNTIF(A1, "apple")

What does the =SUM(A1:A10) formula do?

• Multiplies all the values from A1 to A10

• Adds up all the values from A1 to A10

• Divides the values in A1 by A10

• Subtracts the values in A1 from A10

What is an example of Abstraction in computer science?

• Designing the layout of a webpage

• Ignoring unnecessary details to focus on important information

• Writing a program to perform a task

• Testing software to find errors

In Excel, what is Conditional Formatting used for?

• To perform calculations

• To change the appearance of a cell based on its value

• To add text to a cell

• To set the location of a cell in the spreadsheet

What does the function =AVERAGE(B1:B10) calculate?

• The maximum value in cells B1 to B10

• The sum of the values in cells B1 to B10

• The average of the values in cells B1 to B10

• The minimum value in cells B1 to B10

Which of the following describes Verification?

• Checking data to ensure it is reasonable

• Automatically checking data

• Checking if data is accurate and matches the source

• Making a formula work in a spreadsheet

What is the purpose of a Macro in Excel?

• To calculate the sum of a range of numbers

• To automate a set of tasks with one click

• To format cells based on conditions

• To count specific values in a range

Which of the following is a valid cell reference in Excel?

Which of the following statements about the System Lifecycle is correct?

• A) The System Lifecycle is a process that only applies to hardware systems.

• B) It includes steps like Analysis, Design, Implementation, Testing, and Evaluation.

• C) The Design phase involves building the system.

• D) Testing comes before Implementation.