Computer Awareness MS Excel Online Test, Questions, Computer MCQ

How are data organized in a spreadsheet?

A worksheet range is a

With which of the following all formulas in excel starts?

How can we set Page Border in Excel?

On an excel sheet the active cell in indicated by?

What term describes explanatory text attached to a cell?

How do you change column width to fit the contents?

How we can view a cell comment?

Which of these will not select all the cells in a document?

To insert three columns between columns A and B you would

The default style for new data keyed in a new workbook is?

If you press ___, the cell accepts your typing as its contents?

Which of the following keyboard shortcut can be used for creating a chart from the selected cells?

Formula palette is used to?

A value used in a formula that does not change is called a?

To open an existing workbook, click the Open button on the ___ toolbar?

Which among following is not associated with spelling dialogue box?

What term describes a background that appears as a grainy, non smooth surface?

Which among following is associated with excel?

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

Which types of charts can excel produce?

What function displays row data in a column or column data in a row ?

Each excel file is called a workbook because

Gridlines may be turned off for display but turned on for printing.

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row is?

You can convert existing Excel worksheet data and charts to HTML document by using the?

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
HTML

Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?

A typical worksheet has _____ Number of columns

Macros can be executed from which of the following menu?