Teaching Goodies Y7 ICT Baseline Assessment
A self marking Y7 ICT baseline assessment.
Questions and Answers
- 1.
What of these pieces of software would be the most appropriate to use for producing a poster?
- A.
Microsoft Publisher
- B.
Microsoft Word
- C.
Microsoft Excel
- D.
Microsoft Powerpoint
Correct Answer
A. Microsoft PublisherExplanation
Microsoft Publisher is the most appropriate software to use for producing a poster because it is specifically designed for creating professional-looking publications, including posters. It provides a wide range of templates, design tools, and features that allow users to easily customize and layout their posters. Microsoft Word, Excel, and PowerPoint are more suited for creating documents, spreadsheets, and presentations respectively, and may not have the same level of design capabilities and templates as Microsoft Publisher.Rate this question:
-
- 2.
True or False: If you get a nasty email you should always send a nasty one back.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
It is not advisable to respond to a nasty email with another nasty one. Engaging in a negative exchange can escalate the situation and create more conflict. Instead, it is better to remain calm and composed, and if necessary, address the issue in a polite and professional manner. Responding with kindness and understanding can help defuse the situation and promote better communication and resolution.Rate this question:
-
- 3.
You need to be careful when opening email attachments because sometimes email attachments can contain
Correct Answer
virus, computer virus, trojan, viruses, computer viruses, trojans, VIRUS, Virus, Computer Virus, Computer virus, COMPUTER VIRUS, Computer Viruses, COMPUTER VIRUSES, Computer virusesExplanation
Opening email attachments can be risky because they can contain various types of malware, including viruses, computer viruses, and trojans. These malicious programs can harm your computer, steal your personal information, or cause other damage. It is important to exercise caution and use antivirus software to scan attachments before opening them to protect your computer and data.Rate this question:
- 4.
Which if these is not an input peripheral?
- A.
Printer
- B.
Mouse
- C.
Keyboard
- D.
Webcam
Correct Answer
A. PrinterExplanation
A printer is not considered an input peripheral because it is used to produce output in the form of physical copies of documents or images. Input peripherals are devices that allow users to input data into a computer system, such as a mouse, keyboard, or webcam.Rate this question:
-
- 5.
When using a spreadsheet to perform calculations, which of these functions would you use add together several values?
- A.
=SUM(B5:D8)
- B.
SUM=B5:D8
- C.
=B5:D8(SUM)
- D.
=SUM(B5+D8)
Correct Answer
A. =SUM(B5:D8)Explanation
Formulas and functions always start with an '=' symbol. We then add the function SUM(). In between the brackets you should write the range of cells youd like to add together. In this case, the range is from B5 all the way to D8. You should never use a '+' symbol in a =SUM() function.Rate this question:
-
- 6.
What of these web addresses (URLs) is correct?
- A.
Www.bbc.co.uk
- B.
Bbc.www.com
- C.
Www.bbc@com
Correct Answer
A. Www.bbc.co.ukExplanation
The correct web address (URL) is www.bbc.co.uk. This is because it follows the standard format of a web address, starting with "www" which stands for World Wide Web, followed by the domain name "bbc", and ending with the country code top-level domain ".co.uk" which indicates that it is a website based in the United Kingdom. The other options, bbc.www.com and www.bbc@com, do not follow the standard format and are therefore incorrect.Rate this question:
-
- 7.
Hugo needs to keep draft copies of his presentation as he works to improve it. Which of the following would be the best way to keep draft versions?
- A.
Print off each version
- B.
Just press save
- C.
Save each draft version with a new file name
Correct Answer
C. Save each draft version with a new file nameExplanation
Saving each draft version with a new file name would be the best way to keep draft versions of Hugo's presentation. This method allows him to easily identify and access different versions of his presentation as he works to improve it. By giving each draft a unique file name, Hugo can keep track of the changes he makes and revert back to previous versions if needed. Printing off each version would result in a physical copy that may be difficult to organize and manage. Just pressing save without creating new file names would overwrite previous versions, making it harder to track progress and changes.Rate this question:
-
- 8.
Which of these is a bar chart?
- A.
![Teaching Goodies Y7 ICT Baseline Assessment - Quiz]()
- B.
![Teaching Goodies Y7 ICT Baseline Assessment - Quiz]()
- C.
![Teaching Goodies Y7 ICT Baseline Assessment - Quiz]()
- D.
![Teaching Goodies Y7 ICT Baseline Assessment - Quiz]()
- E.
![Teaching Goodies Y7 ICT Baseline Assessment - Quiz]()
Correct Answer
A.Explanation
A bar chart is a type of graph that represents data using rectangular bars of varying heights. Each bar represents a category or group, and the height of the bar corresponds to the value or frequency of that category. It is commonly used to compare and display data across different categories or time periods. Examples of bar charts include histograms, column charts, and stacked bar charts.Rate this question:
-
- 9.
Which cell of this spreadsheet show the cost of one ruler?
Correct Answer
A9Explanation
The cost of one ruler is shown in cell A9 of the spreadsheet.Rate this question:
- 10.
One method of connecting to the Internet is via a cable. What is another method?
Correct Answer
Wirless, Wirelessly, Mobile, Mobile Internet, 3G, HSDPA, EdgeExplanation
The correct answer is "Wireless". This is another method of connecting to the internet, where a wireless network is used instead of a cable. It allows devices to connect to the internet without the need for physical wired connections. Other terms mentioned in the options such as "Mobile Internet", "3G", "HSDPA", and "Edge" are specific technologies or standards used for wireless internet connectivity on mobile devices.Rate this question:
- 11.
When composing a new email, you will need to choose a recipient. What does recipient mean?
- A.
The person who you are sending the email to
- B.
The person who is sending the email
- C.
It means you are adding a file attachment
- D.
It means you are not allowed to send the email
Correct Answer
A. The person who you are sending the email toExplanation
Recipient means the person who you are sending the email to. This is the person who will receive and read the email.Rate this question:
-
- 12.
Look at this spreadsheet which is being used to work out the costs involved in producing a school year book. Which cell contains the value of the selling price of a year book?
Correct Answer
C4Explanation
The cell C4 contains the value of the selling price of a yearbook. This can be determined by looking at the spreadsheet and identifying the cell that is specifically labeled or designated for the selling price. In this case, C4 is the cell that corresponds to the selling price, as indicated by the given answer.Rate this question:
- 13.
What is the correct name for the technique shown in this example?
- A.
Centre text
- B.
Fill text
- C.
Wrap text
Correct Answer
C. Wrap textExplanation
Wrap text is the correct name for the technique shown in this example. This technique allows the text to automatically wrap and fit within a specified area, such as a cell in a spreadsheet or a text box. It ensures that all the text is visible without extending beyond the boundaries of the designated area. This is useful when dealing with large amounts of text or when formatting data in a visually appealing manner.Rate this question:
-
- 14.
When you are finished writing an email, which button do you press so that is can be delivered?
Correct Answer
Send, send, SENDExplanation
After finishing writing an email, the button that needs to be pressed in order to deliver it is the "Send" button. This action will send the email to the intended recipient(s) and it will be delivered to their inbox. By pressing the "Send" button, the email is sent from the sender's email account to the email server, which then forwards it to the recipient's email server and finally to their inbox.Rate this question:
- 15.
What kind of words will the spellchecker sometimes say are spelled wrong even if they are not?
- A.
Names of people or places
- B.
Months
- C.
Text that wraps around the pictures
- D.
Numbers
Correct Answer
A. Names of people or placesExplanation
The spellchecker sometimes says names of people or places are spelled wrong even if they are not because it may not have those names in its dictionary. Since names can be unique and vary greatly, the spellchecker may not recognize them as correct spellings. Similarly, places may have specific spellings or variations that are not recognized by the spellchecker. Therefore, it may flag them as incorrect even if they are spelled correctly.Rate this question:
-
- 16.
Look at the spreadsheet, if the value in cell B3 is changed, what other two cells will automatically change?
- A.
D3, D6
- B.
D3, C6
- C.
D6, B3
- D.
C3, C6
Correct Answer
A. D3, D6Explanation
If the value in cell B3 is changed, the other two cells that will automatically change are D3 and D6.Rate this question:
-
- 17.
Which of these images is a Folder?
- A.
1st image
- B.
2nd image
- C.
3rd image
- D.
4th image
Correct Answer
B. 2nd imageExplanation
The second image is a folder because it depicts a graphical representation of a folder commonly used in computer systems. It has a tab at the top with a label, a fold in the middle, and a bottom section. This image closely resembles the appearance of a physical folder and is commonly used to organize and store files and documents in digital formats.Rate this question:
-
- 18.
Its ok to give a password to a friend as long as you trust that person.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Giving a password to a friend, even if you trust them, is not recommended. Sharing passwords can lead to security risks and compromise the confidentiality of personal information. It is best to keep passwords private and not share them with anyone, even trusted individuals.Rate this question:
-
- 19.
True or False: You should always open every email attachment.
Correct Answer
False, false, FALSEExplanation
It is not advisable to always open every email attachment. Opening email attachments without verifying their source or content can put your computer and personal information at risk. Attachments can contain viruses, malware, or other malicious software that can harm your device or compromise your data. It is important to exercise caution and only open attachments from trusted sources or when you are expecting them. Always use antivirus software and keep it up to date to protect against potential threats.Rate this question:
- 20.
A horizontal section on a spreadsheet, represented by a number, is called a: _______________________
Correct Answer
row, Row, ROWExplanation
A horizontal section on a spreadsheet, represented by a number, is called a row. The term "row" is commonly used in spreadsheet software to refer to a horizontal line of cells. It is represented by a number, typically displayed on the left side of the spreadsheet. The answer also includes variations of the term "row" with different capitalizations, emphasizing that it can be written in different ways.Rate this question:
- 21.
What symbol is used at the start of every formula?
- A.
/
- B.
+
- C.
*
- D.
=
Correct Answer
D. =Explanation
The equal sign (=) is used at the start of every formula. This symbol is used to indicate that the following characters are part of a formula and not a regular text or number. It is a common convention in many programming languages and spreadsheet applications to use the equal sign as a prefix for formulas.Rate this question:
-
- 22.
How can you access the Windows Start menu?
- A.
Windows Logo on screen
- B.
Windows Logo key on the keyboard
- C.
Any file menu
- D.
Dock
- E.
Command
Correct Answer(s)
A. Windows Logo on screen
B. Windows Logo key on the keyboardExplanation
The start menu had changed since Windows Vista when Windows Aero was introduced. The Windows key on certain keyboards will also work.Rate this question:
-
- 23.
The highlighted icon below is what you click to ________________ a file to your message.
Correct Answer(s)
attach, ATTACHExplanation
The correct answer is "attach, ATTACH". The question is asking for the icon that you click to attach a file to your message. The word "attach" is commonly used to describe the action of adding a file to a message or email. The word "ATTACH" is written in capital letters to emphasize that it is the correct answer.Rate this question:
- 24.
Which of the following is a web address?
- A.
- B.
Http://www.k12.ar.us
- C.
News.k12.chat.teacher
- D.
Ftp.classroom.com
Correct Answer
B. Http://www.k12.ar.usExplanation
The correct answer is "http://www.k12.ar.us" because it starts with "http://" which indicates that it is a web address. Additionally, it includes the domain name "k12.ar.us" which further confirms that it is a web address.Rate this question:
-
- 25.
Which of the following statements is the best description of spreadsheet software?
- A.
Allows you to work with text, images and graphs
- B.
Allows you to work with numerical data and graphs
- C.
Lets you work out maths problems
- D.
Lets you work with different types of information and do sums
Correct Answer
B. Allows you to work with numerical data and graphsExplanation
Spreadsheet software is a tool that allows users to work with numerical data and graphs. It provides a platform for organizing and analyzing data, performing calculations, and creating visual representations such as charts and graphs. This software is commonly used in business and finance to track and analyze data, create budgets and financial models, and generate reports. It is not primarily designed for working with text, images, or solving math problems, although it may have some limited capabilities in these areas.Rate this question:
-
- 26.
Which of the following is an email address:
- A.
Ftp.classroom.com
- B.
- C.
Http://www.k12.ar.us
- D.
News.k12.chat.teacher
Explanation
An email address is a unique identifier used to send and receive electronic mail. It typically consists of a username followed by the "@" symbol and the domain name of the email service provider. In this case, "[email protected]" is a valid email address as it follows this format. The other options provided are not email addresses; they are either website URLs or server addresses.Rate this question:
-
- 27.
If you change the contents of cell C3, what two other cells would automatically change?
- A.
B3, B6
- B.
C3, C6
- C.
C3, D6
- D.
D3, D6
Correct Answer
D. D3, D6Explanation
If you change the contents of cell C3, the two other cells that would automatically change are D3 and D6.Rate this question:
-
- 28.
The blinking line found in the text area where the computer shows you your position on the screen is called the _________.
Correct Answer
cursor, CURSOR, CursorExplanation
The blinking line found in the text area where the computer shows you your position on the screen is called the cursor. The cursor indicates where the next character will be inserted or where the next action will take place. It is used to navigate and edit text in various applications and programs.Rate this question:
- 29.
Another word for "junk" email is ______________ .
Correct Answer
SPAM, spam, SpamExplanation
"Another word for 'junk' email is SPAM. SPAM refers to unsolicited and unwanted emails that are typically sent in bulk to a large number of recipients. The term 'spam' originated from a famous Monty Python sketch where the word 'spam' was repeated multiple times, similar to the repetitive and unwanted nature of these emails. Therefore, SPAM is the correct answer."Rate this question:
- 30.
What is a collection of data or information called, that is stored in a logical and structured way?
- A.
Field
- B.
Story
- C.
Database
- D.
Column
- E.
Spreadsheet
Correct Answer
C. DatabaseExplanation
A collection of data or information that is stored in a logical and structured way is called a database. A database allows for efficient organization, storage, and retrieval of data, making it easier to manage and analyze large amounts of information.Rate this question:
-
- 31.
Select three output devices?
- A.
Scanner
- B.
Speaker
- C.
Printer
- D.
Microphone
- E.
Monitor
Correct Answer(s)
B. Speaker
C. Printer
E. MonitorExplanation
The question asks for three output devices. An output device is a peripheral device that displays or presents data from the computer. The options given are scanner, speaker, printer, microphone, and monitor. Out of these options, the correct answer is speaker, printer, and monitor. A speaker is an output device that plays audio or sound. A printer is an output device that produces hard copies of documents. A monitor is an output device that displays visual output from the computer.Rate this question:
-
- 32.
A vertical section on a spreadsheet, represented by a letter, is called a: _______________________
Correct Answer(s)
column, Column, COLUMNExplanation
A vertical section on a spreadsheet, represented by a letter, is called a column. In spreadsheet software, such as Microsoft Excel, columns are used to organize and categorize data. They are typically labeled with letters, starting from A and going up to Z, and then continuing with AA, AB, AC, and so on. The term "column" can be written in lowercase (column), uppercase (Column), or all uppercase (COLUMN), depending on the context or personal preference.Rate this question:
- 33.
The area around the edge of the page that is not printed on is referred to as:
- A.
Header
- B.
Footer
- C.
Margin
- D.
Edge
Correct Answer
C. MarginExplanation
The area around the edge of the page that is not printed on is referred to as the margin. This space is left blank intentionally to provide a visual buffer and prevent the text or images from being too close to the edge of the page. It also allows for easy handling of the printed material without interfering with the content.Rate this question:
-
- 34.
Among the advantages of using email are (check all that are correct):
- A.
Speed
- B.
Convenience
- C.
Accessibility
- D.
Cost
- E.
Ability to add attachments
Correct Answer(s)
A. Speed
B. Convenience
C. Accessibility
D. Cost
E. Ability to add attachmentsExplanation
Email has several advantages, including speed, convenience, accessibility, cost-effectiveness, and the ability to add attachments. Emails can be sent and received instantly, allowing for quick communication. It is also convenient as it can be accessed from anywhere with an internet connection. Compared to other forms of communication, email is cost-effective as it eliminates the need for postage or phone charges. Additionally, email allows users to attach files, such as documents or images, making it a versatile tool for sharing information.Rate this question:
-
- 35.
What technique has been used here to lay information out neatly?
- A.
Word Processing
- B.
Database
- C.
Form
- D.
Table
Correct Answer
D. TableExplanation
A table has been used to lay out the information neatly. Tables are commonly used in word processing and database programs to organize data in rows and columns, making it easier to read and understand. They provide a structured format for presenting information in a clear and organized manner.Rate this question:
-
- 36.
The correct name for the format of money on a spreadsheet is what?
Correct Answer
currency, Currency, CURRENCYExplanation
The correct name for the format of money on a spreadsheet is currency, Currency, or CURRENCY. This format is used to display monetary values in a specific currency format, such as dollar sign ($) or euro symbol (€), and may include decimal places and thousands separators. It is important to use the correct currency format in order to accurately represent and calculate financial data in a spreadsheet.Rate this question:
- 37.
Why shouldn't I type my e-mails in all CAPITALS?
- A.
Using CAPITALS insinuates you are adding very strong emphasis or yelling.
- B.
It makes you look lazy and/or uneducated.
- C.
It makes reading your e-mail more difficult for the person to whom you are sending it.
- D.
All of the above.
Correct Answer
D. All of the above.Explanation
Typing emails in all capitals should be avoided because it insinuates strong emphasis or yelling, which can come across as aggressive or rude. Additionally, it can make the sender appear lazy or uneducated, as typing in all capitals is often associated with informal or careless communication. Moreover, reading emails in all capitals can be more difficult for the recipient, as it disrupts the normal flow of text and can be visually overwhelming. Therefore, all of the given reasons explain why typing emails in all capitals is not recommended.Rate this question:
-
- 38.
A database program replaces what piece of office equipment?
- A.
Telephone
- B.
Typewriter
- C.
Filing cabinet
Correct Answer
C. Filing cabinetExplanation
A database program replaces a filing cabinet as it allows for the storage and organization of data in a digital format, eliminating the need for physical paper files. With a database program, information can be easily accessed, searched, and updated, making it more efficient and convenient than a filing cabinet.Rate this question:
-
- 39.
Which is best to use for a list that needs to be in the right order?
- A.
Stars
- B.
Bullets
- C.
Dashes
- D.
Numbers
Correct Answer
D. NumbersExplanation
Numbers are the best to use for a list that needs to be in the right order because they provide a clear and sequential hierarchy. Using numbers allows for easy identification and organization of items in the list, ensuring that the order is maintained and easily understood by the readers.Rate this question:
-
- 40.
Look at the chart, what information is missing from it?
- A.
Title, legend
- B.
Title, legend and units
- C.
Title
- D.
Legend
Correct Answer
B. Title, legend and unitsExplanation
The correct answer is Title, legend and units. The chart is missing important information that helps provide context and understanding. A title would give a brief description of what the chart is about, while a legend would explain the meaning of the different elements or colors in the chart. Additionally, units are necessary to understand the scale or measurement being used in the chart. Without these missing pieces of information, it would be difficult to interpret the chart accurately.Rate this question:
-
- 41.
What technique has been used at Point Y in the diagram?
- A.
Centred
- B.
Right justified
- C.
Indented
- D.
Bullets
Correct Answer
C. IndentedExplanation
The technique used at Point Y in the diagram is indented. This can be inferred from the visual representation in the diagram, where the text at Point Y is aligned with a slight indentation from the left margin.Rate this question:
-
- 42.
How has cell C4 been formatted?
- A.
Centred
- B.
Left Justified
- C.
Currency
Correct Answer
A. CentredExplanation
Cell C4 has been formatted as "Centred". This means that the content in the cell is aligned in the center of the cell.Rate this question:
-
- 43.
Look at the spreadsheet, how has cell D6 been formatted?
- A.
Bold, currency
- B.
Bold, centred
- C.
Left aligned, italics
- D.
Bold, formula
Correct Answer
A. Bold, currencyExplanation
Cell D6 has been formatted as bold and currency.Rate this question:
-
- 44.
The technique illustrated below is called:
- A.
Numbering
- B.
Bullets
- C.
Line spacing
Correct Answer
B. BulletsExplanation
The technique illustrated below is called bullets. This refers to the use of small symbols or icons, typically round dots or squares, to visually separate and organize items in a list or paragraph. Bullets are commonly used to present information in a concise and easy-to-read format, allowing for better readability and comprehension.Rate this question:
-
- 45.
Page orientation refers to pages being either portrait or _________________. Type in the missing word below.
Correct Answer
landscape, Landscape, LANDSCAPEExplanation
Page orientation refers to the way in which pages are positioned, either vertically (portrait) or horizontally (landscape). The missing word is "landscape", which is the correct answer. It can be written in lowercase or uppercase, as both are acceptable.Rate this question:
- 46.
In word processing, when you make changes to the words on a page (for example inserting new text), it is called:
- A.
Editing
- B.
Formatting
- C.
Cutting
- D.
Pasting
Correct Answer
A. EditingExplanation
Editing refers to the process of making changes to the words on a page, such as inserting new text, deleting text, or modifying existing text. This can include tasks like proofreading, revising, and rearranging the content to improve clarity, coherence, and overall quality. Formatting, cutting, and pasting are also common actions in word processing, but they do not encompass the broader concept of making changes to the words on a page like editing does.Rate this question:
-
- 47.
Which of the following is a general rule you should follow when naming your files.
- A.
Must be unique (a different name to your other files)
- B.
Must be in all capital leters
- C.
Can only be 8 characters
- D.
Use 'Untitled 1'
Correct Answer
A. Must be unique (a different name to your other files)Explanation
When naming your files, it is important to choose a name that is unique and different from your other files. This helps to avoid confusion and ensures that each file can be easily identified. By giving each file a distinct name, you can easily locate and access the specific file you need without any difficulty.Rate this question:
-
- 48.
Rachel and Andrew use a word processing package to do their homework. They were both working when suddenly there was a power cut. Rachel lost all of her work but Andrew only lost part of his. What had Rachel forgotten to do?
- A.
Print
- B.
Save
- C.
Load
- D.
Spellcheck
Correct Answer
B. SaveExplanation
Rachel had forgotten to save her work.Rate this question:
-
- 49.
True or False. When you copy a file to another location, the original file is deleted.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
When you copy a file to another location, the original file is not deleted. Instead, a duplicate of the file is created in the new location while the original file remains intact in its original location.Rate this question:
-
- 50.
Which of the following is the best definition of "word processing"?
- A.
Using a computer to create, edit and print documents
- B.
Using a computer to type letters
- C.
Using a computer to improve the appearance of documents
Correct Answer
A. Using a computer to create, edit and print documentsExplanation
Word processing refers to the use of a computer to create, edit, and print documents. It involves using software to input and manipulate text, format it, and then produce a physical or digital copy of the document. This definition encompasses the entire process of working with text on a computer, from initial creation to final output. It is a more comprehensive description compared to the other options, which focus on specific aspects such as typing letters or improving document appearance.Rate this question:
-
.jpg "Which if these is not an input peripheral?")
.png)
.png "If you change the contents of cell C3, what two other cells would automatically change?")
.png "How has cell C4 been formatted?")
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
May 02, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 27, 2012Quiz Created by
Teachingoodies
Back to top