Have a question?
Send enquiry
Message sent Close

QUIZ

time left:
:
:

QUIZ

Submit quiz
Once you submit, you will no longer be able to change your answers. Are you sure you want to submit the quiz?
Cancel Submit

Result

38%

😞

4 out of 10 questions answered correctly
Retake
  • Questions count: 10
  • Passing grade: 80%
  • Time limit: 8 minutes
1.
Which function is used to count the number of cells that contain numbers in a range?
COUNT
COUNTA
COUNTIF
COUNTBLANK
2.
Which of the following is the correct syntax for the IF function in Excel?
IF(logical_test, value_if_true, value_if_false)
IF(logical_test, value_if_false, value_if_true)
IF(logical_test, value_if_true)
IF(value_if_true, logical_test, value_if_false)
3.
What function in Excel is used to calculate the average of a range of numbers?
SUM
AVERAGE
COUNT
MEDIAN
4.
Which feature in Excel allows you to visually compare and analyze data trends over time?
Filters
Pivot Table
Sparklines
Conditional Formatting
5.
Which of the following features allows you to automate repetitive tasks in Excel?
Formulas
Charts
Macros
Filters
6.
What is the shortcut key for saving a workbook in Excel?
Ctrl + S
Ctrl + A
Ctrl + Z
Ctrl + X
7.
Which of these charts is best for showing the proportion of parts to a whole?
Line Chart
Bar Chart
Pie Chart
Scatter Plot
8.
What is the intersection of a row and a column in Excel called?
Box
Cell
Grid
Block
9.
Which of the following is used to combine the contents of multiple cells in Excel?
CONCATENATE
SUM
VLOOKUP
IF
10.
Which Excel function is used to find the largest number in a range?
MAX
MIN
LARGE
BIG
Submit quiz
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10