Font size
WorksheetsClass XC ICT Test
Total questions: 20
Worksheet time: 13mins
1. In MS Excel, which function is used to add up the numbers in a range of cells?
SUM
AVG
MAX
MIN
2. Which keyboard shortcut in MS Excel allows you to undo your last action?
Ctrl+C
Ctrl+Z
Ctrl+X
Ctrl+V
3. What does the COUNT function in MS Excel do?
Counts the number of cells in a range that contain numbers
Counts the number of cells in a range that contain text
Counts the number of cells in a range that meet a specified condition
Counts the number of cells in a range that contain formulas
4. Which of the following is NOT a valid file extension for an MS Excel workbook?
.xlsx
.xls
.docx
.xlsm
5. Which tab in the MS Excel ribbon contains commands related to formatting cells?
Home
Data
Insert
Review
6. What does the autofill handle in MS Excel allow you to do?
Insert pre-defined text into adjacent cells based on the pattern of existing text
Insert formulas into adjacent cells based on the pattern of existing formulas
Insert new columns or rows into a worksheet
Insert predefined shapes and objects into a worksheet
7. Which function in MS Excel is used to find the average value of a range of cells?
COUNT
MIN
MAX
AVERAGE
8. Which chart type in MS Excel is best suited for comparing values across categories?
Pie chart
Line chart
bar chart
Scatter chart
9. Which keyboard shortcut in MS Excel allows you to save the current workbook?
Ctrl+C
Ctrl+X
Ctrl+S
Ctrl+V
10. Which function in MS Excel is used to find the smallest value in a range of cells?
MIN
AVG
COUNT
MAX
Which keyboard shortcut in MS Excel allows you to cut the selected cells?
Ctrl+Z
Ctrl+S
Ctrl+V
Ctrl+X
What does the Sort feature in MS Excel allow you to do?
Rearrange the cells in a worksheet based on specified criteria
Adjust the alignment and formatting of selected cells
Insert new columns or rows into a worksheet
Calculate the sum of selected cells
Which keyboard shortcut in MS Excel allows you to select the entire worksheet?
Ctrl+R
Ctrl+P
Ctrl+S
Ctrl+A
What does the AutoSum feature in MS Excel allow you to do?
Automatically sort the selected cells in ascending order
Automatically insert a sum formula into a selected cell
Automatically format the selected cells as a table
Automatically adjust the column width to fit the content in the selected cells
What does the Fill handle in MS Excel allow you to do?
Insert pre-defined text into adjacent cells based on the pattern of existing text
Insert new columns or rows into a worksheet
Insert predefined shapes and objects into a worksheet
Insert formulas into adjacent cells based on the pattern of existing formulas
The (a) function in MS Excel is used to find the largest value in a range of cells.
The shortcut key (a) is used to select the entire column in MS Excel.
The (a) feature in MS Excel allows you to display or hide the formulas in a worksheet.
The (a) function in MS Excel is used to calculate the average value of a range of cells.
The (a) feature in MS Excel allows you to automatically adjust the width of a column to fit the contents.
