WorksheetsFT-2ndSemester Test
Total questions: 107
Worksheet time: 2hrs 55mins
Name
Class
Date
1.
These are your...
a)
Selections
b)
Drawings
c)
Layers
d)
Pictures
2.
What is this tool called?
a)
Quick Selection Tool
b)
Rectangular Marquee Tool
c)
Lasso Tool
d)
Move Tool
3.
What is this tool called?
a)
Magic Wand Tool
b)
Quick Selection Tool
c)
Move Tool
d)
Lasso Tool
4.
What is this tool called?
a)
Lasso Tool
b)
Rectangular Marquee Tool
c)
Move Tool
d)
Quick Selection Tool
5.
What do the little arrows at the top of this picture do?
a)
Change the colors of both boxes- makes the red box blue, the white box black.
b)
Flip the colored boxes around- bottom box goes to the top.
c)
Makes both boxes red.
d)
Make both boxes white.
6.
To make a new layer, you should click...
a)
The piece of paper with the corner flipped up at the bottom.
b)
The trash can at the bottom.
c)
The layer 1.
d)
The black and white circle at the bottom.
7.
How do you move a layer up?
a)
Click the layer, then press the Up arrow on the keyboard.
b)
Right-click the layer and choose Move Upward from the menu.
c)
Drag the layer listing up to the place you want it.
d)
Click the eyeball.
8.
What can you do with this tool?
a)
Change the color of an object
b)
Select an object
c)
Change how transparent an object is
d)
Remove the background
9.
A photo file type is
a)
.jpeg
b)
.mp3
c)
.doc
d)
.mov
10.
Which tool puts text on top of the image?
a)
Spot Healing Brush
b)
Content Aware Move
c)
History Brush
d)
Type Tool
11.
What part of the Photoshop window is B?
a)
Menu / menu bar
b)
Work Area
c)
Panels
d)
Tools panel
12.
What part of the Photoshop window is A?
a)
Tools panel
b)
Work Area
c)
Options bar
d)
Menu / menu bar
13.
What is the name of this Photoshop tool?
a)
paint bucket tool
b)
color sampler tool
c)
horizontal type tool
d)
rectangle tool
14.
What is this tool called?
a)
Move Tool
b)
Eraser
c)
Clone Stamp Tool
d)
Quick Selection Tool
15.
What is standard U.S. paper size?
a)
8.5x11
b)
8x11
c)
10x12
d)
24x36
16.
What is the file extension for a file saved as a PhotoShop file?
a)
.psd
b)
.pds
c)
.photo
d)
.phsd
17.
To keep the ratio of a picture or a shape, you need to
a)
hold down the shift + command keys
b)
hold down the control key
c)
hold down the command key
d)
hold down the shift key
18.
How could you BEST select the dog?
a)
The elliptical marquee since the dog is mostly an oval shape
b)
The rectangular marquee since the dog is mostly a rectanglar shape
c)
The magic wand tool since it is mostly black
d)
The quick selection tool
19.
When you adjust ______, you make the color more intense.
a)
Filters
b)
Channels
c)
Saturation
d)
Color Adjustments
20.
When an image is greater in height than width it is called _____.
a)
Portrait
b)
Landscape
c)
A square
d)
None of the above
21.
Hue, Saturation and Brightness are terms used with color.
a)
True
b)
False
22.
Layers cannot be deleted once they've been created.
a)
True
b)
False
23.
_______is an image editing software.
a)
Adobe
b)
Artsonia
c)
Photoshop
d)
Google Docs
24.
When you put 2 images together that normally do not go together, this is known as____.
a)
Illusion
b)
pretend
c)
surrealisim
d)
imagination
25.
Which tool do we use to get rid of extra space in a photo?
a)
Crop tool
b)
Quick Selection Tool
c)
Marquee Tool
d)
Lasso Tool
26.
What is the correct name for the white rectangle in Photoshop?
a)
potential
b)
paper
c)
blank page
d)
canvas
27.
When an image is the same on both sides, this is known as _______.
a)
A match
b)
Balance
c)
A Symmetry
d)
Symmetry
28.
When the picture is balanced, but is not the same on both sides, this is known as______.
a)
Not a match
b)
Balance
c)
Asymmetry
d)
Symmetry
29.
Which artists did we talk about during our Photoshop Unit?
a)
Andy Warhol and Renee Magritte
b)
Shepard Fairey and Leonardo da Vinci
c)
Andy Warhol and Michelangelo
d)
Renee Magritte and Mona Lisa
30.
When you right click on the gradient tool you will see other tools. Which tool will you see?
a)
Move tool
b)
Paint brush tool
c)
Paint bucket tool
d)
Crop Tool
31.
Selects entire objects
a)
Pen tool
b)
Selection tool
c)
Direct Selection tool
d)
Magic wand tool
32.
Selects points or path segments within objects. (A)
a)
Selection tool
b)
Direct Selection tool
c)
Group Selection tool
d)
Magic Wand tool
33.
Selects objects with similar attributes. (Y)
a)
Magic Wand tool
b)
Direct Selection tool
c)
Lasso tool
d)
Artboard tool
34.
Creates separate artboards for printing or export.
a)
Selection tool
b)
Canvas tool
c)
Artboard tool
d)
Art tool
35.
Draws straight and curved lines to create objects. (P)
a)
Delete Anchor Point tool
b)
Line Segment tool
c)
Add Anchor Point tool
d)
Pen tool
36.
Selects points or path segments within objects. (Q)
a)
Artboard tool
b)
Line Segment tool
c)
Direct Selection tool
d)
Lasso tool
37.
Draws individual straight line segments.
a)
Straight Line tool
b)
Arc tool
c)
Line Segment tool
d)
Line tool
38.
Draws clockwise and counterclockwise spirals.
a)
Spiral tool
b)
Arc tool
c)
Rectangular Grid tool
d)
Polar Grid tool
39.
Draws squares and rectangles with ROUNDED corners.
a)
Rectangular tool
b)
Ellipse tool
c)
Polygon tool
d)
Rounded Rectangle tool
40.
Draws circles and ovals. (L)
a)
Polar Grid tool
b)
Ellipse tool
c)
Circular tool
d)
Oval tool
41.
Draws and edits freehand lines. (N)
a)
Pencil tool
b)
Flare tool
c)
Line tool
d)
Freehand tool
42.
Draws regular, multi-sided shapes.
a)
Multi-sided tool
b)
Vertical tool
c)
Hexagonal tool
d)
Polygonal tool
43.
Smooths Bezier paths.
a)
Smooth tool
b)
Pencil tool
c)
Shape tool
d)
Line tool
44.
Draws freehand and calligraphic lines, as well as art, patterns, and bristle brush strokes on paths. (B)
a)
Mesh tool
b)
Blend tool
c)
Paintbrush tool
d)
Live Paint Bucket tool
45.
Creates and edits meshes and mesh envelopes. (U)
a)
Gradient tool
b)
Eyedropper tool
c)
Mesh tool
d)
Live Paint Selection tool
46.
Adjusts the beginning and ending points and angle of gradients within objects, or applies a gradient to objects. (G)
a)
Eyedropper tool
b)
Mesh tool
c)
Gradient tool
d)
Paintbrush tool
47.
Samples and applies color, type, and appearance attributes, including effects, from objects. (I)
a)
Eyedropper tool
b)
Gradient tool
c)
Mesh tool
d)
Paintbrush tool
48.
Cuts paths at SPECIFIED points. (C)
a)
Eraser tool
b)
Slice tool
c)
Scissors tool
d)
Knife tool
49.
Erases ANY area of the object over which you drag. (Shift-E)
a)
Eraser tool
b)
Scissors tool
c)
Slice tool
d)
Knife tool
50.
Cuts objects along a freehand path you draw with the tool, dividing objects into their component-filled faces. (A face is an area undivided by a line segment.)
a)
Eraser tool
b)
Scissors tool
c)
Knife tool
d)
Slice tool
51.
A reference to a specific cell or range regardless of where the formula is located in the worksheet
a)
Absolute cell reference
b)
Relative cell reference
c)
External reference
d)
Mixed cell reference
52.
A reference that identifies a cell's location in the worksheet based on its row number and column letter
a)
Cell reference
b)
Named range
c)
Operand
d)
Scope
53.
An equation that performs calculations such as addition, subtraction, multiplication, and division on values in a worksheet
a)
Formula
b)
Operand
c)
Scope
d)
Variable
54.
A group or cells and occasionally a single cell with a designated name
a)
Named range
b)
Value
c)
Variable
d)
Operand
55.
The rules Excel follows to calculate any formula that contains two or more operators
a)
Orders or operations
b)
Formulas
c)
Variables
d)
Constants
56.
A cell reference that adjusts the cell identifier automatically if you insert or delete column or row or if you copy the formula to another cell
a)
Relative cell reference
b)
Absolute cell reference
c)
Mixed cell reference
d)
External reference
57.
A number, a cell address, a date, text, or Boolean data in Excel
a)
Value
b)
Variable
c)
Constant
d)
Scope
58.
A formula that calculates the total adjacent cell through the first nonnumeric cell using the SUM function
a)
AutoSum
b)
MAXfunction
c)
SUMfunction
d)
COUNTfunction
59.
A function that calculates the total from the adjacent cell through the first non-numeric cell using SUM function in its formula
a)
AVERAGE function
b)
AutoSum
c)
COUNT function
d)
MIN function
60.
A predefined formula that performs a calculation
a)
Function
b)
AutoSum
c)
Value
d)
Variable
61.
A function that returns the largest values in a set of values
a)
MAX function
b)
AVERAGE function
c)
MIN function
d)
SUM function
62.
Two or more cells combined into a single cell
a)
Merge cells
b)
Variable
c)
Value
d)
AutoSum
63.
A function that determines the minimum value in a range of cells
a)
MIN function
b)
MAX function
c)
SUM function
d)
AVERAGE function
64.
A function that totals all of the cells in a range
a)
SUM function
b)
MIN function
c)
MAX function
d)
AVERAGE function
65.
Arrange in a line or bring into alignment
a)
Align
b)
Wrap
c)
Style
d)
Hyperlink
66.
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed
a)
Conditional formatting
b)
Merged cells
c)
Paste special
d)
Rules manager
67.
A set of text properties that affects the typeface, size, and similar aspects of text
a)
Font
b)
Style
c)
Wrap
d)
Attribute
68.
A set of formatting attributes that you can apply to a cell or range of cell more easily than by setting each attribute individually
a)
Style
b)
Attribute
c)
Font
d)
Wrap
69.
To automatically display data on the next line when it is too long to display within the cell's width
a)
Wrap
b)
Align
c)
Style
d)
Attibute
70.
1. Filters can be used on query results
a)
True
b)
False
71.
2. A primary key field from one table appears in a second table. What is the field in the second table called?
a)
A. A linked key
b)
B. A relationship key
c)
C. A foreign key
d)
D. A primary key
72.
3. What is it called when you "ask the database a question"?
a)
Relationship
b)
Query
c)
Data Integrity
d)
Report
73.
4. What is the advantage of reports over queries?
a)
A. Reports can be formatted
b)
B. Reports can access more data
c)
C. Queries can be formatted
74.
5. Queries can only use data from one table at a time.
a)
True
b)
False
75.
6. A primary key field from one table appears in a second table. What can be said about these tables?
a)
A. The tables are subordinated
b)
B. The tables are queried
c)
C. The tables are in a duplication
d)
D. The tables are in a relationship
76.
7. Does Microsoft Access need to be told about relationships between tables?
a)
A. No, relationships are automatically detected
b)
B. No, relationships are not supported
c)
C. Yes, relationships need to be defined
d)
D. Yes, only when the fields have different names
77.
8. Sorting from A-Z is also called a descending sort.
a)
True
b)
False
78.
9. You cannot change the order of fields on a report.
a)
True
b)
False
79.
10. What is it called when you view some records and hide others?
a)
Report
b)
Sort
c)
Search
d)
Filter
80.
11. A query for a report can come from multiple tables.
a)
True
b)
False
81.
12. What is it called when you want to see database records in a certain order?
a)
Search
b)
Filter
c)
Sort
d)
Report
82.
13. Ascending means sorting from:
a)
A. Smallest to largest
b)
B. Largest to smallest
83.
14. Descending means sorting from:
a)
A. Smallest to largest
b)
B. Largest to smallest
84.
15. In the image to the left, where would you click to look for a name in the database?
a)
A
b)
B
c)
C
85.
16. Look at the information in the database table to the left. What field is being used to SORT the table?
a)
Name
b)
Phone
c)
Address
d)
City
86.
True or False: By default, Excel is set to print pages in landscape orientation.
a)
True
b)
False
87.
True or False: By default, Excel is set to print pages in landscape orientation.
a)
True
b)
False
88.
True or False:The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.
a)
False
b)
True
89.
True or False: Numbers that do not fit in the cell are shown as a series of question marks (??????).
a)
True
b)
False
90.
True or False:The cell in the worksheet in which you can type data is called the active cell.
a)
True
b)
False
91.
True or False:The contents of the active cell always appear in the Formula Bar.
a)
True
b)
False
92.
Formulas can include more than one operator.
a)
False
b)
True
93.
Each formula begins with a quotation mark (").
a)
False
b)
True
94.
Formulas can include more than one operator.
a)
False
b)
True
95.
True or False: A cell style is a collection of formatting characteristics you apply to a cell or range of data.
a)
False
b)
True
96.
True or false: Data moved or copied to a cell replaces any content already in that cell.
a)
True
b)
False
97.
True or False: Hiding permanently removes a row or column from view.
a)
False
b)
True
98.
True or False: All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.
a)
False
b)
True
99.
Where is the command for creating a new table from Table Design view?
a)
File tab
b)
Home Ribbon
c)
Create Ribbon
d)
Database Tools Ribbon
100.
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What data type should he use?
a)
Auto Number
b)
Currency
c)
Yes/No
d)
Hyperlink
101.
Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
a)
Determine what information to include
b)
Discuss the database with users
c)
Gather the information
d)
Input data
102.
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What is auto numbering an example of?
a)
Data Type
b)
Description
c)
Field name
d)
Properties
103.
Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
a)
share workbook
b)
protect workbook
c)
track changes
d)
export
104.
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
a)
align
b)
arrange
c)
group
d)
rotate
105.
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
a)
center
b)
merge & center
c)
orientation
d)
wrap text
106.
Which are valid Microsoft Excel functions?
a)
AVERAGE, MAX, and NUM
b)
MAX, MIN, and WEEK
c)
AVERAGE, MAX, and MIN
d)
WEEKDAY, MAX, and CLOSE
107.
What are three valid methods for saving a database in Microsoft Access?
a)
Alt + S, File tab Save command, Quick Access Toolbar Save command
b)
Alt + S, Home Ribbon Save command, Quick Access Save command
c)
Alt + S, File tab Save command, Shortcut Save command
d)
Ctrl + S, File tab Save command, Quick Access Save command
100 %
