Practice Questions For

ANS : (b) VLOOKUP is used to search for a value in the first column of a table and return data from another column in the same row.

ANS : (d) Excel provides multiple functions like CONCATENATE (older versions), TEXTJOIN (for adding delimiters), and CONCAT (modern alternative to CONCATENATE).

ANS : (b) IFERROR(value, value_if_error) helps handle errors by replacing them with a user-defined value.

ANS : (b) .xlsx is the default file format for Excel workbooks without macros.

ANS : (a) COUNT(range) counts only numerical values, whereas COUNTA counts all non-empty cells.

ANS : (b) Pivot Tables allow users to quickly organize, summarize, and analyze large amounts of data.

ANS : (b) TODAY() returns the current system date, while NOW() returns both the date and time.

ANS : (b) This shortcut opens the Format Cells dialog for advanced formatting options.

ANS : (a) The YEAR() function extracts the year from a given date.

ANS : (a) HLOOKUP searches for a value in the first row of a table and returns a value from a specified row.

ANS : (b) Conditional formatting changes cell formatting (color, font, etc.) based on predefined conditions.

ANS : (a) MAX(range) returns the highest numerical value in a given range.

ANS : (b) INDEX(array, row_num, col_num) fetches a value from a specified row and column.

ANS : (c) $A$1 creates an absolute reference that does not change when copied.

ANS : (b) AVERAGE(range) calculates the mean (average) of numeric values.

ANS : (a) This shortcut quickly inserts a new worksheet into the workbook.

ANS : (a) TEXT(value, format_text) converts numbers into formatted text representations.

ANS : (d) Excel provides multiple ways to prevent duplicates, including UNIQUE, Data Validation, and Conditional Formatting.

ANS : (b) MOD(number, divisor) returns the remainder of a division operation.

ANS : (b) Power Query is an ETL (Extract, Transform, Load) tool used to clean and manipulate data.

ANS : (b) AVERAGE function calculates the mean of a given range of numbers.

ANS : (a) CONCATENATE function is used to join two or more text strings into one.

ANS : (b) Ctrl + Shift + N is the shortcut for inserting a new worksheet in Excel.

ANS : (b) Double-clicking the fill handle will automatically fill the entire column with the formula.

ANS : (b) VLOOKUP searches for a value in the first column and returns a value in the same row from another column.

ANS : (a) IF function checks whether a condition is true or false and returns a specified result based on that.

ANS : (a) Remove Duplicates feature allows you to easily remove duplicate entries from your dataset.

ANS : (a) =SUM(A1:A10) is the correct formula to sum a range of cells in Excel.

ANS : (a) You can protect a worksheet by setting a password under the Review tab.

ANS : (a) F4 key repeats the last action you performed in Excel.

ANS : (a) Relative references change when copied, absolute references stay fixed, and mixed references partially change based on the reference type.

ANS : (c) COUNT function counts the number of cells that contain numbers in a range.

ANS : (a) You can create a pivot table by selecting your data and using the Insert tab to choose Pivot Table.

ANS : (b) HLOOKUP function searches for a value in the first row of a table and returns a value in the same column from another row.

ANS : (a) You can lock the cell and then protect the worksheet to prevent it from being edited.

ANS : (a) To create a chart in Excel, select your data and use the Insert tab to choose a chart type.

ANS : (a) Conditional formatting is used to apply formatting to cells based on specific conditions or criteria.

ANS : (a) The MAX function is used to find the largest number in a range of cells.

ANS : (a) COUNT counts only cells with numbers, while COUNTA counts all non-empty cells, including text.

ANS : (a) You can remove duplicates from a column using the Remove Duplicates tool in the Data tab.

ANS : (a) The AVERAGE function returns the average (arithmetic mean) of a range of numbers.

ANS : (a) You can highlight cells with specific text by using Conditional Formatting.

ANS : (a) The VLOOKUP function searches for a value in the first column and returns a value from the same row in another column.

ANS : (a) You can add a new worksheet by clicking the "+" icon next to the existing worksheets at the bottom.

ANS : (a) The CONCATENATE function is used to join two or more text strings into one.

ANS : (a) The SUMIF function adds values based on a specified condition.

ANS : (c) You can insert the current date in a cell by pressing Ctrl + ; (semicolon).

ANS : (a) The IF function is used to make logical comparisons and return values based on specified conditions.

ANS : (a) You can protect a worksheet by using the "Protect Sheet" option in the Review tab.

ANS : (a) You can filter data by using the Filter button in the Data tab.

Submit