Free Printable Spreadsheet Fundamentals

Worksheets

Spreadsheet Fundamentals - Quiz2

Total questions: 20

Worksheet time: 8mins

Name

Class

Date

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

True

False

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"))

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

COUNT

COUNTIF

SUM

MAX

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

True

False

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

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

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

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

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

100

=SUM(A1:A1)

Sales

0.5

10.

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.

11.

How do you apply a formula to add all values in cells A1 through A10?

=SUM(A1:A1)

=ADD(A1:A1)

=A1 + A2 + A3 + ... + A10

=TOTAL(A1:A1)

12.

Which of the following is an example of an Excel function?

=A1+B1

=SUM(A1:A1)

=A1*B1

=A1-B1

13.

What will the formula =A1 + B1 calculate?

The sum of the values in cells A1 and B1.

The average 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.

14.

What does the formula =IF(A1>10, "High", "Low") do?

It calculates the average of the value in cell A1 if it is greater than 10.

It checks if the value in cell A1 is greater than 10 and returns "High" if true and "Low" if false.

It multiplies the value in cell A1 by 10.

It sorts the value in cell A1 into high or low categories.

15.

Using this in creating formula in Excel the cell references do not change when copied or filled by inserting $. You can use this to keep the row or column constant.

absolute reference

cell reference

relative reference

function

16.

A company tracks sales data for three products: Product A, Product B, and Product C. The sales amounts for each product are listed in cells B2, B3, and B4 respectively.

To calculate the total sales amount, you should enter the following formula in cell B5: (a)

17.

A student's exam score is entered in cell C2. If the score is 75 or higher, the student passes;

otherwise, they fail.

To determine the student's status (Pass/Fail), you should enter the following formula in cell D2: (a)

18.

A spreadsheet contains a list of 5 employees performance ratings in column C1 to C5, ranging from "Excellent" to "Needs Improvement."

To count the number of employees who received an "Excellent" rating, you should enter the following formula in cell C7: (a)

19.

A university has a list of different courses in column A ranging from A1 to A5 and the number of students enrolled in each course in column B ranging from B1 to B5. You want to calculate the total number of students enrolled in the "BSA" course.

To find this, enter the following formula in cell C1: (a) .

20.

The total number of students enrolled in a course is listed in cell C2. The university assigns a course size label based on the number of students enrolled:

If the enrollment is 100 or more, the course is labeled "Large".
If the enrollment is between 50 and 99, the course is labeled "Medium".
If the enrollment is between 20 and 49, the course is labeled "Small".
If the enrollment is below 20, the course is labeled "Very Small".

To determine the course size label, enter the following formula in cell D2: (a) .

Reset

Spreadsheet Fundamentals - Quiz2

Total questions: 20

Worksheet time: 8mins

Similar Resources on Wayground