Quiz # 5 ( T-ICT)

1.   What is the main purpose of using a spreadsheet application like Microsoft Excel?

• Sending emails

• Playing games

• Creating budgets and calculations

• Editing photos

2. Which tab in Excel contains options related to formatting cells?

• home

• insert

• data

• review

    What is the purpose of an electronic spreadsheet?

• To store text documents

• To create presentations

• To perform calculations and analyze data

• To manage email communications

4.      What does the 'Merge & Center' button do in Excel?

• It combines multiple cells and centers the text within them.

• It finds the middle value in a range of cells.

• It merges two worksheets into one.

• It centers the worksheet on the page when printing.

5.   In Excel, which data type is used for whole numbers without decimal points?

• Text

• Number

• Currency

• Date

    Which command is used to insert a new worksheet in Excel?

• Insert Sheet

• New Worksheet

• Add Sheet

• Insert Worksheet

7.      What symbol is used to indicate multiplication in Excel formulas?

• +

• /

• *

• -

8.   How would you apply a formula to sum up the values in cells A1 through A10?

• =SUM(A1:A10)

• =A1+A10

• =TOTAL(A1:A10)

• =ADD(A1:A10

9.      Which data type in Excel is used to store monetary values?

• Text

• Boolean

• Currency

• Date

10.     Which group in the Data tab is used for sorting and filtering data in Excel?

• Analysis

• Data Tools

• Sort & Filter

• Consolidate