Computer Essentials Final Exam Practice Spring 2016
-
________________ allows you to point to a gallery choice and see its effect in the document.
-
None of the above
-
Live Preview
-
Quick Access Preview
-
Active tab
-
Choose the correct answer by clicking the box beside your answer. Make sure only one box is selected.
Quiz Preview
- 2.
The default slide orientation for PowerPoint is:
-
Title slide layout
-
Landscape
-
Portrait
-
Slide sorter view
Correct Answer
A. LandscapeExplanation
The default slide orientation for PowerPoint is landscape. This means that the slides are wider than they are tall, with a horizontal layout. This is the most commonly used orientation for PowerPoint presentations as it allows for more content to be displayed on each slide and is generally easier to read and view on a screen or projector.Rate this question:
-
- 3.
The ___________ is the main strip of buttons across the top of the window.
-
Task manager
-
Review
-
Office Button
-
Ribbon
Correct Answer
A. RibbonExplanation
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.Rate this question:
-
- 4.
______________ displays small or thumbnail versions of all your slides, arranged in horizontal rows to make it easier to rearrange slides.
-
Notes pages view
-
Slide sorter view
-
Outline view
-
Normal view
Correct Answer
A. Slide sorter viewExplanation
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.Rate this question:
-
- 5.
These are visual movements to the slides as they change from one to another
-
Layouts
-
Slide transitions
-
Custom animation
-
Rehearsed times
Correct Answer
A. Slide transitionsExplanation
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.Rate this question:
-
- 6.
_________________ are visual effects applied to individual items such as graphics or bullet points.
-
Slide transitions
-
Custom animation
-
Hyperlinks
-
Custom layouts
Correct Answer
A. Custom animationExplanation
Custom animation refers to the visual effects that are applied to individual items such as graphics or bullet points in a presentation. It allows users to add movement, entrance, exit, and emphasis effects to specific elements on a slide. By using custom animation, presenters can enhance the visual appeal of their slides and make their presentations more engaging and dynamic.Rate this question:
-
- 7.
These are things that visual aids can do except:
-
Improve communication effectiveness
-
Improve audience's perceptions of the presenter
-
Improve the speaker's confidence
-
Improve the speaker's articulation of words
Correct Answer
A. Improve the speaker's articulation of wordsExplanation
Visual aids, such as slides or props, can enhance communication effectiveness by providing visual support and reinforcing key points. They can also improve the audience's perceptions of the presenter by making the presentation more engaging and memorable. Additionally, visual aids can boost the speaker's confidence by providing a visual cue or reference. However, visual aids cannot directly improve the speaker's articulation of words, as that primarily depends on the speaker's vocal skills and clarity of speech.Rate this question:
-
- 8.
What does the 7 x 7 rule mean in Powerpoint?
-
At least sevenlines on a slide and seven words on each line
-
No more than seven lines on a slide and seven words on each line
-
No more than seven words on a slide
-
No more than seven slides and seven pictures in a presentation
Correct Answer
A. No more than seven lines on a slide and seven words on each lineExplanation
The 7 x 7 rule in PowerPoint means that there should be no more than seven lines on a slide and no more than seven words on each line. This rule is often followed to ensure that slides are not overcrowded with text, making them more visually appealing and easier to read for the audience. By limiting the amount of text on each slide, presenters can focus on delivering key points effectively and engage their audience without overwhelming them with information.Rate this question:
-
- 9.
These are all rules to follow when formatting text on a slide except:
-
Be sure to use dark fonts on dark backgrounds
-
Avoid using all capital letters on bullet points
-
Avoid text with a font size less than 24 point
-
Make careful colorful choices
Correct Answer
A. Be sure to use dark fonts on dark backgroundsExplanation
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.Rate this question:
-
- 10.
In Word, to choose a single word with your mouse you can
-
Click once
-
Double-click
-
Triple-click
-
Right click and choose highlight
Correct Answer
A. Double-clickExplanation
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.Rate this question:
-
- 11.
Which item is an output device?
-
Headphones
-
Mouse
-
Keyboard
Correct Answer
A. HeadphonesExplanation
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.Rate this question:
-
- 12.
You can use the ________________ on the Home tab to copy and apply text formatting to other words or paragraphs in a document (looks like a paintbrush).
-
Format painter
-
Paintbrush
-
Format editor
-
Color brush
Correct Answer
A. Format painterExplanation
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.Rate this question:
-
- 13.
What do you call a cell on a spreadsheet that is highlighted?
-
Passive cell
-
A formula
-
Quiet cell
-
Active cell
Correct Answer
A. Active cellExplanation
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.Rate this question:
-
- 14.
The letter "o" is typed with the ______________ finger.
-
Left ring
-
Right ring
-
Left pinky
-
Right pinky
Correct Answer
A. Right ringExplanation
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.Rate this question:
-
- 15.
An icon is an on-screen picture that represents an object or program.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 16.
What formula would you use if you needed to add cells in Excel?
-
=g4*g9
-
=avg(a10:a20)
-
=sum(e4:e8)
-
=m3/m2
Correct Answer
A. =sum(e4:e8)Explanation
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.Rate this question:
-
- 17.
The letter "u" is typed with the _______________ finger.
-
Left index
-
Right index
-
Left ring
-
Right ring
Correct Answer
A. Right indexExplanation
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".Rate this question:
-
- 18.
You want to change the color of a triangle on your document. What tool would you use?
-
Shape fill
-
Font color
-
Line color
Correct Answer
A. Shape fillExplanation
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.Rate this question:
-
- 19.
Which one is a storage device?
-
Flash drive
-
CD
-
Modem
-
Both flash drive and cd
Correct Answer
A. Both flash drive and cdExplanation
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.Rate this question:
-
- 20.
The physical components of the computer system are called
-
Software
-
Keyboard
-
Hardware
-
Monitor
Correct Answer
A. HardwareExplanation
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.Rate this question:
-
- 21.
In Word, what are the default margin settings?
-
.5"
-
1"
-
1.5"
-
2.0"
Correct Answer
A. 1"Explanation
The default margin settings in Word are 1".Rate this question:
-
- 22.
To create a newsletter, what program or programs would you use?
-
PowerPoint
-
Word
-
Publisher
-
Word or Publisher
Correct Answer
A. Word or PublisherExplanation
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.Rate this question:
-
- 23.
Which kind of program would you use to create a chart or graph?
-
Spreadsheet
-
Word processing
-
Database
-
Internet browser
Correct Answer
A. SpreadsheetExplanation
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.Rate this question:
-
- 24.
The letter "e" is typed with the ___________ finger.
-
Left pinky
-
Right pinky
-
Left middle
-
Right middle
Correct Answer
A. Left middleExplanation
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.Rate this question:
-
- 25.
In Word, which menu tab from the Ribbon would you choose to check the spelling of words?
-
Review
-
Page Layout
-
Formulas
-
References
Correct Answer
A. ReviewExplanation
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.Rate this question:
-
- 26.
The Clipboard is a tool that temporarily stores cut or copied text.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 27.
Which device is an input device?
-
Keyboard
-
Speaker
-
Monitor
Correct Answer
A. KeyboardExplanation
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.Rate this question:
-
- 28.
How are columns designated in Excel?
-
Numbers
-
Letters
-
Triangles
-
Circles
Correct Answer
A. LettersExplanation
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.Rate this question:
-
- 29.
In Excel, which cell is directly to the right of cell G8?
-
F8
-
H8
-
G9
-
I8
Correct Answer
A. H8Explanation
The cell directly to the right of cell G8 in Excel is H8.Rate this question:
-
- 30.
CPU means
-
Central Processing Unit
-
Controlled Program Utilization
-
Computer Programming Unit
-
Computer Processing Unit
Correct Answer
A. Central Processing UnitExplanation
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.Rate this question:
-
- 31.
In a spreadsheet formula which symbol is used to multiply?
-
Equal sign =
-
Addition sign +
-
Asterisk *
-
Forward slash /
Correct Answer
A. Asterisk *Explanation
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.Rate this question:
-
- 32.
Where do you go to stop a non-responding application?
-
Display Properties Dialog Box
-
Task Manager
-
Power On System Test
-
System Properties Dialog Box
Correct Answer
A. Task ManagerExplanation
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.Rate this question:
-
- 33.
The hard drive is
-
Drive A
-
Drive B
-
Drive C
-
Drive D
Correct Answer
A. Drive CExplanation
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.Rate this question:
-
- 34.
When you are using a PC, you are using a
-
Programmable console
-
Powered calculating machine
-
Personal computer
-
Processing contraption
Correct Answer
A. Personal computerExplanation
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.Rate this question:
-
- 35.
Which direction do columns run in a spreadsheet or table?
-
Counter clockwise
-
Diagonal
-
Horizontal
-
Vertical
Correct Answer
A. VerticalExplanation
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.Rate this question:
-
- 36.
A formula in Excel must always start with
-
A bracket
-
A capital letter
-
A plus sign
-
An equals sign
Correct Answer
A. An equals signExplanation
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.Rate this question:
-
- 37.
If a cell shows #######, it means that
-
Your formula has a syntax error
-
The function has the wrong sign
-
The column is too narrow to show all the digits of the number
-
Both a and b
Correct Answer
A. The column is too narrow to show all the digits of the numberExplanation
If a cell shows #######, it means that the column is too narrow to show all the digits of the number. This happens when the number in the cell is too long to fit within the column width. To fix this, you can either widen the column or decrease the font size in the cell.Rate this question:
-
- 38.
Excel opens a new workbook with __________ worksheets
-
One
-
Two
-
Three
-
Four
Correct Answer
A. ThreeExplanation
Excel opens a new workbook with three worksheets. This means that when you create a new workbook in Excel, it automatically comes with three blank worksheets. These worksheets can be used to organize and analyze data separately within the same workbook. Having multiple worksheets allows users to work on different aspects of their data or create different reports within the same file.Rate this question:
-
- 39.
When you need to open or save a document, click on _______________ to get to the backstage view.
-
Ribbon
-
File
-
ScreenTip
-
Share toolbar
Correct Answer
A. FileExplanation
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.Rate this question:
-
- 40.
_________________ are made to protect authors and artists that create things that are original.
-
Trademarks
-
Photos and illustrations
-
Text
-
Copyright laws
Correct Answer
A. Copyright lawsExplanation
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.Rate this question:
-
- 41.
In Word, to move to the end of a line, press the ______ key.
-
CTRL + HOME
-
RIGHT ARROW
-
PAGE DOWN
-
END
Correct Answer
A. ENDExplanation
To move to the end of a line in Word, the correct key to press is "END". This key allows the user to quickly navigate to the end of the current line without having to manually scroll or use the arrow keys. It is a convenient shortcut that saves time and effort when editing or formatting text.Rate this question:
-
- 42.
When arranging paragraphs in alphabetical, numerical, or date order based on the first character of each paragraph, it is called ___________.
-
Formatting
-
Dimensioning
-
Ordering
-
Sorting
Correct Answer
A. SortingExplanation
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.Rate this question:
-
- 43.
In PowerPoint, a presentation is also called a _________
-
Preview
-
Gallery
-
Slide show
-
None of the above
Correct Answer
A. Slide showExplanation
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.Rate this question:
-
- 44.
In PowerPoint, the ____________ introduces the presentation to the audience.
-
Title slide
-
Home page
-
Active tab
-
None of the above
Correct Answer
A. Title slideExplanation
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.Rate this question:
-
- 45.
When you change the layout of a slide, PowerPoint ___________ the text and objects.
-
Deletes
-
Retains or keeps
-
Copies
Correct Answer
A. Retains or keepsExplanation
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.Rate this question:
-
- 46.
When applying background colors to slides, you may choose whether to apply to all slides in the presentation or just the selected slide.
-
True
-
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 47.
Turns multiple objects into a single object.
-
Ungroup
-
Watermark
-
Wordart
-
Group
Correct Answer
A. GroupExplanation
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.Rate this question:
-
- 48.
A small printed card usually containing a person's name and business contact information.
-
Letterhead
-
Business card
-
Logo
-
Business envelope
Correct Answer
A. Business cardExplanation
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.Rate this question:
-
- 49.
A _____________ is name, symbol, emblem, or trademark designed to define an image for a company.
-
Blank publication
-
Business card
-
Watermark
-
Logo
Correct Answer
A. LogoExplanation
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.Rate this question:
-
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
May 16, 2016Quiz Created by
Christy Williams
Back to top