MS Excel Interview Questions and Topic Discussions

What is data validation in MS Excel?

Seema Arora, 2 years ago

300

1

What is Scenario Manager in MS Excel?

Seema Arora, 2 years ago

484

1

What is a Solver in MS Excel?

Seema Arora, 2 years ago

293

0

No replies

What is Goal Seek in MS Excel?

Seema Arora, 2 years ago

345

0

No replies

What is a two-variable data table in MS Excel?

Seema Arora, 2 years ago

265

0

No replies

What is a one-variable data table in MS Excel?

Seema Arora, 2 years ago

462

0

No replies

Can we sort multiple columns at one time in MS Excel?

Seema Arora, 2 years ago

288

0

No replies

What is an advanced Filter in MS Excel?

Seema Arora, 2 years ago

408

0

No replies

How can you remove duplicates from a data set in MS Excel?

Seema Arora, 2 years ago

204

0

No replies

How can you select all blank cells in MS Excel?

Seema Arora, 2 years ago

268

0

No replies

How can you transpose a data set in MS Excel?

Seema Arora, 2 years ago

266

0

No replies

How can you sort data in MS Excel?

Seema Arora, 2 years ago

345

0

No replies

What kind of data filters are available in MS Excel?

Seema Arora, 2 years ago

184

0

No replies

How to replace one value with another in MS Excel?

Seema Arora, 2 years ago

294

0

No replies

What is a Bullet chart? When should we use it in MS Excel?

Seema Arora, 2 years ago

486

0

No replies

What is a secondary axes in a chart in MS Excel?

Seema Arora, 2 years ago

274

0

No replies

What are Combination charts in MS Excel?

Seema Arora, 2 years ago

242

0

No replies

What is a Waterfall chart? When would you use it?

Seema Arora, 2 years ago

426

0

No replies

Are Pie charts good? Should it used in reports/dashboard?

Seema Arora, 2 years ago

440

0

No replies

What is a Scatter chart in MS Excel?

Seema Arora, 2 years ago

259

0

No replies

What is a Line chart in MS Excel?

Seema Arora, 2 years ago

286

0

No replies

What is a Bar chart in MS Excel?

Seema Arora, 2 years ago

267

0

No replies

What is a Column chart in MS Excel?

Students Community, 2 years ago

399

0

No replies

What are Calculated Fields in Pivot Table?

Students Community, 2 years ago

286

0

No replies

Can I make a Pivot Table from multiple tables?

Students Community, 2 years ago

216

0

No replies

What is a Pivot Cache in MS Excel?

Students Community, 2 years ago

369

0

No replies

Can you group dates in Pivot Tables in MS Excel?

Students Community, 2 years ago

184

0

No replies

How can you refresh a Pivot Table?

Students Community, 2 years ago

335

0

No replies

What are the difference between Pivot Charts Vs Regular Charts?

Students Community, 2 years ago

375

0

No replies

What is a Pivot Chart in MS Excel?

Students Community, 2 years ago

315

0

No replies

What are slicers in MS Excel?

Students Community, 2 years ago

266

0

No replies

What are the various sections in a Pivot Table?

Students Community, 2 years ago

199

0

No replies

What is a Pivot Table, and when would you use one?

Students Community, 2 years ago

241

0

No replies

What’s the shortcut to insert a comment in Excel?

Students Community, 2 years ago

268

0

No replies

How would you insert a new line in the same cell in MS Excel?

Students Community, 2 years ago

344

0

No replies

How can you select all the cells in the worksheet?

Students Community, 2 years ago

201

0

No replies

What is the shortcut to open a new Excel workbook?

Students Community, 2 years ago

200

0

No replies

What is the shortcut to quickly auto-sum rows/columns?

Students Community, 2 years ago

382

0

No replies

What is the shortcut for spell check?

Students Community, 2 years ago

340

0

No replies

What is the shortcut for opening the find and replace dialog box in MS Excel?

Students Community, 2 years ago

332

0

No replies

What are the most useful keyboard shortcuts you use in MS Excel?

Students Community, 2 years ago

234

0

No replies

What are volatile functions? Can you name a few?

Students Community, 2 years ago

333

0

No replies

When would you use the SUBTOTAL function in MS Excel?

Students Community, 2 years ago

522

0

No replies

What are the known limitations of the VLOOKUP function?

Students Community, 2 years ago

231

0

No replies

How would you get rid of leading / trailing / double spaces in a text in Excel?

Students Community, 2 years ago

420

0

No replies

What is the syntax of the VLOOKUP function?

Students Community, 2 years ago

384

0

No replies

What formula would you use to find the length of a text string in a cell in MS Excel?

Students Community, 2 years ago

453

0

No replies

How can you combine the text from multiple cells using a formula in MS Excel?

Students Community, 2 years ago

299

0

No replies

Which function would you use to get the current date and time in Excel?

Students Community, 2 years ago

296

0

No replies

How can you tackle errors when working with Excel Formulas?

Students Community, 2 years ago

221

0

No replies