CS CS Technology & Office Software 1 — Questions and Answers
Question 1: In Microsoft Word, the 'Track Changes' feature is used to:
- Save multiple versions of a file automatically
- Record edits so reviewers can see what was changed and by whom (Correct answer)
- Format documents with a specific template
- Convert documents to PDF format
Correct answer: Record edits so reviewers can see what was changed and by whom
Track Changes records insertions, deletions, and formatting changes so collaborators can review, accept, or reject each edit.
Question 2: What does 'cloud storage' mean?
- Storing files on the office server's local hard drive
- Saving data on remote internet-based servers accessible from any device (Correct answer)
- Backing up files to a USB drive
- Printing documents for physical filing
Correct answer: Saving data on remote internet-based servers accessible from any device
Cloud storage saves data on remote servers managed by third-party providers, making files accessible via the internet from any authorized device.
Question 3: Which keyboard shortcut is universally used to copy selected text or items?
- Ctrl+X
- Ctrl+V
- Ctrl+C (Correct answer)
- Ctrl+Z
Correct answer: Ctrl+C
Ctrl+C copies the selected content to the clipboard without removing it from its original location.
Question 4: A spreadsheet formula that adds all values in cells A1 through A10 would be written as:
- =TOTAL(A1:A10)
- =ADD(A1,A10)
- =SUM(A1:A10) (Correct answer)
- =COUNT(A1:A10)
Correct answer: =SUM(A1:A10)
The SUM function in spreadsheet applications like Excel adds all numeric values within a specified range of cells.
Question 5: What is the purpose of a PDF file format?
- To allow easy editing by multiple users
- To preserve document formatting across different devices and operating systems (Correct answer)
- To compress images for web use
- To enable real-time collaboration on documents
Correct answer: To preserve document formatting across different devices and operating systems
PDF (Portable Document Format) preserves the exact layout, fonts, and formatting of a document regardless of the software or device used to view it.
Question 6: When creating a mail merge, the 'data source' file typically contains:
- The formatted letter template
- The list of recipients with their names and addresses (Correct answer)
- The company logo and branding
- The email server settings
Correct answer: The list of recipients with their names and addresses
In a mail merge, the data source (often a spreadsheet or database) contains the variable information like names and addresses that get inserted into the template.
CS CS Technology & Office Software 1
In Microsoft Word, the 'Track Changes' feature is used to: