-
web.groovymark@gmail.com
- December 8, 2024
Question 01
What does the CONCAT function do in Excel?
A. Combines text from multiple cells into one
B. Adds numbers from multiple cells
C. Multiplies the values in two cells
D. Replaces text within a cell
Answer: A. Combines text from multiple cells into one
Explanation: The CONCAT function combines text from multiple cells into a single cell.
Question 02
What is the shortcut for saving a workbook in Excel?
A. Ctrl + S
B. Ctrl + P
C. Ctrl + T
D. Ctrl + C
Answer: A. Ctrl + S
Explanation: Ctrl + S is the standard shortcut for saving a workbook in Excel.
Question 03
Which of the following functions returns the current date in Excel?
A. TODAY()
B. DATE()
C. NOW()
D. TIME()
Answer: A. TODAY()
Explanation: The TODAY() function returns the current date without the time.
Question 04
How do you quickly switch to the next worksheet in Excel?
A. Press Ctrl + Tab
B. Press Ctrl + Page Down
C. Press Shift + Tab
D. Press Alt + N
Answer: B. Press Ctrl + Page Down
Explanation: Ctrl + Page Down switches between worksheets in Excel.
Question 05
Which chart type is best for showing parts of a whole?
A. Line Chart
B. Bar Chart
C. Pie Chart
D. Scatter Chart
Answer: C. Pie Chart
Explanation: A Pie Chart is used to display parts of a whole as slices of a circle.
Question 06
What does the MAX function do in Excel?
A. Returns the highest value in a range
B. Returns the average value in a range
C. Returns the lowest value in a range
D. Returns the sum of values in a range
Answer: A. Returns the highest value in a range
Explanation: The MAX function returns the largest value in a specified range of cells.
Question 07
What is the purpose of the Fill Handle in Excel?
It copies the content and formatting of a cell
B. It formats a range of cells automatically
C. It extends a series or copies content to adjacent cells
D. It deletes a selected range
Answer: C. It extends a series or copies content to adjacent cells
Explanation: The Fill Handle is used to quickly copy or fill a pattern in cells.
Question 08
Which of the following functions can you use to return the current day of the week in Excel?
A. WEEKDAY()
B. TODAY()
C. DAY()
D. DATE()
Answer: A. WEEKDAY()
Explanation: The WEEKDAY() function returns a number representing the day of the week for a date.
Question 09
What is the default file extension for Excel workbooks?
A. .xls
B. .xlsx
C. .csv
D. .txt
Answer: B. .xlsx
Explanation: The default file extension for Excel workbooks is .xlsx.
Question 10
How do you create a comment in an Excel cell?
A. Right-click the cell and choose “Insert Comment”
B. Use the “Insert” tab and select “Add Comment”
C. Use the Review tab and select “New Comment”
D. Press Ctrl + Shift + C
Answer: C. Use the Review tab and select “New Comment”
Explanation: Comments can be added to cells through the Review tab by selecting “New Comment.”
Question 11
What does the COUNTA function do in Excel?
A. Counts all the blank cells in a range
B. Counts all the non-blank cells in a range
C. Adds up the numerical values in a range
D. Counts the number of rows in a range
Answer: B. Counts all the non-blank cells in a range
Explanation: COUNTA counts all cells that are not empty, regardless of the type of data.
Question 12
What is a Sparkline in Excel?
A. A mini chart displayed inside a single cell
B. A feature to highlight data trends
C. A type of formula to calculate totals
D. A tool for drawing a line graph
Answer: A. A mini chart displayed inside a single cell
Explanation: Sparklines are small charts that fit into a single cell to show trends.
Question 13
Which of the following functions calculates the number of years between two dates in Excel?
A. YEARFRAC()
B. DATEDIF()
C. DAYS()
D. YEAR()
Answer: B. DATEDIF()
Explanation: DATEDIF can calculate the difference in years, months, or days between two dates.
Question 14
How do you merge two or more cells in Excel?
A. Use the Format Painter
B. Use the Merge & Center option on the Home tab
C. Press Ctrl + M
D. Right-click and select “Merge”
Answer: B. Use the Merge & Center option on the Home tab
Explanation: The Merge & Center feature merges multiple selected cells and centers the content.
Question 15
What is the shortcut to insert a new worksheet in Excel?
A. Ctrl + N
B. Shift + F11
C. Ctrl + W
D. Ctrl + Shift + N
Answer: B. Shift + F11
Explanation: Shift + F11 quickly inserts a new worksheet into the workbook.
Question 16
What does the ROUND function do in Excel?
A. Returns the largest integer less than or equal to a number
B. Returns the nearest integer
C. Rounds a number to a specified number of digits
D. Multiplies a value by 10
Answer: C. Rounds a number to a specified number of digits
Explanation: ROUND allows you to specify the number of digits to round a number.
Question 17
Which of the following error messages indicates a divide-by-zero error?
A. #DIV/0!
B. #VALUE!
C. #NAME?
D. #REF!
Answer: A. #DIV/0!
Explanation: #DIV/0! occurs when a formula attempts to divide by zero.
Question 18
How can you convert text to columns in Excel?
A. Use the “Text to Columns” feature in the Data tab
B. Use the Merge & Center tool
C. Use the Format Painter
D. Use the Review tab
Answer: A. Use the “Text to Columns” feature in the Data tab
Explanation: The Text to Columns feature splits text in one column into multiple columns based on a delimiter.
Question 19
What is the result of the formula =AVERAGE(10, 20, 30)?
A. 20
B. 15
C. 10
D. 30
Answer: A. 20
Explanation: The AVERAGE function calculates the mean value of the numbers provided, which is 20.
Question 20
What is the purpose of Freeze Panes in Excel?
A. To save a workbook
B. To lock certain rows or columns in place
C. To protect a worksheet from edits
D. To filter a dataset
Answer: B. To lock certain rows or columns in place
Explanation: Freeze Panes locks specified rows or columns so that they remain visible while scrolling through the worksheet.
