MS Office Excel 2007/2010 Advance - Post Test

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

Concatenate

Consolidate

Containing

Filtering

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.

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.

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

False

True

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.

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.

3. Excel provides some LOOKUP functions which is

Vector Lookup, V Lookup and W Lookup

Vector Lookup, H Lookup and Horizontal Lookup

Vector Lookup, H Lookup and V Lookup

HectorLookup, VLookup and Vector Lookup

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."

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."

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

Views

Scenario Manager

Solver

Bookmarks

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.

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.

5. What is short cut key to make hyperlink?

Ctrl H

Ctrl K

Alt H

Alt K

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.

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.

6. What If Analysis contains all below except

Data Table

Scenario Manager

Goal Seek

Pivot Tables

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.

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.

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

True

False

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.

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.

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

Array for Data Table

Pivot Table

Vector Lookup

Data Validation

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.

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.

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

Icon Range Manager

Icon Range Name

Icon Name Designer

Icon Name Manager

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.

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.

10. Which one is valid Vector Lookup statement?

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

=VLOOKUP(B13,D3:D11,E11)

=VECTORLOOKUP(B13,D3:D11,E11)

=VHLOOKUP(B13,D3:D11,E11)

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).

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).