What is the command (button) to change the background color of a cell?
Fill color
100
Cell address F12 refers to the cell at which column and which row?
Column 6, row 12
100
Name the function to find the total number of cells that have numbers.
count()
100
Name a chart type which is round in shape.
pie chart
200
Sheet1, Sheet2, Sheet3 in Excel are called ...
worksheets
200
When text in too long to fit within a cell, suggest two ways to make it fit.
wrap text, adjust column width
200
What is the cell address to the right of Z10?
AA10
200
Name the two functions to find the largest value AND average value.
max(), average()
200
Name two chart types that are non-circular in shape.
bar, column, line
300
Which command can be used to change the name of a worksheet?
rename
300
The sort button is used for …
arranging information in order
300
Cell F4 has the formula =C4+D4. After adding one column after column A. What will the formula become?
=D4+E4
300
Write a formula using function to find the smallest value in cells A2:A40.
=min(A2:A40)
300
Name the cells used for creating a chart.
data series
400
Suggest two OTHER commands you can use on a worksheet.
insert, delete, copy, move
400
What should be selected first before performing a sort?
cells to be sorted
400
Cell H4 has the formula =D4+E4+F4. After moving column C after column A. What will the formula be?
=D4+E4+F4
400
Write a formula using function to find the largest value of cells A1 to E1, A2 to E2, A3 to E3.
=MAX(A1:E3)
400
What is the purpose of using data labels?
show actual values of the data series
500
When the collection of worksheets are saved, it is called a …
workbook
500
In an Excel file with 6 columns (A - F) and 120 rows of information. If only column B is selected to be sorted, what could have happened?
Information on the other columns will not match with column B.
500
Cell J12 has the formula =SUM(J2:J11). After deleting row 2, what will the formula be?
=SUM(J2:J10)
500
Write a formula using function to sum up the cells A1, A3, A5 to A30.
=SUM(A1, A3, A5:A30)
500
Pie chart is good at showing a portion as a whole. What should be set up in a pie chart to clearly show the relationship between individual data value and the whole data series?