-
web.groovymark@gmail.com
- December 8, 2024
Question 41
How do you insert a new worksheet in Excel?
A. Press Shift + F11
B. Press Ctrl + N
C. Press Alt + W
D. Press Ctrl + Shift + N
Answer: A. Press Shift + F11
Explanation: Pressing Shift + F11 inserts a new worksheet into the workbook.
Question 42
What does pressing Ctrl + A do in Excel?
A. Selects the entire worksheet
B. Opens the “Save As” dialog box
C. Copies the current cell
D. Highlights the active row
Answer: A. Selects the entire worksheet
Explanation: Ctrl + A selects all the cells in the current worksheet.
Question 43
What does the COUNTA function do in Excel?
A. Counts non-empty cells
B. Counts cells with numbers only
C. Adds up all numbers in a range
D. Subtracts values in a range
Answer: A. Counts non-empty cells
Explanation: COUNTA counts the number of cells that are not empty.
Question 44
How do you apply borders to a selected range of cells in Excel?
A. Use the Home tab and select “Borders”
B. Use the Insert tab and select “Borders”
C. Right-click and select “Apply Borders”
D. Press Ctrl + B
Answer: A. Use the Home tab and select “Borders”
Explanation: The Borders option in the Home tab lets you add borders to the selected range of cells.
Question 45
Which of the following tools is used to track changes made to a workbook?
A. Track Changes
B. Version History
C. Watch Window
D. PivotTable
Answer: A. Track Changes
Explanation: Track Changes records the changes made in a shared workbook.
Question 46
What is the shortcut for selecting the entire column in Excel?
A. Ctrl + Space
B. Shift + Space
C. Ctrl + Shift + C
D. Alt + Space
Answer: A. Ctrl + Space
Explanation: Ctrl + Space selects the entire column of the active cell.
Question 47
Which of the following is the purpose of the CHOOSE function in Excel?
A. Selects a value from a list based on an index number
B. Sorts data in a specific order
C. Finds and replaces text
D. Selects multiple cells at once
Answer: A. Selects a value from a list based on an index number
Explanation: The CHOOSE function returns a value from a list of values based on an index number.
Question 48
What does the CLEAN function do in Excel?
A. Removes all non-printable characters from text
B. Cleans up formatting in a cell
C. Removes duplicates from a range
D. Clears cell contents
Answer: A. Removes all non-printable characters from text
Explanation: CLEAN removes non-printable characters from a text string.
Question 49
How do you delete multiple worksheets at once in Excel?
A. Hold down Ctrl, select the sheets, right-click, and choose Delete
B. Press Shift + Del
C. Press Ctrl + D
D. Use the View tab and select “Delete Sheets”
Answer: A. Hold down Ctrl, select the sheets, right-click, and choose Delete
Explanation: You can delete multiple worksheets by selecting them while holding Ctrl, right-clicking, and selecting Delete.
Question 50
What does the LARGE function do in Excel?
A. Returns the k-th largest value in a data set
B. Returns the maximum value in a range
C. Calculates the sum of all numbers in a range
D. Multiplies the largest values in a range
Answer: A. Returns the k-th largest value in a data set
Explanation: LARGE returns the k-th largest value from a data set based on the specified position.
