NEW
Font size
WorksheetsExcel Multiple Choice Questions
Total questions: 10
Worksheet time: 5mins
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
