Computer Essentials Final Exam Practice Spring 2016

An icon is indeed an on-screen picture that is used to represent an object or program. Icons are commonly used in graphical user interfaces to visually represent different functions, applications, or files. They provide a visual cue to users and make it easier to identify and access various elements on a screen. Therefore, the statement "An icon is an on-screen picture that represents an object or program" is true.

A business card is a small printed card that typically includes a person's name and business contact information. It serves as a convenient way for individuals to share their professional details with others. Business cards are commonly used in networking events, meetings, and conferences to exchange contact information and promote one's business or services. They are portable and easily fit into wallets or cardholders, making them a practical tool for professionals to establish and maintain connections in the business world.

Headphones are considered an output device because they receive audio signals from a computer or device and produce sound for the user to hear. They do not input any data or commands into the computer, making them solely an output device for audio output.

Hardware refers to the physical components of a computer system, such as the keyboard, monitor, and other tangible parts. Software, on the other hand, refers to the programs and instructions that run on the hardware. Therefore, the correct answer is hardware as it specifically refers to the physical components of the computer system.

When applying background colors to slides, you have the option to apply them to either all slides in the presentation or just the selected slide. This means that you can choose to have a consistent background color throughout the entire presentation or have different background colors for different slides.

The correct answer is "Personal computer" because when using a PC, you are referring to a device that is designed for personal use and can perform various tasks such as word processing, internet browsing, gaming, etc. It is a general-purpose computer that can be programmed to perform different functions based on the user's requirements.

A firewall acts as a gatekeeper controlling the Internet traffic leaving from and coming into your computer. It monitors and filters the network traffic based on predetermined security rules, allowing only authorized connections and blocking potentially harmful ones. By doing so, it helps protect your computer and network from unauthorized access, viruses, malware, and other cyber threats.

In a spreadsheet formula, the asterisk symbol (*) is used to indicate multiplication. This symbol is used to perform the mathematical operation of multiplying two or more values together.

To access the backstage view in order to open or save a document, you need to click on "File". This option typically appears in the top left corner of the application's interface and provides access to various file-related functions such as creating new documents, opening existing ones, saving, printing, and managing document properties.

The clipboard is a feature or tool in a computer or software program that allows users to temporarily store cut or copied text. This text can then be pasted into another location or document. The purpose of the clipboard is to provide a way to transfer or move text from one place to another without losing the original content. Therefore, the statement that the clipboard is a tool that temporarily stores cut or copied text is true.

An active cell is a term used to describe a cell on a spreadsheet that is currently selected or highlighted. This means that any data or formulas entered into the spreadsheet will be applied to the active cell. It is the cell where the user can input or edit data, and any changes made to the active cell will be reflected in the spreadsheet.

The correct answer is Central Processing Unit. The CPU, or Central Processing Unit, is the primary component of a computer that carries out instructions of a computer program by performing basic arithmetic, logical, control, and input/output (I/O) operations. It is often referred to as the "brain" of the computer as it is responsible for executing instructions and coordinating the activities of all the hardware and software components in a computer system.

To stop a non-responding application, you would go to the Task Manager. The Task Manager is a utility in Windows that allows users to view and manage running processes, including the ability to end tasks or processes that are not responding. By accessing the Task Manager, users can identify the non-responding application and force it to close, allowing them to regain control of their system.

A presentation in PowerPoint is commonly referred to as a "slide show" because it involves displaying a series of slides containing information, graphics, and multimedia elements in a sequential manner. During a slide show, the presenter navigates through the slides to deliver the content to an audience. Therefore, the term "slide show" accurately describes the process of presenting a PowerPoint presentation.

A logo is a name, symbol, emblem, or trademark designed to define an image for a company. It serves as a visual representation of the company's identity and helps to create brand recognition and recall among customers. Logos are often used on various marketing materials, such as business cards and publications, to establish a cohesive and memorable brand image.

The correct answer is "undo" because the undo command allows you to reverse an action that you realize was a mistake. This command is commonly used in various software applications to revert back to a previous state or to undo the last action performed. It is a convenient way to fix errors or changes made unintentionally.

To change the color of a triangle on a document, you would use the "shape fill" tool. This tool allows you to select a specific color or pattern to fill the shape with, giving it a new appearance. The "font color" tool is used to change the color of text, not shapes. The "line color" tool is used to change the color of the outline or border of a shape, not the interior color.

A keyboard is an input device because it allows the user to input data or commands into a computer or electronic device. It consists of a set of keys that are used to type letters, numbers, and other characters. When the keys are pressed, the corresponding characters are sent to the computer or device, allowing the user to interact with it and provide input. In contrast, speakers and monitors are output devices, as they display or produce information from the computer or device.

When you change the layout of a slide, PowerPoint retains or keeps the text and objects. This means that when you switch to a different layout, the content on the slide, including the text and objects, will still be present and unchanged. The layout change only affects the arrangement and design of the slide, not the actual content.

Copyright laws are designed to protect authors and artists who create original works. These laws grant the creators exclusive rights to reproduce, distribute, and publicly display their works. This ensures that others cannot use or profit from their creations without permission. By providing legal protection, copyright laws encourage creativity and innovation by allowing creators to benefit from their original ideas and expressions.

Both a flash drive and a CD are considered storage devices because they are capable of storing and retrieving data. A flash drive is a portable device that uses flash memory to store data, while a CD is an optical disc that uses laser technology to read and write data. Both devices can be used to store files, documents, photos, videos, and other types of data.

To organize information more effectively in Word, you would insert a table. A table allows you to create columns and rows, making it easier to structure and present data in a clear and organized manner. This feature is particularly useful when dealing with large amounts of information or when you need to compare and analyze data. By inserting a table, you can easily input and manipulate data within the designated cells, facilitating better organization and readability of your document.

The correct answer is =sum(e4:e8). This formula is used to add the values of cells e4 to e8 in Excel. The SUM function in Excel is used to calculate the total of a range of cells. In this case, it will add the values in cells e4, e5, e6, e7, and e8 together and provide the sum as the result.

To check the spelling of words in Word, you would choose the "Review" menu tab from the Ribbon. This tab contains various tools and options related to proofreading and editing, including the spell check feature. By clicking on the "Review" tab, you can access the spell check tool and correct any spelling errors in your document.

In Excel, a formula must always start with an equals sign. This is because the equals sign tells Excel that what follows is a formula or calculation, rather than a simple text entry. Without the equals sign, Excel will treat the entry as a regular text or number value, rather than a formula to be calculated. Therefore, it is important to always include an equals sign at the beginning of a formula in Excel.

Slide transitions refer to the visual movements that occur when transitioning from one slide to another in a presentation. These transitions can include effects such as fading, sliding, or zooming, which add visual interest and smoothness to the overall presentation. Custom animations, on the other hand, involve animating individual elements within a slide, while rehearsed times pertain to the timing of slide transitions and animations during a presentation. Layouts, although important for organizing content on a slide, do not directly relate to the visual movements between slides.

The title slide is the first slide in a PowerPoint presentation that introduces the topic and provides basic information about the presentation to the audience. It typically includes the presentation title, the presenter's name, and any other relevant details. This slide sets the tone for the rest of the presentation and helps the audience understand what to expect.

The correct answer is "group". Grouping is a process in which multiple objects are combined together to form a single object. This can be useful when you want to move or manipulate multiple objects as a single unit. By grouping objects, you can easily manage and organize them in a more efficient way.

A spreadsheet program is the most suitable tool for creating a chart or graph. Spreadsheets provide a grid-like structure that allows users to organize and manipulate data easily. They offer features specifically designed for creating and formatting charts and graphs, such as chart templates, data sorting, and data analysis functions. With a spreadsheet program, users can input their data, select the desired chart type, and customize it according to their needs. This makes spreadsheets an efficient and practical choice for creating visual representations of data.

The letter "e" is typed with the left middle finger because it is located on the middle row of the keyboard, directly to the right of the letter "r" which is typed with the right index finger. The left middle finger naturally rests on the "e" key when typing.

Audacity is a free sound editing software that offers various features such as amplifying, cropping, and mixing music. This software allows users to create audio tracks that can be used in different projects, making it a versatile tool for musicians, podcasters, and content creators. With Audacity, users have the ability to enhance and modify their audio recordings, resulting in professional-quality sound.

The letter "u" is typed with the right index finger because it is located on the right side of the keyboard, specifically on the row above the home row. The index finger is responsible for reaching the keys in that area, making it the correct choice for typing the letter "u".

A virus is a program that is designed to either annoy or cause harm to a computer system. It can replicate itself and spread from one computer to another, often without the user's knowledge or consent. Viruses can corrupt files, slow down the system, and even steal personal information. They are considered malicious software and are a major threat to computer security.

A .wav file is a type of audio or sound file. Unlike video files, such as MP4, or compressed audio files like MP3, .wav files are uncompressed and retain high-quality audio. They are commonly used for storing audio recordings, music, and sound effects.

When using Word, to choose a single word with your mouse, you can double-click on the word. Double-clicking quickly selects the entire word, making it easy to perform actions such as copying, deleting, or formatting the selected word.

The letter "o" is typed with the right ring finger because it is located in the middle row of the keyboard, directly under the right ring finger's resting position. This finger is responsible for reaching the "o" key without having to stretch or move from its natural position, making it the most efficient and comfortable finger to use for typing this letter.

The cell directly to the right of cell G8 in Excel is H8.

The correct answer is Ribbon. The Ribbon is the main strip of buttons across the top of the window. It is a user interface element in Microsoft Office applications that organizes commands and features into a series of tabs and groups. The Ribbon contains various buttons, icons, and drop-down menus that allow users to access and perform different tasks and functions within the application.

Slide sorter view is a view in presentation software that displays small or thumbnail versions of all slides in a horizontal row. This view is designed to make it easier for users to rearrange slides by simply dragging and dropping them into the desired order. It provides a visual overview of the entire presentation, allowing users to quickly navigate and organize their slides.

The correct answer is "insertion point." The blinking vertical bar referred to as the insertion point is used to indicate the specific location where text, graphics, or other items will be inserted in a document or any other editable area. It serves as a visual guide for users, allowing them to accurately position and input content within the desired location.

Downloading is the process of retrieving a file or software from a remote computer and saving it onto your own computer's storage device, such as the hard drive, flash drive, or CD. This allows you to access and use the file or software locally without needing a constant connection to the remote computer.

In Excel, columns are designated by letters. Each column is labeled with a letter from A to Z, and then continues with AA, AB, AC, and so on. This letter designation is used to reference and identify specific columns in formulas, functions, and data manipulation tasks.

The given answer suggests that using dark fonts on dark backgrounds is not a rule to follow when formatting text on a slide. This is because using dark fonts on dark backgrounds can make the text difficult to read and may result in poor visibility. It is generally recommended to use high contrast between the font color and background color to ensure legibility.

The format painter tool on the Home tab allows users to copy and apply text formatting to other words or paragraphs in a document. It is represented by an icon that looks like a paintbrush. This tool is useful for quickly applying consistent formatting to multiple sections of a document, saving time and effort.

The correct answer is Drive C because it is the only option that matches the given question, "The hard drive is." Drive A, Drive B, and Drive D are not relevant to the question and therefore incorrect.

When arranging paragraphs in alphabetical, numerical, or date order based on the first character of each paragraph, it is called sorting. This process involves organizing the paragraphs in a specific sequence or pattern to make it easier to locate and access information. By sorting the paragraphs, it becomes possible to arrange them systematically, allowing for efficient searching and referencing.

To create a graphic object out of text, the most suitable feature would be "word art." Word art allows users to apply various artistic effects to text, such as curved or twisted shapes, shadowing, and 3D effects. This feature enhances the visual appeal of the text and transforms it into a graphic object.

To create a newsletter, you can use either Microsoft Word or Microsoft Publisher. Both programs have features and templates that are specifically designed for creating newsletters. Word is a versatile word processing program that allows you to easily format and layout text, add images, and create a professional-looking newsletter. Publisher, on the other hand, is a desktop publishing program that offers more advanced design and layout options, making it ideal for creating visually appealing newsletters with complex designs. Therefore, both Word and Publisher are suitable choices for creating a newsletter, depending on your specific needs and design preferences.

The statement "Make it busy graphically" is not one of the guidelines for creating a logo. When creating a logo, it is generally recommended to make it simple, ensuring that it is easily recognizable and memorable. Additionally, the text should be readable, allowing for clear communication of the brand or company name. However, making the logo busy graphically can lead to a cluttered and confusing design, which is not desirable for a logo.

In a spreadsheet or table, columns run vertically. This means that they go from top to bottom, allowing data to be organized and displayed in a vertical manner. This is different from rows, which run horizontally from left to right. By understanding the direction of columns, users can effectively input and analyze data in a structured and organized way.