Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

Hey everyone,
I can't seem to get into the exam unless I've finished building my database...
I think I have an idea for one, but I'm struggling to get the referential integrity set up right.
Thanks in advance,

Any help at all would be great.

silverpuma3 said:Look, if you actually specify which version of Word you're running, you might actually get some useful advice on how to turn that thing off... 🙂

Sent using Tapatalk

I'm running Word 2010, and I just downloaded an add-on for the USA... 🙂

Amy Martinez16 said:any help would be huge

check out these tutorials, maybe they can help you out

- Access

Robert Green93 said:Microsoft Office keeps auto-correcting my words on its own.
Like, I'll type "goodness" and it flips it to "goodaga" or some other nonsense. Tons of examples just like that. How do I kill this feature?

Look for the option "Automatically use suggestions from the spelling checker" and try toggling that off.
Or "Replace text as you type"
File => Proofing => AutoCorrect => ....

I am currently working on an Excel spreadsheet, and I need to calculate a value based on the product of two previous cells. However, the result doesn't necessarily have to be the exact mathematical product. Instead, I want to follow these rules:
* if the calculation results in 0, the cell should show 0
* if the calculation is less than 500, the cell should show 500
* if the calculation is greater than 500, it should show the actual product

Here is how I attempted to write it:
= sum(if(sum(c25*d25)=0;0);if(0500;sum(c25*d25)),

The problem is that whenever the product of c25 and d25 falls between 0 and 500, the formula returns 0 instead of the required 500.
Where did I go wrong? It seems my logic for the range 0 < sum(c25*d25) < 500 is failing me.

Jacob Martinez54 said:I'm currently working on an Excel sheet where I need a specific cell to display the product of two previous fields. However, the result shouldn't just be a raw calculation; it needs some logic applied:
* if SUM(c25*d25)=0, show 0
* if SUM(c25*d25) * if SUM(c25*d25)>500, show the actual product

Here is how I tried to write it:
= sum(if(sum(c25*d25)=0;0);if(0500;sum(c25*d25)),

The problem is, whenever c25*d25 is greater than 0 but less than 500, it just spits out 0 instead of 500.
Where did I go wrong? It seems my attempt at defining the range 0div>

Look, the syntax if functions follow this rule: If(condition; value_if_true; value_if_false).

In all your IF functions, you've only provided the condition and the true value: if(condition; value_if_true). You're missing the "value_if_false" part entirely. Because of that, Excel is just defaulting to 0 when the condition isn't met and cutting off the rest of your formula. In technical terms, what you actually need to do here is nesting the functions.

Try restructuring your formula like this (your original version is a bit of a mess, so use this as a guide to build what you actually need):

if(sum(c25*d25)=0;0;if(AND(sum(c25*d25)>0;sum(c25*d25)500;sum(c25*d25);"Value is less than zero")))

Thank you. I will give it a shot. I actually attempted it earlier today while I was at the office. I wouldn't exactly call myself an expert when it comes to Excel formulas, but I am certainly trying my best...

Maybe this formula is a bit more straightforward, or perhaps I just missed something in my haste while rushing through this...

=IF(C25*D25=0;0;IF(C25*D25div>

Walter Jackson48 said:Perhaps this formula is a bit more straightforward? Or did I perhaps overlook something in my haste?

=IF(C25*D25=0;0;IF(C25*D25<500;500;C25*D25))

Yes, indeed!! My sincere thanks to you both for all the help!

I have a quick question regarding Word 2010 and more recent versions. On my older systems, I could always toggle overtype mode simply by hitting the INSERT key, but now it seems completely unresponsive to that command.
I would appreciate some guidance on how to fix this. 😉

Is anyone actually in the loop here? It seems like I'm shouting into a void.

Is there any specific add-on I can install for Office 2003 that would allow me to open and read documents with a .docx extension?

Kyle Johnson2 said:Look for the option that says "Automatically use suggestions from the spelling checker" and try toggling that off.
Or maybe "Replace text as you type"
File => Proofing => AutoCorrect => ....

Thanks. 👍
The menu path wasn't exactly like that, but I figured it out...

urbancyclist72 said:Is there some kind of add-on I can install for Office 2003 so I can actually open .docx files?

http://www.microsoft.com/en-us/downl...ails.aspx?id=3

I could use some help here.
I’m working in Word 2010 on a template for meeting minutes—basically a master form I’ll be using every single day where I just swap out the data. There are two specific spots in this template where I want the computer to automatically plug in the time I’m typing. Naturally, the time at the first spot needs to be different from the second one. Since my template uses those little edit boxes (the ones you drop into the text to create fillable fields), I added two of them and went into the properties to set them both to pull the "current time" in my preferred format. So far, so good: while I'm actually typing, the boxes show two different times, which is exactly what I want. But here's the catch: the moment I try to print, the software decides they should be identical and syncs both boxes to the exact same time. I can't have that. So, where am I messing up? Any ideas on how to fix this?

Hello, I have been working on an Excel spreadsheet to track incoming and outgoing invoices—it was an absolute nightmare to put together. I am attaching a small screenshot of my attempt at the layout here 🙂. Is there any way at all to recover the data? This is extremely urgent for me, please help 🙂

Unless you’ve got that auto-backup feature toggled on, take a quick look in the same folder where your spreadsheet lives. You should see a file with basically the same name but some weird, funky extension—I can't recall the exact one off the top of my head. Just try opening that one up. Otherwise, as far as I know, there isn't much else to try.

Sent using Tapatalk

steeltrucker142 said:I really need some help here...

You might want to try preventing those date or time fields from updating automatically. Here is what I do—just highlight the field and hit Ctrl + F11, print out the document, and then before you start filling it out again for, say, a different employee, you just unlock the update functionality on those fields by hitting Ctrl+Shift+F11. Honestly, you could probably just bundle all those steps into a single macro to save yourself the headache. (Just so you know, I'm still running Office 2003 on my machine).
Might be worth a shot.

steeltrucker142 said:Help me out here.
I've got this template where I need the computer to auto-fill the timestamp in two different spots. ...The headache is when I try to print it; the software just lumps both timestamps together into one box (which is definitely not what I want). So, where am I messing up? What's the fix?

Check these out, maybe they'll help you out.

- Auto-timestamping data entry
- Remember TODAY

btw: merging cells is usually a bad move for specific layouts, if I'm following you right.

Rachel Moore19 said:Hey, what's up. Just finished grinding through this spreadsheet for tracking home expenses—incoming and outgoing bills. Man, that was a total nightmare. It kicked my ass. Anyway, here’s a quick look at my attempt at setting it all up.🙂Is there ANY way to get my data back? This is an absolute emergency. PLEASE help me out!🙂

Scan the whole drive for hidden files.
Like, Excel ~$filename.xlsx, or if you're rocking Excel 2003, it’s more like ~filename.xls or ~filename.tmp—something like that.
If you're running Total Commander, just throw in ~* when you're searching. It'll sniff out everything hidden that starts with a tilde. Simple as that.

Of course, all of this only matters if you actually have auto-recovery turned on.