kashworld

A Blogs@Baruch site

Archive for February, 2012


The Microsoft Excel Tutorial

Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly.

As a tutor, I would start with basics of excel which is to learn spreadsheet;

So let’s get started digging into what makes a spreadsheet work. Spreadsheets are made up of

  • columns
  • rows
  • and their intersections are called cells

In each cell there may be the following types of data

  • text (labels)
  • number data (constants)
  • formulas (mathematical equations that do all the work)
  • In a spreadsheet the COLUMN is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN’S location.

Worksheets

Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576.

The Formula Bar

If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. Cell entries display on the right side of the Formula bar. If you do not see the Formula bar in your window, perform the following steps:

  1. Choose the View tab.
  2. Click Formula Bar in the Show/Hide group. The Formula bar appears.

EXERCISE 1

Move Around the Worksheet

The Down Arrow Key

  • Press the down arrow key several times. Note that the cursor moves downward one cell at a time.

 

The Up Arrow Key

  • Press the up arrow key several times. Note that the cursor moves upward one cell at a time.

The Tab Key

  1. Move to cell A1.
  2. Press the Tab key several times. Note that the cursor moves to the right one cell at a time.

The Shift+Tab Keys

  • Hold down the Shift key and then press Tab. Note that the cursor moves to the left one cell at a time.

The Right and Left Arrow Keys

  1. Press the right arrow key several times. Note that the cursor moves to the right.
  2. Press the left arrow key several times. Note that the cursor moves to the left.

Page Up and Page Down

  1. Press the Page Down key. Note that the cursor moves down one page.
  2. Press the Page Up key. Note that the cursor moves up one page.

The Ctrl-Home Key

  1. Move the cursor to column J.
  2. Stay in column J and move the cursor to row 20.
  3. Hold down the Ctrl key while you press the Home key. Excel moves to cell A1.

Go To Cells Quickly

The following are shortcuts for moving quickly from one cell in a worksheet to a cell in a different part of the worksheet.

I hope this tutorial gives the right and adequate info to learn the very basics for excel for CIS 3810 class.

Manovich’s Variability

Manovich portrays in one of his five principles of new media that variability is “a new media object it is not something fixed once and for all, but something that can exist in different, potentially infinite versions” To better explain the idea of variability, he compares old media to new media. Unlike old media, new media does not change structure and content together.

He interprets that you can take a piece and control it in a way from the original type that it differs by using other values to change the effect of the original, an example of variability would be how photos can be resized using zoom in and zoom out.

My understanding of something that contains variability is how the different versions of Microsoft Word that was first created in 1983 Multi-Tool Word for Xenix systems now has evolved into more complex versions as it progressed and changed the effect of original and currently latest version is Microsoft Office 2012.

I agree with Manovich principle of Variability. Things that can be prearranged in distinctive format and structures, delivering the user with different outcomes.

Pro’s & Con’s of Social Networking Sites

People who are usually shy or not outspoken can use social networking as a type of shield to overcome that. Social networking is a platform, rather more a site that concentrates on building and reflecting of social networks.

Big business use Facebook as means of attracting customers educating the public about their services and you can use this to your advantage when looking for a job, in term as of your career research the company get to see what their culture is like that’s the potential for you.

I started using Facebook as a means of staying connected and not only have you been in touch with friends but I have expanded professional contacts as well. I found an engineering firm through Facebook and was scheduled an interview on the phone and then in person luckily I got appointed for the job and now earning a decent salary, but you have to be cautious what you put out there it can greatly influence your image based on what you put out there even if you don’t mean for that to happen because of stalkers, spams and etc. Limiting personal information also helps.

Some of the Cons of social networking sites that I faced were the first thing i did was when I turned the laptop on would go to Facebook and spend hours on it, due to this habit. I lacked going to the gym put on additional pounds, also stopped reading books and spend less and less time with family, eventually started to fiddle off in school work. Finally when I realized my mistakes so I temporary deactivated my Facebook account and focused in everything else, learned how to manage my time and responsibility so I was able to activate my account and since everything has worked out fine.

Hello world!

Welcome to Blogs@Baruch!

This is your first post. Edit or delete it, then start blogging.