EXCEL_NAVIGATION EXAM QUESTIONS

PDF Download

EXCEL_NAVIGATION EXAM QUESTIONS

Actual Qs and Ans - Expert-Verified Explanation -Guaranteed passing score -8 Questions and Answers

-Format: Multiple-choice / Flashcard

Question 1: Which two components can be connected with a slicer?

Answer:

The two components that can be connected with a slicer are pivot tables and charts.Question 2: When using the VLOOKUP function, what is the purpose of the first parameter?

Answer:

The first parameter of the VLOOKUP function is the column and row of the query entry to retrieve the matching data Question 3: When using the VLOOKUP function, what is the purpose of the second parameter?

Answer:

The second parameter of the VLOOKUP function is the range of data domain where the data is identified and selected.Question 4: What are the two challenges of creating pivot tables based on a range of tables created by VLOOKUP?

Answer:

VLOOKUP calculations are slow and limited to the number of rows that Excel can handle.

Question 5: When using the VLOOKUP function, what is the purpose of the fourth parameter?

Answer:

The first parameter of the VLOOKUP function is a Boolean flag whose true value is an approximate match request and false for an exact match request.Question 6: When using the VLOOKUP function, what is the purpose of the third parameter?

Answer:

The third parameter is the number of the target column with respect to the key.

Question 7: What are three reasons to use tables in Excel?

Answer:

The three reasons to use tables in Excel are: Independent management of rows and columns in a workbook, creating expressions that refer to column names and applying a predefined style.

Question 8: Which two actions unhide a worksheet in a workbook?

Answer:

Right-click a worksheet tab, and click Unhide, or, on the Home tab, click Format in the Cells group, select Hide & Unhide, and click Unhide Sheet.