IT Fundamentals And Office Productivity Tools – Q1
Which field property is used to control the format of the values that users have to
enter for a field, such as a phone number?
Options
1. Validation Rule
2. Input Mask
3. Required
4. Default Value
Which of the following capitalizes the first letter of each word in the selected
text?
Options
1. Sentence Case
2. Toggle Case
3. Lower Case
4. Title Case
Which of the following form views gives a detailed view of the form structure?
Options
1. Design
2. Layout
3. Form
4. Print Preview
Which of the following groups of the Page Layout tab provides options to display
custom views, gridlines, and headings?
Options
1. Page Setup
2. Scale To Fit
3. Sheet Options
4. Arrange
Which of the following capitalizes only the first character of the selected sentence?
Options
IT Fundamentals And Office Productivity Tools – Q1

1. Sentence Case
2. Toggle Case
3. Lower Case
4. Title Case
Which of the following options is a category of information that pertains to all
records?
Options
1. Table
2. Record
3. Value
4. Field
Which of the following buttons in the Replace tab of the Find and Replace dialog box
replaces every instance of the search criteria with the new data?
Options
1. Replace With
2. Replace All
3. Replace
4. Find Next
Which of the following is a tab in the Find and Replace dialog box that lets you
specify where exactly you want to navigate in the document?
Options
1. Find
2. Replace
3. Go To
4. Line and Page Breaks
Which of the following options is a group of records stored in a row and column
format?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Table

2. Record
3. Value
4. Field
Sam wants to use a chart to represent the sales trend for the product launched a
year ago by his company. Which of the following chart type will he use to display the
trend?
Options
1. Area
2. Pie
3. Bar
4. Line
The _____________ option in the Printed Watermark dialog box enables the image
to get translucent.
Options
1. Semitransparent
2. Washout
3. Color
4. Scale
Which of the following options available in the Alignment group of the Home tab is
the default vertical alignment of text?
Options
1. Align Text Left
2. Align Text Right
3. Center
4. Bottom Align
Which of the following tabs on the Ribbon allows you to quickly access and add
different object types, such as charts, tables, and pictures, in your document?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Home tab

2. Insert tab
3. View tab
4. References tab
Which of the following sites refers to an educational Web site?
Options
1. www.transport.gov
2. www.icgwelfare.org
3. www.Transtraining.edu
4. www.nikibooks.com
Which of the following tabs in Microsoft Outlook allows you to attach a file with your
message?
Options
1. Message
2. Insert
3. Options
4. Format Text
Diane Frye, an HR manager wants to create a database of all the employees in the
organization. Diane wants to create an employees table and make one of the keys a
primary key. Which of the following fields is most suitable to be a primary key field?
Options
1. Employee_No
2. Employee_FirstName
3. Employee_LastName
4. Employee_Address
Martin has created a presentation in PowerPoint 2007. He wants to apply a shadow
to the text in a slide. Which of the following options in the Font group can be used to
perform this operation?
Options
1. Text Shadow
2. Strikethrough

3. Font Size
4. Font
IT Fundamentals And Office Productivity Tools – Q1
Which of the following tabs in the Page Setup dialog box will you use to add a
number at the bottom of the worksheet?
Options
1. Page
2. Margins
3. Header/Footer
4. Sheet
A _________ is used to display the ratio of the piece of data in a selected data
series. It can be used to provide information about only one data series.
1. Line chart
2. Pie chart
3. Bar chart
4. Column chart
_____________ is a program that responds to requests from Web browsers to
retrieve resources?
Options
1. Web Server
2. Browser
3. Web Site
4. Home Page
The ____________ view helps you manage your schedule by keeping track of your
appointments and meetings.
Options
1. Calendar
2. Mail
3. To-Do bar
4. Tasks

Which of the following database objects allows you to search for information and
then display the result?
Options
1. Query
2. Table
3. Report
4. Forms
IT Fundamentals And Office Productivity Tools – Q1
Which of the following chart types will you use to display a trend over an even
interval of time?
Options
1. Stock chart
2. Line chart
3. Surface chart
4. Area chart
Which of the following keys do you press to access Help?
Options
1. F1
2. F2
3. F4
4. F5
.
The __________ pane is used to view the contents of the e-mail messages without
opening the message.
Options
1. Page Setup
2. Left Hand Pane
3. Address Bar
4. Preview
A _____________ is used to display the trend of data at various intervals of time. It

can be used to compare the trend of two or more types of data at equal intervals of
time.
Options
1. Column chart
2. Bar chart
3. Line chart
4. Pie chart
Which of the following group of Design Contextual Tab enables you to change the
view and execute a query?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Result
2. Query Type
3. Query Setup
4. Show/Hide
Which of the following Add Effect options will you use to change the appearance of
the selected objects in the presentation?
Options
1. Entrance
2. Exit
3. Motion Paths
4. Emphasis
Which of the following features fills a cell data or a series of data in a worksheet into
a selected range of cells?
1. Undo
2. Redo
3. Auto Fill
4. Save
You can switch between multiple Word documents by using the Switch Windows
option in the ________ group within the View tab.

Options
1. Windows
2. Document Views
3. Show/Hide
4. Zoom
Which of the following aggregate functions provides you the total number of values
present in a specified column?
Options
1. Sum
2. Average
3. Maximum
4. Count
IT Fundamentals And Office Productivity Tools – Q1
Which of the following functions returns the value attained by dividing the sum of
numbers by their count?
Options
1. Sum
2. Average
3. Max
4. Min
Which of the following is the default file format for Microsoft Word 2007?
Options
1. .doc
2. .docx
3. .dotx
4. .dot
Which of the following elements can be used to send a message to a recipient such
that the recipient's name is not visible to the other recipients of the same message?
Options
1. To

2. Cc
3. Bcc
4. Subject
.
Which of the following types of query enables you to calculate aggregates such as
sum, average, and count and group them together?
Options
1. Simple
2. Crosstab
3. Find Duplicates
4. Find Unmatched
Which of the following is the default view for creating and editing slides in
PowerPoint 2007?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Slide Sorter
2. Normal
3. Notes Page
4. Slide Show
____________ is the blank area surrounding the text along the top, bottom, left, and
right edges of a page.
Options
1. Ruler
2. Margins
3. Selection bar
4. Scroll bar
____________ is a device and platform-independent format that is widely used to
distribute documents over the Internet.
Options
1. .docx

2. .pdf
3. .dot
4. .dotx
If the Employee Id field consists of alphabet and numbers, which of the following
data types should be used for the Employee Id field in an Access database?
1. Text
2. Date/Time
3. Number
4. Memo
The ___________ option on Quick Access Toolbar helps correct unnecessary or
erroneous actions.
Options
1. Redo
2. Undo
3. Delete
4. Cut
IT Fundamentals And Office Productivity Tools – Q1
Which of the following elements of the Word interface contains commonly-used
commands?
Options
1. Quick Access Toolbar
2. Microsoft Office Button
3. Ribbon
4. Status bar
Which of the following options contain buttons that can be used instead of menu
options?
Options
1. Menu bar
2. Standard toolbar
3. Navigation pane

4. To-Do bar
Which of the following database object retrieves data from tables using commands?
Options
1. Table
2. Query
3. Form
4. Report
Which of the following presentation views allows you to view thumbnails of all the
slides in your presentation?
Options
1. Notes Page
2. Slide Show
3. Slide Sorter
4. Normal
Which of the following features in Excel 2007 helps to manage data according to
the chosen criteria?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Sort & Filter
2. Find & Select
3. Styles
4. AutoFill
You can repeat the last action performed by pressing the ______ key.
Options
1. F1
2. F4
3. F3
4. F6
Which of the following button from the Internet Options dialog box set the default
Microsoft starting page as the starting page of the Internet Explorer?

Options
1. Use Current
2. Use Default
3. Use Blank
4. Delete cookie
Which of the following reply options is used to send a copy of a message to
someone who did not receive the original copy?
Options
1. Reply to All
2. Forward
3. Reply
4. Send
Which of the following data types enables you to insert or embed objects created in
other applications into an Access database?
Options
1. OLE Object
2. AutoNumber
3. Currency
4. Hyperlink
.
IT Fundamentals And Office Productivity Tools – Q1
Which of the following tabs allows you to modify the style, layout, data source,
and type of chart of the worksheet?
Options
1. Format
2. Design
3. View
4. Layout
Which of the following options can be used to turn off the spell checker in Word?
Options

1. Word Options dialog box
2. Review tab
3. Spelling and Grammar: English (U.S.) dialog box
4. View tab
Which of the following button from the Internet Options dialog box will you select to
set the currently displayed page as the starting page of the Internet Explorer ?
Options
1. Use Blank
2. Use Current
3. Use default
4. Delete cookie
To be able to quickly identify messages related to a particular category, you need to
assign a ______________ to messages in the category.
Options
1. Name
2. Color category
3. Flag
4. Value
Which of the following key combination enables you to create a database in
Microsoft Access 2007?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Ctrl+N
2. Alt+N
3. Ctrl+S
4. Alt+S
.
Which of the following chart types will you use to add visual impacts to your
charts?
Options

1. Area chart
2. Pie chart
3. Stock chart
4. Line chart
Ronald Billing wants to display the current date and time in a worksheet. Which of
the following functions will Ronald use to perform this operation?
Options
1. DATE
2. NOW
3. TODAY
4. EDATE
Which of the following presentation views allow you to display the contents of the
Notes pane in full-page format?
Options
1. Slide Show
2. Slide Sorter
3. Normal
4. Notes Page
Which of the following is the shortcut key to open a new worksheet?
Options
1. Ctrl+N
2. Ctrl+F11
3. Ctrl+O
4. Ctrl+F10
IT Fundamentals And Office Productivity Tools – Q1
____________ is a program that allows you to search for a particular set of words
specified by you, on the Internet?
Options
1. Search Engine
2. Web Server

3. E-Mail
4. Web Site
.
Which of the following reply options is used to send a response only to the sender of
the message?
Options
1. Reply to All
2. Forward
3. Reply
4. Status bar
__________ bound control is used to display data linked to a field in a table.
Options
1. Text Box
2. Option Button
3. Check Box
4. Label
Which of the following tabs on the Format Picture dialog box contains various
alignment options and wrapping styles that you can apply to an image?
Options
1. Layout
2. Size
3. Picture
4. Text Box
Which of the following services will you use to Send file to another computer?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Telnet
2. FTP
3. E-Mail
4. Newsgroups

Which of the following view is available for all four database objects?
Options
1. DataSheet
2. Design
3. SQL
4. Layout
.
Which of the following keys begins the presentation in the Slide Show view?
Options
1. F5
2. Page Down
3. P
4. Slide Number + Enter
Which of the following form creation tools will you use to view the form in Form view
and Datasheet view simultaneously?
Options
1. Form
2. Form Design
3. Split Form
4. Blank Form
Which of the following components of the Microsoft Application window provides
access to frequently used commands in the application?
Options
1. Office Button
2. Quick Access Toolbar
3. Ribbon
4. Task Pane
IT Fundamentals And Office Productivity Tools – Q1
Which of the following is a set of data pertaining to one person or entity?
Options

1. Table
2. Record
3. Field
4. Value
Which of the following keys/key combinations will take the insertion pointer to the
end of the line?
Options
1. End
2. Ctrl + End
3. Ctrl + Home
4. Home
.
Which of the following database objects enable you to automate certain frequently
used actions in the application?
Options
1. Macro
2. Module
3. Report
4. Table
Which of the following options is used to refer to the data of various cells in a
formula?
Options
1. References
2. Operators
3. Constant
4. Function
Which of the following groups in the Home tab provides features for cutting, copying,
and pasting text in a Word document?
Options
IT Fundamentals And Office Productivity Tools – Q1

1. Font
2. Clipboard
3. Paragraph
4. Editing
Which of the following options of the Alignment tab of the Format Cells dialog box,
enables you to align text to the left and numbers to the right?
Options
1. General
2. Distributed (Indent)
3. Justify
4. Center Across Selection
Which of the following Ribbon tabs can be used to modify the page orientation?
Options
1. Page Layout tab
2. Insert tab
3. Home tab
4. View tab
.
Which of the following options enables you to put together addresses that are
commonly used?
Options
1. File > New > Distribution List
2. File > New > Contact
3. File > New > Task
4. File > New > Group
Which of the following key combinations can be used to send a message?
Options
1. Ctrl+Enter
2. Ctrl+S
3. Alt+Enter

4. Alt+S
IT Fundamentals And Office Productivity Tools – Q1
Which of the following group of Design Contextual Tab Enables you to insert and
delete rows and columns, launch the Builder for building expressions, and launch
Show Table for setting up a query from a table, another query, or both?
Options
1. Result
2. Query Type
3. Query Setup
4. Show/Hide
Diane Frye wants to add picture, charts, clip arts, and various shapes to the slides in
a presentation. Which of the following groups in the Insert tab can be used to
perform this task?
Options
1. Illustrations
2. Text
3. Links
4. Media Clips
Which of the following types of functions enable you to test whether a cell or a range
of cells meets a specified condition?
1. Text
2. Logical
3. Date & Time
4. Financial
Which of the following is an option in the AutoFit behavior section of the Insert
Table dialog box that can be used to resize the width of a column based on the text
entered in a cell?
Options
1. AutoFit to content
2. AutoFit to window

3. Fixed column width
___________________is the first hypertext document (in HTML) that is displayed
when the user opens a Web site?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Home Page
2. Web site
3. Web Server
4. Browser
________________ is a message that is sent electronically using an application.
Options
1. Item
2. Appointment
3. E-mail
4. Folder
Which of the following chart types will you use to compare values at different points
in time and to make comparisons between items?
Options
1. Bar and Column chart
2. Pie chart
3. Line and Bar chart
4. Area chart
.
Which of the following component from Expression Builder displays the table, query,
form, report object, user defined function, and other folders?
Options
1. Left box
2. Operator buttons
3. Expression box
4. Middle box

Which of the following Change Case options will you use to capitalize only the first
letter in the selected text?
Options
1. Sentence case
2. Lowercase
3. Capitalize Each Word
4. Toggle Case
IT Fundamentals And Office Productivity Tools – Q1
A macro is created using the Record Macro button in the _____ group of the
Developer tab.
Options
1. Controls
2. XML
3. Code
4. Protect
Which of the following types of queries enables you to find records in a table with no
related records in another table?
Options
1. Simple
2. Find Duplicate
3. Find Unmatched
4. Crosstab
In Excel 2007, text is ___________ aligned by default.
Options
1. Left
2. Right
3. Center
4. Justify
.
______________ is the area at the left margin of a document that is used to select

text.
Options
1. Selection Bar
2. Quick Access Toolbar
3. Ribbon
4. Mini Toolbar
Which of the following allows you to preview the contents of a message without
opening it?
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Navigation Pane
2. Reading Pane
3. Folder Contents List
4. Folder List
Which of the following query enables you to find duplicate field values?
Options
1. Simple
2. CrossTab
3. Find Duplicates
4. Find Unmatched
Which of the following options of the Font group is used to define the font type for
the selected text?
Options
1. Font
2. Font Size
3. Font Color
4. Change Case
__________________ is a graphic element that is used to illustrate information in
a document.
Options

1. Picture
2. Shapes
3. Chart
4. SmartArt
.
Which of the following workbook elements allows you to rename, add, or remove a
worksheet from an Excel 2007 workbook?
Options
1. Title bar
2. Sheet tab
3. Insert worksheet button
4. Home tab
IT Fundamentals And Office Productivity Tools – Q1
Which of the following options of the Microsoft Office button allows you to share
your document with other people through the Web?
Options
1. Publish
2. Send
3. Save As
4. Open
Which of the following views enable you to enter data into the fields of a table?
Options
1. Design
2. Datasheet
3. Database
4. Layout
Which of the following form creation tools will you use to create a form that displays
all the fields in a table?
Options
1. Form

2. Form Design
3. Split Form
4. Blank Form
Which of the following tabs helps you in modifying the display of the open
worksheet and the application window?
Options
1. View tab
2. Page layout tab
3. Review tab
4. Home tab
.
_______________ is a formatting tool that allows you to duplicate the character or
paragraph formatting in the selected text to a new text selection without
duplicating efforts.
IT Fundamentals And Office Productivity Tools – Q1
1. Cut and Paste
2. Copy and Paste
3. Format Painter
4. Paste Special
Which of the following options is a collection of data that is logically related and
organized?
Options
1. Database
2. Table
3. Record
4. Field
How many sheets does an Excel 2007 worksheet contain by default?
Options
1. 3
2. 4

3. 2
4. 1
___________ button on the Quick Access Toolbar helps correct unnecessary or
erroneous actions.
Options
1. Redo
2. Undo
3. Delete
4. Cut
Which of the following options of the Alignment tab of the Format Cells dialog box
indents the text to both sides of the cell?
Options
1. General
2. Distributed (Indent)
3. Justify
4. Center Across Selection
IT Fundamentals And Office Productivity Tools – Q1
Which of the following key combinations can be used to insert a manual page break
in a document?
Options
1. Ctrl+End
2. Ctrl+Enter
3. Alt+End
4. Alt+Enter
.
Which of the following options in the Font group enables you to color the
background of the selected cell or range of cells?
Options
1. Fill color
2. Font color

3. Font
4. Border
Which of the following CANNOT be used as a data source for mail merge?
Options
1. Word document
2. Excel file
3. Access database
4. PowerPoint presentation
Which of the following dialog box will you use to change all instances of the font at
the same time?
Options
1. Replace
2. Replace Font
3. Font
4. Find
_____________________ tab in the Ribbon is used to create a macro.
Options
IT Fundamentals And Office Productivity Tools – Q1
1. Developer
2. Review
3. Mailings
4. Add-Ins
.
Which of the following key combinations enable you to add a blank worksheet to the
left of the currently selected worksheet?
Options
1. Shift+F11
2. Alt+F11
3. Shift+F5
4. Alt+F5

.
Which of the following folders helps you keep a record of any interaction that you
want to remember?
Options
1. Calendar
2. Journal
3. Contacts
4. Drafts
_____________ is the process that ensures data validity across two tables.
Options
1. Referential Integrity
2. Cascade Delete
3. Cascade Update
4. Join
Which of the following toolbar buttons in a formatting toolbar allows you to format a
specified number with a $ sign before the number?
Options
1. Accounting Number Format
2. Percent Style
3. Comma Style
4. Increase Decimal