79. Which of the following functions in Excel returns the number of characters in a cell?
a) =CHAR()
b) =LENGTH()
c) =LEN()
d) =COUNT()
Answer: c
80. How do you add a cell border in Excel?
a) Use the "Borders" button in the Home tab
b) Press Ctrl + B
c) Right-click and select "Add Border"
d) Both a and c
Answer: d
81. What does the "AND" function do in Excel?
a) Returns TRUE if both conditions are met
b) Returns TRUE if one condition is met
c) Returns FALSE if any condition is met
d) Joins multiple text strings
Answer: a
82. Which Excel feature is used to remove duplicate values from a range?
a) Data Validation
b) Remove Duplicates
c) Conditional Formatting
d) Filter
Answer: b
83. How can you adjust the width of a column to fit the longest entry in Excel?
a) Double-click the right edge of the column header
b) Right-click the column header and select "AutoFit"
c) Press Ctrl + Shift + W
d) Both a and b
Answer: d
84. How do you apply a conditional format to highlight cells greater than a certain value in Excel?
a) Use "Find & Select" > "Go To Special"
b) Use "Conditional Formatting" > "Highlight Cells Rules"
c) Right-click and select "Highlight Cells"
d) Use the "Data Validation" feature
Answer: b
85. What function would you use to calculate the number of characters in a string that are digits?
a) =LEN()
b) =COUNT()
c) =ISNUMBER()
d) =TEXT()
Answer: c
86. Which function in Excel is used to find the remainder when one number is divided by another?
a) =MOD()
b) =QUOTIENT()
c) =DIVIDE()
d) =REMAINDER()
Answer: a
87. How can you switch between open Excel workbooks?
a) Press Ctrl + Tab
b) Press Alt + Tab
c) Press Ctrl + F6
d) Both a and c
Answer: d
88. What is the purpose of the "SUBTOTAL" function in Excel?
a) Calculates a total, excluding hidden values
b) Finds the average of a range of values
c) Calculates a total, including hidden values
d) Returns a percentage of a value
Answer: a
89. What is the result of the formula =2+3*4 in Excel?
a) 14
b) 20
c) 12
d) 24
Answer: a
90. How can you move a chart to a new worksheet in Excel?
a) Right-click the chart and select "Move to New Sheet"
b) Click the chart and go to the Insert tab
c) Press Ctrl + Shift + M
d) Both a and b
Answer: a
91. What does the "OR" function do in Excel?
a) Returns TRUE if at least one of the conditions is met
b) Returns TRUE if both conditions are met
c) Joins multiple text strings together
d) Returns FALSE if either condition is met
Answer: a
92. How can you change the format of numbers to show as percentages in Excel?
a) Right-click and select "Format Cells" > "Percentage"
b) Use the "Percentage" button in the Home tab
c) Type a percentage sign after the number
d) All of the above
Answer: d
93. What is the purpose of the "Text to Columns" feature in Excel?
a) To split a single column into multiple columns
b) To merge multiple columns into one
c) To adjust column width automatically
d) To sort data in columns
Answer: a
94. How can you apply a filter to a data range in Excel?
a) Go to the Data tab and select "Filter"
b) Right-click the data range and select "Apply Filter"
c) Press Ctrl + Shift + F
d) All of the above
Answer: a
95. Which of the following is the correct formula to calculate the average of numbers in Excel?
a) =AVERAGE()
b) =SUM()
c) =COUNT()
d) =TOTAL()
Answer: a
96. How can you hide a worksheet in Excel?
a) Right-click the sheet tab and select "Hide"
b) Press Ctrl + Shift + H
c) Go to the View tab and select "Hide Sheet"
d) Both a and c
Answer: d
97. What is the purpose of the "Freeze Panes" option in Excel?
a) To keep specific rows or columns visible while scrolling
b) To lock specific cells for editing
c) To hide rows or columns
d) To protect the entire worksheet
Answer: a
98. Which formula will return the lowest value from a range of cells in Excel?
a) =MAX()
b) =LOWEST()
c) =MIN()
d) =AVERAGE()
Answer: c
99. How can you remove a hyperlink from a cell in Excel?
a) Right-click the cell and select "Remove Hyperlink"
b) Use the "Clear Hyperlink" option from the Insert tab
c) Press Ctrl + Shift + H
d) All of the above
Answer: a
100. How can you prevent a cell reference from changing when you copy a formula in Excel?
a) Use relative references
b) Use absolute references by adding "$" before the row and column (e.g., $A$1)
c) Use a mix of absolute and relative references
d) Use the "Protect" feature in the Review tab
Answer: b
