Solved bca assignment: Computer Fundamentals

Showing posts with label Computer Fundamentals. Show all posts

Friday, 1 March 2013

08:14 -

Write short note on A) Cell and Cell Address B) Status Bar in MS-Excel

A) Cell and Cell Address

Ø Cell: In Excel the intersection of a column and a row is called as a cell . Each cell has a name or cell address. A cell is basic block of MS Excel. It hold data and formulas in tabular format. In a worksheet there has 65536 row and 256 columns.

The total cells in a worksheet are 256*65536 =16777216

Wednesday, 27 February 2013

23:03 -

Computer Fundamentals

Discuss the three methods available to open a new blank document in MS-Word.

There are three methods available to open a new blank document in MS-Word.

All the three methods are easy to open a blank document but the third one is more easy.

These three methods are as follow:

1. Use of New Blank Document button on standard tool bar:

Click the New button that is there on the Standard Tool Bar and we will get the new blank document.

22:44 -

Computer Fundamentals

Explain Single User, Multi User and Batch Processing System.

Operating System is system software. This is software acts as an interface between the user and the computer. It also controls and coordinates different operations of computer. These operating systems are categorized of basis of users and their tasks.

Single user:

a) Single user, Single Task: As the name implies, this operating system is designed to manage the computer so that one user can effectively do one thing at a time. The Palm OS for Palm handheld computers is a good example of a modern single-user, single-task operating system. When you are using MS-DOS it is a single user single task operating system.

22:38 -

Computer Fundamentals

Multiply the following binary numbers A) 1001 * 1010 B) 1.01 * 10.1

A) 1001*1010 = 1011010

Multiplication 1001

X 1010

0000

1001

0000

1001

1011010

B) 1.01*10.1=11.001

Multiplication 1.01

X 10.1

101

100

101

11.001

22:31 -

Computer Fundamentals

No comments

Binary to Decimal (i) 1001(2) (ii) 1100.01(2)

i) 1001 = 9

Conversion from Binary to Decimal:

1 x 2³+0 x 2²+0 x 2¹+1 x 2⁰

1 x 2 x 2 x 2+0 x 2 x 2 + 0 x 2 + 1x 1

8+0+0+1=9

ii) 1100.01 = 12.25

Conversion from Binary to Decimal of 1100

1 x 2³+1 x 2²+ 0 x 2¹+ 0 x 2⁰

1 x 2 x 2 x 2+ 1 x 2 x 2 + 0 x 2 + 0 x 1

8+4+0=12

Conversion from Binary to Decimal of .01

0 x 2^-1 + 1 x 2^-2

0 x 0 + 1 x 0.25

0 + 0.25=0.25

22:29 -

Computer Fundamentals

Convert A) Decimal to Binary (i) 5¾ (ii) 20

(i) 5¾ =101.11

5 / 2 = 2 + remainder of 1

2 / 2 = 1 + remainder of 0

1 / 2 = 0 + remainder of 1

Binary presentation of 5 (read from down to up) = 101

¾ = 0.75 (Decimal representation)

0.75 -1 x 2-1 = 0.75 – 0.5=0.25

0.25 – 1x 2-2 = 0.25 – 0.25 = 0

Binary presentation of ¾ = 0.11

Binary presentation of 5¾ (or 5.75)=101.11

22:23 -

Computer Fundamentals

With a neat diagram explain the organizations of a computer

Organization of a Computer

A computer is a fast and accurate device, which can accept data, store data, process them and give, desired results as output. The computer is organized into four units as shown in the following diagram.

Input Unit: