MS Office Excel 2007/2010 Advance - Post Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,239
| Attempts: 1,341
SettingsSettings
Please wait...
  • 1/10 Questions

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

    • Concatenate
    • Consolidate
    • Containing
    • Filtering
Please wait...
About This Quiz

This advanced post-test for MS Office Excel 2007\/2010 assesses proficiency in complex functions such as LOOKUP, What If Analysis, and data consolidation. It evaluates the ability to apply Excel tools effectively, enhancing data analysis and presentation skills.

MS Office Excel 2007/2010 Advance - Post Test - Quiz

Quiz Preview

  • 2. 

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

    • False

    • True

    Correct Answer
    A. 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:

  • 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

    Correct Answer
    A. 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:

  • 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

    Correct Answer
    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 is short cut key to make hyperlink?

    • Ctrl H

    • Ctrl K

    • Alt H

    • Alt K

    Correct Answer
    A. 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:

  • 6. 

    What If Analysis contains all below except

    • Data Table

    • Scenario Manager

    • Goal Seek

    • Pivot Tables

    Correct Answer
    A. 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:

  • 7. 

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

    • True

    • False

    Correct Answer
    A. 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:

  • 8. 

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

    • Array for Data Table

    • Pivot Table

    • Vector Lookup

    • Data Validation

    Correct Answer
    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:

  • 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

    Correct Answer
    A. 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. 

    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)

    Correct Answer
    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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 07, 2011
    Quiz Created by
    Naldsauza
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.