CA ITT MS Excel Online Test, CA ITT Question and Answers in English

VBA stands for ______________________.

The Excel 2007 worksheet contains _______ columns.

MS Excel 2007 displays ____ worksheets by default.

A cell reference in a spreadsheet can refer to _________________.

In Excel, a cell on a different sheet of the same spreadsheet is addressed as
_______________.

Full form of OLE is __________________.

Keyboard shortcut to show a shortcut menu in Excel, is _______________.

Excel gives a ______ extension to the template file.

Which function is used in Excel to enter current date?

To delete selected rows in Excel 2007, click the arrow next to Delete in Cells group in
Home tab, and then click ______________.

Keyboard shortcut to save a workbook in Excel, is _____.

In MS Excel, references to cells in other workbooks are called _____.

In Excel, when E$5 is copied down or across, the _________ reference can change.

Which of these is a valid range name in Excel?

How to name a range in Excel?

Which operator is used for exponentiation in Excel?

In Excel, ____ are structured programs that calculate a specific result.

In Excel, FACT(2.9) returns __________.

In Excel, LOG function returns the ________________.

In Excel, MROUND(1.3, 0.2) returns _______.

In Excel, __________ returns the average of the absolute deviations of data points from
their mean.

In Excel, ___ error message is given if the formula contains a blank cell.

In Excel, _________ error message is given if the formula contains text that Excel doesn’t
recognize.

To manually calculate all the formulas in a worksheet, press _______.

To have column and row headings visible while scrolling the worksheet,
_______________ feature is used.

If a cell is formatted as Accounting in Excel, zero values are shown as ________.

By default, MS-Excel aligns error values in the ________.

If cells A2, A3, B2 and B3 in a worksheet are merged, the cell reference for the merged
cell is _______.

Which of the following is not a chart type in Excel?

In MS-Excel, a 3-D column chart uses three axes – a horizontal axis, a vertical axis, and a
________ axis.

In which of the following situations, Excel’s pie chart should be used?

In a clustered bar chart in Excel, the ___________ are typically organized along the
vertical axis.

In which of the following situations, Excel’s XY charts are not required to be used?

Volume-open-high-low-close subtype of stock charts in Excel, requires _____ series of
values.

In Excel, a 3-D surface chart displayed without color is called a ___________ 3-D surface
chart.

In Excel, if user wants to create a hyperlink to a specific location in the file or on the Web
page, click _________.

When a record is deleted using a data form in Excel, __________.

In Excel, the user can sort up to _____ levels using the Data Sort dialog box.

In Excel, the default criteria setting for AutoFilter in each field is _______.

External data source for an Excel workbook can be __________.

Which of the following cannot store connection information of an external data source in
Excel?

A _____________ in Excel, summarizes the columns of information in a database in
relationship to each other.

In Excel, pivot charts don’t have _________________.

Excel’s default margins are _______ on each side.

Macros option is in Code group of ________ Ribbon in Excel.

In Excel, a ___________ is a grid made up of horizontal rows and vertical columns.

In Excel, an absolute cell reference is indicated by prefixing the row and column numbers
with ________.

Keyboard shortcut for Auto Fill in Excel, is ____________.

By default, Excel range names use ___________ cell references.

In Excel, INT(-5.7) returns __________.

In _______ function in Excel, text and logical values are compared as well as numbers.

While tracing precedents of a cell in Excel, if the cell is referenced by a cell on another
worksheet or workbook, a _________ arrow points from the selected cell to a worksheet
icon.

To apply a gradient or texture to selected cells in a worksheet, use _________________.

In Excel, the _______ charts emphasize the magnitude of change over time.

Which of the following is not a chart subtype of Excel’s radar charts?

In Excel, a macro’s series of commands and functions are stored in
___________________.

OLAP stands for ________________________.

In Excel, a macro can be accessed using ___________.

Excel’s ______________ feature doesn’t work with the data form.

A __________ is used in Excel, to select records that meet a specific criterion and
temporarily hide all the other records.