MS Office Excel 2007/2010 Advance - Post Test
Select the best answer
Questions and Answers
- 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
Correct Answer
C. Vector Lookup, H Lookup and V LookupExplanation
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)
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:
-
- 3.
What If Analysis contains all below except
- A.
Data Table
- B.
Scenario Manager
- C.
Goal Seek
- D.
Pivot Tables
Correct Answer
D. Pivot TablesExplanation
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
Correct Answer
A. ViewsExplanation
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
Correct Answer
A. Array for Data TableExplanation
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
Correct Answer
B. ConsolidateExplanation
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
Correct Answer
B. Ctrl KExplanation
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
Correct Answer
B. FalseExplanation
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
Correct Answer
D. Icon Name ManagerExplanation
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
Correct Answer
B. TrueExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 07, 2011Quiz Created by
Naldsauza
Back to top