How can I chart survey answers when respondents could select more than one option?
Count each selected option separately, then label your chart so readers can distinguish option selections from distinct respondents.
Read the guide 5 min read
GEEZ AT WORK
Technology & devices
Questions, practical answers, and useful follow-ups to help you work through the details.
Latest guides
Showing 313–336 of 845 guides
How can I find the most common answer in a survey without counting blanks?
Standardize response wording first, then count nonblank answers with a PivotTable or a targeted COUNTIF and report ties clearly.
Read the guide 4 min read
How can I check that an imported roster has one row per person?
Reconcile an imported roster against expected person IDs, spot repeated IDs, and investigate missing or extra records before relying on the file.
Read the guide 5 min read
How can I make a chart show inventory counts by location but still include items with zero?
Build a complete location summary before charting: count inventory records by location, merge counts into the full location list, and show unmatched locations as zero.
Read the guide 5 min read
How do I spot rows that failed to import because required fields were missing?
Separate genuinely missing required values from permitted blanks, then keep rejected rows in a reviewable correction queue.
Read the guide 5 min read
Which chart makes a weekly room-booking schedule easiest to compare?
Choose a chart for comparing room totals, tracking week-by-week changes, or showing each room’s share of a defined booking total.
Read the guide 5 min read
How do I show only inventory items whose review date is coming up soon?
Choose a review window, filter for dates within it, and handle blank or overdue records separately so they are not overlooked.
Read the guide 4 min read
How do I find the latest check-in for each shared piece of equipment?
Find the newest dated check-in for each equipment ID, then check for tied dates, missing values, and inconsistent IDs before relying on the results.
Read the guide 5 min read
How can I filter a roster to show people assigned to any of several shifts?
Use OR logic for shift alternatives: include people assigned to at least one selected shift, and use AND for any additional required condition.
Read the guide 4 min read
How can I return a room number for a person when names are not unique?
Use a verified unique identifier—or a checked composite key—instead of a repeated name, so your lookup can return the intended person’s room.
Read the guide 5 min read
How do I match two lists when one has extra spaces in the ID values?
Keep original IDs, clean both lists consistently in helper columns, compare the cleaned values, then review unmatched records and possible collisions.
Read the guide 4 min read
How can I require a roster row to have both a name and a shift before it is accepted?
Use a custom validation rule that permits fully blank or fully completed rows, then test blank, complete, and partly filled examples.
Read the guide 4 min read
How do I check that a PDF export preserved equations and special characters?
Use targeted text searches and visually compare representative formula-heavy and symbol-rich pages with the original to check for missing, altered, or poorly rendered content.
Read the guide 5 min read
How do I make a document's language clear to screen readers and spell-check tools?
Set proofing languages for text in Word, then check the exported PDF’s primary and passage-level language settings separately.
Read the guide 4 min read
How can I remove unnecessary document metadata before publishing a PDF?
Review visible PDF properties, remove only unnecessary information with a suitable tool, then inspect the exact copy you plan to publish.
Read the guide 5 min read
How can I make document links and bookmarks survive a PDF export?
Prepare links and bookmarks in Word, choose PDF export options deliberately, then test the finished PDF’s navigation before sharing it.
Read the guide 5 min read
How do I prepare a document for printing and digital reading without maintaining two conflicting copies?
Set one editable source of truth, then review separate print and digital exports against it with a repeatable checklist.
Read the guide 4 min read
How do I add checkboxes and radio buttons that behave as intended in a PDF form?
Choose the right control for each question, name and label fields clearly, and test the saved PDF in the recipient’s workflow.
Read the guide 5 min read
How do I extract selected pages from a PDF into a separate file?
Use Acrobat’s page organizer to select the pages, create one new PDF, and verify both the selection and saved file without deleting pages from the original.
Read the guide 4 min read
How can I make a PDF's color choices easier to read in grayscale?
Review charts, labels, and emphasis in grayscale, then add clear labels, patterns, symbols, or wording wherever color alone carries meaning.
Read the guide 4 min read
How do I create a document template with protected fields for repeated use?
Plan what stays fixed and what changes, set up suitable Word fields and restrictions, then test a fresh copy before sharing.
Read the guide 4 min read
How can I insert a revised page into a PDF without rebuilding the whole file?
Choose replacement or insertion based on whether the page count should change, then check nearby layout, numbering, links, and bookmarks in the saved PDF.
Read the guide 4 min read
How can I optimize a PDF for email while preserving readable text?
Reduce a PDF’s size in measured steps, then check text, images, forms, accessibility features, and navigation before sharing.
Read the guide 4 min read
How can I accept or reject tracked changes selectively?
Review edits individually or by reviewer, keep uncertain changes unresolved, and check the document carefully before sharing it.
Read the guide 4 min read
YOUR QUESTION. YOUR DETAILS.
Let’s work through your situation.
Get a tailored answer or help with your next task. Starts at $1, with a quote before you pay.