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()

9. Shortcut key to open a new workbook?

A) Ctrl+N

B) Ctrl+O

C) Ctrl+S

D) Ctrl+P

10. AutoFill is used to?

A) Copy a pattern/series into adjacent cells

B) Delete data

C) Sort data

D) None of these

11. Which feature removes duplicate values from data?

A) Remove Duplicates

B) Sort

C) Filter

D) Freeze Panes

12. Freeze Panes is used to?

A) Keep rows/columns visible while scrolling

B) Delete rows

C) Add color

D) None of these

MS Excel Test

1. File extension of an Excel workbook is?

2. A cell is the intersection of?

3. Which formula/function adds numbers in a range?

4. Which key moves the selection to the next cell?

5. Every formula in Excel must start with?

6. Worksheet Tabs (at the bottom) are used to?

7. Which chart type is best for showing trends over time?

8. Which function calculates the average of a range?

9. Shortcut key to open a new workbook?

10. AutoFill is used to?

11. Which feature removes duplicate values from data?

12. Freeze Panes is used to?

Sitemap

Support

Contact Us