51. Which of the following formulas is used to find the absolute value of a number in Excel?
a) =ABS()
b) =VALUE()
c) =ABSOLUTE()
d) =MOD()
Answer: a
52. How do you insert the current date in a cell in Excel?
a) Press Ctrl + Shift + D
b) Type =DATE()
c) Type =TODAY()
d) Type =CURRENTDATE()
Answer: c
53. What is the default alignment for text in Excel?
a) Left
b) Right
c) Center
d) Justify
Answer: a
54. Which of the following options is used to hide a row in Excel?
a) Right-click the row and select "Hide"
b) Press Ctrl + Shift + H
c) Go to Data tab and select "Hide Row"
d) Press Ctrl + R
Answer: a
55. Which function is used to count the number of cells containing numbers in a range?
a) =COUNT()
b) =COUNTA()
c) =COUNTIF()
d) =COUNTBLANK()
Answer: a
56. How do you change the cell format to currency in Excel?
a) Right-click the cell and choose "Format Cells" > "Currency"
b) Go to the Home tab and click on the "Currency" button
c) Press Ctrl + Shift + C
d) Both a and b
Answer: d
57. What is the purpose of the "PMT" function in Excel?
a) Calculates loan payments based on constant payments and interest rates
b) Calculates the principal of a loan
c) Calculates interest rates
d) Computes the total loan amount
Answer: a
58. How do you select an entire column in Excel?
a) Click on the column header
b) Press Ctrl + A
c) Press Shift + Spacebar
d) Right-click a cell in the column and select "Select Column"
Answer: a
59. Which of the following is used to show data in the form of bars or columns in Excel?
a) Pivot Table
b) Conditional Formatting
c) Bar Chart or Column Chart
d) Data Validation
Answer: c
60. What does the "Find and Replace" feature in Excel allow you to do?
a) Find specific data and replace it with something else
b) Find all cells with formulas
c) Find and remove duplicate values
d) Find and highlight empty cells
Answer: a
61. Which function is used to combine two or more cells into one in Excel?
a) =MERGE()
b) =COMBINE()
c) =CONCATENATE()
d) =JOIN()
Answer: c
62. How do you insert a comment in a cell in Excel?
a) Right-click the cell and select "Insert Comment"
b) Use the "Insert" tab and select "Comment"
c) Press Ctrl + Shift + C
d) Both a and b
Answer: d
63. Which of the following Excel functions calculates the monthly payment for a loan?
a) =PMT()
b) =MORTGAGE()
c) =LOAN()
d) =INTEREST()
Answer: a
64. What does the "AutoSum" button do in Excel?
a) Adds the sum of a selected range of cells
b) Automatically sorts the data in ascending order
c) Automatically formats the selected range
d) Automatically fills the selected range with data
Answer: a
65. Which Excel feature allows you to enter repetitive data quickly by dragging the fill handle?
a) AutoFill
b) Flash Fill
c) Fill Series
d) Fill Down
Answer: a
66. How can you protect your workbook from being opened by others in Excel?
a) Go to File > Protect Workbook
b) Go to File > Save As > Tools > General Options
c) Press Ctrl + S and choose password protection
d) Right-click the workbook and select "Encrypt"
Answer: b
67. Which of the following is used to sort data in Excel?
a) Conditional Formatting
b) Data Validation
c) Data Sorting
d) Filter
Answer: c
68. What does the "Freeze Panes" option do in Excel?
a) It keeps a row or column visible while scrolling through the worksheet
b) It prevents cells from being edited
c) It prevents the workbook from being opened
d) It locks the worksheet from changes
Answer: a
69. What is the correct syntax for a basic "IF" function in Excel?
a) =IF(logical_test, value_if_true, value_if_false)
b) =IF(value_if_true, logical_test, value_if_false)
c) =IF(value_if_false, logical_test, value_if_true)
d) =IF(logical_test, value_if_false, value_if_true)
Answer: a
70. What is the purpose of the "Data Validation" feature in Excel?
a) To restrict the type of data that can be entered into a cell
b) To automatically calculate totals
c) To create a chart from data
d) To automatically find errors in data
Answer: a
71. Which of the following is used to insert a hyperlink in Excel?
a) Right-click the cell and select "Insert Hyperlink"
b) Press Ctrl + K
c) Use the "Insert" tab and select "Hyperlink"
d) All of the above
Answer: d
72. How can you remove a filter from a column in Excel?
a) Click on the "Clear" button in the Data tab
b) Right-click the column and select "Remove Filter"
c) Go to the View tab and uncheck "Filter"
d) Both a and b
Answer: d
73. What is the maximum number of sheets you can have in an Excel workbook?
a) 256
b) 1,048,576
c) 100
d) No limit, based on system memory
Answer: d
74. Which of the following is used to highlight cells that meet specific criteria?
a) Conditional Formatting
b) Cell Styles
c) Data Validation
d) Filters
Answer: a
75. How do you adjust the height of a row in Excel?
a) Right-click the row number and select "Row Height"
b) Drag the row boundary
c) Use the Format option in the Home tab
d) All of the above
Answer: d
