MS Office Excel 2007/2010 Advance - Post Test

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

Questions

Settings

Create your own Quiz

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

Select the best answer

Questions and Answers

1.

_______ 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
2.

You can ________ data from each separate worksheet into a master worksheet to summarize and report results.
- A.
  
  Concatenate
- B.
  
  Consolidate
- C.
  
  Containing
- D.
  
  Filtering
3.

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

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

What If Analysis contains all below except
- A.
  
  Data Table
- B.
  
  Scenario Manager
- C.
  
  Goal Seek
- D.
  
  Pivot Tables
6.

What formula it is {=TABLE(,B4)} ?
- A.
  
  Array for Data Table
- B.
  
  Pivot Table
- C.
  
  Vector Lookup
- D.
  
  Data Validation
7.

What is short cut key to make hyperlink?
- A.
  
  Ctrl H
- B.
  
  Ctrl K
- C.
  
  Alt H
- D.
  
  Alt K
8.

1 of rules for create range name is can have space between name
- A.
  
  True
- B.
  
  False
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
10.

You can create hyperlink to link between 2 workbook, between 2 worksheet or between Excel worksheet and Internet
- A.
  
  False
- B.
  
  True