MS Excel MCQs

which of these keys are used in ms excel to copy values from the above cell?

1. ctrl +
2. ctrl F
3. ctrl S
4. ctrl D

which of the following is a correct cell address?

1. AA
2. 5C
3. 38,7
4. C5

In MS excel, a ___ identifies a range by the cells located at diagonally opposed corners.

1. Range
2. Range Address
3. Cell
4. None of these

In MS Excel window, on the bottom, right area of the spreadsheet there is/are:

1. Horizontal scroll bar
2. Zoom tool
3. Page view commands
4. All of these

which of the following is not a valid Zoom percentage in Excel?

1. 100
2. 200
3. 500
4. None

In Microsoft Excel, the file you create and edit is called?

1. A form
2. A ledger
3. A Work Book
4. A Table

In MS Excel; comments put in the cell are called----

1. Smart tip
2. Vip tip
3. Soft tip
4. None

In MS Excel, Conditional Formatting is in ___ tab?

1. Home
2. View
3. Page Layout
4. Insert

A numeric value can be treated as label value if it is precedes with

1. Apostrophe
2. Exclamation
3. Hash
4. Ampersand

In chart wizard, term data series refers to

1. A chart legend
2. A collection of chart data markers
3. A data label
4. None