MS excel set 10 Detailed Explanation And More Example

Question : 1

We can save and protect 1he workbook by

a) Write Reservation Password

b) Protection Password

c) Read-only Recommended

d) Any of the above

e) None of these

Question : 2

Merge cells option can be applied from

a) Format Cells dialog box Alignment Tab

b) Formatting toolbar

c) Both of above

d) All of above

e) None of these

Question : 3

How are data organized in a spreadsheet?

a) Lines and spaces

b) Layers and planes

c) Rows and columns

d) Height and width

e) None of these

Question : 4

Which types of charts can excel produce?

a) Line graphs and pie charts only

b) Only line graphs

c) Bar charts, line graphs and pie charts

d) Bar charts and line graphs only

e) None of these

Question : 5

Which of the following types of tables constraints will prevent the entry of duplicate rows?

a) Primary key

b) Unique

c) Null

d) Foreign key

e) None of these

Question : 6

In Excel when a label is too long to fit within a worksheet cell, you typically must

a) Shorten the label

b) Increase the column width

c) Decrease the column width

d) Adjust the row height