-
web.groovymark@gmail.com
- December 8, 2024
Question 41
What does the RANK function do in Excel?
A. Sorts values in ascending order
B. Calculates the position of a number in a list
C. Returns the median of a range
D. Adds all numbers in a list
Answer: B. Calculates the position of a number in a list
Explanation: The RANK function returns the rank of a number within a list of numbers.
Question 42
How do you toggle between displaying formulas and values in Excel?
A. Press Ctrl + ` (grave accent)
B. Press Ctrl + Shift + F
C. Press Alt + F9
D. Press Ctrl + Alt + F
Answer: A. Press Ctrl + ` (grave accent)
Explanation: Pressing Ctrl + ` toggles between displaying formulas and the resulting values in the worksheet.
Question 43
What is the purpose of Data Validation in Excel?
A. To filter data based on criteria
B. To restrict the type of data that can be entered in a cell
C. To format data based on conditions
D. To hide rows that do not meet certain criteria
Answer: B. To restrict the type of data that can be entered in a cell
Explanation: Data Validation ensures that only specific types or ranges of data can be entered into a cell
Question 44
Which Excel function would you use to count cells that meet a specific condition?
A. COUNT
B. COUNTIF
C. COUNTA
D. SUM
Answer: B. COUNTIF
Explanation: COUNTIF counts the number of cells in a range that meet a given condition.
Question 45
What is the purpose of conditional formatting in Excel?
A. To apply consistent formatting across all cells
B. To highlight cells that meet specific criteria
C. To automatically adjust column widths
D. To convert data into a chart
Answer: B. To highlight cells that meet specific criteria
Explanation: Conditional formatting applies formatting to cells based on the conditions you set.
Question 46
How do you remove duplicates in a dataset in Excel?
A. Use the “Remove Duplicates” feature in the Data tab
B. Press Ctrl + Shift + D
C. Use the Filter feature in the Data tab
D. Right-click and select “Delete Duplicates”
Answer: A. Use the “Remove Duplicates” feature in the Data tab
Explanation: The Remove Duplicates tool helps remove duplicate values in a dataset.
Question 47
How do you insert a column chart in Excel?
A. Use the Insert tab and select “Column Chart”
B. Press Ctrl + Shift + C
C. Use the Home tab and select “Insert Chart”
D. Right-click the worksheet and choose “Insert Column Chart”
Answer: A. Use the Insert tab and select “Column Chart”
Explanation: The Insert tab provides options to create various charts, including a column chart.
Question 48
What is the shortcut for selecting an entire row in Excel?
A. Shift + Space
B. Ctrl + Space
C. Alt + Space
D. Ctrl + Shift + Space
Answer: B. Ctrl + Space
Explanation: Pressing Ctrl + Space selects the entire row of the active cell.
Question 49
Which of the following is a use of the SUMIF function?
A. To sum numbers based on a condition
B. To count cells that contain a specific value
C. To multiply values based on a condition
D. To return the largest value in a range
Answer: A. To sum numbers based on a condition
Explanation: SUMIF adds the values in a range that meet a specified condition.
Question 50
What is the default alignment for text in Excel?
A. Center
B. Right
C. Left
D. Justified
Answer: C. Left
Explanation: By default, Excel aligns text to the left side of the cell.
