Excel Multiple Choice Questions

What is Excel primarily used for ?

• Word processing

• Data analysis and calculations

• Graphic design

• Web browsing

What is the default file extension for Excel workbooks?

• .xls

• .xlsx

• .xlsm

• .csv

How do you create a chart in Excel?

• Use the Chart Wizard

• Insert a Chart from the Insert tab

• Type the data and press F11

• All of the above

Which of the following is NOT a type of chart in Excel?

• Line Chart

• Bar Chart

• Pie Chart

• Draw Chart

What is a cell's address in Excel?

• The data it contains

• The range it refers to

• Its position defined by a letter and a number (e.g., A1)

• Its formatting

How do you adjust the width of a column?

• Drag the right edge of the column header

• Use the Format Cells option

• Double-click the cell

• All of the above

Which of the following formulas calculates the average of numbers in cells A1 to A10?

• =AVERAGE(A1:A10)

• =AVRG(A1:A10)

• =SUM(A1:A10)/20

• =MEAN(A1:A10)

What will the formula =MIN(A1:A10) return?

• The highest number from the range A1 to A10

• The sum of the numbers from A1 to A10

• The lowest number from the range A1 to A10

• An error if A1 to A10 are empty

If the range B1:B5 contains the values 10, 20, 30, 40, and 50, what will =MAX(B1:B5) return?

• 30

• 20

• 40

• 50

How would you calculate the total of values from C1 to C10 using the SUM function?

• =TOTAL(C1:C10)

• =SUM(C1:C10)

• =ADD(C1:C10)

• =C1 + C2 + C3