mcdst in action

bighornsheepbighornsheep Member Posts: 1,506
in MCDST
a similar situation occured at work, and I just thought I would post about it here as sort of a practice question.

You are the desktop support person of your department managing Windows XP professional desktops with Microsoft Office applications. A user calls you and states that there is data corruption in an excel file that she has been working on for many months.

The file is in a folder share located on your department server, and your system administrator is on holiday. You verify that no other files in the folder is corrupt, but the user insists that data is incorrect because dates and numbers appear as '######', what is the most likely cause of the problem?
A) The file is corrupt, restore a backup copy
B) Cells are locked
C) Cell Format needs to be configured
D) Cell is linked to an inaccessible location
E) Cell width needs to be configured

I overheard the situation and was able to provide the proper solution...heh....have fun~ and good luck!
Jack of all trades, master of none
· Share on FacebookShare on Twitter

Comments

  • D-boyD-boy Member Posts: 595
    C) Cell Format needs to be configured

    Just a guess!
    · Share on FacebookShare on Twitter
  • SirDragoSirDrago Member Posts: 66 ■■□□□□□□□□
    Could be D, but i'm just guessing too.
    · Share on FacebookShare on Twitter
  • spike_tomahawkspike_tomahawk Member Posts: 43 ■■□□□□□□□□
    E: double click on the column line and it will auto size to the contents in the cell
    · Share on FacebookShare on Twitter
  • sprkymrksprkymrk Member Posts: 4,884 ■■■□□□□□□□
    It's E. I've seen it happen before. :)

    BTW - If it was indeed corrupted, and you had a smart admin, you could simply instruct the user to right click the file, go to properties and then previous versions. I love Shadow Copies. icon_cool.gif
    All things are possible, only believe.
    · Share on FacebookShare on Twitter
  • bighornsheepbighornsheep Member Posts: 1,506
    we have a winner! ...well.. two...
    spike_tomahawk, sprkymrk

    congrats! yup.....it's e), the width size needs to be increased.

    well, now you know... :)
    Jack of all trades, master of none
    · Share on FacebookShare on Twitter
  • Orion82698Orion82698 Member Posts: 483
    F. I hate Excel icon_wink.gif

    I was going to say Back up or Shadow copy as well.

    thumbs up to sprkymrk for that one :D
    WIP Vacation ;-)

    Porsche..... there is no substitute!
    · Share on FacebookShare on Twitter
  • sprkymrksprkymrk Member Posts: 4,884 ■■■□□□□□□□
    G. Reboot
    H. Reinstall Office

    icon_lol.gificon_lol.gif
    All things are possible, only believe.
    · Share on FacebookShare on Twitter
  • Orion82698Orion82698 Member Posts: 483
    sprkymrk wrote:
    G. Reboot
    H. Reinstall Office

    icon_lol.gificon_lol.gif

    icon_lol.gif touche
    WIP Vacation ;-)

    Porsche..... there is no substitute!
    · Share on FacebookShare on Twitter
  • sprkymrksprkymrk Member Posts: 4,884 ■■■□□□□□□□
    Believe it or not, I know a couple of "techs" that would have chosen reboot as the first thing, and if that didn't work they would reinstall. It's pretty much their standard operationg procedure; reboot, reinstall, rinse and repeat as necessary. icon_rolleyes.gif
    All things are possible, only believe.
    · Share on FacebookShare on Twitter
  • bighornsheepbighornsheep Member Posts: 1,506
    sprkymrk wrote:
    Believe it or not, I know a couple of "techs" that would have chosen reboot as the first thing, and if that didn't work they would reinstall. It's pretty much their standard operationg procedure; reboot, reinstall, rinse and repeat as necessary. icon_rolleyes.gif

    exactly why I posted this scenario with made up answers by me :)
    an MCSA+MCDBA+CCNA said it's because of Office XP/Office 2003 issue..... icon_rolleyes.gif
    Jack of all trades, master of none
    · Share on FacebookShare on Twitter
  • Orion82698Orion82698 Member Posts: 483
    bighornsheep wrote:
    sprkymrk wrote:
    Believe it or not, I know a couple of "techs" that would have chosen reboot as the first thing, and if that didn't work they would reinstall. It's pretty much their standard operationg procedure; reboot, reinstall, rinse and repeat as necessary. icon_rolleyes.gif

    exactly why I posted this scenario with made up answers by me :)
    an MCSA+MCDBA+CCNA said it's because of Office XP/Office 2003 issue..... icon_rolleyes.gif

    LOL... that's very typical where I work too. If you can't figure out the error or issue "It's got to a bug in the program"

    BTW sprkymrk... I love your avitar! Is that Wilson Combat 1911?
    WIP Vacation ;-)

    Porsche..... there is no substitute!
    · Share on FacebookShare on Twitter
  • sprkymrksprkymrk Member Posts: 4,884 ■■■□□□□□□□
    orion82698 wrote:
    BTW sprkymrk... I love your avitar! Is that Wilson Combat 1911?

    Thanks. :)
    It's actually a Springfield. It's from their custom shop. icon_cool.gif
    All things are possible, only believe.
    · Share on FacebookShare on Twitter
  • itdaddyitdaddy Senior Member Member Posts: 2,089 ■■■■□□□□□□
    E:

    bighornsheep

    yes, i would agree and this would be my boss!
    icon_confused.gif
    · Share on FacebookShare on Twitter
Sign In or Register to comment.