MENU
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?
Answer: D) MATCH()
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?
Answer: C) COUNTIFS()
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?
Answer: B) Sparklines
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?
Answer: A) Home
Explanation
The "Home" ribbon tab in Excel contains tools for common formatting tasks, including changing the font, font size, and font color of cell contents.
10)
What is the purpose of the "Transpose" option in Excel?
Answer: B) It flips the orientation of a range of cells, switching rows to columns and vice versa
Explanation
The "Transpose" option in Excel allows you to switch the orientation of a range of cells, turning rows into columns and columns into rows.