MS Office Excel 2007/2010 Advance - Post Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 25 | Total Attempts: 17,068
Questions: 10 | Attempts: 1,327

Settings

• 1.

Excel provides some LOOKUP functions which is

• A.

Vector Lookup, V Lookup and W Lookup

• B.

Vector Lookup, H Lookup and Horizontal Lookup

• C.

Vector Lookup, H Lookup and V Lookup

• D.

HectorLookup, VLookup and Vector Lookup

C. Vector Lookup, H Lookup and V Lookup
Explanation
Excel provides three main lookup functions: VLOOKUP, HLOOKUP, and INDEX/MATCH (often referred to as "vector lookup"). VLOOKUP is used to search for a value vertically in a table and return a corresponding value from a different column. HLOOKUP is similar to VLOOKUP but searches horizontally instead of vertically. INDEX/MATCH is a combination of the INDEX and MATCH functions, allowing for more flexible and powerful lookup capabilities. Therefore, the correct answer is "Vector Lookup, H Lookup and V Lookup."

Rate this question:

• 2.

Which one is valid Vector Lookup statement?

• A.

=LOOKUP(B13,D3:D11,E3:E11)

• B.

=VLOOKUP(B13,D3:D11,E11)

• C.

=VECTORLOOKUP(B13,D3:D11,E11)

• D.

=VHLOOKUP(B13,D3:D11,E11)

A. =LOOKUP(B13,D3:D11,E3:E11)
Explanation
The correct answer is =LOOKUP(B13,D3:D11,E3:E11). This is a valid Vector Lookup statement because it uses the LOOKUP function to search for a value in the range D3:D11 and returns the corresponding value from the range E3:E11. The function takes three arguments: the value to be searched (B13), the range to search in (D3:D11), and the range to return values from (E3:E11).

Rate this question:

• 3.

What If Analysis contains all below except

• A.

Data Table

• B.

Scenario Manager

• C.

Goal Seek

• D.

Pivot Tables

D. Pivot Tables
Explanation
The question asks for the item that is not included in the What If Analysis. Pivot Tables are not a part of the What If Analysis feature in Excel. Data Table, Scenario Manager, and Goal Seek are all tools that are commonly used in What If Analysis to analyze different scenarios and find solutions to problems. However, Pivot Tables are a separate tool in Excel that is used for summarizing and analyzing large amounts of data. Therefore, Pivot Tables are not included in the What If Analysis feature.

Rate this question:

• 4.

_______ allows you to save different display and print setting and impose them quickly and easily on the worksheet at any time

• A.

Views

• B.

Scenario Manager

• C.

Solver

• D.

Bookmarks

A. Views
Explanation
Views allows you to save different display and print settings and impose them quickly and easily on the worksheet at any time. This feature allows users to create and save customized views of the worksheet, including specific zoom levels, hidden or visible columns and rows, and other formatting options. By saving different views, users can easily switch between different configurations of the worksheet depending on their needs, improving efficiency and productivity.

Rate this question:

• 5.

What formula it is {=TABLE(,B4)} ?

• A.

Array for Data Table

• B.

Pivot Table

• C.

Vector Lookup

• D.

Data Validation

A. Array for Data Table
Explanation
The formula "=TABLE(,B4)" is used to create an array for a data table. This formula allows you to input a range of values and perform calculations on them, such as finding the average or sum. By using this formula, you can easily analyze and manipulate large sets of data in a structured and organized manner.

Rate this question:

• 6.

You can ________ data from each separate worksheet into a master worksheet to summarize and report results.

• A.

Concatenate

• B.

Consolidate

• C.

Containing

• D.

Filtering

B. Consolidate
Explanation
Consolidate is the correct answer because it means to combine or merge separate pieces of data into one. In this context, it refers to the action of bringing together data from different worksheets into a single master worksheet for the purpose of summarizing and reporting the results.

Rate this question:

• 7.

What is short cut key to make hyperlink?

• A.

Ctrl H

• B.

Ctrl K

• C.

Alt H

• D.

Alt K

B. Ctrl K
Explanation
The correct answer is Ctrl K. This shortcut key is used to create a hyperlink in various applications such as Microsoft Word, Excel, and PowerPoint. By selecting the text or object you want to turn into a hyperlink and then pressing Ctrl K, you can quickly and easily add a link to a website, document, or email address.

Rate this question:

• 8.

1 of rules for create range name is can have space between name

• A.

True

• B.

False

B. False
Explanation
The statement is false because one of the rules for creating a range name is that it cannot have spaces between the name. Range names in Excel or other spreadsheet programs are typically single words or phrases without any spaces.

Rate this question:

• 9.

Where can we find, delete and edit our Range Name and Cell Name?

• A.

Icon Range Manager

• B.

Icon Range Name

• C.

Icon Name Designer

• D.

Icon Name Manager

D. Icon Name Manager
Explanation
The correct answer is "icon Name Manager". The Name Manager is a feature in Excel that allows users to view, edit, and delete range names and cell names. It provides a comprehensive list of all the defined names in the workbook and allows users to make changes to them as needed. This feature can be accessed by clicking on the "Name Manager" icon in Excel.

Rate this question:

• 10.

You can create hyperlink to link between 2 workbook, between 2 worksheet or between Excel worksheet and Internet

• A.

False

• B.

True

B. True
Explanation
The statement is true because in Excel, you have the ability to create hyperlinks that can link between different workbooks, different worksheets within the same workbook, or even link to websites on the internet. This feature allows users to easily navigate and access related information or external resources within their Excel files.

Rate this question:

Related Topics