Information management and technology assurance

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

This month I am turning the tables; it’s your turn to face the challenge. A reader sent me the following Excel question, and I am submitting it to you for a chance to solve his problem: Q: I have created an Excel template in which we enter employee information and

Q: My computer contains several decades of Word documents scattered across many folders. Is there a quick way to produce a simple list of all of these documents that I can then sort in Word or Excel? A: I can think of at least three ways to accomplish this task,

Q: We frequently need to select samples of populations for test of transaction work when auditing or reviewing client financial data. Currently, each staff member uses his or her own sampling method, some of which seem to produce skewed results. We would like to deploy a consistent sampling method using

Q: I work with several massive Excel workbooks that contain large quantities of data consisting of many millions of rows, contained in multiple workbooks. As our data continues to grow, I find my current computer system to be inadequate. I need a computer that is not only powerful, but also