AI Tools for Productivity

Practice questions

An automation will email fee-due reminders to 300 students from a sheet. What should happen before the first real run?

  1. Run it on a test copy with a few dummy rows, check each message by hand, and have a person approve the real send
  2. Run it once on all 300 to see what happens
  3. Let it run without review because reminders are harmless
  4. Ask students to report any mistakes after they receive it
Answer and explanation

Answer: A

A mistake would reach 300 people at once in the institution's name. Testing on dummy data, checking the output and keeping a person's approval for the real send prevent that.

A new email rule is meant to move supplier invoices to a folder. Which is the best way to test it?

  1. Turn it on for the whole office and wait for complaints
  2. Send yourself a few test emails, including ones that should not match, and check where each one lands
  3. Ask an AI tool whether the rule is correct and switch it on
  4. Test it only after a month of use
Answer and explanation

Answer: B

Known test inputs - some that should match and some that should not - show exactly what the rule does before it can hide real mail.

In 'Every Friday at 5 p.m., if any row in the leave sheet is marked Pending, email a list to the section officer', which part is the condition?

  1. Every Friday at 5 p.m.
  2. Emailing a list to the section officer
  3. The leave sheet itself
  4. A row in the leave sheet is marked Pending
Answer and explanation

Answer: D

The schedule is the trigger, the email is the action, and 'a row is marked Pending' is the condition that decides whether the action runs.

Which statement about AI-drafted presentations is correct?

  1. Speaker notes from AI can be read aloud without checking
  2. The outline should be reviewed and edited before slides are made
  3. Every slide should contain as much text as possible
  4. Figures on AI-drafted slides need no checking if the design looks professional
Answer and explanation

Answer: B

Reviewing the outline puts your goal and knowledge into the talk before effort goes into slides. Notes, text density and figures all need the presenter's judgement and checking.

A presenter wants a map of India for an official presentation. Which source is most appropriate?

  1. An image generator asked to draw a map of India
  2. The first map image found in a web search
  3. A map copied from a social media post
  4. A map from an authoritative official source, used as its terms allow
Answer and explanation

Answer: D

AI-generated maps can show wrong borders or names, and random web images may be inaccurate or copyrighted. An official, authoritative map used within its terms is the right choice.

Attendance at a training fell from 250 to 200. A draft slide says 'Attendance fell by 25%'. What is the correct figure?

  1. 25%
  2. 50%
  3. 20%
  4. 40%
Answer and explanation

Answer: C

Fall = 250 − 200 = 50. Percentage fall = 50 ÷ 250 × 100 = 20%. The 25% comes from dividing by the new value, 200.

A register lists 500 expense entries with Department, Month and Amount. Which tool most directly gives the total amount for each department?

  1. A pie chart of the 500 entries
  2. A pivot table grouped by Department with Amount totalled
  3. An IF formula on each row
  4. Sorting the list by Amount
Answer and explanation

Answer: B

A pivot table groups rows by a field and totals another - exactly 'group by department, add up amount'. A check on one department's total by hand confirms it.

Marks are 72, 45, 88, 30 and 65 in B2:B6. A formula gives 58.75 for the average. What is the most likely mistake?

  1. The formula averages only B2:B5, leaving out the last row
  2. The formula adds the marks instead of averaging them
  3. The formula uses an exact-match lookup
  4. The formula divides by 6 instead of 5
Answer and explanation

Answer: A

The correct average is 300 ÷ 5 = 60. The first four marks sum to 235, and 235 ÷ 4 = 58.75, so the range missed B6. Dividing 300 by 6 would give 50.

Marks in B2:B6 are 72, 45, 88, 30 and 65. An AI suggests =COUNTIF(B2:B6,">40") to count passes at a pass mark of 40. Neha's mark is changed to 40. What will the formula show, and what should it show?

  1. It shows 4 and should show 4
  2. It shows 5 and should show 5
  3. It shows 4 but should show 5
  4. It shows 3 but should show 4
Answer and explanation

Answer: C

The marks become 72, 45, 88, 40, 65. With ">40" the 40 is not counted, so the formula shows 4. A student on exactly the pass mark passes, so the right count is 5, given by ">=40".

A typist uses an AI tool to draft a letter that goes out under a senior officer's signature with a wrong date. Who answers for the error?

  1. The AI tool
  2. The person who signed the letter, with the typist who prepared it
  3. No one, because the error was made by software
  4. The person who received the letter
Answer and explanation

Answer: B

Responsibility stays with the people who prepared and signed the document. A tool is not accountable; the signature says the contents were checked.

An AI proof-read returns a smoother letter. One sentence changed from 'payment will not be released before verification' to 'payment will be released before verification'. What does this show?

  1. Proof-reading changes must be listed and checked, because a small edit can reverse the meaning
  2. The new sentence is better English and should be kept
  3. AI tools never change meaning, so this must be a typing error by the writer
  4. Proof-reading should be done only after the letter is sent
Answer and explanation

Answer: A

Dropping 'not' reverses the instruction. Asking the tool to list each change, and reading the changes, catches this kind of error.

Which drafting prompt is most likely to produce a usable official email?

  1. Write an email to the supplier.
  2. Write an impressive email that gets results.
  3. Write a long and very polite email about the order.
  4. Draft a formal email from the stores clerk to the supplier asking for a quotation for 50 chairs by [date]; under 100 words; leave brackets for missing details.
Answer and explanation

Answer: D

It states writer, reader, purpose, the key fact (50 chairs), tone, length and how to handle gaps. The other prompts leave the tool to guess the facts.

A search engine shows an AI-written answer giving a recruitment's last date. What is the correct next step?

  1. Note the date and apply on the last day
  2. Ask a friend whether the date sounds right
  3. Open the official notice on the recruiting body's own website and read the date there
  4. Search again and accept the date if it appears twice
Answer and explanation

Answer: C

AI search answers are assembled from web pages that may be old or wrong. Only the official notice is the authority for a date.

An AI summary of an eligibility clause says 'Age limit: 18 to 27 years.' The notice says 'Age limit: 18 to 27 years as on 1 January; relaxation for certain categories as per rules.' What kind of error is in the summary?

  1. A spelling error
  2. An omission of conditions that change who is eligible
  3. A wrong upper age limit
  4. No error, because the numbers match
Answer and explanation

Answer: B

The numbers match, but the summary dropped the date on which age is counted and the relaxation clause. Omitted conditions change eligibility, which is why every condition is checked, not just the numbers. (The clause is illustrative.)

A candidate pastes a public notice into a chatbot and asks for key dates. Which addition to the prompt makes checking the output fastest?

  1. Ask for the page or paragraph each point comes from
  2. Ask for the answer in bold type
  3. Ask the tool to be as confident as possible
  4. Ask for the answer in fewer than ten words
Answer and explanation

Answer: A

Page or paragraph references let you go straight to the sentence in the original and confirm each point, instead of re-reading the whole document.

A spreadsheet from an unknown sender asks you to 'enable macros to view the content'. What should you do?

  1. Do not enable macros; report or delete the file as your office's policy says
  2. Enable macros, since spreadsheets are always safe
  3. Forward it to colleagues to see if it opens for them
  4. Enable macros but close the file quickly
Answer and explanation

Answer: A

Macros are small programs and can carry malware. Files from unknown senders that ask for macros to be enabled are a common attack, so they are not enabled.

An office sets up AI to draft replies to public queries. What is the safest arrangement?

  1. The AI sends replies at once so citizens are not kept waiting
  2. The AI prepares drafts and a staff member reviews and sends each one
  3. Replies are sent automatically and checked once a month
  4. Only replies longer than 100 words are reviewed
Answer and explanation

Answer: B

Anything sent to other people in the office's name is reviewed by a person first, because an automatic reply can state wrong facts or make promises the office cannot keep.

Which task is the poorest candidate for automation?

  1. Moving every email from a known supplier into one folder
  2. Adding each form response as a row in a sheet
  3. Deciding how to reply to a citizen's unusual complaint
  4. A weekly reminder to update the attendance register
Answer and explanation

Answer: C

A reply to an unusual complaint needs judgement every time. The others are frequent, rule-based steps that suit automation.

A task takes 6 minutes a day, 5 days a week. Automating it takes 2 hours to set up. Roughly how many weeks until it pays back?

  1. 2 weeks
  2. 4 weeks
  3. 10 weeks
  4. 24 weeks
Answer and explanation

Answer: B

Time saved per week = 6 × 5 = 30 minutes. Setup = 2 hours = 120 minutes. Payback = 120 ÷ 30 = 4 weeks.

In the automation 'When a new email arrives, if the subject contains Invoice, move it to the Accounts folder', what is the trigger?

  1. Moving the email to the Accounts folder
  2. The word Invoice in the subject
  3. The Accounts folder
  4. A new email arriving
Answer and explanation

Answer: D

The trigger is the event that starts the automation: a new email arriving. The subject check is the condition and moving the email is the action.

Privacy · Terms · Refunds · Delivery