MS excel set 3 Detailed Explanation And More Example

Question : 1

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

e) None of these

Question : 2

To save a workbook, you:

a) Click the save button on the standard toolbar from the menu

b) Press Ctrl+F5

c) Click Save on the Windows Start button

d) Select Edit>Save

e) None of these

Question : 3

How can you show or hide the gridlines in Excel Worksheet?

a) Go to Tools >> Options > > View tab and mark or remove the check box named Gridline

b) Click Gridline tool on Forms toolbar

c) Both of above

d) Press F7

e) None of these

Question : 4

The intersection of a row and column is called :

a) data

b) afield

c) a cell

d) an equation

e) None of these

Question : 5

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts

e) None of these

Question : 6

In Excel advantage of using a spreadsheet is

a) calculations can be done automatically.

b) changing data automatically updates calculations

c) more flexibility

d) all of the above