LearnUp - Online Course & Education HTML Template

Interview Questions

Q.1 What is the difference between Excel functions VLOOKUP and HLOOKUP?

VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row from another column. HLOOKUP works similarly, but searches in the first row.

Q.2 Explain the difference between absolute and relative cell references.

Relative references change when a formula is copied to another cell, while absolute references stay constant. You can create an absolute reference by adding dollar signs before the column and row identifiers (e.g., $A$1).

Q.3 What is the purpose of the IFERROR function?

IFERROR is used to handle errors in formulas. It returns a specified value if the formula results in an error and the result of the formula if it is not an error.

Q.4 How can you create a PivotTable in Excel?

Select the data range, go to the \"Insert\" tab, and click on \"PivotTable.\" Choose the location for the PivotTable and define the fields for rows, columns, values, and filters.

Q.5 Explain the use of the INDEX and MATCH functions.

INDEX returns the value of a cell in a specified row and column of a range. MATCH searches for a value in a range and returns its relative position.

Q.6 What is the purpose of the CONCATENATE function, and how is it different from CONCAT?

CONCATENATE combines multiple text strings into one. CONCAT is a newer function that also combines text but is more versatile and can handle ranges.

Q.7 How can you remove duplicates in Excel?

Select the range, go to the \\

Q.8 Explain the purpose of the VBA (Visual Basic for Applications) in Excel.

VBA allows users to automate tasks and create custom functions in Excel. It involves writing and running macros to perform repetitive actions.

Q.9 What is the difference between a workbook and a worksheet in Excel?

Q.10 What is the difference between a workbook and a worksheet in Excel?

Q.10 How can you protect cells or sheets in Excel?

Go to the \"Review\" tab, select \"Protect Sheet\" or \"Protect Workbook,\" and set a password. You can choose various options, such as allowing certain actions.

Q.11 Explain the purpose of the COUNTIF function.

Please Login to See Full Content

Q.12 How do you create a macro in Excel?

Please Login to See Full Content

Q.13 What is conditional formatting, and how can you apply it in Excel?

Please Login to See Full Content

Q.14 What is the purpose of the VLOOKUP function, and what are its limitations?

Please Login to See Full Content

Q.15 How can you transpose data in Excel?

Please Login to See Full Content

Q.16 Explain the use of the IF function.

Please Login to See Full Content

Q.17 How do you create a data validation drop-down list?

Please Login to See Full Content

Q.18 What is the purpose of the CHOOSE function?

Please Login to See Full Content

Q.19 How can you create a named range in Excel?

Please Login to See Full Content

Q.20 What is the difference between a relative cell reference and a mixed cell reference?

Please Login to See Full Content

Q.21 How do you create a line chart in Excel?

Please Login to See Full Content

Q.22 Explain the purpose of the PMT function.

Please Login to See Full Content

Q.23 Explain the purpose of the CONCATENATEX function in Power Pivot.

Please Login to See Full Content

Q.24 What is the purpose of the INDEX-MATCH-MATCH combination?

Please Login to See Full Content

Q.25 How can you create a drop-down list with data from another sheet?

Please Login to See Full Content

Q.26 Explain the purpose of the DATEDIF function.

Please Login to See Full Content

Q.27 How can you protect a worksheet but still allow certain cells to be edited?

Please Login to See Full Content

Q.28 What is the purpose of the INDIRECT function?

Please Login to See Full Content

Q.29 How can you split data into multiple columns in Excel?

Please Login to See Full Content

Q.30 Explain the purpose of the PIVOT function in Excel.

Please Login to See Full Content

Q.31 How do you enable iterative calculations in Excel, and why would you use them?

Please Login to See Full Content

Q.32 Explain the purpose of the RANK function.

Please Login to See Full Content

Q.33 How do you use the GETPIVOTDATA function?

Please Login to See Full Content

Q.34 What is the purpose of the XLOOKUP function, and how is it different from VLOOKUP?

Please Login to See Full Content

Q.35 How can you consolidate data from multiple sheets into one sheet?

Please Login to See Full Content

Q.36 Explain the purpose of the OFFSET function.

Please Login to See Full Content

Q.37 How can you remove blank rows in Excel?

Please Login to See Full Content

Q.38 What is the purpose of the NPV (Net Present Value) function?

Please Login to See Full Content

Q.39 Explain the purpose of the SUBTOTAL function.

Please Login to See Full Content

Q.40 How can you use the Data Model in Excel?

Please Login to See Full Content

Q.41 What is the purpose of the RAND and RANDBETWEEN functions?

Please Login to See Full Content

Q.42 Explain the purpose of the CUBE functions in Excel.

Please Login to See Full Content

Q.43 How can you protect a workbook with a password?

Please Login to See Full Content

Q.44 What is the purpose of the HYPERLINK function?

Please Login to See Full Content

Q.45 How do you create a named range with dynamic range reference using OFFSET?

Please Login to See Full Content

Q.46 Explain the purpose of the TEXTJOIN function.

Please Login to See Full Content

Q.47 How can you protect a workbook\'s structure and prevent users from adding or deleting sheets?

Please Login to See Full Content

Q.48 How do you create a 3D reference in Excel?

Please Login to See Full Content

Q.49 What is the purpose of the IFERROR function in Excel, and how can it be used?

Please Login to See Full Content

Q.50 How can you create a dynamic named range in Excel?

Please Login to See Full Content

Popular Interview Topics

Trending Courses

Advanced MS - Excel With MIS Reporting

₹999~~₹12500~~

Website Design Using WordPress

₹1499~~₹12500~~

Solid Works Training

₹499~~₹15000~~

Catia Training

₹499~~₹15000~~

Staad Pro Training

₹499~~₹15000~~