1. What is the default Excel 2010-2013 extension?
2. $B$4 is an example of which cell reference type?
3. What is the F4 key used for in the worksheet?
4. To use a formula, is it necessary to always and only enter the equal sign (=) in a cell?
5. If we have to add all the cells in the range from A1 to A10, is the following Function correct = Sum (A1; A10)?
6. In cell A1 we find the following Function = IF (B1> 25; "OK"; "ERROR"). What will appear in cell A1 if the number 25 is entered in B1?
7. In cell A1 is inserted: luca in cell B1: Rossi. If I wanted to display Luca Rossi in cell C1, what function should be used?
8. What does the VLOOKUP function do?
9. What is a macro?
10. Which Function can I set to display the current date and time in a cell?
11. Which Function should be used to calculate how many working days there are between two dates?
12. Which of these elements is not present in the SUMIFS function?
13. Is it possible to link different worksheets in different files?
14. What is the Data Validation tool allows?
15. What is a pivot table?
16. Which of the following are not in a pivot table?
17. What is the keyboard command to copy the contents of a cell?
18. Is it possible to protect only certain cells in the Worksheet?
19. What kind of data can you put in a single cell?
20. In Excel, which symbol identifies absolute references?