IT Exam Items Repository What sign do all Microsoft Excel formulas start with?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is the Microsoft Excel "LEN" function used for?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsIn Microsoft Excel, what is the "INDEX" function used for?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is the name of the Microsoft Excel function in the formula "=INDEX(ProductSales,MATCH(1,($A2=ProductSales[Country])*($B2=ProductSales[Product]),0), 3)"?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsHow is an active cell displayed in Microsoft Excel?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is the Microsoft Excel Data > Sort command used for?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is the Microsoft Excel "CONCATENATE" function used for?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat keyboard shortcut can be used in Microsoft Excel to select all the data?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat are two important considerations when selecting data for an analysis project? (Choose two.)ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich two methods are used to collect unstructured data for analysis? (Choose two.)ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhich universal file format is organized in rows and has the columns separated by a delimiter character?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat are Web scrapping tools used for in big data analytics?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsAn analyst is reviewing gathered data from various sources and modifying incompatible metrics into a usable form. In which ETL step would this task be completed in?ITExamAnswers Editorial Team asked 1 year ago • Data Analytics EssentialsWhat is a characteristic of open data?ITExamAnswers Editorial Team asked 4 years ago • Data Analytics Essentials, IoT Big Data & AnalyticsIn a data analysis project, which process gathers all grades for students enrolled in a college course?ITExamAnswers Editorial Team asked 4 years ago • Data Analytics Essentials, IoT Big Data & Analytics