MS Excel MCQs

What are the basic rectangular building blocks of a spreadsheet?

1. cells
2. zoom slider
3. help button
4. all

Which of the following is not a term pertaining to spreadsheets?

1. cell
2. character
3. browser
4. formula

Which of following is not true regarding conditional formatting?

1. You can set condition to look for Bold and apply Italics on them
2. You can add more than one condition to check
3. You can apply Font, border and pattern formats that meets the specified conditions
4. None of these

in Microsoft Excel template is the combination of different ___?

1. Colors
2. Effects
3. Fonts
4. All of these

… is a standard Windows control that displays the percentage of completion of a particular process as a graphical bar?

1. Progress Bar
2. Address bar
3. Menu bar
4. None

In a spreadsheet, letters are used to represent _____

1. Columns
2. Rows
3. Cells
4. None

In Excel, which is used to perform what if analysis ?

1. Goal seek
2. Solver
3. Scenario Manager
4. All of above

Microsoft Excel functions arguments are always written in __ ?

1. Rows
2. Cells
3. Columns
4. Parentheses

the command used to apply look of one piece of text to other parts of text documents.

1. Copy
2. Past
3. Format Painter
4. None of these

___ displays the content of active cell?

1. Row headings
2. Name box
3. Formula bar
4. None