NEW
Font size
WorksheetsSpreadsheet - Basic Functions and Conditional Formatting
Total questions: 10
Worksheet time: 5mins
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
