MS Excel MCQs

A. 256

B. 1024

C. 32767

D. 65535

A. Format > window

B. View > window > split

C. Window > split

D. View > split

A. VisiCalc

B. Lotus 1-2-3

C. Excel

D. StarCalc

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

A. Extends a sequential series of data

B. Automatically adds range of cell values

C. Applies a boarder around the selected cells

D. All of the above

A. Multiplication and division exponentiation positive and negative values

B. Multiplication and division, positive and negative values, addition and subtraction

C. Addition and subtraction, positive and negative values, exponentiation

D. None of above

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit > Edit Cell from the menu

D. None of above

A. Copy cell contents

B. Move cell contents

C. Add cell contents

D. A and B both

A. Press the Alt key

B. Clicking the formula bar

C. Pressing the F2 key

D. Double clicking the cell

A. Delete the column from the worksheet

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

C. Select Data > Delete Record from the menu

D. Click the Delete button on the Standard toolbar