Q61. Which of the following actions will delete the content of a cell but keep the cell itself?
a) Right-click the cell and select “Delete”
b) Press the “Delete” key
c) Press the “Backspace” key
d) Use the “Clear” option in the “Edit” menu
Show Answer
Correct Answer: b) Press the “Delete” key
Explanation: Pressing the “Delete” key removes the content of the selected cell but retains the cell itself within the worksheet.
Q62. How can you insert a new column in Excel?
a) Right-click on a column header and choose “Insert”
b) Use the “Insert Column” button in the Home tab
c) Press Ctrl + Shift + “+”
d) Use the “Insert” option from the “Data” menu
Show Answer
Correct Answer: a) Right-click on a column header and choose “Insert”
Explanation: Right-clicking a column header and selecting “Insert” adds a new column to the left of the selected column.
Q63. What does the “F4” key do when editing a formula in Excel?
a) Repeats the last action
b) Toggles the formula between relative and absolute references
c) Opens the “Find” dialog
d) Adds a new worksheet
Show Answer
Correct Answer: b) Toggles the formula between relative and absolute references
Explanation: Pressing “F4” in a formula toggles between relative, absolute, and mixed cell references, helping users manage formula references efficiently.
Q64. How can you quickly apply a border to a selected cell or range of cells?
a) Use the “Borders” button in the Home tab
b) Right-click and choose “Add Border”
c) Use the “Format Cells” dialog and select “Borders”
d) Both a and c
Show Answer
Correct Answer: d) Both a and c
Explanation: Borders can be applied quickly using the “Borders” button in the Home tab or through the “Format Cells” dialog under the “Borders” tab.
Q65. What is the purpose of the “Flash Fill” feature in Excel?
a) Automatically fills in values based on patterns detected in adjacent cells
b) Highlights cells with missing data
c) Quickly applies a formatting style to a range
d) Adds comments to selected cells
Show Answer
Correct Answer: a) Automatically fills in values based on patterns detected in adjacent cells
Explanation: “Flash Fill” detects patterns in data entry and automatically completes the remaining values in a column, simplifying data entry tasks.
Q66. How can you format a cell to display a date in the format “DD-MM-YYYY”?
a) Use the “Custom” date format in the “Format Cells” dialog
b) Use the “Date” format option from the Home tab
c) Enter the date manually in the desired format
d) Apply a predefined date format from the “Number” tab
Show Answer
Correct Answer: a) Use the “Custom” date format in the “Format Cells” dialog
Explanation: The “Custom” date format in the “Format Cells” dialog allows users to specify the exact date format, such as “DD-MM-YYYY.”
Q67. What does the “SUMPRODUCT” function do?
a) Multiplies corresponding elements in given ranges and returns the sum of those products
b) Adds up values in a range and returns the total
c) Calculates the product of a range of numbers
d) Counts the number of products in a range
Show Answer
Correct Answer: a) Multiplies corresponding elements in given ranges and returns the sum of those products
Explanation: The SUMPRODUCT function multiplies corresponding elements in specified ranges and then sums the results, useful for weighted calculations.
Q68. What is the “HLOOKUP” function used for in Excel?
a) To search for a value in the first row of a range and return a value in the same column from a specified row
b) To search for a value in the first column of a range and return a value in the same row from a specified column
c) To find the highest value in a range
d) To count cells that contain text
Show Answer
Correct Answer: a) To search for a value in the first row of a range and return a value in the same column from a specified row
Explanation: The HLOOKUP function searches for a value in the first row of a range and returns a value from a specified row within the same column.
Q69. How can you quickly sum a range of numbers in Excel?
a) Use the AutoSum button in the Home tab
b) Enter the SUM() function manually
c) Use the “Total” button in the Status Bar
d) Right-click and select “Sum”
Show Answer
Correct Answer: a) Use the AutoSum button in the Home tab
Explanation: The AutoSum button automatically inserts a SUM() formula to total a selected range of numbers, simplifying the summation process.
Q70. Which of the following functions would you use to calculate the average of a range of cells?
a) AVERAGE()
b) MEDIAN()
c) MODE()
d) SUM()
Show Answer
Correct Answer: a) AVERAGE()
Explanation: The AVERAGE() function calculates the mean of a range of cells by summing the values and dividing by the number of cells.