MS excel set 11 Detailed Explanation And More Example

Question : 1

In Excel to create a formula, you first

a) Select the cell you want to place the formula into

b) Type the equals sign (=) to tell Excel that you’re about to enter a formula

c) Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d) Choose the new command from the file menu

Question : 2

Tab scroll buttons are place on Excel screen

a) towards the bottom right corner

b) towards the bottom left corner

c) towards the top right corner

d) towards the top left corner

e) None of these

Question : 3

When you link data maintained in an excel workbook to a word document

a) The word document can not be edit

b) The word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

e) None of these

Question : 4

In Excel a fast way to add up this column of number is to click in the cell below the numbers and then

a) Click subtotals on the data menu

b) View the sum in the formula bar

c) Click the autosum button on the standard toolbar, then press enter

d) All of above

Question : 5

In Excel each excel file is called a workbook because

a) It can contain text and data

b) It can be modified

c) It can contain many sheets including worksheets and chart sheets

d) You have to work hard to create it

Question : 6

When you use the fill effects in the format data series dialog box, you can not

a) rotate text on the chart

b) select a fore ground color

c) select a pattern

d) select a background color

e) None of these