Basic Excel

What is MS Excel?

• System software

• Driver software

• Malware

• Spreadsheet Software

Which place shows the cell address?

• Formula Bar

• Title Bar

• Name Box

• Active Cell

Shortcut key to insert new worksheet is

• Ctrl+F10

• Shift+F11

• Alt+F9

• Shift+F10

Absolute cell reference uses which sign

• $

• +

• =

• &

The shortcut key to edit a cell is

• F2

• F4

• F5

• F11

The total number of rows in a worksheet is

• 16,384

• 12,49,576

• 10,48,576

• 11,48,576

The last column name in a worksheet is

• XFD

• FXD

• DFX

• FXD

The default file extension of an excel file is

• .xls

• .xlsx

• .lsx

• .xslx

The shortcut key to return to the first cell in a worksheet is

• Ctrl+Backspace

• Ctrl+Page Up

• Ctrl+Home

• Ctrl+Up Arrow

To insert a column between Column B & C, Which column is to be selected first?

• B

• C

• Both

• Any Cell