22 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Advanced Excel INSTRUCTIONS 1. Candidates are informed that they are liable for punishment for involvement in Malpractice. 2. Click on Start Examination button to start the examination. 3. All the questions of a particular type in a particular level will be displayed in a vertically scrolled window for online exam. 4. Candidate must Click the Submit Answer button displayed after every question, after selecting the option so as to submit the answer. 5. Examination can be terminated by clicking on End Examination button. It will be automatically terminated if the total time set to solve the exam is over. 1 / 50 In a Line Chart, the X axis displays _____ while in a Scatter Chart, the X axis displays ____ categories, values values, categories 2 / 50 A surface chart uses Colors to distinguish the DATA SEREIS VALUES 3 / 50 A surface chart shows a _________surface that connects a set of data points Two-dimensional Flat Three-dimensional 4 / 50 When there is a change in source data, use this option to update PivotTable data. Pivot table Tools > Analyse Tab > Data Group > Refresh Pivot table Tools > Analyse Tab > Data Group > Update 5 / 50 Filters applied to a PivotChart ______ the related PivotTable Effect Do not affect 6 / 50 If you change the data in the source worksheet, the PivotTable _______ automatically Updates Does not update 7 / 50 When you conditionally format a PivotTable, you can apply rules to the _______ of the PivotTable itself so that the formatting accurately responds to changes values source structure 8 / 50 Cell styles are saved with the workbook they are created in Built-in custom 9 / 50 Is it possible to use a custom cell style created in one workbook in another workbook by? Copying the style Linking the workbooks 10 / 50 To be able to copy macros between two workbooks, both need to be open True False 11 / 50 To be able to merge copies of a workbook, they should be saved in a different folder from the original workbook True False 12 / 50 Password details of a workbook are stored in the metadata True False 13 / 50 To be able to remove password protection, you need to know the password True False 14 / 50 You want users to be able to edit only certain parts of your worksheet. Is this possible? Yes No 15 / 50 Can you merge scenarios from workbooks with different layouts? Yes No 16 / 50 You want to calculate your profit based on your sales and expenses figures. Will Goal Seek help you with this? Yes No 17 / 50 A cell contains the NOW () function. Is it possible to get the Year, Month and Date based on this Yes No 18 / 50 You can copy a macro created in one workbook to another workbook using the Project Explorer Pane. The Ribbon option used to display this is Home tab> clipboard group> copy Developer tab> copy group>macros Data tab> get external data group> existing connection Developer tab> code group> visual basic 19 / 50 Slicers can be used to _______ PivotTable data Sort Summarize Filter Enhance 20 / 50 A _________ Chart plots the values of each category along a separate axis that starts in the centre of the chart and ends on the outer ring Scatter Radar Surface Bubble 21 / 50 A surface chart is useful when you need to plot ______ dependent variable against _______ independent variables One, three Two, three Two, one One, two 22 / 50 Charts are used to emphasize different types of information in a chart by combining multiple chart types Combination Joint Double Couple 23 / 50 A Bubble Chart is a variation of a ______ Chart Line Column Scatter Pie 24 / 50 Wireframe Contour is a type of _______ chart Scatter Surface Bubble Stock 25 / 50 This is NOT a type of Scatter Chart Scatter with Smooth Lines Scatter with Straight Lines Scatter with Straight Lines and Markers Scatter with Plain Lines 26 / 50 A scatter chart plots the values for ______ variable/s as a set of points on a graph. One Two Three Four 27 / 50 You can make background areas in an Area chart visible by _______. making background areas transparent making foreground areas transparent making background areas opaque making foreground areas opaque 28 / 50 An Area Chart is an enhanced version of a _______ chart Line Bar Column Pie 29 / 50 Using__________ makes it easy to examine a range of possibilities on a single worksheet SCENARIOS CSTOME VIEWS DATA TABLES GOAL SEEK 30 / 50 ____________work/s only with one or two variables, but can accept many different values for those variables SCENARIO GOAL SEEK DATA TALES IF 31 / 50 What-If Analysis tools allow you to Apply filters to data Validate data See how changed values affect the outcomes of formulas Represent dada in visual form 32 / 50 The TRIM function removes spaces from text Including Excluding Extra All 33 / 50 The LEN function returns the number of characters in a string Including Excluding Validate data Apply filters to data 34 / 50 This function allows you to extract a substring from a string, starting from the left-most character LEN LOWER FIND LEFT 35 / 50 This function returns the current date along with the current time TODAY () NOW () DATE() DAY() 36 / 50 The function can be used to retrieve information such as contents Format Size Content Cells 37 / 50 The MATCH function searches for a specified item in a range of cells and returns the of that item in the range Position Value Bar cell 38 / 50 You can open the "Function Arguments" window by clicking . Fx The formula bar The name box The tick mark 39 / 50 The MODE function returns The most frequently occurring value in a range of numeric data The mode in which the worksheet is opened The most frequently occurring value in a range of alphabetic data The mode property of the worksheet as displayed on the file tab 40 / 50 In order to work correctly, a function must be written according to certain rules called Groups Guidelines Syntax Methods 41 / 50 A worksheet can have custom views Unlimited Maximum 5 Maximum 4 Maximum 6 42 / 50 To check spelling in another language, select the language in the . Help language box on the language page of the excel options window Screen tip language box on the language page of the excel option window Display language box on the language page of the excel option window Dictionary language box on the proofing page of the excel option window 43 / 50 This group in the Developer tab is used to insert Form Controls Insert Forms Controls Styles 44 / 50 A Group Box organizes a set of controls into A sorted list A group of charts A single element A set of formulas 45 / 50 A control is used to increase or decrease a value within a defined range Command button List box Group box Spin button 46 / 50 You can add to your worksheets by using Form Controls Formulas Filters Interactivity Conditional formatting 47 / 50 When icon sets are used for conditional formatting, small ____are displayed in the cells Charts Bars Graphics Lines 48 / 50 You have the marks of 50 students in an Excel sheet. You want to highlight the 3 highest scorers. Which conditional formatting rules should you use? Highlight Cells Rules Color Scales Data Bars Top/Bottom Rules 49 / 50 Which of the following is not a conditional formatting rule category? Highlight Cells Rules Left/Right Rules Data Bars Icon Sets 50 / 50 Which of these will you use to separate data into multiple columns instantly? Fill Handle Flash Fill Filtering Sorting Your score is LinkedIn Facebook Twitter VKontakte