2nd Semester_ Computer Quiz-2__ 7th Grade

QuizÂ by Ustaz Yonis

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

• edit the questions
• save a copy for later
• start a class game
• automatically assign follow-up activities based on studentsâ€™ scores
• assign as homework
• share a link with colleagues
• print as a bubble sheet

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

10 questions
• Q1
What are the steps to sort data out on the MS Excel spreadsheet?
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.
120s
• Q2
What are the 3 Text formatting options we can use in MS Excel program?
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.
60s
• Q3
What is a Function used in the MS Excel 2007 program?
A function is a preset formula in Excel Spreadsheet.
A function is a preset editing in Excel Spreadsheet.
A function is a preset animation in Excel Spreadsheet.
A function is a preset naming in Excel Spreadsheet.
60s
• Q4
Identify each Part of the following Excel formula " =SUM(B1:B9)"
= email sign, SUM is a formula, ( ) brackets B1:B9 Arrangement.
= email sign, SUM is a name, ( ) equal sign, B1:B9 letters and numbers.
= Equals sign, SUM is a Function, ( ) Parantheses B1:B9 Arrguments.
= equals sign, SUM is active cell, ( ) brackets, B1:B9 letters and signs.
60s
• Q5
Which of the following is an example of an Excel statiscal function?
AVERAGE.
CURRENCY
PERCENTAGE
TOTAL
60s
• Q6
What is a Table on the Excel program?
It is a series of active cells consisted of columns and columns that typically contains related data.
It is a series of name box consisted of rows and worksheet that typically contains related data.
It is a series of worksheet consisted of rows and columns that typically contains related data.
It is a series of workbook consisted of active cells and columns that typically contains related data.
60s
• Q7
How do you modify a Table using "Table Tools Design Tab" in the Excel 2007 program?
We can Graph a Total Row in the Table Format Options group.
We can Write a Total Row in the Table Design and Options group.
We can Insert a Total Row in the Table Styles Options group.
We can Graph a Total Row in the Table Font style Options group.
60s
• Q8
How do you turn off the filtering arrows that appear on an Excel table ?
You select the Edit tab, click the Sort & Filter command, and select Filter from the numbers.
You select the Design tab, click the Sort & Filter command, and select Filter from the numbers.
You select the View tab, click the Sort & Filter command, and select Filter from the numbers.
You select the Home tab, click the Sort & Filter command, and select Filter from the list.
60s
• Q9
What are the 2 types of sorting we use to organize data on MS Excel program?
Forms (A --> F) and Reports (F-->A)
You can organize data in a column A to Column Z.
You can organize data in a Report only
Ascending order ( A --> Z ) and Descending order ( Z --> A )
60s
• Q10
What does the image specify?
Remove Filter.