MS Office Excel 2007/2010 Advance - Pre Test
-
Excel provides some LOOKUP functions which is Vector Lookup, H Lookup, V Lookup
-
True
-
False
-
I Dont Know
-
About This Quiz
This pre-test assesses advanced skills in MS Office Excel 2007\/2010, covering LOOKUP functions, data validation, view settings, What If Analysis, and data consolidation. It is designed to evaluate proficiency in managing complex Excel tasks, enhancing decision-making and error control.
Quiz Preview
- 2.
Is it formula is valid for Vector Lookup? =LOOKUP(B13,D3:D11,E11)
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
The given formula "=LOOKUP(B13,D3:D11,E11)" is valid for Vector Lookup. The LOOKUP function searches for a value in the first column of a range and returns a value from the same row in a specified column. In this case, it searches for the value in cell B13 within the range D3:D11 and returns the corresponding value from the same row in column E. Therefore, the answer is True.Rate this question:
-
- 3.
Data Validation can help us to uniform data and at the same time control human error by using warning created by you.
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
Data Validation is a process of ensuring that data entered into a system meets certain criteria and is accurate, complete, and consistent. By implementing data validation, we can standardize and uniform data, ensuring that it is in the desired format and meets specific requirements. Additionally, data validation can help in controlling human errors by creating warning messages or alerts when incorrect or inconsistent data is entered. Therefore, the statement that data validation can help us to uniform data and control human error is true.Rate this question:
-
- 4.
View allows you to save different display and print setting and impose them quickly and easily on the worksheet at any time
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
The statement is true because the view feature in a worksheet allows users to customize the display and print settings according to their preferences. These settings can be saved and applied whenever needed, making it convenient and efficient for users to switch between different views without manually adjusting the settings every time.Rate this question:
-
- 5.
What If Analysis contain several method to help us make decisions such as Solver, Data Tables and Conditional Formatting
-
True
-
False
-
I Dont Know
Correct Answer
A. FalseExplanation
The statement is false because "What If Analysis" does not contain methods such as Solver, Data Tables, and Conditional Formatting to help make decisions. These methods are actually tools within Microsoft Excel that can be used for data analysis and problem-solving, but they are not part of the "What If Analysis" feature itself.Rate this question:
-
- 6.
You can consolidate data from each separate worksheet into a master worksheet to summarize and report result
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
Consolidating data from separate worksheets into a master worksheet allows for the summarization and reporting of results. By combining the data from multiple worksheets, it becomes easier to analyze and present the information in a cohesive manner. This can be particularly useful when working with large amounts of data or when needing to compare and contrast information from different sources. Overall, consolidating data into a master worksheet streamlines the reporting process and enhances the ability to draw insights from the data.Rate this question:
-
- 7.
You can create hypelink within Excel spreadsheet and Excel workbook by pressing Ctrl+H
-
True
-
False
-
I Dont Know
Correct Answer
A. FalseExplanation
The statement is incorrect. In Excel, you can create a hyperlink within a spreadsheet or workbook by right-clicking on a cell, selecting "Hyperlink" from the menu, and then entering the desired link address. Pressing Ctrl+H in Excel brings up the Find and Replace dialog box, not the hyperlink creation feature.Rate this question:
-
- 8.
Cell name and Range name can be create by rules of Using AplhaNumeric, Cannot contain space and can use symbol "_" only.
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
The statement is true because cell names and range names in Excel can only be created using alphanumeric characters and the symbol "_". They cannot contain spaces or any other symbols. This is a rule set by Excel to ensure that cell and range names are valid and can be easily referenced in formulas and functions.Rate this question:
-
- 9.
You can create Pivot table either within same data source worksheet or new worksheet.
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
The statement is stating that a Pivot table can be created either within the same data source worksheet or in a new worksheet. This means that the user has the flexibility to choose where they want to create the Pivot table based on their preference or requirements. Therefore, the correct answer is True.Rate this question:
-
- 10.
We can find a Name Manager Dialog Box in Excel at Formula Tab.
-
True
-
False
-
I Dont Know
Correct Answer
A. TrueExplanation
The explanation for the given correct answer is that in Excel, the Name Manager dialog box can be found under the Formula tab. This dialog box allows users to create, edit, and delete named ranges in their workbook. By using named ranges, users can easily refer to specific cells or ranges in formulas, making their formulas more understandable and easier to manage. Therefore, the statement "We can find a Name Manager Dialog Box in Excel at Formula Tab" is true.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, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 11, 2011Quiz Created by
Naldsauza
Back to top