G07 Q4 ICT MOCK TEST

What is the function of a formula in Excel?

• To format cells with colors and borders

• To insert hyperlinks in a worksheet

• To perform calculations and generate results

• To create shapes and pictures

In Excel, which symbol is used to begin a formula?

• @

• #

• $

• =

What is the main role of parentheses in Excel formulas?

• To change the font color of the text

• To organize data in columns

• To control the sequence of calculations

• To insert hyperlinks

According to the MDAS rule, which mathematical operation should be carried out first?

• Addition

• Multiplication

• Division

• Subtraction

What does the formula "= (A1 + B1) * C1 / D1" compute, following the MDAS rule?

• Addition, Multiplication, Division, Subtraction

• Division, Addition, Multiplication, Subtraction

• Multiplication, Division, Addition, Subtraction

• Subtraction, Division, Addition, Multiplication

What is the main reason for using charts in Excel?

• To format cells with borders and colors

• To insert images and shapes

• To visually represent data for better understanding

• To create hyperlinks in a worksheet

Which Excel chart type is most suitable for comparing data across different categories?

• Line chart

• Bar chart

• Pie chart

• Scatter plot chart

How can you generate a chart in Excel?

• Click on a chart type, and it will be created automatically

• Enter chart data in a cell next to your data

• Use the "Shapes" gallery and choose a chart shape

• Open the "Insert" tab and select a chart type

What type of data is best displayed using a pie chart?

• Data showing trends over time

• Data with percentages or proportional values

• Data comparing different categories

• Data with multiple variables

Which tab in Excel contains the option to insert a chart?

• Home

• Insert

• Format

• Review