MS Excel Interview Questions and Topic Discussions

What is data validation in MS Excel?

Seema Arora, 2 years ago

312

1

What is Scenario Manager in MS Excel?

Seema Arora, 2 years ago

501

1

What is a Solver in MS Excel?

Seema Arora, 2 years ago

309

0

No replies

What is Goal Seek in MS Excel?

Seema Arora, 2 years ago

360

0

No replies

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

Seema Arora, 2 years ago

281

0

No replies

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

Seema Arora, 2 years ago

478

0

No replies

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

Seema Arora, 2 years ago

295

0

No replies

What is an advanced Filter in MS Excel?

Seema Arora, 2 years ago

414

0

No replies

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

Seema Arora, 2 years ago

214

0

No replies

How can you select all blank cells in MS Excel?

Seema Arora, 2 years ago

282

0

No replies

How can you transpose a data set in MS Excel?

Seema Arora, 2 years ago

276

0

No replies

How can you sort data in MS Excel?

Seema Arora, 2 years ago

357

0

No replies

What kind of data filters are available in MS Excel?

Seema Arora, 2 years ago

189

0

No replies

How to replace one value with another in MS Excel?

Seema Arora, 2 years ago

298

0

No replies

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

Seema Arora, 2 years ago

494

0

No replies

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

Seema Arora, 2 years ago

291

0

No replies

What are Combination charts in MS Excel?

Seema Arora, 2 years ago

254

0

No replies

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

Seema Arora, 2 years ago

437

0

No replies

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

Seema Arora, 2 years ago

454

0

No replies

What is a Scatter chart in MS Excel?

Seema Arora, 2 years ago

270

0

No replies

What is a Line chart in MS Excel?

Seema Arora, 2 years ago

301

0

No replies

What is a Bar chart in MS Excel?

Seema Arora, 2 years ago

279

0

No replies

What is a Column chart in MS Excel?

Students Community, 2 years ago

416

0

No replies

What are Calculated Fields in Pivot Table?

Students Community, 2 years ago

289

0

No replies

Can I make a Pivot Table from multiple tables?

Students Community, 2 years ago

224

0

No replies

What is a Pivot Cache in MS Excel?

Students Community, 2 years ago

387

0

No replies

Can you group dates in Pivot Tables in MS Excel?

Students Community, 2 years ago

187

0

No replies

How can you refresh a Pivot Table?

Students Community, 2 years ago

350

0

No replies

What are the difference between Pivot Charts Vs Regular Charts?

Students Community, 2 years ago

392

0

No replies

What is a Pivot Chart in MS Excel?

Students Community, 2 years ago

331

0

No replies

What are slicers in MS Excel?

Students Community, 2 years ago

272

0

No replies

What are the various sections in a Pivot Table?

Students Community, 2 years ago

202

0

No replies

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

Students Community, 2 years ago

252

0

No replies

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

Students Community, 2 years ago

280

0

No replies

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

Students Community, 2 years ago

359

0

No replies

How can you select all the cells in the worksheet?

Students Community, 2 years ago

214

0

No replies

What is the shortcut to open a new Excel workbook?

Students Community, 2 years ago

204

0

No replies

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

Students Community, 2 years ago

399

0

No replies

What is the shortcut for spell check?

Students Community, 2 years ago

357

0

No replies

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

Students Community, 2 years ago

342

0

No replies

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

Students Community, 2 years ago

236

0

No replies

What are volatile functions? Can you name a few?

Students Community, 2 years ago

344

0

No replies

When would you use the SUBTOTAL function in MS Excel?

Students Community, 2 years ago

535

0

No replies

What are the known limitations of the VLOOKUP function?

Students Community, 2 years ago

235

0

No replies

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

Students Community, 2 years ago

433

0

No replies

What is the syntax of the VLOOKUP function?

Students Community, 2 years ago

387

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

467

0

No replies

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

Students Community, 2 years ago

309

0

No replies

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

Students Community, 2 years ago

305

0

No replies

How can you tackle errors when working with Excel Formulas?

Students Community, 2 years ago

223

0

No replies