Opening Hours : Monday to Saturday - 8 Am to 5 Pm
Partner Login
Home
About us
Courses
Apply For Admission
Our teachers
Contact
Verify Certificate
MS Excel Test
Home
MS Excel
1. File extension of an Excel workbook is?
A) .xlsx
B) .docx
C) .pptx
D) .txt
2. A cell is the intersection of?
A) A row and a column
B) Two rows
C) Two columns
D) None of these
3. Which formula/function adds numbers in a range?
A) =SUM()
B) =ADD()
C) =TOTAL()
D) =PLUS()
4. Which key moves the selection to the next cell?
A) Tab
B) Shift
C) Ctrl
D) Alt
5. Every formula in Excel must start with?
A) =
B) +
C) @
D) #
6. Worksheet Tabs (at the bottom) are used to?
A) Switch between sheets
B) Format text
C) Print the file
D) None of these
7. Which chart type is best for showing trends over time?
A) Line Chart
B) Pie Chart
C) Bar Chart
D) Scatter Chart
8. Which function calculates the average of a range?
A) =AVERAGE()
B) =AVG()
C) =MEAN()
D) =SUM()
Submit Test & Get Score