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