Introduction to MS Excel - Quiz

What is the primary function of Microsoft Excel?

• Word processing

• Spreadsheet calculations

• Graphic design

• Presentation design

Which feature in Excel is used to automatically sum a range of numbers?

• AutoSum

• AutoCalculate

• AutoTotal

• AutoAdd

What does the function VLOOKUP do in Excel?

• Vertical lookup for text

• Vertical lookup for values

• Verify lookup data

• Validate lookup results

What is the keyboard shortcut for copying cell contents in Excel?

• Ctrl+C

• Ctrl+X

• Ctrl+V

• Ctrl+Z

1. Which function is used to count the number of cells that contain numbers in a range?

• SUM

• 1. COUNT

• 1. AVERAGE

• 1. MAX

In Excel, what does the formula =$A$1 represent?

• A relative cell reference

• A circular reference

• A mixed cell reference

• An absolute cell reference

Which chart type in Excel is best suited for showing the relationship between two variables?

• Line chart

• Pie chart

• Scatter plot

• Bar chart

What does the "IF" function do in Excel?

• Sorts data in ascending order

• Converts text to uppercase

• Multiplies two numbers together

• Returns a specified value if a condition is met

How can you filter data in Excel to only display rows that meet specific criteria?

• By using the SORT function

• By using the FILTER function

• By using the SEARCH function

• By using the HIDE function

Which tab in the Excel ribbon is used for inserting and editing charts?

• Home

• Formulas

• Insert

• Data