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