Microsoft Excel Quiz 0% 1 votes, 5 avg 0 Exam Microsoft Excel 1 / 20 11. The Greater Than sign (>) is an example of _____ operator. B. Logical C. Conditional D. Greater A. ArithmaticB. Logical C. ConditionalD. Greater 2 / 20 What type of chart is useful for comparing values over categories ? Line Chart Pie Chart Column Chart Dot Graph 3 / 20 15. What type of chart is useful for comparing parts of a whole ? D. Dot Graph A. Pie Chart B. Column Chart C. Line Chart 4 / 20 What is the intersection of a column and a row on a worksheet called ? Column Cell Value AddressD 5 / 20 Which function in Excel checks whether a condition is true or not ? SUM IF AVERAGE COUNT 6 / 20 Which functioning Excel tells how many numeric entries are there ? COUNT SUM NUM CHKNUM 7 / 20 18. How many sheets are there, by default, when we create a new Excel file ? B. 3 A. 1 C. 5 D. 10 8 / 20 Which one is not a Function in MS Excel ? SUM AVG MAX MIN 9 / 20 Functions in MS Excel must begin with ___ A Plus Sign A > Sign An () sign An Equal Sign 10 / 20 In Excel, Columns are labelled as ___ 1,2,3 etc A1, A2, etc A, B, C etc $A$1, $A$2, etc. 11 / 20 14. The ____ feature of MS Excel quickly completes a series of data B. Auto Fill C. Fill Handle A. Auto Complete D. Sorting 12 / 20 13. The process of arrenging the items of a column in some sequence or order is known as : B. Autofill C. Sorting A. Arrengin D. Filtering 13 / 20 19. An Excel file is generally called a / an : A. E-Spreadsheet C. Workbook D. Sheet B. Woorksheet 14 / 20 20. What type of chart will you use to compare performance of sales of two products ? tB. Line Chart C. Pie Chart D. Both A and B A. Column Char 15 / 20 17. The basic unit of a worksheet into which you enter data in Excel is called a B. table C. box D. column A. cell 16 / 20 A features that displays only the data in column (s) according to specified criteria Filtering Pivot Sorting Formula 17 / 20 Functions in MS Excel must begin with ___ A Plus Sign A > Sign An () sign An Equal Sign 18 / 20 Statistical calculations and preparation of tables and graphs can be done using Notepad Power Point Excel Adobe Photoshop 19 / 20 12. What type of chart is useful for showing trends or changes over time ? B. Column Chart C. Line Chart D. Dot Graph A. Pie Chart 20 / 20 16. In Excel, Rows are labelled as ______ B. 1,2,3 etc D. $A$1, $A$2, etc. C. A1, A2, etc. A. A, B, C, etc NamePhone Number Your score isThe average score is 0% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Please click the stars to rate the quiz Send feedback Posted on: August 7, 2018, by : admin Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment * Name * Email * Website Save my name, email, and website in this browser for the next time I comment.