#### Microsoft Excel

1)

What does the "AutoSum" feature in Excel do?

##### Answer: B) It automatically calculates the sum of a selected range of cells
###### Explanation

The AutoSum feature in Excel is used to quickly calculate the sum of a selected range of cells without manually entering the SUM() function

2)

Which Excel function is used to find the position of a specific value within a range?

###### Explanation

The MATCH() function in Excel is used to find the position (or relative row or column number) of a specific value within a range

3)

In Excel, what does the "Fill Handle" refer to?

##### Answer: C) A tool for copying and filling data into adjacent cells
###### Explanation

The Fill Handle is a small square located at the lower-right corner of a selected cell or range, which can be used to copy and fill data into adjacent cells

4)

What is the purpose of the "Data Validation" feature in Excel?

##### Answer: B) To restrict the type of data that can be entered into a cell
###### Explanation

Data Validation in Excel allows you to define rules that restrict the type of data that can be entered into a cell, helping maintain data accuracy

5)

Which Excel function is used to count the number of cells that meet multiple criteria?

###### Explanation

The COUNTIFS() function is used to count the number of cells that meet multiple criteria in Excel

6)

In Excel, what does the formula "=SUM(A1:A5)" do?

##### Answer: C) It calculates the sum of values in the range A1:A5
###### Explanation

The SUM() function in Excel adds up all the values in the specified range

7)

Which Excel feature allows you to create a visual representation of your data using bars or columns to represent values?

###### Explanation

Sparklines are small, simple charts that can be inserted in individual cells to provide a visual representation of data trends.

8)

What is the purpose of the Excel function "VLOOKUP"?

##### Answer: B) To search for a value in a table and return a corresponding value from another column
###### Explanation

The VLOOKUP function in Excel is used to search for a specific value in a table and retrieve a corresponding value from another column.

9)

Which ribbon tab in Excel contains tools for changing the font, font size, and font color of cell contents?