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
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- 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
10 questions
Show answers
- Q1What 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
- Q2What 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
- Q3What 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
- Q4Identify 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
- Q5Which of the following is an example of an Excel statiscal function?AVERAGE.CURRENCYPERCENTAGETOTAL60s
- Q6What 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
- Q7How 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
- Q8How 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
- Q9What 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 onlyAscending order ( A --> Z ) and Descending order ( Z --> A )60s
- Q10What does the image specify?Remove Filter.Add Filter.Sort & Filter command.Select all Filterings.60s