BBC LA County BBC Office Technology and Equipment 2 — Questions and Answers
Question 1: In a spreadsheet application, a formula that adds the values in cells A1 through A10 would be written as:
- =ADD(A1:A10)
- =SUM(A1:A10) (Correct answer)
- =TOTAL(A1-A10)
- =COUNT(A1:A10)
Correct answer: =SUM(A1:A10)
The SUM function is the correct spreadsheet formula for adding a range of cell values.
Question 2: Which of the following best describes the purpose of a computer's operating system?
- It stores all user documents permanently
- It manages hardware resources and provides a platform for applications (Correct answer)
- It connects the computer to the internet
- It creates backups of all files automatically
Correct answer: It manages hardware resources and provides a platform for applications
An operating system manages hardware resources and provides the foundation on which application software runs.
Question 3: When using email in a county office, which practice best protects sensitive county information?
- Forwarding all emails to a personal account for convenience
- Encrypting emails containing confidential data before sending (Correct answer)
- Using 'Reply All' on every message to keep everyone informed
- Saving attachments to the desktop for quick access
Correct answer: Encrypting emails containing confidential data before sending
Encrypting emails that contain sensitive or confidential information is the correct security practice for government offices.
Question 4: A voicemail message left for a supervisor should include:
- Only your first name
- Your name, callback number, brief reason, and a good time to reach you (Correct answer)
- A long detailed explanation of every issue
- Your personal cell phone number only
Correct answer: Your name, callback number, brief reason, and a good time to reach you
A complete voicemail includes the caller's name, phone number, reason for calling, and preferred callback time to enable an efficient response.
Question 5: Which action should be taken before performing routine maintenance such as clearing a paper jam from a photocopier?
- Increase the copy count setting
- Power off the machine and unplug it if required (Correct answer)
- Call the vendor without attempting any fix
- Continue sending print jobs while clearing the jam
Correct answer: Power off the machine and unplug it if required
Safety protocol requires powering off and unplugging electrical equipment before performing any manual maintenance.
Question 6: In Microsoft Outlook, the 'CC' field when composing an email stands for:
- Copied Content
- Carbon Copy (Correct answer)
- Confirmed Contact
- Categorized Correspondence
Correct answer: Carbon Copy
CC stands for Carbon Copy, and recipients in this field receive a copy of the email for informational purposes.
BBC LA County BBC Office Technology and Equipment 2
In a spreadsheet application, a formula that adds the values in cells A1 through A10 would be written as: