Excel Basics Quiz for Grade 10

Which of the following is a basic Excel function used to calculate the sum of a range of cells?

• AVERAGE

• SUM

• COUNT

• MAX

What is the purpose of cell formatting in Excel?

• To perform calculations

• To change the appearance of data

• To sort data

• To create charts

Which symbol is used to start a formula in Excel?

• #

• @

• =

• $

What is the difference between relative and absolute cell references in Excel?

• Relative references change when copied, absolute references do not

• Absolute references change when copied, relative references do not

• Both change when copied

• Neither change when copied

Which of the following is a simple chart type available in Excel?

• Histogram

• Scatter plot

• Line chart

• Pie chart

What is the function of data validation in Excel?

• To ensure data is entered correctly

• To format cells

• To create charts

• To perform calculations

Which function would you use to find the average of a set of numbers in Excel?

• SUM

• AVERAGE

• MIN

• MAX

How do you apply bold formatting to a cell in Excel?

• Use the SUM function

• Click the Bold button on the toolbar

• Enter a formula

• Use data validation

• Multiplies the values in cells A1 and B1

• Subtracts the value in B1 from A1

• Adds the values in cells A1 and B1

• Divides the value in A1 by B1

Which of the following is an example of an absolute cell reference?

• A1

• A$1