NEW
Font size
WorksheetsExcel Basics Quiz for Year 10
Total questions: 15
Worksheet time: 8mins
Which of the following formulas would you use in Excel to add the values in cells A1, A2, and A3?
=ADD(A1:A3)
=SUM(A1:A3)
=TOTAL(A1:A3)
=PLUS(A1:A3)
What is the correct way to make the text in a cell bold in Excel?
Right-click the cell and select 'Bold'
Click the 'B' icon on the Home tab
Type =BOLD() in the cell
Press Ctrl + I
Which function would you use to find the average of numbers in cells B1 to B10?
=SUM(B1:B10)
=AVERAGE(B1:B10)
=MEAN(B1:B10)
=MEDIAN(B1:B10)
How can you change the background colour of a cell in Excel?
Use the 'Font Colour' button
Use the 'Fill Colour' button
Use the 'Insert' tab
Use the 'Conditional Formatting' button only
Which chart type is best for showing the proportion of different categories in a dataset?
Line chart
Pie chart
Scatter plot
Column chart
What does the formula =A1*B1 do in Excel?
Adds the values in A1 and B1
Multiplies the values in A1 and B1
Divides A1 by B1
Subtracts B1 from A1
Which of the following is a valid way to sort data in Excel?
Use the 'Sort & Filter' button on the Home tab
Use the 'Insert' tab
Use the 'Review' tab
Use the 'Page Layout' tab
If you want to highlight all cells greater than 100 in a column, which feature should you use?
Data Validation
Conditional Formatting
Data Filter
Freeze Panes
Which function would you use to count the number of cells in a range that contain numbers?
=COUNT()
=COUNTA()
=COUNTIF()
=SUM()
What is the result of the formula =SUM(2, 4, 6)?
6
10
12
14
How do you insert a column chart in Excel?
Select data, go to 'Insert' tab, and choose 'Column Chart'
Right-click and select 'Insert Chart'
Use the 'Page Layout' tab
Type =CHART() in a cell
Which of the following is NOT a cell formatting option in Excel?
Changing font size
Adding cell borders
Sorting data
Changing number format
What does the filter feature in Excel allow you to do?
Remove all data from a worksheet
Display only rows that meet certain criteria
Change the font style of cells
Insert new worksheets
Which formula would you use to find the highest value in a range from C1 to C10?
=MIN(C1:C10)
=MAX(C1:C10)
=SUM(C1:C10)
=COUNT(C1:C10)
If you want to automatically apply a green fill to cells where the value is above 80, which Excel feature should you use?
Data Validation
Conditional Formatting
Sort & Filter
Find & Select
