49

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 ____

2 / 50

A surface chart uses Colors to distinguish the

3 / 50

A surface chart shows a _________surface that connects a set of data points

4 / 50

When there is a change in source data, use this option to update PivotTable data.

5 / 50

Filters applied to a PivotChart ______ the related PivotTable

6 / 50

If you change the data in the source worksheet, the PivotTable _______ automatically

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

8 / 50

Cell styles are saved with the workbook they are created in

9 / 50

Is it possible to use a custom cell style created in one workbook in another workbook by?

10 / 50

To be able to copy macros between two workbooks, both need to be open

11 / 50

To be able to merge copies of a workbook, they should be saved in a different folder from the original workbook

12 / 50

Password details of a workbook are stored in the metadata

13 / 50

To be able to remove password protection, you need to know the password

14 / 50

You want users to be able to edit only certain parts of your worksheet. Is this possible?

15 / 50

Can you merge scenarios from workbooks with different layouts?

16 / 50

You want to calculate your profit based on your sales and expenses figures. Will Goal Seek help you with this?

17 / 50

A cell contains the NOW () function. Is it possible to get the Year, Month and Date based on this

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

19 / 50

Slicers can be used to _______ PivotTable data

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

21 / 50

A surface chart is useful when you need to plot ______ dependent variable against _______ independent variables

22 / 50

Charts are used to emphasize different types of information in a chart by combining multiple chart types

23 / 50

A Bubble Chart is a variation of a ______ Chart

24 / 50

Wireframe Contour is a type of _______ chart

25 / 50

This is NOT a type of Scatter Chart

26 / 50

A scatter chart plots the values for ______ variable/s as a set of points on a graph.

27 / 50

You can make background areas in an Area chart visible by _______.

28 / 50

An Area Chart is an enhanced version of a _______ chart

29 / 50

Using__________ makes it easy to examine a range of possibilities on a single worksheet

30 / 50

____________work/s only with one or two variables, but can accept many different values for those variables

31 / 50

What-If Analysis tools allow you  to  

32 / 50

The TRIM function removes spaces from text

33 / 50

The LEN function returns the number of characters in a string 

34 / 50

This function allows you to extract a substring from a string, starting from the left-most character

35 / 50

This function returns the current date along with the current time

36 / 50

The function can be used to retrieve information such as contents

37 / 50

The MATCH function searches for a specified item in a range of cells and returns the  of that item in the range

38 / 50

You can open the "Function Arguments" window by clicking .

39 / 50

The MODE function returns 

40 / 50

In order to work correctly, a function must be written according to certain rules called 

41 / 50

A worksheet can have  custom views

42 / 50

To check spelling in another language, select the language in the .

43 / 50

This group in the Developer tab is used to insert Form Controls

44 / 50

A Group Box organizes a set of controls into 

45 / 50

A  control is used to increase or decrease a value within a defined range

46 / 50

You can add  to your worksheets by using Form Controls

47 / 50

When icon sets are used for conditional formatting, small ­­­­­­­____are displayed in the cells

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?

49 / 50

Which of the following is not a conditional formatting rule category?

50 / 50

Which of these will you use to separate data into multiple columns instantly?