NEW
Font size
WorksheetsICT 7 Quiz / 3rd Quarter
Total questions: 10
Worksheet time: 5mins
Which function is used to find the average of a range of numbers?
Sum
Average
Count
Max
What is the purpose of embedding a chart in a worksheet?
To store more data
To visually represent data
To delete unnecessary information
To increase file size
Which formula correctly adds the values in cells A1 to A5?
=ADD(A1:A5)
=TOTAL(A1:A5)
=SUM(A1:A5)
=COUNT(A1:A5)
What type of chart is best for showing trends over time?
Column chart
Pie chart
Line chart
Bar chart
If a cell contains =B2+C2*D2, which operation is performed first?
Multiplication
Addition
Subtraction
Division
What shortcut key is used to quickly format a cell as currency?
Ctrl + B
Ctrl + Shift + $
Ctrl + C
Ctrl + P
Which tool helps in automatically filling a sequence of numbers in a column?
AutoFormat
Fill Handle
Sort & Filter
Data Validation
What is the purpose of using conditional formatting?
To change font styles
To delete empty rows
To sort data
To highlight cells based on condition
How do you insert a new worksheet in Excel?
Press Ctrl + N
Click the “Insert” tab
Click the “+” button on the sheet tab bar
What does the COUNTIF function do?
Counts all empty cells in a range
Counts the number of cells that meet a condition
Calculates the total of selected cells
Displays the highest value in a range
