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?
Your score is