Lets Learn Excel : Ultimate Multiple Choices Questions on Excel

Free Excel learning online. Answer these Multiple Choice questions ot understand Excel and improve your knowledge 
How to take the questions 
  • Select either A, B C or D 
  • A 3 seconds countdown will begin 
  •  Next question will be revealed.
QUESTION 1 OF 20
What is Microsoft Excel mainly used for?
Word processing
Spreadsheet calculations
Image editing
Video editing
What is the intersection of a row and column called?
Sheet
Cell
Range
Box
Which symbol is used to start a formula in Excel?
@
#
=
&
What does the SUM function do?
Multiplies values
Adds values
Divides values
Subtracts values
Which function is used to find the average?
SUM
COUNT
AVERAGE
MAX
What is a workbook?
A single cell
A collection of worksheets
A chart
A formula
What is a worksheet?
A file
A page in a workbook
A chart
A formula
Which key is used to edit a cell?
F1
F2
F3
F4
What does the COUNT function do?
Counts text
Counts numbers
Counts formulas
Counts blanks
Which chart is best for showing trends over time?
Pie chart
Line chart
Bar chart
Column chart
What is the default file extension of modern Excel files?
.xls
.xlsx
.docx
.pptx
What does the MAX function do?
Finds smallest value
Finds largest value
Adds values
Counts values
What does the MIN function do?
Finds largest value
Finds smallest value
Adds values
Multiplies values
Which function is used to count non-empty cells?
COUNT
COUNTA
COUNTBLANK
SUM
What is a range?
One cell
A group of cells
A worksheet
A chart
Which feature allows you to organize data alphabetically?
Filter
Sort
Format
Merge
What does the IF function do?
Adds numbers
Tests a condition
Counts values
Formats cells
Which shortcut is used to copy?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + Z
Which shortcut is used to paste?
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + A
What does Ctrl + Z do?
Redo
Undo
Save
Print

QUIZ DONE!

0%
0
0
Answering 20 multiple-choice questions (MCQs) on Microsoft Excel can significantly improve learning by reinforcing key concepts through active recall and immediate practice. As learners work through questions on formulas, functions, data handling, and formatting, they strengthen their understanding and identify areas that need improvement. MCQs also encourage critical thinking, as students must analyze options carefully before selecting the correct answer. This repeated engagement helps build confidence, accuracy, and speed in using Excel, ultimately enhancing both theoretical knowledge and practical skills essential for real-world applications.
Powered by Blogger.