OSC Computer and Technology Skills 1 — Questions and Answers
Question 1: In Microsoft Word, which keyboard shortcut creates a new document?
- Ctrl+O
- Ctrl+N (Correct answer)
- Ctrl+S
- Ctrl+P
Correct answer: Ctrl+N
Ctrl+N opens a new blank document in Microsoft Word and most Office applications.
Question 2: What does a spreadsheet's 'AutoSum' function do?
- Formats cells automatically
- Automatically calculates the sum of selected cells (Correct answer)
- Sorts data alphabetically
- Converts text to numbers
Correct answer: Automatically calculates the sum of selected cells
AutoSum (Σ) inserts a SUM formula that totals the selected range of cells with one click.
Question 3: Which file format is most universally compatible for sharing documents across different systems?
- .docx
- .pdf (Correct answer)
- .pages
- .wps
Correct answer: .pdf
PDF (Portable Document Format) preserves formatting across all platforms and devices, making it ideal for sharing.
Question 4: Cloud storage services like OneDrive or Google Drive primarily allow users to:
- Increase RAM speed
- Store and access files from any internet-connected device (Correct answer)
- Replace the operating system
- Block malware automatically
Correct answer: Store and access files from any internet-connected device
Cloud storage saves files on remote servers, enabling access and sharing from any device with an internet connection.
Question 5: What is the purpose of the 'Track Changes' feature in Microsoft Word?
- To change the document font
- To record and display edits made to a document (Correct answer)
- To translate text to another language
- To add page numbers automatically
Correct answer: To record and display edits made to a document
Track Changes marks insertions, deletions, and formatting changes so reviewers can accept or reject each edit.
Question 6: In a spreadsheet, which formula correctly calculates a percentage: the value in A1 out of the total in B1?
- =A1+B1
- =A1/B1 (Correct answer)
- =A1*B1
- =B1-A1
Correct answer: =A1/B1
Dividing the part (A1) by the total (B1) gives the decimal percentage, which can then be formatted as a percent.
OSC Computer and Technology Skills 1
In Microsoft Word, which keyboard shortcut creates a new document?