ICT 7 Quiz / 3rd Quarter

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