Back to Course Basic Statistics | Test Your Knowledge – Module Quiz Quiz 1 of 0 Basic Statistics | Test Your Knowledge – Module Quiz In this quiz, you’ll consolidate your knowledge of Excel and basic descriptive statistics. Time limit: 0 Quiz Summary 0 of 5 Questions completed Questions: Information You have already completed the quiz before. Hence you can not start it again. Quiz is loading… You must sign in or sign up to start the quiz. You must first complete the following: Results Quiz complete. Results are being recorded. Results 0 of 5 Questions answered correctly Your time: Time has elapsed You have reached 0 of 0 point(s), (0) Earned Point(s): 0 of 0, (0) 0 Essay(s) Pending (Possible Point(s): 0) Categories Not categorized 0% 1 2 3 4 5 Current Review Answered Correct Incorrect Question 1 of 5 1. Question How do I keep my header row visible as I scroll down? View Tab > Freeze Panes > Freeze Top Row View Tab > Freeze Panes > Freeze Panes View Tab > Freeze Panes > Lock Panes View Tab > Freeze Panes > Lock Top Row Correct Incorrect Question 2 of 5 2. Question Which symbol ‘locks’ cells in place in a formula? # @ $ & Correct Incorrect Question 3 of 5 3. Question How do you calculate the Median? Sum all values in the dataset, then divide by total number of values. The middle value in an ordered dataset. The difference between the highest and lowest values in a dataset. The most commonly occurring value in the dataset. Correct Incorrect Question 4 of 5 4. Question Where can I quickly find aggregations of my selected cells? Formula bar Quick ribbon Data tab Status bar Correct Incorrect Question 5 of 5 5. Question Where is the Filter button located? Home Tab Data Tab View Tab Filter Tab Correct Incorrect