Perform Advanced Mathematical Calculations



When you perform mathematical calculations in Excel, be careful of precedence. Calculations are performed from left to right, with multiplication and division performed before addition and subtraction.

Copy, Cut, Paste, and Cell Addressing

In Excel, you can copy data from one area of a worksheet and place the data you copied anywhere in the same or another worksheet. In other words, after you type information into a worksheet, if you want to place the same information somewhere else, you do not have to retype the information. You simple copy it and then paste it in the new location.

You can use Excel's Cut feature to remove information from a worksheet. Then you can use the Paste feature to place the information you cut anywhere in the same or another worksheet. In other words, you can move information from one place in a worksheet to another place in the same or different worksheet by using the Cut and Paste features.

Microsoft Excel records cell addresses in formulas in three different ways, called absolute, relative, and mixed. The way a formula is recorded is important when you copy it. With relative cell addressing, when you copy a formula from one area of the worksheet to another, Excel records the position of the cell relative to the cell that originally contained the formula. With absolute cell addressing, when you copy a formula from one area of the worksheet to another, Excel references the same cells, no matter where you copy the formula. You can use mixed cell addressing to keep the row constant while the column changes, or vice versa.

Show properties of operating systems.

Operating System - Properties Following are few of very important tasks that Operating System handles Batch processing Batch processing is a technique in which Operating System collects one programs and data together in a batch before processing starts. Operating system does the following activities related to batch processing. OS defines a job which has predefined sequence of commands, programs and data as a single unit.

· OS keeps a number a jobs in memory and executes them without any manual information.

· Jobs are processed in the order of submission i.e first come first served fashion.

· When job completes its execution, its memory is released and the output for the job gets copied into an output spool

· for later printing or processing.

ADVANTAGES Batch processing takes much of the work of the operator to the computer.

· Increased performance as a new job get started as soon as the previous job finished without any manual intervention.

· DISADVANTAGES Difficult to debug program.

· A job could enter an infinite loop.

· Due to lack of protection scheme, one batch job can affect pending jobs.

Multitasking refers to term where multiple jobs are executed by the CPU simultaneously by switching between them. Switches occur so frequently that the users may interact with each program while it is running. Operating system does the following activities related to multitasking. The user gives instructions to the operating system or to a program directly, and receives an immediate response.

· Operating System handles multitasking in the way that it can handle multiple operations / executes multiple programs at a time.

 Multitasking Operating Systems are also known as Time-sharing systems. These Operating Systems were developed to provide interactive use of a computer system at a reasonable cost.· A time-shared operating system uses concept of CPU scheduling and multiprogramming to provide each user with a· small portion of a time-shared CPU. Each user has at least one separate program in memory.· A program that is loaded into memory and is executing is commonly referred to as a process.· When a process executes, it typically executes for only a very short time before it either finishes or needs to perform· I/O. Since interactive I/O typically runs at people speeds, it may take a long time to completed. During this time a CPU· can be utilized by another process. Operating system allows the users to share the computer simultaneously. Since each action or command in a timeshared· system tends to be short, only a little CPU time is needed for each user. As the system switches CPU rapidly from one user/program to the next, each user is given the impression that· he/she has his/her own CPU, whereas actually one CPU is being shared among many users.

Multiprogramming When two or more programs are residing in memory at the same time, then sharing the processor is referred to the multiprogramming. Multiprogramming assumes a single shared processor. Multiprogramming increases CPU utilization by organizing jobs so that the CPU always has one to execute. Following figure shows the memory layout for a multiprogramming system. Operating system does the following activities related to multiprogramming. The operating system keeps several jobs in memory at a time.· This set of jobs is a subset of the jobs kept in the job pool.· The operating system picks and begins to execute one of the job in the memory.· Multiprogramming operating system monitors the state of all active programs and system resources using memory· management programs to ensures that the CPU is never idle unless there are no jobs ADVANTAGES High and efficient CPU utilization.· User feels that many programs are allotted CPU almost simultaneously.·

 DISADVANTAGES CPU scheduling is required.· To accommodate many jobs in memory, memory management is required.· Interactivity Interactivity refers that a User is capable to interact with computer system. Operating system does the following activities related to interactivity. OS provides user an interface to interact with system.· OS managers input devices to take inputs from the user. For example, keyboard.· OS manages output devices to show outputs to the user. For example, Monitor.· OS Response time needs to be short since the user submits and waits for the result.· Real Time System Real time systems represents are usually dedicated, embedded systems. Operating system does the following activities related to real time system activity. In such systems, Operating Systems typically read from and react to sensor data.· The Operating system must guarantee response to events within fixed periods of time to ensure correct performance.·

Distributed Environment Distributed environment refers to multiple independent CPUs or processors in a computer system. Operating system does the following activities related to distributed environment. OS Distributes computation logics among several physical processors.· The processors do not share memory or a clock.· Instead, each processor has its own local memory.· OS manages the communications between the processors. They communicate with each other through various· communication lines.

Spooling Spooling is an acronym for simultaneous peripheral operations on line. Spooling refers to putting data of various I/O jobs in a buffer. This buffer is a special area in memory or hard disk which is accessible to I/O devices. Operating system does the following activites related to distributed environment. OS handles I/O device data spooling as devices have different data access rates.· OS maintains the spooling buffer which provides a waiting station where data can rest while the slower device· catches up. OS maintains parallel computation because of spooling process as a computer can perform I/O in parallel fashin. It· becomes possible to have the computer read data from a tape, write data to disk and to write out to a tape printer while it is doing its computing task. ADVANTAGES The spooling operation uses a disk as a very large buffer.· Spooling is capable of overlapping I/O operation for one job with processor operations for another job.·


Дата добавления: 2018-02-15; просмотров: 265; ЗАКАЗАТЬ РАБОТУ