SKILLS TEST MICROSOFT EXCEL – CORRADI



    Campo obbligatorio



    Campo obbligatorio



    Campo obbligatorio

    1. What is the default Excel 2010-2013 extension?


    docxpptxxlsxlsx

    2. $B$4 is an example of which cell reference type?


    Relative referenceAbsolute referenceMixed referenceDouble reference

    3. What is the F4 key used for in the worksheet?


    To automatically insert a graphTo format with properties evaluates a numberTo repeat the last command executed in ExcelTo quickly copy all selected areas

    4. To use a formula, is it necessary to always and only enter the equal sign (=) in a cell?


    YesNoNo, only in some formulasNo, only with operations like = A1 + A2

    5. If we have to add all the cells in the range from A1 to A10, is the following Function correct = Sum (A1; A10)?


    YesNoIt must all be imputed in lower caseIt must be imputed in all capital letters

    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?


    OKERROR#FIRST NAME?#VALUE!

    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?


    CONCATENATEMERGEANDTEXTJOIN

    8. What does the VLOOKUP function do?


    Look for a value in the first row of a matrix and return a value below on the same columnSearches for a value in the first column of a matrix and returns a value to the left or right on the same rowSearches for a value in the first column of a matrix and returns a value to the left on the same rowSearches for a value in the first column of a matrix and returns a value to the right on the same row

    9. What is a macro?


    A calculation within a data matrixAn advanced Excel functionA procedure written in VBA that carries out a recurring procedureIt is the command that allows you to use the zoom in the worksheets

    10. Which Function can I set to display the current date and time in a cell?


    NOWTODAYDATE HOURDATEVALUE

    11. Which Function should be used to calculate how many working days there are between two dates?


    DATEWORKDAYNETWORKDAYSDAYS360

    12. Which of these elements is not present in the SUMIFS function?


    intervalindexcriterionthe SUMIFS function does not exist

    13. Is it possible to link different worksheets in different files?


    YesYes, only if the files are in the same folderYes, only with the Excel 2016 versionNo

    14. What is the Data Validation tool allows?


    A check on the correct syntax of a FunctionThe creation of a logical function that allows to verify the correctness of the entered dataSet a data category to be entered in a cellNone of the above

    15. What is a pivot table?


    An advanced Excel functionA procedure written in VBA that carries out a recurring procedureA table linked to a databaseNone of the above

    16. Which of the following are not in a pivot table?


    Calculated elementRow labelsColumn labelsAll previous elements belong to a pivot table

    17. What is the keyboard command to copy the contents of a cell?


    Ctrl + XCtrl + CCtrl + VCtrl + Alt

    18. Is it possible to protect only certain cells in the Worksheet?


    YES, but only from the 2010 version, using the tools contained in the REVISION tabYES, but only from the 2013 version, using the tools contained in the REVISION tabYES, leaving only the cells to be protected Locked and then protecting the WorksheetNO, only the entire Worksheet can be write-protected

    19. What kind of data can you put in a single cell?


    Only numbers and formulasOnly text and numbersText, numbers and formulasNumbers only

    20. In Excel, which symbol identifies absolute references?


    Dollar ($)Asterisk (*)Hashtag (#)None of the above