The Geek Forum

  • April 27, 2024, 05:21:22 AM
  • Welcome, Guest
Please login or register.

Login with username, password and session length
Advanced search  

News:

Due to the prolific nature of these forums, poster aggression is advised.

*

Recent Forum Posts

Shout Box

Forum Stats

Members
Stats
  • Total Posts: 129551
  • Total Topics: 7148
  • Online Today: 148
  • Online Ever: 1013
  • (January 12, 2023, 01:18:11 AM)

Author Topic: Simple Excel Question  (Read 2662 times)

Min

  • Nice Ex-Hackernetwork Moderator
  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +468/-13
  • Offline Offline
  • Gender: Female
  • Posts: 5970
  • Slacker Wiseass
    • View Profile
Simple Excel Question
« on: October 22, 2009, 04:28:24 PM »
I got a question wrong on my Excel quiz.  But I actually opened up Excel and did what it was asking and I had the right answer.  Maybe I'm just looking at it wrong or I'm crazy.  What do you guys get for this...



In order to add a column of data between existing columns in a worksheet
one will place the cursor in a cell:

A. directly to the right of where you would like the column, then select Insert > Columns

B. directly to the left of where you would like the column, then select Insert > Columns
Logged
Flammable : Inflammable :: Duh : No Duh
"I TYPE 120 WORDS PER MINUTE, BUT IT'S IN MY OWN LANGUAGE!"  -ivan
1,180,463,441,680 Coolio Points

jeee

  • Dork
  • ***
  • Coolio Points: +189/-4
  • Offline Offline
  • Gender: Male
  • Posts: 796
    • View Profile
Re: Simple Excel Question
« Reply #1 on: October 22, 2009, 05:47:45 PM »
If it's 2007 and you choose insert then column you get some 2 or 3 d chart.

you should rightclick the column on the right from which you want to insert and the choose insert.
Logged

ivan

  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +499/-50
  • Offline Offline
  • Posts: 4929
  • Not a Mod, nor a Rocker. A Mocker.
    • View Profile
Re: Simple Excel Question
« Reply #2 on: October 22, 2009, 06:13:17 PM »
You put your cursor in a cell DIRECTLY WHERE you want to insert the new column. Then you perform the insert. The contents of the columns beneath and to the right of the cursor get shifted to the right (because they cannot be shifted to the left), and a blank column is inserted under the cursor.

So, if you want to insert a new column C, you put the cursor somewhere on column C and do the insert. Not to the right of column C, which would be column D, nor to the left of column C, which would be column B. You put the cursor right where you want the new column to be.

I suppose if you imagine that the new column is actually being inserted into the tiny little space between columns, then you can say that your cursor is placed to the right of the tiny space where the new column will appear. So if you think of it in terms of "I want to insert a new column between B and C", then you would put the cursor to the right of the space between B and C.

So I suppose the answer is "to the right".

Logged
"I TYPE 120 WORDS PER MINUTE, BUT IT'S IN MY OWN LANGUAGE!"  -Detta

xolik: WHERE IS OBAMA'S GIFT CERTIFICATE?
Demosthenes: Is that from the gifters movement?

Detta: Crappy old shorts and a tank top.  This is how I dress for work. Because my job is to get puked on.
Demosthenes: So is mine.  I work in IT.

bananaskittles: The world is 4chan and God is a troll.

xolik

  • King of the Geekery
  • Hacker
  • ****
  • Coolio Points: +541/-25
  • Offline Offline
  • Gender: Male
  • Posts: 5176
  • HAY GUYS
    • View Profile
Re: Simple Excel Question
« Reply #3 on: October 22, 2009, 06:24:52 PM »
Quote from: jeee on October 22, 2009, 05:47:45 PM
If it's 2007 and you uninstall it and go back to using 2003, which is much MUCH better.

FTFY  :lol:
Logged
Barium: What you do if CPR fails.

=-=-=-=-=-=-=-=-=-=-=
[The Fade^C Compound]
-=-=-=-=-=-=-=-=-=-=-

ivan

  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +499/-50
  • Offline Offline
  • Posts: 4929
  • Not a Mod, nor a Rocker. A Mocker.
    • View Profile
Re: Simple Excel Question
« Reply #4 on: October 22, 2009, 06:28:23 PM »
On the other hand, if you think of an existing column as "the column", and you say to yourself, "Self? This here column needs to shove over one," then you would place the cursor to the left of where you would like the column.

So the answer is "to the left".
Logged
"I TYPE 120 WORDS PER MINUTE, BUT IT'S IN MY OWN LANGUAGE!"  -Detta

xolik: WHERE IS OBAMA'S GIFT CERTIFICATE?
Demosthenes: Is that from the gifters movement?

Detta: Crappy old shorts and a tank top.  This is how I dress for work. Because my job is to get puked on.
Demosthenes: So is mine.  I work in IT.

bananaskittles: The world is 4chan and God is a troll.

ivan

  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +499/-50
  • Offline Offline
  • Posts: 4929
  • Not a Mod, nor a Rocker. A Mocker.
    • View Profile
Re: Simple Excel Question
« Reply #5 on: October 22, 2009, 06:29:29 PM »
2003 is easier unless you have more than 65,000 rows on your sheet. Then it's not easier.
Logged
"I TYPE 120 WORDS PER MINUTE, BUT IT'S IN MY OWN LANGUAGE!"  -Detta

xolik: WHERE IS OBAMA'S GIFT CERTIFICATE?
Demosthenes: Is that from the gifters movement?

Detta: Crappy old shorts and a tank top.  This is how I dress for work. Because my job is to get puked on.
Demosthenes: So is mine.  I work in IT.

bananaskittles: The world is 4chan and God is a troll.

ivan

  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +499/-50
  • Offline Offline
  • Posts: 4929
  • Not a Mod, nor a Rocker. A Mocker.
    • View Profile
Re: Simple Excel Question
« Reply #6 on: October 22, 2009, 06:47:50 PM »
BEFORE 2007:

client: Can you send me your current inventory?

ivan: Sure. We have 755,000 active items. How do you want it?

client: Can you send it in Excel?

*ivan gets sick feeling in gut at prospect of importing 755,000 rows into Excel in 65,000-row chunks*

AFTER 2007:

client: Can you send me your current inventory?

ivan: Sure. We have 755,000 active items. How do you want it?

client: Can you send it in Excel?

ivan: Absolutely! Do you have Excel 2007?

client: No.

*ivan gets sick feeling in gut at prospect of breaking a 755,000 row sheet into 12 separate 65,000-row sheets so he can save it as a goddam .xls file*

So life got marginally better, I suppose.

Logged
"I TYPE 120 WORDS PER MINUTE, BUT IT'S IN MY OWN LANGUAGE!"  -Detta

xolik: WHERE IS OBAMA'S GIFT CERTIFICATE?
Demosthenes: Is that from the gifters movement?

Detta: Crappy old shorts and a tank top.  This is how I dress for work. Because my job is to get puked on.
Demosthenes: So is mine.  I work in IT.

bananaskittles: The world is 4chan and God is a troll.

12AX7

  • Guest
Re: Simple Excel Question
« Reply #7 on: October 22, 2009, 07:38:53 PM »
Quote from: ivan on October 22, 2009, 06:47:50 PM
BEFORE 2007:

client: Can you send me your current inventory?

ivan: Sure. We have 755,000 active items. How do you want it?

client: Can you send it in Excel?

*ivan gets sick feeling in gut at prospect of importing 755,000 rows into Excel in 65,000-row chunks*

AFTER 2007:

client: Can you send me your current inventory?

ivan: Sure. We have 755,000 active items. How do you want it?

client: Can you send it in Excel?

ivan: Absolutely! Do you have Excel 2007?

client: No.

*ivan gets sick feeling in gut at prospect of breaking a 755,000 row sheet into 12 separate 65,000-row sheets so he can save it as a goddam .xls file*

So life got marginally better, I suppose.



  I see your problem, ivan. Try it like this next time; see if it works any easier for you:

BEFORE 2007:

client: Can you send me your current inventory?

ivan: Sure!

  ivan sends inventory in format of his choice; customer never being the wiser



AFTER 2007:

client: Can you send me your current inventory?

ivan: Absolutely!

ivan sends inventory in format of his choice; customer never being the wiser




Logged

BizB

  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +439/-15
  • Offline Offline
  • Gender: Male
  • Posts: 4324
  • Keep making circles
    • View Profile
Re: Simple Excel Question
« Reply #8 on: October 23, 2009, 08:05:09 AM »
I would have selected answer choice B, but it is, as ivan pointed out, a poorly worded question.  The answer should be "Exactly where you want the new column to be inserted thereby pushing all existing content to the right"
Logged
Without me, it's just 'aweso'.

pbsaurus

  • Hacker
  • ****
  • Coolio Points: +354/-31
  • Offline Offline
  • Gender: Male
  • Posts: 9981
  • Everyone Loves The King Of The Sea
    • View Profile
    • http://www.myspace.com/flipperpete
Re: Simple Excel Question
« Reply #9 on: October 27, 2009, 01:23:53 PM »
Yep, except it should say alt-i c
Logged