MS Excel Interview Questions and Topic Discussions

What is data validation in MS Excel?

Seema Arora, 2 years ago

274

1

What is Scenario Manager in MS Excel?

Seema Arora, 2 years ago

461

1

What is a Solver in MS Excel?

Seema Arora, 2 years ago

253

0

No replies

What is Goal Seek in MS Excel?

Seema Arora, 2 years ago

270

0

No replies

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

Seema Arora, 2 years ago

210

0

No replies

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

Seema Arora, 2 years ago

424

0

No replies

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

Seema Arora, 2 years ago

248

0

No replies

What is an advanced Filter in MS Excel?

Seema Arora, 2 years ago

389

0

No replies

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

Seema Arora, 2 years ago

187

0

No replies

How can you select all blank cells in MS Excel?

Seema Arora, 2 years ago

219

0

No replies

How can you transpose a data set in MS Excel?

Seema Arora, 2 years ago

236

0

No replies

How can you sort data in MS Excel?

Seema Arora, 2 years ago

285

0

No replies

What kind of data filters are available in MS Excel?

Seema Arora, 2 years ago

157

0

No replies

How to replace one value with another in MS Excel?

Seema Arora, 2 years ago

275

0

No replies

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

Seema Arora, 2 years ago

440

0

No replies

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

Seema Arora, 2 years ago

226

0

No replies

What are Combination charts in MS Excel?

Seema Arora, 2 years ago

184

0

No replies

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

Seema Arora, 2 years ago

386

0

No replies

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

Seema Arora, 2 years ago

393

0

No replies

What is a Scatter chart in MS Excel?

Seema Arora, 2 years ago

223

0

No replies

What is a Line chart in MS Excel?

Seema Arora, 2 years ago

225

0

No replies

What is a Bar chart in MS Excel?

Seema Arora, 2 years ago

250

0

No replies

What is a Column chart in MS Excel?

Students Community, 2 years ago

353

0

No replies

What are Calculated Fields in Pivot Table?

Students Community, 2 years ago

243

0

No replies

Can I make a Pivot Table from multiple tables?

Students Community, 2 years ago

205

0

No replies

What is a Pivot Cache in MS Excel?

Students Community, 2 years ago

315

0

No replies

Can you group dates in Pivot Tables in MS Excel?

Students Community, 2 years ago

176

0

No replies

How can you refresh a Pivot Table?

Students Community, 2 years ago

285

0

No replies

What are the difference between Pivot Charts Vs Regular Charts?

Students Community, 2 years ago

338

0

No replies

What is a Pivot Chart in MS Excel?

Students Community, 2 years ago

277

0

No replies

What are slicers in MS Excel?

Students Community, 2 years ago

257

0

No replies

What are the various sections in a Pivot Table?

Students Community, 2 years ago

179

0

No replies

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

Students Community, 2 years ago

210

0

No replies

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

Students Community, 2 years ago

258

0

No replies

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

Students Community, 2 years ago

294

0

No replies

How can you select all the cells in the worksheet?

Students Community, 2 years ago

167

0

No replies

What is the shortcut to open a new Excel workbook?

Students Community, 2 years ago

191

0

No replies

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

Students Community, 2 years ago

331

0

No replies

What is the shortcut for spell check?

Students Community, 2 years ago

308

0

No replies

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

Students Community, 2 years ago

287

0

No replies

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

Students Community, 2 years ago

222

0

No replies

What are volatile functions? Can you name a few?

Students Community, 2 years ago

290

0

No replies

When would you use the SUBTOTAL function in MS Excel?

Students Community, 2 years ago

476

0

No replies

What are the known limitations of the VLOOKUP function?

Students Community, 2 years ago

220

0

No replies

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

Students Community, 2 years ago

374

0

No replies

What is the syntax of the VLOOKUP function?

Students Community, 2 years ago

359

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

407

0

No replies

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

Students Community, 2 years ago

269

0

No replies

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

Students Community, 2 years ago

267

0

No replies

How can you tackle errors when working with Excel Formulas?

Students Community, 2 years ago

186

0

No replies