MS Excel Interview Questions and Topic Discussions

What is data validation in MS Excel?

Seema Arora, 2 years ago

288

1

What is Scenario Manager in MS Excel?

Seema Arora, 2 years ago

477

1

What is a Solver in MS Excel?

Seema Arora, 2 years ago

279

0

No replies

What is Goal Seek in MS Excel?

Seema Arora, 2 years ago

306

0

No replies

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

Seema Arora, 2 years ago

245

0

No replies

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

Seema Arora, 2 years ago

446

0

No replies

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

Seema Arora, 2 years ago

269

0

No replies

What is an advanced Filter in MS Excel?

Seema Arora, 2 years ago

401

0

No replies

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

Seema Arora, 2 years ago

198

0

No replies

How can you select all blank cells in MS Excel?

Seema Arora, 2 years ago

254

0

No replies

How can you transpose a data set in MS Excel?

Seema Arora, 2 years ago

254

0

No replies

How can you sort data in MS Excel?

Seema Arora, 2 years ago

321

0

No replies

What kind of data filters are available in MS Excel?

Seema Arora, 2 years ago

168

0

No replies

How to replace one value with another in MS Excel?

Seema Arora, 2 years ago

280

0

No replies

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

Seema Arora, 2 years ago

468

0

No replies

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

Seema Arora, 2 years ago

251

0

No replies

What are Combination charts in MS Excel?

Seema Arora, 2 years ago

225

0

No replies

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

Seema Arora, 2 years ago

416

0

No replies

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

Seema Arora, 2 years ago

415

0

No replies

What is a Scatter chart in MS Excel?

Seema Arora, 2 years ago

249

0

No replies

What is a Line chart in MS Excel?

Seema Arora, 2 years ago

255

0

No replies

What is a Bar chart in MS Excel?

Seema Arora, 2 years ago

263

0

No replies

What is a Column chart in MS Excel?

Students Community, 2 years ago

377

0

No replies

What are Calculated Fields in Pivot Table?

Students Community, 2 years ago

274

0

No replies

Can I make a Pivot Table from multiple tables?

Students Community, 2 years ago

210

0

No replies

What is a Pivot Cache in MS Excel?

Students Community, 2 years ago

335

0

No replies

Can you group dates in Pivot Tables in MS Excel?

Students Community, 2 years ago

181

0

No replies

How can you refresh a Pivot Table?

Students Community, 2 years ago

312

0

No replies

What are the difference between Pivot Charts Vs Regular Charts?

Students Community, 2 years ago

360

0

No replies

What is a Pivot Chart in MS Excel?

Students Community, 2 years ago

291

0

No replies

What are slicers in MS Excel?

Students Community, 2 years ago

261

0

No replies

What are the various sections in a Pivot Table?

Students Community, 2 years ago

194

0

No replies

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

Students Community, 2 years ago

222

0

No replies

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

Students Community, 2 years ago

265

0

No replies

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

Students Community, 2 years ago

323

0

No replies

How can you select all the cells in the worksheet?

Students Community, 2 years ago

189

0

No replies

What is the shortcut to open a new Excel workbook?

Students Community, 2 years ago

196

0

No replies

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

Students Community, 2 years ago

358

0

No replies

What is the shortcut for spell check?

Students Community, 2 years ago

319

0

No replies

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

Students Community, 2 years ago

322

0

No replies

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

Students Community, 2 years ago

230

0

No replies

What are volatile functions? Can you name a few?

Students Community, 2 years ago

311

0

No replies

When would you use the SUBTOTAL function in MS Excel?

Students Community, 2 years ago

500

0

No replies

What are the known limitations of the VLOOKUP function?

Students Community, 2 years ago

227

0

No replies

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

Students Community, 2 years ago

407

0

No replies

What is the syntax of the VLOOKUP function?

Students Community, 2 years ago

378

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

427

0

No replies

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

Students Community, 2 years ago

293

0

No replies

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

Students Community, 2 years ago

284

0

No replies

How can you tackle errors when working with Excel Formulas?

Students Community, 2 years ago

200

0

No replies