IC3 GS6 Level 2 Exam – Questions and Verified
Answers | 100% Correct
1. What is the primary function of a "Key Assignment" in a software application?
A) To lock the keyboard
B) To assign a specific task to a function key
C) To perform a command using a keyboard shortcut
D) To reassign letters on the keyboard
2. When you use the "Save As" function, what are you typically doing?
A) Overwriting the original file
B) Creating a duplicate of the file with a new name or location
C) Saving only the changes made since the last save
D) Creating a backup copy that cannot be edited
3. In a word processor, what does the Thesaurus tool help you do?
A) Check spelling
B) Find synonyms and antonyms for words
C) Translate text into another language
D) Improve grammar
4. Which chart type is best for showing the relationship between two variables?
A) Pie Chart
B) Scatter Plot
C) Line Chart
D) Bar Chart
5. In a spreadsheet, what does the function =SUM(A1:A10) calculate?
A) The average of cells A1 through A10
B) The highest value in cells A1 through A10
C) The total of all numerical values in cells A1 through A10
D) The number of cells containing data in A1 through A10
,6. What is the purpose of "Mail Merge" in a word processor?
A) To combine multiple email accounts
B) To send a single document to multiple recipients by merging a template with a
data source
C) To merge comments from multiple reviewers
D) To compress large email attachments
7. Which file format is typically used for a read-only document that preserves its
formatting across different devices?
A) .TXT
B) .DOCX
C) .PDF
D) .RTF
8. What is the primary use of "Conditional Formatting" in a spreadsheet?
A) To lock cells based on a condition
B) To automatically change the appearance of cells based on their values
C) To create formulas that only work under certain conditions
D) To sort data alphabetically
9. Which key is used to select non-adjacent files in a file explorer window?
A) Shift
B) Alt
C) Ctrl
D) Tab
10. What does the "Find and Replace" feature allow you to do?
A) Locate misspelled words and correct them automatically
B) Search for specific text and optionally replace it with different text
C) Find lost files on your computer
D) Replace images in a document
11. In a presentation application, what are "Slide Transitions"?
A) The visual effects when moving from one slide to the next
B) The animations applied to individual elements on a slide
,C) The template used for the slides
D) The way slides are organized in the outline view
12. What is a "Cell Reference" in a spreadsheet?
A) A note attached to a cell
B) The address of a cell, defined by its column letter and row number
C) A function that refers to another workbook
D) The style and formatting of a cell
13. Which of the following is an absolute cell reference?
A) A1
B) $A$1
C) A$1
D) #A#1
14. The "Print Area" feature in a spreadsheet allows you to:
A) Select a specific printer to use
B) Define which parts of the worksheet will be printed
C) Adjust the paper size for printing
D) Change the print quality
15. What is the main purpose of the "Track Changes" feature in a word
processor?
A) To automatically correct errors
B) To keep a record of edits, additions, and deletions made by reviewers
C) To track the time spent on a document
D) To change the document's version history
16. Which function would you use to join text from multiple cells into one cell?
A) COMBINE
B) JOIN
C) CONCATENATE or CONCAT
D) MERGE
, 17. In a database, what is a "Record"?
A) A category of information, like "First Name"
B) A single, complete set of related information about one item or person
C) A tool for sorting data
D) A search query
18. What does the "Freeze Panes" feature in a spreadsheet do?
A) Locks specific rows and/or columns in place so they remain visible while
scrolling
B) Makes the spreadsheet read-only
C) Stops formulas from recalculating
D) Hides selected rows and columns
19. Which view in a presentation application is best for arranging the order of
slides?
A) Normal View
B) Slide Sorter View
C) Notes Page View
D) Reading View
20. What is a "Template" in key applications?
A) A pre-designed document with placeholder text and formatting to create a
consistent look
B) The final version of a document
C) A blank document with no formatting
D) A type of file compression
21. The formula =IF(A1>10, "Yes", "No") will return:
A) "Yes" if A1 is less than 10
B) "No" if A1 is greater than 10
C) "Yes" if A1 is greater than 10, and "No" if it is not
D) An error
22. What is the purpose of a "Primary Key" in a database table?
A) To encrypt the data
Answers | 100% Correct
1. What is the primary function of a "Key Assignment" in a software application?
A) To lock the keyboard
B) To assign a specific task to a function key
C) To perform a command using a keyboard shortcut
D) To reassign letters on the keyboard
2. When you use the "Save As" function, what are you typically doing?
A) Overwriting the original file
B) Creating a duplicate of the file with a new name or location
C) Saving only the changes made since the last save
D) Creating a backup copy that cannot be edited
3. In a word processor, what does the Thesaurus tool help you do?
A) Check spelling
B) Find synonyms and antonyms for words
C) Translate text into another language
D) Improve grammar
4. Which chart type is best for showing the relationship between two variables?
A) Pie Chart
B) Scatter Plot
C) Line Chart
D) Bar Chart
5. In a spreadsheet, what does the function =SUM(A1:A10) calculate?
A) The average of cells A1 through A10
B) The highest value in cells A1 through A10
C) The total of all numerical values in cells A1 through A10
D) The number of cells containing data in A1 through A10
,6. What is the purpose of "Mail Merge" in a word processor?
A) To combine multiple email accounts
B) To send a single document to multiple recipients by merging a template with a
data source
C) To merge comments from multiple reviewers
D) To compress large email attachments
7. Which file format is typically used for a read-only document that preserves its
formatting across different devices?
A) .TXT
B) .DOCX
C) .PDF
D) .RTF
8. What is the primary use of "Conditional Formatting" in a spreadsheet?
A) To lock cells based on a condition
B) To automatically change the appearance of cells based on their values
C) To create formulas that only work under certain conditions
D) To sort data alphabetically
9. Which key is used to select non-adjacent files in a file explorer window?
A) Shift
B) Alt
C) Ctrl
D) Tab
10. What does the "Find and Replace" feature allow you to do?
A) Locate misspelled words and correct them automatically
B) Search for specific text and optionally replace it with different text
C) Find lost files on your computer
D) Replace images in a document
11. In a presentation application, what are "Slide Transitions"?
A) The visual effects when moving from one slide to the next
B) The animations applied to individual elements on a slide
,C) The template used for the slides
D) The way slides are organized in the outline view
12. What is a "Cell Reference" in a spreadsheet?
A) A note attached to a cell
B) The address of a cell, defined by its column letter and row number
C) A function that refers to another workbook
D) The style and formatting of a cell
13. Which of the following is an absolute cell reference?
A) A1
B) $A$1
C) A$1
D) #A#1
14. The "Print Area" feature in a spreadsheet allows you to:
A) Select a specific printer to use
B) Define which parts of the worksheet will be printed
C) Adjust the paper size for printing
D) Change the print quality
15. What is the main purpose of the "Track Changes" feature in a word
processor?
A) To automatically correct errors
B) To keep a record of edits, additions, and deletions made by reviewers
C) To track the time spent on a document
D) To change the document's version history
16. Which function would you use to join text from multiple cells into one cell?
A) COMBINE
B) JOIN
C) CONCATENATE or CONCAT
D) MERGE
, 17. In a database, what is a "Record"?
A) A category of information, like "First Name"
B) A single, complete set of related information about one item or person
C) A tool for sorting data
D) A search query
18. What does the "Freeze Panes" feature in a spreadsheet do?
A) Locks specific rows and/or columns in place so they remain visible while
scrolling
B) Makes the spreadsheet read-only
C) Stops formulas from recalculating
D) Hides selected rows and columns
19. Which view in a presentation application is best for arranging the order of
slides?
A) Normal View
B) Slide Sorter View
C) Notes Page View
D) Reading View
20. What is a "Template" in key applications?
A) A pre-designed document with placeholder text and formatting to create a
consistent look
B) The final version of a document
C) A blank document with no formatting
D) A type of file compression
21. The formula =IF(A1>10, "Yes", "No") will return:
A) "Yes" if A1 is less than 10
B) "No" if A1 is greater than 10
C) "Yes" if A1 is greater than 10, and "No" if it is not
D) An error
22. What is the purpose of a "Primary Key" in a database table?
A) To encrypt the data
