MS Office Excel 2007/2010 Advance - Pre Test

10 Questions | By Naldsauza | Last updated: Mar 21, 2022 | Total Attempts: 949

Questions

Settings

Create your own Quiz

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

Select either True, False or I Don't Know

Questions and Answers

1.

Excel provides some LOOKUP functions which is Vector Lookup, H Lookup, V Lookup
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
2.

Is it formula is valid for Vector Lookup? =LOOKUP(B13,D3:D11,E11)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
3.

Data Validation can help us to uniform data and at the same time control human error by using warning created by you.
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
4.

View allows you to save different display and print setting and impose them quickly and easily on the worksheet at any time
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
5.

What If Analysis contain several method to help us make decisions such as Solver, Data Tables and Conditional Formatting
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
6.

You can consolidate data from each separate worksheet into a master worksheet to summarize and report result
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
7.

You can create hypelink within Excel spreadsheet and Excel workbook by pressing Ctrl+H
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
8.

Cell name and Range name can be create by rules of Using AplhaNumeric, Cannot contain space and can use symbol "_" only.
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
9.

You can create Pivot table either within same data source worksheet or new worksheet.
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
10.

We can find a Name Manager Dialog Box in Excel at Formula Tab.
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know