How are data organized in a spreadsheet ?

Charts can be embedded in Excel sheet

In Excel, by default, the numbers are left aligned and text values are right aligned.

In EXCEL, a formula starts with =.

Microsoft Excel ignores manual page breaks when you use the Fit to option of the Page Setup.

Spreadsheet file cannot be protected by password.

Text function is used for ?

In Excel, standard width of a column is 18.43

The ____ feature of MS Excel quickly completes a series of data

=ROUND(2.15,1) entered in a cell displays

The Cell/range names are case sensitive.

When you copy a formula in Excel, relative cell references do not change ?

When you create a chart on a separate sheet in the same workbook it is called a

Which of the following you can paste selectively using Paste Special command ?

You can not move the active cell within a selected range.

It is possible to protect an Excel sheet using password.

Extension of Excel file is...

To print only part of your Excel worksheet, change the size of the font.

The following is not a valid Cell Address.

The cancel and Enter buttons appear in the Formula bar.

While working you may have to reference data from more than one sheet which is called referencing multiple sheets.

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid ?

What happens if you do not apply = before formula in MS Excel ?

The AutoSum button on the Standard toolbar automatically creates a formula to total rows and columns or rows.

To open the Format Cells dialog box, press

Data can be arranged in ascending or descending order by using Sort command from Data Table Short

Pie chart can represent multiple series of data.

= What will be the value of Ceiling (97,7) ?

The basic unit of a worksheet in which you enter the data in Excel is called a

The Insert tab lets you add special ingredients like tables, graphics, charts, and hyperlinks in a spreadsheet program.

Hold down Ctrl key while selecting non adjacent cells

All functions begin with the formula prefix

What are the columns in a Microsoft access table called ?

Standard width of a column is 18.43

What type of chart will you use to compare performance of two employees in the year 2016 ?

To select a column in excel the easiest method is to ?

The function ROUND(1343.45,-2) returns

A workbook is a grid with labeled columns and rows

Tabs that appear at the bottom of each workbook is called sheet tabs.

You cannot turn off grid lines.

The data to be drawn as a chart cannot be selected after the chart wizard is started.

It is possible to undo the deletion of a sheet.

To select several cells or ranges that are not touching each other, you would … while selecting

The text that appears in the bottom margin of the page is called as the Footer

Cylinder,cone, and pyramid are all chart types.

A1 is an example of an absolute cell reference

In Excel, Columns are labelled as ___

The cell reference for cell range of G2 to M12 is

On an excel sheet the active cell in indicated by ?

To display the current time, the TIME() function can be used.

To set the contents of a cell in right alignment Ctrl+R is used.

If the Bold and Underline buttons are appearing lighter than before, it means that they are currently in use.

An Excel file is generally called

In a Spreadsheet you cannot refer contents of another worksheet.

While Finding and Replacing some data in Excel, which of the following statement is valid ?

To display the current time, the TIME() function can be used.

A collection of worksheets is called as

In Excel, standard width of a column is 8.43

The way to convert relative positioning to absolute positioning is to put a $ sign after each element in the cell address that should not change.

Formatting a cell in Number format you can not set

Maximum width of a cell is 12.75 pt

You can sort a table by columns.

You cannot move or copy sheets from one workbook to another

To display the current time, the TIME() function can be used.

What is the intersection of a column and a row on a worksheet called ?

The box on the chart that contains the name of each individual record is called the axis.

Formatting is the process of changing the appearance of the data in a Worksheet.

=SUM(Sheet2:Sheet13!B5) adds all the values contained in cell B5 on all the worksheets between and including Sheet 2 and Sheet 13

Which of the following is not a valid Zoom percentage in Excel ?

The box on the chart that contains the name of each individual record is called the axis.

When the formula bar is activated, you can see

Sales is a valid name for a cell or a range.

Excel cannot insert multiple rows in its sheet.

In MS Excel Header & Footer are displayed in Page Break Preview

Each excel file is called a workbook because

Hyperlinks cannot be

3-D charts have a category (x) axis a value (y) axis and a third (z) axis

It is possible to undo the deletion of a sheet.

The formula used in excel to find Remainder

Short cut key for go to Previous Cell

=sum(A1.A10) is valid formula.

Which of the following is a chart type present in MS Excel

Arithmetic calculations can be done in Excel

When a formatted number does not fit within a cell, it displays

Red triangle at the top right corner of a cell indicates

In Excel you can indicate absolute references by a hash sign (#)

Which function in Excel checks whether a condition is true or not ?

You can copy data or formulas

In Excel, it is not possible to select two non-adjacent ranges at a time.

Date and Time are internally stored as serial number in EXCEL.

Maximum width of a cell is 12.75

Spreadsheets are created in ?

The name box is at the left end of the formula bar

The Formula Bar is at the left end of the formula bar

What does SUMIF function do ?

What will be the value of mod (50, -7) ?

The default page orientation in Excel is

A features that displays only the data ,according to specified criteria

You can check the conditions against __________ when applying conditional formatting

Pie chart can represent multiple series of data.