MS excel set 4 Detailed Explanation And More Example

Question : 1

Which of the following special function keys allow the content in cell

a) esc

b) shift

c) return

d) Tab

e) None of these

Question : 2

How can you remove borders applied In cells?

a) Choose None on Border , tab of Format cells

b) Open the list on Border tool in Formatting toolbar then choose first tool (no border)

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

While Finding and Replacing some data in Excel, which of the following statement is valid?

a) You can Find and Replace within the sheet or workbook

b) Excel does not have option to match case for find

c) Excel cannot replace

d) All of above

e) None of these

Question : 5

In Excel you can zoom a worksheet

a) With the mouse pointer in Print Preview

b) With the zoom button on the Print Preview toolbar

c) With the Zoom command on the view menu

d) All of the above

Question : 6

What Is the short cut key to highlight the entire column?

a) Ctrl+C

b) Ctrl+Enter

c) Ctrl+PageUp

d) Ctrl+SpaceBar

e) None of these