Excel MCQs (Chapterwise Multiple Choice Questions)

Goal seek uses a different approach from traditional _______ analysis.

Hypothetical

What-if

Worksheet

Trial-and-error

Answer & Explanation

Correct Answer: What-if

Note: This Question is unanswered, help us to find answer for this one

What formula permits the use of multiple lookup criteria?

Index(match())

Vlookup(Index())

Sumproduct

Hlookup

Indirect

Answer & Explanation

Correct Answer: Sumproduct

Note: This Question is unanswered, help us to find answer for this one

How do you change the orientation of a spreadsheet from portrait to landscape?

Page layout > scale to fit > landscape

Page layout > orientation > landscape

Page layout > landscape > orientation

Answer & Explanation

Correct Answer: Page layout > orientation > landscape

Note: This Question is unanswered, help us to find answer for this one

A header contains ____ boxes.

The largest value in the argument

255

January 1, 2000

3

Answer & Explanation

Correct Answer: 3

Note: This Question is unanswered, help us to find answer for this one

How does a user prevent circular references conflict errors?

Click on the "Enable Iterative Calculations" box

click on the "Enable All Calculations" box

Click on the "Enable All Functions" box

Click on the "Enable Circular References" box

Answer & Explanation

Correct Answer: Click on the "Enable Iterative Calculations" box

Note: This Question is unanswered, help us to find answer for this one

Assuming Cell A1 is populated with 16.8942, which of the following formulas would result in 16?

=INT(A1)

=ROUND(A1)

=RAND(A1)

=ROUND(A1,-1)

=ROUND(A1,0)

Answer & Explanation

Correct Answer: =INT(A1)

Note: This Question is unanswered, help us to find answer for this one

Which worksheet function returns the parameters of an exponential trend?

EXPONEN

LOGEXP

LOGEST

LOG

EXPONENTIAL

Answer & Explanation

Correct Answer: LOGEST

Note: This Question is unanswered, help us to find answer for this one

To create a summary sheet requires navigation of ____________.

Summary sheet.

Detail sheet.

Synopsis sheet.

Review sheet

Answer & Explanation

Correct Answer: Summary sheet.

Note: This Question is unanswered, help us to find answer for this one

The Solver in MS Excel is used for what?

To find only optimal maximum solutions to linear programming problems

To find only optimal minimum solutions to linear programming problems

To find optimal minimum or maximum solutions to linear programming problems

Answer & Explanation

Correct Answer: To find optimal minimum or maximum solutions to linear programming problems

Note: This Question is unanswered, help us to find answer for this one

In Microsoft Excel 2016, which of the following keyboard shortcuts is used for the "Clear filter" command for Slicer in a Pivot table?

Alt + C

Ctrl + C

Windows + C

Shift + C

Answer & Explanation

Correct Answer: Alt + C

Note: This Question is unanswered, help us to find answer for this one

Excel Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.