MS Excel Interview Questions and Topic Discussions

What is data validation in MS Excel?

Seema Arora, 2 years ago

266

1

What is Scenario Manager in MS Excel?

Seema Arora, 2 years ago

454

1

What is a Solver in MS Excel?

Seema Arora, 2 years ago

231

0

No replies

What is Goal Seek in MS Excel?

Seema Arora, 2 years ago

252

0

No replies

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

Seema Arora, 2 years ago

200

0

No replies

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

Seema Arora, 2 years ago

401

0

No replies

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

Seema Arora, 2 years ago

205

0

No replies

What is an advanced Filter in MS Excel?

Seema Arora, 2 years ago

376

0

No replies

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

Seema Arora, 2 years ago

183

0

No replies

How can you select all blank cells in MS Excel?

Seema Arora, 2 years ago

173

0

No replies

How can you transpose a data set in MS Excel?

Seema Arora, 2 years ago

227

0

No replies

How can you sort data in MS Excel?

Seema Arora, 2 years ago

239

0

No replies

What kind of data filters are available in MS Excel?

Seema Arora, 2 years ago

152

0

No replies

How to replace one value with another in MS Excel?

Seema Arora, 2 years ago

257

0

No replies

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

Seema Arora, 2 years ago

398

0

No replies

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

Seema Arora, 2 years ago

199

0

No replies

What are Combination charts in MS Excel?

Seema Arora, 2 years ago

176

0

No replies

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

Seema Arora, 2 years ago

365

0

No replies

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

Seema Arora, 2 years ago

343

0

No replies

What is a Scatter chart in MS Excel?

Seema Arora, 2 years ago

182

0

No replies

What is a Line chart in MS Excel?

Seema Arora, 2 years ago

203

0

No replies

What is a Bar chart in MS Excel?

Seema Arora, 2 years ago

208

0

No replies

What is a Column chart in MS Excel?

Students Community, 2 years ago

327

0

No replies

What are Calculated Fields in Pivot Table?

Students Community, 2 years ago

206

0

No replies

Can I make a Pivot Table from multiple tables?

Students Community, 2 years ago

186

0

No replies

What is a Pivot Cache in MS Excel?

Students Community, 2 years ago

289

0

No replies

Can you group dates in Pivot Tables in MS Excel?

Students Community, 2 years ago

166

0

No replies

How can you refresh a Pivot Table?

Students Community, 2 years ago

246

0

No replies

What are the difference between Pivot Charts Vs Regular Charts?

Students Community, 2 years ago

308

0

No replies

What is a Pivot Chart in MS Excel?

Students Community, 2 years ago

238

0

No replies

What are slicers in MS Excel?

Students Community, 2 years ago

250

0

No replies

What are the various sections in a Pivot Table?

Students Community, 2 years ago

172

0

No replies

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

Students Community, 2 years ago

207

0

No replies

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

Students Community, 2 years ago

234

0

No replies

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

Students Community, 2 years ago

257

0

No replies

How can you select all the cells in the worksheet?

Students Community, 2 years ago

162

0

No replies

What is the shortcut to open a new Excel workbook?

Students Community, 2 years ago

186

0

No replies

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

Students Community, 2 years ago

292

0

No replies

What is the shortcut for spell check?

Students Community, 2 years ago

300

0

No replies

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

Students Community, 2 years ago

244

0

No replies

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

Students Community, 2 years ago

211

0

No replies

What are volatile functions? Can you name a few?

Students Community, 2 years ago

256

0

No replies

When would you use the SUBTOTAL function in MS Excel?

Students Community, 2 years ago

423

0

No replies

What are the known limitations of the VLOOKUP function?

Students Community, 2 years ago

213

0

No replies

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

Students Community, 2 years ago

351

0

No replies

What is the syntax of the VLOOKUP function?

Students Community, 2 years ago

351

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

383

0

No replies

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

Students Community, 2 years ago

231

0

No replies

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

Students Community, 2 years ago

233

0

No replies

How can you tackle errors when working with Excel Formulas?

Students Community, 2 years ago

172

0

No replies