In a Line Chart, the X axis displays _____ while in a Scatter Chart, the X axis displays ____

A surface chart uses Colors to distinguish the

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

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

Filters applied to a PivotChart ______ the related PivotTable

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

When you conditionally format a PivotTable, you can apply rules to the _______ of the PivotTable itself so that the formatting accurately responds to changes

Cell styles are saved with the workbook they are created in

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

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

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

Password details of a workbook are stored in the metadata

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

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

Can you merge scenarios from workbooks with different layouts?

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

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

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

Slicers can be used to _______ PivotTable data

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

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

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

A Bubble Chart is a variation of a ______ Chart

Wireframe Contour is a type of _______ chart

This is NOT a type of Scatter Chart

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

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

An Area Chart is an enhanced version of a _______ chart

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

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

What-If Analysis tools allow you  to  

The TRIM function removes spaces from text

The LEN function returns the number of characters in a string 

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

This function returns the current date along with the current time

The function can be used to retrieve information such as contents

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

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

The MODE function returns 

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

A worksheet can have  custom views

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

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

A Group Box organizes a set of controls into 

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

You can add  to your worksheets by using Form Controls

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

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?

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

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