Information management and technology assurance

In the August 2013 JofA, I challenged readers to solve an Excel problem in which a preformatted report fetched an ever-changing last row of data. We received well over 200 solutions from a group of Excel-savvy CPAs. Though each solution was different, all of them worked properly and employed a

Q: I am in the process of updating a Word 2003 document containing videos that were inserted as embedded objects. Previously, these videos appeared in a video window and when double-clicked played in place within Word 2003. However, in subsequent editions of Word, these embedded videos appear as a file

Q: I see many new Windows 8 tablet PCs and touchscreen ultrabooks hitting the market, but most of them are fairly small. I am currently shopping for a larger Windows 8 touchscreen ultrabook (with a fast solid-state drive) that is big enough to easily read, and with a keyboard large

Q: I recently purchased a touchscreen ultrabook with Office 2013 installed, and I would like to learn more about operating Word 2013 using the touch controls. Can you send me to a list of Office 2013’s touchscreen controls? A: Microsoft offers the Office Touch Guide at tinyurl.com/kcatd39. It includes instructional

Q: We use Norton anti-virus software on multiple computers in our offices, and we have been happy with its ability to protect our computers. However, we find the process of renewing our Norton licenses confusing because clicking Norton’s renewal button links users to a Norton sales webpage that prompts them

Q: My Excel workbook contains numerous comments explaining the source of selected values in my report, and I want to include these comments on the printed report. I have tried both of the Page Setup options that enable me to print the comments either “as displayed on sheet” or “at

Last month I turned the tables and challenged JofA readers to answer another reader’s Excel question, as follows: Q: I have created an Excel template in which I enter employee information and pension data, and as we enter this data, I want the last row automatically displayed in the ready-to-print

Q: Our satellite offices provide temporary office space to visiting staff, and each office is equipped with a shared computer. I frequently use these office computers, but after I’m done I am not comfortable that Word and Excel display the names of the most recently opened files, because this allows

Q: Windows 8 lets me run a slideshow from the My Pictures folder, but is it possible to run a slideshow of pictures contained in my other folders (other than the My Pictures folder) as does Windows 7? A: In an effort to de-clutter the Windows 8 screens, Microsoft tucked

Q: I purchased an Apple iPad 2 two years ago with iOS 4.33 installed, and I now need to update the operating system because many of my current app updates require iOS 5.xx (or higher). In addition, I am unable to install newer apps that require iOS 5.xx (or higher).

Q: My small business client has a successful business but awful accounting records. He blames his accounting system, stating that “it doesn’t work right, and it constantly produces errors.” I realize that the true problem is he doesn’t know accounting, but how do I convey this criticism without upsetting or