Top 5 Excel Data Analytics Interview Question & Answers
1. What is Excel and what are its primary uses?
Excel is a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Its primary uses include creating spreadsheets, performing calculations, and making charts.
2. How do you open a new workbook in Excel?
To open a new workbook in Excel, you can either click on “File” in the menu, then select “New” and “Blank Workbook,” or you can press “Ctrl + N” on your keyboard.
3. Explain the difference between a workbook and a worksheet.
A workbook is like a file that contains all your data and is made up of one or more worksheets. Worksheets are the individual pages within a workbook where you enter and manipulate data.
4. How do you navigate between different worksheets in Excel?
To move between different worksheets in Excel, you can click on the tabs at the bottom of the Excel window. Each tab represents a different worksheet.
5. How do you apply a formula to an entire column in Excel?
To apply a formula to an entire column, write the formula in the first cell, then drag the fill handle (small square at the bottom-right corner) down to the last cell. Alternatively, double-click the fill handle to autofill the column.
