Microsoft Excel Set – 1

Excel is a ____ program developed by Microsoft.

What is the extension of a Microsoft Excel file?

 What is the default file name of Microsoft Excel file?

Shortcut key CTRL + D is used to ____.

What is the collection of worksheets called?

 The total number of rows in a worksheet?

 The total number of columns in a worksheet?

What is the column width in a worksheet?

The total number of characters that a cell contains is?

How many hyperlinks can be there in a worksheet?

 How many times undo levels can be used in a worksheet?

How many users can open the Excel file at the same time?

The intersection of a column and a row in a worksheet is called ____.

The fill function can be ____ to complete formulas in a range.

 What is the keyboard shortcut to insert a SUM formula in MS Excel?

 Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

 Which option is used to hide/show the Headings in MS Excel?

Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

Which function is used to find the sum of complex numbers in MS Excel?

What is the keyboard shortcut to switch between open Excel windows?

 What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?

 What is the keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar in MS Excel?

What is the keyboard shortcut to view formulas instead of values in MS Excel?

 Which symbol is used to specify the fixed columns or rows in the formula?