ICT Grade 8 Model exam Altaluq private school Excel

1. What is the correct way to find the total in Excel?

• A) =TOTAL(B3:B9)

• - B) =ADD(B3:B9)

• - D) =COUNT(B3:B9)

• - C) =SUM(B3:B9)

2. How can you quickly add up numbers using Excel?

• - D) Use the MIN function

• - A) Use the autosum button

• - B) Type "Add" in a cell

• - C) Use the CONCATENATE function

3. What does the MIN function in Excel give?

• - A) The largest number in a group

• - B) The smallest number in a group

• - C) The average of a group of numbers

• - D) The total of a group of numbers

5. What does the CONCATENATE function in Excel do?

• - B) Finds the smallest value in a range

• - A) Sums a range of cells

• - C) Joins text from different cells

• - D) Multiplies values in a range

6. In Excel, how are columns arranged?

• - A) Horizontally

• - B) Vertically

• - C) Diagonally

• - D) Circularly

6. In Excel, how are columns arranged?

• - C) Diagonally -

• - A) Horizontally

• - B) Vertically

• D) Circularly

7. In Excel, what do you click to select an entire column?

• - A) Row number

• - B) Cell

• - C) Column letter

• - D) Table

8. Can the IF function in Excel be used to do what?

• - A) Find the average of a range

• - B) Highlight cells with specific values

• - C) Show letter grades based on criteria

• - D) Count the number of cells in a range

9. Can conditional formatting in Excel be used to do what?

• - A) Merge cells

• - B) Highlight cells with specific values

• - C) Perform calculations

• - D) Create charts

10. What do Excel charts provide?

• - A) A way to organize data

• - B) A visual representation of data

• - C) A method to write formulas

• - D) A way to sort data