WorksheetsLevel 2
Total questions: 60
Worksheet time: 3hrs 0mins
Name
Class
Date
1.
How could you send out a colorful message about an upcoming company picnic?
a)
create a flyer in Publisher
b)
create a flyer in PowerPoint
c)
create a tri fold brochure in Publisher
d)
create a flyer in Excel
2.
Which of the following are not created in MS Publisher?
a)
Flyers
b)
Brochures
c)
Spreadsheets
d)
Business Cards
3.
Graphics are
a)
Small squares that appear for shortcuts.
b)
printouts that are taller than they are wide
c)
images or things that are visual on your work.
d)
sounds and things that you can hear on your work
4.
On the outside of a tri-fold brochure, you will find
a)
The inside pages.
b)
The outside pages.
c)
The first page of a brochure.
d)
The inside flap, back cover and front cover.
5.
The Spelling command in Publisher will indicate possible misspellings by a placing which of the following under the word?
a)
Green dashed line
b)
Blue outline
c)
Yellow dotted line
d)
Wavy red line
6.
The color scheme of a publication may be altered using the commands on which Ribbon?
a)
Home
b)
Page Layout
c)
Format
d)
Page Design
7.
You don’t need to worry about copy rights when you use
a)
Picture from the internet
b)
Clipart
c)
Ready design from the internet
d)
All the above
8.
You can import information to from ____________ to Publisher software
a)
Microsoft word
b)
Microsoft excel
c)
None of the above
d)
A and B
9.
What is the file extension which is generally used by the Microsoft Publisher
a)
.exe
b)
.pub
c)
.doc
d)
.ppt
10.
Sometimes you want to save files so that they cannot be modified, so you save them as
a)
Document file
b)
Paint file
c)
Pdf file
d)
Excel file
11.
Publication templates may be changed using which of the following commands on the Page Design Ribbon?
a)
Modify
b)
New Template
c)
Alter Template
d)
Change Template
12.
The blue dotted border in a publication represents the
a)
border.
b)
frame.
c)
margin.
d)
design.
13.
You want an image to go behind the text on your brochure, which command do you use?
a)
Align
b)
Bring forward
c)
Send backward
d)
Rotate
14.
Which Menu item do I use to format my font styles and paragraph settings?
a)
File
b)
Home
c)
Insert
d)
View
15.
When a formatted number does not fit within a cell, it displays
a)
#####
b)
#DIV/0
c)
#DIV@
d)
None of these
16.
Data can be arranged in ascending or descending order by using
a)
Sort command from Table menu
b)
Sort command from Data menu
c)
Sort command from Tools menu
d)
None of these
17.
Which function in Excel tells how lowest numeric entries in the list
a)
MIN
b)
MAX
c)
COUNT
d)
AVG
18.
A features that displays only the data in column (s) according to specified criteria
a)
Formula
b)
Sorting
c)
Filtering
d)
Pivot
19.
Which one is not a Function in MS Excel?
a)
SUM
b)
AVG
c)
MAX
d)
MIN
20.
Functions in MS Excel must begin with ___
a)
An () sign
b)
An Equal Sign
c)
Plus Sign
d)
A > Sign
21.
The numbers in our worksheet look like this: 1000.You want them to look like this: $1,000.How can you accomplish this?
a)
None of these
b)
Select Format > Money from the menu
c)
Click the Currency Style button on the formatting toolbar
d)
You have to retype every time
22.
The cells are addressed in terms of
a)
Row and column labels
b)
Row labels
c)
Rows
d)
Columns
23.
How do you rearrange the data in ascending or descending order
a)
A. Data, Sort
b)
Data, Form
c)
Data, Table
d)
Data Subtotals
24.
We can make corrections when its needed by replacing data, where can we find that
a)
Home tab> find and replace
b)
Insert tab> find and replace
c)
Home tab> format
d)
None of the above
25.
What is the correct way to refer the cell A10 on sheet3 from sheet1?
a)
sheet3!A10
b)
sheet1!A10
c)
Sheet3.A10
d)
A10
26.
Which would you choose to create a bar diagram?
a)
Edit, Chart
b)
Insert, Chart
c)
Tools, Chart
d)
Format, Chart
27.
What Excel-related file extensions
a)
xlsx
b)
ptx
c)
dox
d)
exe
28.
The filter by selection feature allows you to filter
a)
Those records that match an entity in a field
b)
Records based on a criterion you specify
c)
Records that meet any of several criteria you specify
d)
All of above
29.
The following database object can you import from one MS-Access database to another?
a)
Queries
b)
Tables
c)
Forms
d)
All of the above
30.
What are the columns in a Microsoft Access table called?
a)
Rows
b)
Records
c)
Fields
d)
Columns
31.
What is a form in MS Access
a)
It is a printed page where users will write their data to fill it up
b)
It is an input screen designed to make the viewing and entering data easier
c)
This is an important part of database used by analysts to draw conclusions
d)
All of above
32.
The task of arranging data in order is called
a)
Searching
b)
Sorting
c)
Ordering
d)
Shorting
33.
A primary key in any table has the properties
a)
Not Null
b)
No Duplicates
c)
Both of above
d)
None of above
34.
The term data integrity refers to:
a)
The accuracy of data
b)
The consistency of data
c)
Prevent user from making mistakes
d)
All the above
35.
In a datasheet, what does each row represent?
a)
Record
b)
Field
c)
Database
d)
Table
36.
Which is the valid data type in Access? (
a)
Number
b)
Text
c)
Currency
d)
All of the above
37.
Which data type is better to use for storing phone number in the following format “977-1-1234567”? )
a)
Text
b)
AutoNumber
c)
Number
d)
Currency
38.
Which data type is better to use for storing the price of an item?
a)
Text
b)
AutoNumber
c)
Number
d)
Currency
39.
Which of the following data type is used to store logical value in MS Access?
a)
True/False
b)
On/Off
c)
Yes/No
d)
All of Above
40.
Which of the following is use to get data from user?
a)
Query
b)
Pages
c)
Form
d)
Report
41.
Which of the following is use to view or print the data in organized manner?
a)
Query
b)
Report
c)
Table
d)
Form
42.
Query can be used to select data from
a)
Single Table
b)
Multiple Tables
c)
Both A & B
d)
None of above
43.
In MS Access, Field Value may contain
a)
Text
b)
Date & Time
c)
Picture
d)
All of the Above
44.
This key uniquely identifies each record
a)
primary key
b)
key record
c)
unique key
d)
field name
45.
To check for spelling errors you go to
a)
Home tab, in the Records group
b)
Insert tab, in the Records group
c)
Format tab, in the Records group
d)
None of the above
46.
Which of the following best describes the Grouped Report
a)
A part of report that can be generated by the report wizard
b)
A report that displays data that has been sorted in ascending or descending order
c)
A report that displays data grouped by fields you specify
d)
None of a the above
47.
You can create a report from
a)
Table
b)
Query from one table
c)
Query from multiple table
d)
All of the above
48.
During a slide show , pressing the ESC key
a)
Displays the last slide
b)
Displays the first slide
c)
Ends the slide
d)
Displays the previous slide
49.
The apply design template command is used to:
a)
Change the order of the slides
b)
Change the shapes of the slides
c)
Change the background and fonts of the entire presentation
d)
Create a new empty presentation.
50.
You can copy an object using (
a)
Right mouse button
b)
Edit menu
c)
Control C
d)
All
51.
Which of the following can be inserted on a slide? (
a)
Text
b)
Pictures
c)
organizational charts
d)
all
52.
Power point slides can have? (
a)
Titles, text, graphs
b)
Drawn objects, shapes
c)
Clipart, drawn art, visual
d)
All
53.
If you want to add a new slide you must be in the ________ tab?
a)
Insert
b)
Animation
c)
Home
d)
Design
54.
WHICH extension is used to save files in powerpoint
a)
PPT
b)
DOC
c)
PUB
d)
EXE
55.
How do you add the same transition for each slide
a)
Click the transition
b)
Click the transition then click "Apply to all"
c)
Click the transition then click "Remove"
d)
Click Design
56.
How can you reorder slides in the slide show?
a)
Click on the slide and drag to where you want it to go
b)
You can't
c)
Delete the previous slide and import a new one
d)
What Would Jesus Do?
57.
A theme includes all of the following except
a)
fonts
b)
clip art
c)
colors
d)
background
58.
To correct an error detected by the automatic spell checker, ________ the misspelled word
a)
double-click
b)
right-click
c)
hover over
d)
home tab
59.
You can present your presentation by selecting the ________ view at the bottom of the PowerPoint window.
a)
Reading
b)
Add new slide
c)
Start Presentation
d)
Slide Show
60.
Which command allows you to add a shadow to a shape?
a)
Shape Fill
b)
Shape Outline
c)
Send Backward
d)
Shape Effects
100 %
