MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel all worksheet formula

a) Use the addition operator

b) Return a formula result

c) Manipulate labels

d) Manipulate values

Question : 2

In Excel how can you delete a record?

a) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

b) Select Data > Delete Record from the menu

c) Click the Delete button on the Standard toolbar

d) Delete the column from the worksheet

Question : 3

In Excel you can group noncontiguous worksheets wit

a) The shift key and the mouse

b) The group button on the standard toolbar

c) The alt+enter key

d) The ctrl key and mouse

Question : 4

In Excel when working in the page break preview, you can

a) Add or remove page breaks

b) View exactly where each page break occurs

c) Change the print area

d) All of above

Question : 5

In Excel….. is a group of cells that form a rectangle on the screen.

a) Range

b) Calculation

c) Range address

d) Formula

Question : 6

In Excel Status indicators are located on the

a) Horizontal scroll bar

b) Vertical scroll bar

c) Formatting toolbar

d) Formula bar