MS excel set 8 Detailed Explanation And More Example

Question : 1

In Excel LEN function does what?

a) Compares the content in two cells

b) Counts the numbers of characters in a cell

c) Deletes extra space in text

d) All of above

Question : 2

Status indicators are located on the

a) Vertical scroll bar

b) Horizontal scroll bar

c) Formula bar

d) Standard toolbar

e) None of these

Question : 3

In Excel you can copy cell formats from one cell to another by using the

a) Backspace key

b) Default font

c) Format painter

d) Formatting toolbar

Question : 4

What happens when you press Ctrl + X after selecting some cells in Excel?

a) The cell content of selected cells disappear from cell and stored in clipboard

b) The cells selected are marked for cutting

c) The selected cells are deleted and the cells are shifted left

d) The selected cells are deleted and cells are shifted up

e) None of these

Question : 5

To open the Format Cells dialog box, press

a) Alt* 1

b) Ctrl + 1

c) Ctrl + Shift + 1

d) F1

e) None of these

Question : 6

How can you find specific information in a list?

a) Select Tools > Finder from the menu

b) Click the Find button on the standard toolbar

c) Select Insert > Find from the menu

d) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

e) None of these