Excel Level 3
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
Correct Answer
A. The file menu -
- 2.
What language is used to create macros in Excel?
- A.
Visual C++
- B.
Visual Basic
- C.
Java
- D.
Flash
Correct Answer
B. Visual Basic -
- 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
Correct Answer
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
Correct Answer
A. 1900 and 1904 -
- 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
Correct Answer
A. The formula is trying to divide an empty cell -
- 6.
The Range, Criteria and Sum_range are part of which function?
- A.
Nested If
- B.
IF
- C.
SumIf
- D.
Vlookup
Correct Answer
C. SumIf -
- 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.
Correct Answer
B. The vlookup looks up data in the left column - index and match can lookup multiple columns -
- 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
Correct Answer
A. In Excel, the Transpose function returns a transposed range of specified cells. In other words in turns information in columns to rows -
- 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
Correct Answer
B. Pivot tables creates reports from information you supply -
- 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.
Correct Answer
B. The functions will help to clean up data -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 20, 2013Quiz Edited by
ProProfs Editorial Team -
Aug 08, 2012Quiz Created by
MarieLamb
Back to top