MS EXCEL MCQ PART 1

1. What is the shortcut key to insert a new worksheet in an Excel workbook?

A) Ctrl + N
B) Shift + F11
C) Ctrl + W
D) Alt + Shift

2. Which symbol is used to start a formula in Excel?

A) =
B) +
C) (
D) /

3. What function is used to calculate the average of a range of values?

A) =SUM()
B) =AVERAGE()
C) =COUNT()
D) =MEDIAN()

4. Which feature in Excel allows data to be sorted in ascending or descending order?

A) Filter
B) Sort
C) Format
D) Review

5. What is the intersection of a row and a column in Excel called?

A) Cell
B) Gridline
C) Table
D) Box

6. In which tab can you find the “Conditional Formatting” option in Excel?

A) Insert
B) View
C) Data
D) Home

7. What is the default file extension of an Excel workbook in newer versions (2013 and later)?

A) .xls
B) .xlsx
C) .txt
D) .csv

8. Which function is used to find the largest value in a dataset?

A) =MIN()
B) =MAX()
C) =LARGEST()
D) =HIGHEST()

9. What is the name of the feature that allows you to combine data from multiple sheets into one?

A) PivotTable
B) Consolidate
C) Filter
D) Sort

10. Which type of chart is best for showing proportions of a whole?

A) Line Chart
B) Column Chart
C) Pie Chart
D) Scatter Chart