NEW
Font size
WorksheetsComp Apps - Final Exam
Total questions: 35
Worksheet time: 18mins
The _______________ holds more frequently used commands like Save, Print, Undo, etc.
Quick Access Toolbar
Ribbon
Tabs
Status Bar
On the desktop computer, this key allows you to select/highlight text that is not directly
side by side
Control Key
Option Key
Command Key
Shift Key
The bar that displays details and information about a document like page count, word count, and spell check is called:
Title bar
Status Bar
Ribbon
Quick Access Toolbar
The quick key shortcut for Save as on the desktopis:
Control + S
F12
Option + Shift + S
F5
The Quick Key Shortcut for Undo on the desktop computer is
Control + U
Control + Z
Control + Y
Control + R
A ____________ is used to list off an order of sequence within the list of text
Numbered List
Bullet Points
Tab Points
None of the above
Which tool copies the formatting of selected text and applies it to different text in the document?
Format Designer
Paste Button
Format Painter
Paste Special
Inserting a _____________ after a section of text in the document gives appropriate credit to sources you have referenced and taken information from.
Bibliography
Citation
Reference material
Indentation
_________ are used to organize sets of information and show relationships between separate pieces of information
Documents
Tables
Images
None of the above
This is term used for a blank file or database in Excel (Document = Word, ____________ = Excel)
Worksheet
Work Document
Workbook
All of the above
Boxes that intersect by rows and columns that make up a spreadsheet are called
Cells
Grids
Squares
Tables
This is used to display and enter text, formulas, data, etc. into the spreadsheet.
Name Box
Insert Table button
Formula Bar
Search Box
The tool located in the bottom right corner of the active or selected cells that will recognize patterns and copy data into multiple cells (Complete dates, times, number patterns, formulas, etc.)
Fill Handle
Auto-fill button
Fill option
Control + Enter
To get rid of data in a spreadsheet, you can do which of the following?
Select the data and hit the delete key on the keyboard
Select the data and use the delete button on the ribbon
Select the date and right click to clear the contents
All of the above
When performing simple calculations (Addition, Subtraction, Multiplication, and Division) in a spreadsheet, you should use a(n):
Function
Formula
Absolute Cell reference
Calculator
__________ are just simplified formulas that perform specific calculations (Sum, Average, Minimum, etc.)
Formulas
Functions
Absolute Cell Reference
Calculator
When you have to use just one specific cell in multiple formulas, you should use an Absolute Cell Reference by clicking by the cell name in the formula, then hit:
F1
F3
F4
F2
___________ are formatting presets that can be applied to cells with one click (Title style, total style, headings, etc.)
Cell Options
Cell Styles
Cell Design
Cell Setup
When you need to combine multiple cells in a spreadsheet together, which tool should you use?
Merge cells
Combine cells
Add cells together
Merge tables
When looking at how data changes over time, which of the charts or graphs would be best?
Pie chart
Bar graph
Line graph
All of the above
In PowerPoint, which tab is used to allow objects/images to enter a slide, emphasize an effect, or leave a slide?
Transitions
Animations
Slide Show
Design
When designing a presentation that you don't want someone to just click to get to the next slide easily, you should change the set up of the show to which of the following?
Presented by a speaker (full screen)
Browsed by an individual (window)
Browsed at a Kiosk (full screen)
None of the above
When an object/image lets you go to a different slide in the presentation by clicking or touching the object/image, it has been:
Hyperlinked
Actively linked
Slide linked
All of the above
When you need to change a slide from having a Title and Subtitle to just being a blank slide, you use the _______ button.
New Slide
Design
Section
Layout
If you need to apply a picture to the background of the slide, you should:
Copy and Paste the image on the slide
Use the Insert Picture button on the Insert tab
Use the Format Background button on the Design tab
You can't apply a picture to the background of a slide
What are the four core operations of a computer?
Compute, Store, Display, Connect
Input, Process, Output, Storage
Input, Process, Output, Network
Receive, Calculate, Transmit, Save
Which of the following best defines the difference between hardware and software?
Hardware is movable, software is stationary
Hardware costs money, software is free
Hardware runs on batteries, software runs on electricity
Hardware is made up of physical components, software is programmed instructions
What is the primary role of an operating system?
To manage system resources and provide user interface
To design computer hardware
To create applications
To generate binary code
Which of the following is the MAIN way computers will connect and share resources?
Power cables
USB ports
Internet connections
Bluetooth
What does binary code consist of?
Colored pixels
0s and 1s
Letters and numbers
Mathematical equations
What is the difference between system software and application software?
System software manages computer resources, application software performs specific tasks
System software is more expensive, application software is cheaper
System software only works on Windows
Application software runs faster
Which of these devices is considered a standard input device?
Speaker
Printer
Keyboard
Monitor
What enables computers to transform raw data into meaningful information?
Processing
Output
Input
Storage
If you were running a business meeting with employees in multiple locations across the country, which of these would be the best communication tool?
SMS messaging
Videoconferencing
VolP
Which of the following is NOT a true employability skill?
Professional appearance
Transferable skills
Professional qualities
Career Search skills
Social Media Skills
