Spreadsheet Fundamentals - Quiz2

The IF function can be nested inside another IF function to handle multiple conditions.

• True
• False

Answer explanation

The IF function can indeed be nested within another IF function to handle more than one condition, known as Nested IFs.

Which formula would correctly use a nested IF to categorize scores as "Excellent" for scores 90 and above, "Good" for scores 75-89, and "Needs Improvement" for scores below 75?

• =IF(A1>=90,"Excellent",IF(A1>=75,"Good","Needs Improvement"))
• =IF(A1>=75,"Good",IF(A1>=90,"Excellent","Needs Improvement"))
• =IF(A1>=90,"Good",IF(A1>=75,"Excellent","Needs Improvement"))
• =IF(A1<75,"Needs Improvement",IF(A1<90,"Good","Excellent"))

Answer explanation

The formula =IF(A1>=90,"Excellent",IF(A1>=75,"Good","Needs Improvement")) correctly categorizes the scores as specified, checking for the highest range first.

Which of the following functions would you use to count how many times a specific word appears in a range?

• COUNT
• COUNTIF
• SUM
• MAX

Answer explanation

COUNTIF can be used to count the number of cells that contain a specific word or value in a given range.

The SUM function can only be used to add up numbers in a single row or column.

• True
• False

Answer explanation

The SUM function can add numbers across multiple rows and columns, not just a single row or column.

Which of the following functions could be used to count the number of cells in a range that contain numbers greater than 100?

• COUNT
• COUNTA
• COUNTIF
• SUMIF

Answer explanation

The COUNTIF function can count cells in a range that meet the criterion of containing numbers greater than 100.

How do you apply conditional formatting to highlight cells greater than a certain value?

• Home > Insert > Conditional Formatting
• Home > Conditional Formatting > Highlight Cells Rules > Greater Than
• Data > Conditional Formatting > Manage Rules
• File > Options > Conditional Formatting

Answer explanation

To apply conditional formatting for cells greater than a specified value, navigate to Home > Conditional Formatting > Highlight Cells Rules > Greater Than.

What does the "Filter" option in Excel allow you to do?

• Hide rows
• Display only the rows that meet certain criteria
• Sort the data alphabetically
• Remove duplicates from the dataset

Answer explanation

The "Filter" option allows you to display only those rows that meet specific criteria, making it easier to analyze data.

How can you create a formula that multiplies the value in cell A1 by 10 and adds the value in cell B1?

• =A1 * 10 + B1
• =A1 + 10 * B1
• =10 * (A1 + B1)
• =A1 * B1 + 10

Answer explanation

This formula multiplies the value in A1 by 10 and then adds the value in B1.

Which of the following represents a label in an Excel worksheet?

• 100
• =SUM(A1:A1)
• Sales
• 0.5

Answer explanation

Labels are text values used to describe data or categories, such as "Sales."

What is the difference between a formula and a value in Excel?

• A formula displays text, while a value displays numbers.
• A formula performs calculations and displays results, while a value is a static number or text.
• A formula can be used to filter data, while a value cannot.
• A formula changes automatically, while a value remains constant.

Answer explanation

Formulas perform calculations and can dynamically change, while values are static entries in cells.