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