Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/10
Score 0
What are the steps to sort data out on the MS Excel spreadsheet?
120
Select a Number in the Row you want to Edit. then Click the Sort & Filter Menu on the Edit tab. and then Select Sort A to Z, or select Sort Z to A.
Select the column you want to filter. then Click the clear Filter command on the Design tab. and then Select Sort A to W, or select Sort Z to Y.
Select a cell in the column you want to sort. then Click the Sort & Filter command on the Home tab. and then Select Sort A to Z, or select Sort Z to A.
Select a cell in the Table you want to remove. then Click the Sort & Filter button on the View tab. and then Select Sort A to A, or select Sort Z to Z.
Q 2/10
Score 0
What are the 3 Text formatting options we can use in MS Excel program?
60
Font Style, Font Color, and Font Size.
Font tag, Font button, and Font Menu.
Font Menu, Font Edit, and Font name.
Font Text, Font Number, and Font Box.
10 questions
Q.
What are the steps to sort data out on the MS Excel spreadsheet?
1
120 sec
Q.
What are the 3 Text formatting options we can use in MS Excel program?
2
60 sec
Q.
What is a Function used in the MS Excel 2007 program?
3
60 sec
Q.
Identify each Part of the following Excel formula " =SUM(B1:B9)"
4
60 sec
Q.
Which of the following is an example of an Excel statiscal function?
5
60 sec
Q.
What is a Table on the Excel program?
6
60 sec
Q.
How do you modify a Table using "Table Tools Design Tab" in the Excel 2007 program?
7
60 sec
Q.
How do you turn off the filtering arrows that appear on an Excel table ?
8
60 sec
Q.
What are the 2 types of sorting we use to organize data on MS Excel program?