Broward College Computer Literacy Practice Test

These questions are part of the practice quiz. Start practicing

• What is data validation in spreadsheets?
• What makes up the workbook?
• What is the computer device used for storing data?
• Why is accessibility important in computing?
• In a production environment, which arrangement of devices communicates to monitor and control operations without human input?
• Which term is used for the tabbed areas at the bottom of a spreadsheet that allow you to move between pages?
• Which storage device is the most economical for storing large amounts of data?
• Which option best describes data validation in spreadsheets?
• Which of the following statements about Peer-to-Peer networks is true?
• Why are software updates important for productivity and security?
• Swiping, tapping, pinching, clicking, and dragging are associated with which condition?
• Which term describes very fast storage the CPU uses to speed up access to data?
• In a spreadsheet, what is the intersection of a row and a column called?
• Which tool helps you navigate the contents of your computer to locate files and folders?
• Which system is used to deliver and track web-based training for students, such as D2L?
• What term provides information about the workbook?
• Which statement correctly defines an IP address?
• What does GUI stand for?
• What type of fonts do not have strokes at the ends?
• Which term describes hackers who damage or destroy computer resources?
• What is the means through which you interact with a program?
• Which of the following is a basic first-step diagnostic when a computer will not turn on?
• Which orientation is taller than wide?
• Which statement correctly describes cloud storage versus local storage?
• Which feature allows annotation and clipping of portions of a webpage for later reference?
• What is phishing?
• Which font retains its appearance regardless of the current theme?
• What is a transition in a presentation?
• What is malware and give two examples.
• Which term refers to the grouping of text and numbers in a rectangular grid or table?
• Which term is a predesigned workbook with design features and content?
• What is the plural term for the individual pages that make up a workbook?
• Which action is a recommended response when you suspect a phishing attempt?
• Which feature shows a small preview image of a file before you open it?
• What sequence lets you rename a folder using the Organize option?
• Which term identifies the location of a cell by its column and row coordinates?
• Which network technology is best suited for small networks with only a few computers?
• What acronym describes a communication type where company computers monitor assembly lines and equipment without human intervention?
• What browsing feature allows multiple webpages to display in the same browser window?
• What is the purpose of slide layouts in a presentation program?
• In spreadsheets, which statement correctly identifies the A1 notation?
• Hackers who use their skills for ulterior motives are best described as which type of hacker?
• Which statement about operating system updates is true?
• Give an example of a simple SUM formula for cells B2 through B6.
• In spreadsheets, what is a cell?
• What is a hyperlink?
• Which term refers to the labels that appear over each tab and command on the ribbon?
• What is a compressed folder that stores files so that they take up less disk space?
• Which term describes the central software that manages hardware and software resources on a computer?
• What is the primary benefit of using slide layouts?
• In professional email etiquette, when using attachments, you should:
• Which term refers to a collection of electronic documents or files stored on web servers?
• Which user interface feature contains buttons for common formatting options used for the selected item?
• Which term best describes someone who uses servers, industry-specific computers, spreadsheets, databases, and accounting software?
• What enables file overview, and the ability to move, copy, rename, and delete files and folders?
• Which shows the results of each formatting option before you apply it to your workbook?
• What term describes a small hint that appears when you hover over a web link, showing the URL?
• Which colors are always available regardless of the workbook's theme?
• Which element displays details about the folder window and the selected objects?
• A hybrid topology combines which two classic topologies?
• What does NIC stand for in computer networking?
• In a spreadsheet, how do you sort data in ascending order by a single column?
• What provides previews of the file contents for certain file types?
• What is the purpose of a username and password in a system?
• Which term describes a device that reorganizes data to improve access times on disk?
• Which topology is described as a combination of bus and star configurations?
• What browser feature tracks the pages you visit over time, not just within a single session?
• Which term describes the sheet that contains a chart used to visually represent worksheet data?
• Which term describes the 12 colors that belong to the workbook's theme?
• Cloud computing relies on which two essentials for access?
• Wi-Fi stands for Wireless Fidelity. What is its primary purpose?
• Which technique reduces file size to save storage space?
• What is the term for the notation that indicates a file's location on your computer?
• Which feature shows folders you used frequently and recently?
• Which toolkit is used for creating 2D and 3D drawings, game interfaces, and multiplayer control?
• Which file format is commonly used to preserve document formatting across devices and applications?
• Which device is NOT a typical input device?
• Which statement correctly describes Disk Operating System in the material?
• Which font category updates automatically when the theme changes?
• Which of the following is a best practice for creating strong passwords?
• Which platform coordinates hardware resources and determines what kind of software can be used, among other things?
• Which term describes services that locate information on the internet by querying keywords?
• Which term is the full form of the acronym GUI?
• Why are backups important for data security?
• What is proper email etiquette for professional messages?
• Which tool removes unnecessary and temporary files?
• Which term refers to the record of websites you have visited over time?
• Unauthorized access and usage of computing resources is described as what?
• Which of the following is a primary reason to keep the operating system updated?
• A common scam used to steal passwords and personal information by impersonating a legitimate company is called what?
• Name a common input device pair.
• Which device is primarily responsible for connecting two or more networks and directing data flow between them?
• Which orientation is used when the page is wider than tall?
• Which term refers to descriptive text that appears when you hover over a command on the ribbon?
• Which process reorganizes files in storage for faster access?
• Which font remains unchanged by the theme?
• Which statement best describes a phishing attempt?
• Which feature allows you to save articles for later reading?
• What does GUI stand for?
• In manufacturing, which term refers to using computer software to guide the production process?
• Encryption is best described as which of the following?
• What is a backup and why is it important?
• When the copyright has expired, the work is free to copy without requesting permission from the last copyright holder. What is this status called?
• Which term describes a sheet that contains a chart that provides a visual representation of worksheet data?
• What feature lets you save a webpage with notes and highlights and clip a section of the page?
• Which term is a box with descriptive text about a command that appears when you point to a button on the ribbon?
• What term describes the status when a creative work is no longer protected by copyright?
• Which term is abbreviated as WAP?
• Which term refers to computers connected to the internet that manage the display of webpages?
• Which method allows you to sort data by more than one column, specifying primary and secondary sort keys?
• Which of the following is a typical chart type used to represent data visually?
• Which statement best describes the operating system’s role?
• Which term refers to the individual pages contained within a workbook?
• Which term describes a sheet that contains grids and columns into which you can enter text, numbers, dates, formulas and display charts?
• Which term identifies the address of a specific page on the web?
• Which element can display a quick list of frequently used resources and locations?
• What is the difference between Save and Save As?
• In Windows 10, which electronic personal assistant helps you find files and perform tasks?
• Which statement about volatile memory is true?
• Which term describes the area at the bottom of the Excel window that shows information about the workbook?
• What term describes a device that routes traffic between a local network and the internet?
• What is the primary function of the CPU?
• Which pane displays icons and links to resources and locations on your computer?
• What do you call two or more computers connected together to share resources?
• Which term refers to a container that stores files and subfolders, not a single file?
• Which term describes the small, fast memory used by the CPU to speed up data access?
• How does RAM differ from hard drive storage?
• Devices that draw power even when turned off or in standby are often called what?
• In a spreadsheet, what is the term for the cell that is currently selected?
• Which term is described as text-based and is commonly abbreviated as the Disk Operating System?
• Which statement about file extensions is accurate?
• What best defines a digital footprint?
• What is a container for files?
• What is the term for a scam where attackers impersonate a real company to obtain personal information?
• How can phishing emails be distinguished from legitimate messages?
• Which orientation is wider than tall?
• Which statement describes HTTPS security?
• Which characters should be avoided in file names for compatibility across systems?
• What is the purpose of a chart in a spreadsheet?
• What identifies where a webpage is located on the internet?
• Which scenarios can a backup help recover from?
• Which device connects a home network to the internet by combining a modem and router?
• What term specifies in which direction content is printed on the page?
• Which step is performed last in the described process to save a file on a USB drive?
• Backups are used to recover data after which event?
• What term describes the system of interlinked documents accessed via the internet?
• Name a common Excel function used to calculate the average of a range.
• Which term denotes a single page in a spreadsheet that holds data arranged in rows and columns?
• What does QR stand for in codes scanned by cameras?
• Which component delivers web pages to users?
• Which of the following is considered hardware?
• What is the total amount of sales at all stores?
• Which statement describes version history in cloud documents?
• Why is https more secure than http?
• Which term indicates the column and row in which the cell is located?
• Which term describes the types of sheets Excel supports?
• What does a file path like C:\Users\John\Documents represent?
• Contains buttons for viewing the properties of a file or folder, creating a new folder, and customizing the toolbar.
• Which term describes a workbook with many design features and some content already filled in?
• Which technology is used to speak to others online, enabling voice communication over the Internet?
• What is version history in cloud documents?
• Which description best matches the effect of browser caching on page load times?
• What is the collection of formatting for text, colors, and effects that give a workbook a unique look and feel?
• Which term is the name you give to a file when you save it to identify its contents?
• What do you call a collection of data that has a name and is stored on a computer?
• Which term describes the container that holds files and subfolders?
• What feature enters text based on patterns it finds in the data?
• In Windows, what file extension usually indicates a Word document created with Microsoft Word?
• Which term describes the window that displays the entire workbook and lets you switch between sheets?
• What term describes the global system of interconnected computer networks that enables communication and information exchange?
• Which keyboard shortcuts copy and paste?
• In Windows, which assistant helps you locate files and perform system searches?
• Which feature saves links to webpages that you want to read later?
• What is a graphical user interface (GUI)?
• Name a common output device pair.
• Which font category is used for headings and body text in the workbook and changes automatically when the theme changes?
• Which protocol is used for transferring files between computers on a network?
• What operation maximizes hard drive space?
• What is the term for the collection of webpages that are accessible via the internet?
• Which is an example of using the AVERAGE function on a range?
• What term describes manufacturing where workers use computers to assemble a custom product?
• Which interface is described as colorful and displays pictures?
• The notation A1:G5 separated by a colon is called what?
• Which concept involves accessing files and programs online via the internet, requiring a web browser?
• What are cookies in a web browser?
• Where are the contents of a workbook laid out in a grid of rows and columns?
• What does the term 'browser cache' refer to?
• Which fonts have extra strokes at the end of each character that aid in reading passages of text (for example Times New Roman)?
• What is the term for a key or combination of keys used to access a feature or perform a command?
• Which hardware component must be present for a computer to connect to a network?
• A cookies in a web browser are used to
• Why might you export a document as a PDF rather than a Word file?
• What is a digital footprint?
• What is Presenter View in a presentation program?
• What does HTTP stand for?
• What is cloud collaboration?
• What is the acronym for File Transfer Protocol?
• What term describes the set of rules computers use to exchange files?
• Which service provides online storage space for your files?
• Which cloud service from Microsoft provides online storage for your files?
• What does WAP stand for?
• Which set of tools is contained in a Software Development Kit for creating 2D/3D drawings, game interfaces, and multiplayer control?
• Which term describes a collection of related pages that share a domain?
• Which feature enables multiple people to work on the same document at the same time?
• Which acronym is commonly used for platforms that host online courses and track learner progress?
• What should you consider when opening email attachments from unknown senders?
• What is the purpose of an operating system?
• Which option shows a preview of formatting changes before you apply them?
• What term describes a device that retrieves and sometimes records data on a disk?
• What is the difference between relative and absolute cell references?
• What term denotes a collection of related webpages?
• What term describes good hackers who work to protect and strengthen systems?
• Which term describes a hacker who uses skills to improve security by finding vulnerabilities with permission?
• Which term describes tools that return lists of relevant documents in response to a user query on the internet?
• What feature fills a column with data based on patterns in neighboring data?
• Which toolbar provides quick access to common formatting options when editing text?
• Which action describes renaming a folder in a typical file management workflow?
• RFID technology uses radio frequencies to track objects and often features one-way communication.
• What is the legal protection granted by law to the author of an original work called?
• How does cloud storage differ from local storage?
• Using someone else's Wi-Fi without consent is known as what?
• Which element provides options for specifying how File Explorer and its contents are displayed?