Spreadsheet - Basic Functions and Conditional Formatting

Which function is used to find the sum of a range of numbers in a spreadsheet?

• =ADD()

• =TOTAL()

• =SUM()

• =COMBINE()

What does the formula =AVERAGE(10, 20, 30) return?

• 60

• 20

• 10

• 30

Which function returns the largest number from a given range?

• =MAX()

• =HIGH()

• =LARGE()

• =BIG()

What will =COUNT(A1:A5) return if A1=10, A2=20, A3=Hello, A4=, A5=30?

• 3

• 4

• 5

• 2

If you want to find the smallest number in cells B1 to B10, which function should you use?

• =LOW()

• =SMALL()

• =MIN()

• =LEAST()

What is the main purpose of conditional formatting in a spreadsheet?

• To automatically sort data

• To change the appearance of cells based on conditions

• To lock certain cells

• To create charts

Which of the following is NOT a type of conditional formatting rule?

• Highlight cells greater than a certain number

• Change font color based on text value

• Automatically create a chart

• Apply color scales to a range

If you want to highlight all cells with values less than 50 in red, what should you do?

• Use a formula to filter data

• Apply a conditional formatting rule with "Less than" and set the fill color to red

• Use the =MIN() function

• Sort the data in ascending order

In conditional formatting, what does a "color scale" do?

• Shows only the highest and lowest values

• Fills cells with colors based on value ranges

• Locks the cells so they cannot be edited

• Converts numbers into text

You want to highlight duplicate values in a column. Which tool should you use?

• Filter

• Sort by color

• Conditional formatting → Duplicate Values

• Data Validation