Excel 2010 (Level 3 - Advanced)
10 Questions
| Total Attempts: 707
Knowledge Excel Level 3 (Advanced)
Questions and Answers
- 1.How many conditions can the sumif check for?
- A.
1
- B.
2
- C.
3
- D.
4
- 2.By default how many worksheets are in a workbook?
- A.
1
- B.
2
- C.
3
- D.
4
- 3.An nested if statement only allows for one argument?
- A.
True
- B.
False
- 4.What is a pivot table?
- A.
A report
- B.
An advanced filter
- C.
A filter
- D.
Vlookup
- 5.A macro is a part of a conditional format?
- A.
True
- B.
False
- 6.If the range lookup is false in a vlookup what does it mean?
- A.
The result will return an exact match
- B.
The result will return the nearest match
- C.
It will return a negative
- D.
None of the above
- 7.A template is a worksheet which has all the necessary features you require?
- A.
True
- B.
False
- 8.What is a scenario?
- A.
Figures which switch between varying amounts
- B.
A conditional format
- C.
A macro
- D.
An IF statement
- 9.The sumif function has the...... range, criteria, sum_range?
- A.
True
- B.
False
- 10.A lookup table counts the columns in the Col_index_No and not the cell reference?
- A.
True
- B.
False
Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your...
Questions: 50 | Attempts: 3101 | Last updated: May 18, 2021
-
Sample Question_______ tab, in the Editing group, click Find & Select, and then click Go To.
Questions: 22 | Attempts: 6041 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Here is an interesting quiz about 'Excel Intermediate 2013' that is designed to test your knowledge of this subject. Do you have a good understanding of Excel Intermediate 2013? If your answer is yes, then you must take...
Questions: 29 | Attempts: 13143 | Last updated: Nov 28, 2021
-
Sample QuestionFrom the following list, select the choice that is a 3D formula in Excel.
What is The Perfect Gift for Your Best Friend Quiz
What is The Perfect Gift for Your Best Friend Quiz
Are You Really Best Friends? Take The Quiz & Prove It
Are You Really Best Friends? Take The Quiz & Prove It
Back to top