MS Excel Test 2 | Computer Awareness Free Online Tests | 20 MCQs with Answers

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?

To drag a selected range of data to another worksheet in the same workbook, use the?

Protection and the Protect Sheet options can be selected from?

To drag a selected range of data to another worksheet in the same workbook, use the?

You can check the conditions against ____ when applying conditional formatting?

Which function calculates your monthly mortgage payment?

VLOOKUP function used to?

You can activate a cell by?

A function inside another function is known as?

When you insert an Excel file into a Word document, the data are

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result