MS excel set 1 Detailed Explanation And More Example

Question : 1

Which area in an excel window allows entering values and formulas ?

a) Formula bar

b) Title bar

c) Standard toolbar

d) Menu bar

Question : 2

In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu

a) Tools

b) Edit

c) Data

d) Format

Question : 3

In Excel when you want to insert a blank imbedded excel object in a word document you can

a) Click the office links button on the standard toolbar

b) Click the object command on the insert menu

c) Click the import excel command on the file menu

d) Click the create worksheet button on the formatting toolbar

Question : 4

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

In Excel accounting style shows negative numbers in

a) Quotes

b) Parentheses

c) Brackets

d) Bold

Question : 6

In Excel the view that puts a blue a blue line around each page that would be printed is the

a) Split View

b) Page Break Preview

c) Normal View

d) Print Preview