Ci Quiz

Which is not a function in MS Excel

• SUM

• AVG

• MAX

• MIN

On an Excel Sheet, the active cell is indicated by?

• A Blinking Border

• A Dotted Border

• A Dark Wide Border

• By Italic Text

To create an interactive Pivot table for the web, you use a MS office Web Component called?

• HTML

• Pivot Table Field List

• Pivot Table List

• Pivot Table Report

Which key is used to "Goto" tab in MS Excel?

• F9

• F7

• F6

• F5

How can we set Page Border in Excel?

• From Home

• From Edit Menu

• You can not set Page Border in Excel

• From Tools Menu

Which of these keys are used in MS Excel to Copy Value from above cell?

• Ctrl+ ;

• Ctrl+ "

• Ctrl+ :

• Ctrl+ D

___________function in excel tells how many numeric entries are there.

• NUM

• SUM

• COUNT

• CHKNUM

To minimize workbook in MS Excel

• Ctrl + F9

• Ctrl + F8

• Ctrl + F7

• Ctrl + F6

The maximum number of rows in a worksheet is (xls file format)

• 1,084,657

• 1,048,756

• 1,084,675

• 1,048,576

The maximum number of columns in a worksheet is (xls file format)

• 15,834

• 16,384

• 17,534

• 15,384