Font size
WorksheetsTech Composite Review
Total questions: 55
Worksheet time: 28mins
Provide the cell address of the cell above.
C5
C6
5C
D5
A _____ is the intersection (where they meet/connect) of a row and a column.
Spreadsheet
Column
Row
Cell
Columns are identified by ________, while rows are identified by __________.
Numbers, Symbols
Numbers, Letters
Letters, Numbers
Letters, Symbols
At the beginning of a formula, what should always be at the front of the formula so your computer knows you want to solve an equation?
=
*
/
$
The way that the text appears in a document is called:
Font Style
Font Size
Font Look
Font Alignment
This device allows you to copy a physical image or document and save it as a digital image.
Tablet
Printer
Scanner
Monitor
Understanding how to store and save computer files efficiently is only important in school, not in the business world.
True
False
How can you tell if a website is credible?
Anything on the web is automatically credible
You must review aspects of the site such as the author’s credibility
If it has a top-level domain of .com, it is credible
All of the above
Which of the following is considered a proper keyboarding technique?
Key each key with your pointer fingers
Sit up straight and position your feet on the floor for balance
Key the Enter key with whichever finger feels most comfortable
Curve your fingers over the bottom row keys
Fill in the blanks. Identify the missing home row keys in order (left to right):
A _ D _ J _ L _
S F K ;
None of the answers are correct
S G H K
F S ; K
What is different about the keys your POINTER fingers rest on in comparison to the
other keys?
They are the letters G and H.
They are the letters A and L.
They are different colors.
They have bumps on them.
What is the file extension for a Microsoft Power Point presentation?
.docx
.pptx
.html
What is the file extension for a Microsoft Word document?
.docx
.pptx
.xlsx
What is the shift key used for?
To capitalize letters only
The shift key has no purpose
To capitalize letters and certain symbols
To navigate through a menu
Which key is used to start a new line?
Delete
Shift
Enter
Backspace
What does CPU stand for?
Central Processing Unit
Certified Personal Unit
Central Professional Unit
Certificate of People United
What is a shortcut for pasting on Microsoft Word?
Ctrl + V
Ctrl + P
Ctrl + F
Ctrl + C
What is a shortcut for copying on Microsoft Word?
Ctrl + V
Ctrl + P
Ctrl + F
Ctrl + C
What is a shortcut for printing on Microsoft Word?
Ctrl + V
Ctrl + P
Ctrl + F
Ctrl + C
Which program would you use to create a PRESENTATION for Ms. Rodriguez's class?
Word Processing
Power Point Presentation
Excel Spreadsheet
YouTube
Which program would you use to create a LETTER to the president?
Word Processing
Power Point Presentation
Excel Spreadsheet
YouTube
How do you open a PowerPoint presentation you have saved?
File-Save As
File-Open
Edit-Undo
File-Save
When using Microsoft PowerPoint, what tab allows you to insert pictures?
Insert Tab
Design Tab
Animations Tab
Home Tab
When using Microsoft PowerPoint, this allows user to create notes to be used with the presentation of each slide?
Notes Page
Clip Note
Comment Section
Text Boxes
What is software?
Guides the hardware and helps accomplish a task
Set of instructions to tell hardware what to do
It has physical structure
It includes internal parts of the computer
What manages the hardware and runs the software?
Embedded system
Computer system
Operating system
Peripheral system
Google Chrome, Apple Safari and Firefox are examples of _______.
Streaming Video
Web Browser
Spam
Social Media
When using Microsoft PowerPoint, the special effects used to introduce slides in a
presentation are called _____.
Slide Transitions
Custom Animations
Preset Animations
Slide Effects
When using Microsoft PowerPoint, which of the following can be added to a slide?
Photos
Videos
Clip Art
All of the Above
Which finger is used on the letter “a” on the computer keyboard?
Right pointer/index finger
Left Pinky
Right Pinky
None of the above
The home row keys are:
(a)
True or False. You can save a PowerPoint as a .pptx or a PDF.
TRUE
FALSE
When using Microsoft PowerPoint, what is a motion path?
A type of animation entrance effect
A method of moving items on a slide
A method of advancing slides
None of the above
When using Microsoft PowerPoint, the special effects used to introduce slides in a
presentation are called _________.
Slide Effects
Custom Animations
Preset Animations
Slide Transitions
What is a URL?
The computer’s working memory
An extensive, world-wide computer to other computers through a phone line
The address of a website on the world wide web
A computer program that was written to purposely damage a computer system
What does WPM stand for?
Words per millimeter
Will Peter move
Words people move
Words per minute
What type of software helps you find information on the Internet?
Games
Word Processor
Search Engine
How does ergonomics seating help with typing?
This allows you to type slower and more motion when reaching for keys
This allows you to type in an ineffective manner
This allows you to type faster and MORE motion when reaching for keys
This allows you to type faster and LESS motion when reaching for keys
Computer __________ is the collection of all the parts you can physically touch.
Software
Hardware
Malware
Online resource
What is the name of the group of keys your fingers should rest on when typing?
Middle row keys
Home row keys
Qwerty keys
None of the above
When using Microsoft PowerPoint, what tab allows you to insert pictures?
Insert tab
Design tab
Home tab
Animations tab
When typing, where are your eyes supposed to be looking at?
Keyboard
Computer screen
Bug on the wall
My bestfriend
A predefined set of colors, fonts, line and fill effects, and other formats that can be applied to your presentation:
Theme
Theme effects
Theme fonts
Theme presentation
The computer’s main circuit board is called a ________.
Hard drive
Monitor
Bluetooth card
Motherboard
Columns are labeled with ________.
Letters
Numbers
Symbols
Emojis
Rows are labeled with ________.
Letters
Numbers
Symbols
Emojis
How many sheets can you have in one excel document?
0
1 only
multiple
-When I need to indent my first paragraph, I click on the ____ key.
Delete
Shift
Tab
Backspace
When using Microsoft Excel, which of the following can NOT be found in a sheet?
Photos
Rows
Cells
Columns
A keyboard is an example of a ____.
Hardware
Software
Power Point is an example of a ____.
Hardware
Software
When using Microsoft PowerPoint and you begin a new slideshow, your first slide has what type of layout?
Comparison
Title
Title and Content
Picture with caption
To change the page orientation between landscape and portrait, which tab would you select?
Orientation Tab
Layout Tab
Design Tab
Insert Tab
I want to 50 and 78. What is the formula I must use?
E5+E8
=E4+E7
=E5+E8
E4+E7
I want to multiply 40 by -3. What is the formula I must use?
D7/F6
=D7/F6
=D7*F6
D7*F6
