MS Excel MCQs

Which elements of a worksheet can be protected from accidental modification

1. Scenarios
2. Objects
3. Contents
4. All of the above

Getting data from a cell located in a different sheet is called

1. Accessing
2. Referencing
3. Updating
4. none

How do you display current date and time in MS Excel ?

1. Date ()
2. Today ()
3. Year ()
4. Now ()
5. Time ()

In a computer spreadsheet rows are labeled:

1. By letters
2. By numbers
3. By cell references
4. By symbols
5. None of these

User developed instruction for excel are called___?

1. Procedured
2. Macros
3. Programs
4. None

Which of following is not an element of computer spreadsheet interface ?

1. Pencil work
2. Active cell
3. Menu bar
4. None

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

1. Clicking three times with the right mouse button in the spreadsheet
2. both
3. Using the Edit- Select all menu
4. None

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

1. Comma
2. Normal
3. Currency
4. percent

Which command will you choose to convert a column of data into row?

1. Paste Special > Transpose
2. Cut and Paste
3. Special
4. none

Instructions are written in machine language as

1. Binary Code
2. English Code
3. Link Code
4. None of these