Excel Level 3
Settings
Advanced Excel skills.
- 1.What is known as the backstage view in Excel?
- A.
The file menu
- B.
Print Menu
- C.
The information menu
- D.
The edit menu
- 2.What language is used to create macros in Excel?
- A.
Visual C++
- B.
Visual Basic
- C.
Java
- D.
Flash
- 3.You can save and protect your workbook by using the following?
- A.
Write reservation Password
- B.
Protection Password
- C.
Read only recommended
- D.
All of the above
- 4.What are the two dates systems that Excel can use?
- A.
1900 and 1904
- B.
Excel can use any format
- C.
2004 and 2010
- D.
1900 and 2000
- 5.When you see the following in a cell - what does it mean? #DIV/0!
- A.
The formula is trying to divide an empty cell
- B.
You have failed to put the / sign inside the formula
- C.
The cells do not exist
- D.
You have inserted an incorrect cell
- 6.The Range, Criteria and Sum_range are part of which function?
- A.
Nested If
- B.
IF
- C.
SumIf
- D.
Vlookup
- 7.What is the difference between the vlookup and index and match?
- A.
They are both the same
- B.
The vlookup looks up data in the left column - index and match can lookup multiple columns
- C.
The vlookup looks up data to the left and the Index and Match looks up data to the right
- D.
- 8.What does transpose mean in Excel?
- A.
In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns to rows
- B.
Paste Special
- C.
Paste
- D.
Paste without values
- 9.What is a Pivot table?
- A.
A lookup table
- B.
Pivot tables creates reports from information you supply
- C.
A Pivot table quickly allows you to make your table look visually presentable
- D.
It shows only the formulas
- 10.What are the len, left and Mid function used for?
- A.
Looking up data
- B.
The functions will help to clean up data
- C.
It is part of the pivot table
- D.
Back to top