Computer Science Quiz Test 4 Start your test Q1. How many sheets are there, by default, when we create a new Excel file? A.1 B.3 C.5 D.10 None Q2. In Excel, which one denoted a range from B1 through E5 A. B1 - E5 B. B1:E5 C. B1 to E5 D. B1$E5 None Q3. An Excel file is generally called a / an: A. E-Spreadsheet B. Woorksheet C. Workbook D. Sheet None Q4. It is a collection of data that is stored electronically as a series of records in a table. A.spreadsheet B.presentation C.database D.MS Word None Q5. What type of chart will you use to compare performance of sales of two products? A.Column Chart B.Line Chart C.Pie Chart D.Both A and B None Q6. The Greater Than sign (>) is an example of _____ operator. A. Arithmetic B. Logical C. Conditional D. Greater None Q7. What type of chart is useful for showing trends or changes over time? A.Pie Chart B.Column Chart C.Line Chart D.Dot Graph None Q8. The process of arrenging the items of a column in some sequence or order is known as: A. Arranging B. Autofill C. Sorting D. Filtering None Q9. The ____ feature of MS Excel quickly completes a series of data A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting None Q10. What type of chart is useful for comparing parts of a whole? A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph None Q11. What is the intersection of a column and a row on a worksheet called? A.Column B.Value C.Address D.Cell None Q12. What type of chart is useful for comparing values over categories? A.Pie Chart B.Column Chart C.Line Chart D.Dot Graph None Q13. Which functionin Excel tells how many numeric entries are there? A.NUM B.COUNT C.SUM D.CHKNUM None Q14. A features that displays only the data in column (s) according to specified criteria A.Formula B.Sorting C.Filtering D.Pivot None Q15. Statistical calculations and preparation of tables and graphs can be done using A.Adobe Photoshop B.Excel C.Notepad D.Power Point None Q16. In Excel, Rows are labelled as ______ A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc. None Q17. What do you use to create a chart? A.Pie Wizard B.Excel Wizard C.Data Wizard D.Chart Wizard None Q18. How will you graphically represent expenditure in different departments? A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart None Q19. What type of chart is good for single series of data? A. Column Chart B. Line Chart C. Pie Chart D. Cone Chart None Q20. The basic unit of a worksheet into which you enter data in Excel is called a A.cell B.table C.box D.column None Q21. What type of chart will you use to compare performance of two employees in the year 2016? A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart None Q22. Which one is not a Function in MS Excel? A. SUM B. AVG C. MAX D. MIN None Q23. Functions in MS Excel must begin with ______. A. An () sign B. An Equal Sign C. A Plus Sign D. A > Sign None Q24. Which functionin Excel checks whether a condition is true or not? A. SUM B. COUNT C. IF D. AVERAGE None Q25. In Excel, Columns are labelled as ______. A. A, B, C, etc. B. 1,2,3 etc. C. A1, A2, etc. D. $A$1, $A$2, etc. None Time's upTime is Up!
