ISTM 210 Exam 2- Excel Exam 2024 Questions & Answers 100% Correct!

Fill Feature - ANSWERSAllows you to automatically populate cells in a worksheet Series Feature - ANSWERSAllows you to complete a pattern within a range of cells Freeze Pain Feature - ANSWERSAllows you to lock rows and columns when you navigate through a data table Sorting Feature - ANSWERSAllows information on the table to be presented in an organized fashion Filtering Feature - ANSWERSAllows you to display only specific information on a data table Relative cell reference - ANSWERScells automatically update when a formula is pasted into those cells Absolute cell reference - ANSWERScells reference remains constant when a formula is pasted into a new cell What does the function wizard allow you to do? - ANSWERS-Allows you to enter or select inputs -provides a description of the function and each argument -Lists function results (outputs) What are the 6 statistic functions? - ANSWERSSum Count CountA Average Max MIn Sum Function - ANSWERS=SUM(number1, [number2]) The SUM function adds all data in a range of cells Count function - ANSWERS=COUNT(value1, [value2]) Counts the number of cells in range of cells that contain numbers CountA function - ANSWERS=COUNTA(value1, [value2])