MS excel set 1 Detailed Explanation And More Example

Question : 1

In Excel accounting style shows negative numbers in

a) Quotes

b) Parentheses

c) Brackets

d) Bold

Question : 2

In Excel you can create only a horizontal page break by first selecting

a) A cell in column A

b) A row below the row where you want the page break to occure

c) A cell in row 1

d) (A) and (B)

Question : 3

In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004

a) Networkdays

b) Workday

c) Date

d) All of the above

Question : 4

In Excel you can use the drag and drop method to

a) Add cell contents

b) Copy cell contents

c) Move cell contents

d) (B) and (C)

Question : 5

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 : 6

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