Windows XP Home / Pro Run Commands and Short Cuts

How To - Click Start, Click Run and enter the command Click OK

Run commands
Calc - Calculator
Cfgwiz32 - ISDN Configuration Wizard
Charmap - Character Map
Chkdisk - Repair damaged files
Cleanmgr - Cleans up hard drives
Clipbrd - Windows Clipboard viewer
Cmd - Opens a new Command Window (cmd.exe)
Control - Displays Control Panel
Dcomcnfg - DCOM user security
Debug - Assembly language programming tool
Defrag - Defragmentation tool
Drwatson - Records programs crash & snapshots
Dxdiag - DirectX Diagnostic Utility
Explorer - Windows Explorer
Fontview - Graphical font viewer
Ftp - ftp.exe program
Hostname - Returns Computer's name
Ipconfig - Displays IP configuration for all network adapters
Jview - Microsoft Command-line Loader for Java classes
MMC - Microsoft Management Console
Msconfig - Configuration to edit startup files
Msinfo32 - Microsoft System Information Utility
Nbtstat - Displays stats and current connections using NetBios over TCP/IP
Netstat - Displays all active network connections
Nslookup- Returns your local DNS server
Ping - Sends data to a specified host/IP
Regedit - registry Editor
Regsvr32 - register/de-register DLL/OCX/ActiveX
Regwiz - Reistration wizard
Sfc /scannow - Sytem File Checker
Sndrec32 - Sound Recorder
Sndvol32 - Volume control for soundcard
Sysedit - Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)
Systeminfo - display various system information in text console
Taskmgr - Task manager
Telnet - Telnet program
Taskkill - kill processes using command line interface
Tskill - reduced version of Taskkill from Windows XP Home
Tracert - Traces and displays all paths required to reach an internet host
Winchat - simple chat program for Windows networks
Winipcfg - Displays IP configuration

Management Consoles

certmgr.msc - Certificate Manager
ciadv.msc - Indexing Service
compmgmt.msc - Computer management
devmgmt.msc - Device Manager
dfrg.msc - Defragment
diskmgmt.msc - Disk Management
fsmgmt.msc - Folder Sharing Management
eventvwr.msc - Event Viewer
gpedit.msc - Group Policy -XP Pro only
iis.msc - Internet Information Services
lusrmgr.msc - Local Users and Groups
mscorcfg.msc - Net configurations
ntmsmgr.msc - Removable Storage
perfmon.msc - Performance Manager
secpol.msc - Local Security Policy
services.msc - System Services
wmimgmt.msc - Windows Management

Shortcuts

access.cpl - Accessibility Options
hdwwiz.cpl - Add New Hardware Wizard
appwiz.cpl - dd/Remove Programs
timedate.cpl - Date and Time Properties
desk.cpl - Display Properties
inetcpl.cpl - Internet Properties
joy.cpl - Joystick Properties
main.cpl keboard - Keyboard Properties
main.cpl - Mouse Properties
ncpa.cpl - Network Connections
ncpl.cpl - Network Properties
telephon.cpl - Phone and Modem options
powercfg.cpl - Power Management
intl.cpl - Regional settings
mmsys.cpl sounds - Sound Properties
mmsys.cpl - Sounds and Audio Device Properties
sysdm.cpl - System Properties
nusrmgr.cpl - User settings
firewall.cpl - Firewall Settings (sp2)
wscui.cpl - Security Center (sp2)

Windows Environment Commands

%ALLUSERSPROFILE% - Open the All User's Profile
%HomeDrive% - Opens your home drive e.g. C:\
%UserProfile% - Opens you User's Profile
%temp% Opens - temporary file Folder
%systemroot% - Opens Windows folder

Wupdmgr - Takes you to Microsoft Windows Update

General keyboard shortcuts

CTRL+C(Copy)
CTRL+X (Cut)
CTRL+Z (Undo)
DELETE (Delete)
SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
CTRL while dragging an item (Copy the selected item)
CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
F2 key (Rename the selected item)
CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
CTRL+A (Select all)
F3 key (Search for a file or a folder)
ALT+ENTER (View the properties for the selected item)
ALT+F4 (Close the active item, or quit the active program)
ALT+ENTER (Display the properties of the selected object)
ALT+SPACEBAR (Open the shortcut menu for the active window)
CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
ALT+TAB (Switch between the open items)
ALT+ESC (Cycle through items in the order that they had been opened)
F6 key (Cycle through the screen elements in a window or on the desktop)
F4 key (Display the Address bar list in My Computer or Windows Explorer)
SHIFT+F10 (Display the shortcut menu for the selected item)
ALT+SPACEBAR (Display the System menu for the active window)
CTRL+ESC (Display the Start menu)
ALT+Underlined letter in a menu name (Display the corresponding menu)
Underlined letter in a command name on an open menu (Perform the corresponding command)
F10 key (Activate the menu bar in the active program)
RIGHT ARROW (Open the next menu to the right, or open a submenu)
LEFT ARROW (Open the next menu to the left, or close a submenu)
F5 key (Update the active window)
BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
ESC (Cancel the current task)
SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)
CTRL+SHIFT+ESC (Open Task Manager) Dialog box keyboard shortcuts

If you press SHIFT+F8 in extended selection list boxes, you enable extended selection mode. In this mode, you can use an arrow key to move a cursor without changing the selection. You can press CTRL+SPACEBAR or SHIFT+SPACEBAR to adjust the selection. To cancel extended selection mode, press SHIFT+F8 again. Extended selection mode cancels itself when you move the focus to another control.

CTRL+TAB (Move forward through the tabs)
CTRL+SHIFT+TAB (Move backward through the tabs)
TAB (Move forward through the options)
SHIFT+TAB (Move backward through the options)
ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
ENTER (Perform the command for the active option or button)
SPACEBAR (Select or clear the check box if the active option is a check box)
Arrow keys (Select a button if the active option is a group of option buttons)
F1 key (Display Help)
F4 key (Display the items in the active list)
BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Opendialog box)

Microsoft natural keyboard shortcuts

Windows Logo+BREAK (Display the System Properties dialog box)
Windows Logo+D (Display the desktop)
Windows Logo+M (Minimize all of the windows)
Windows Logo+SHIFT+M (Restore the minimized windows)
Windows Logo+E (Open My Computer)
Windows Logo+F (Search for a file or a folder)
CTRL+Windows Logo+F (Search for computers)
Windows Logo+F1 (Display Windows Help)
Windows Logo+ L (Lock the keyboard)
Windows Logo+R (Open the Run dialog box)
Windows Logo+U (Open Utility Manager)

Accessibility keyboard shortcuts

Right SHIFT for eight seconds (Switch FilterKeys either on or off)
Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
SHIFT five times (Switch the StickyKeys either on or off)
NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
Windows Logo +U (Open Utility Manager)

Windows Explorer keyboard shortcuts

END (Display the bottom of the active window)
HOME (Display the top of the active window)
NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
NUM LOCK+Minus sign (-) (Collapse the selected folder)
LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut keys for Character Map

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts
RIGHT ARROW (Move to the right or to the beginning of the next line)
LEFT ARROW (Move to the left or to the end of the previous line)
UP ARROW (Move up one row)
DOWN ARROW (Move down one row)
PAGE UP (Move up one screen at a time)
PAGE DOWN (Move down one screen at a time)
HOME (Move to the beginning of the line)
END (Move to the end of the line)
CTRL+HOME (Move to the first character)
CTRL+END (Move to the last character)
SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC) main window keyboard shortcuts

• CTRL+O (Open a saved console)
CTRL+N (Open a new console)
CTRL+S (Save the open console)
CTRL+M (Add or remove a console item)
CTRL+W (Open a new window)
F5 key (Update the content of all console windows)
ALT+SPACEBAR (Display the MMC window menu)
ALT+F4 (Close the console) • ALT+A (Display the Action menu)
ALT+V (Display the View menu)
ALT+F (Display the File menu)
ALT+O (Display the Favorites menu)

MMC console window keyboard shortcuts

CTRL+P (Print the current page or active pane)
ALT+Minus sign (-) (Display the window menu for the active console window)
SHIFT+F10 (Display the Action shortcut menu for the selected item)
F1 key (Open the Help topic, if any, for the selected item)
F5 key (Update the content of all console windows)
CTRL+F10 (Maximize the active console window)
CTRL+F5 (Restore the active console window)
ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
F2 key (Rename the selected item)
CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote desktop connection navigation

CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
ALT+PAGE UP (Switch between programs from left to right)
ALT+PAGE DOWN (Switch between programs from right to left)
ALT+INSERT (Cycle through the programs in most recently used order)
ALT+HOME (Display the Start menu)
CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
ALT+DELETE (Display the Windows menu)
CTRL+ALT+Minus sign (-) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)
CTRL+ALT+Plus sign (+) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)

Microsoft Internet Explorer navigation

CTRL+B (Open the Organize Favorites dialog box)
CTRL+E (Open the Search bar)
CTRL+F (Start the Find utility)
CTRL+H (Open the History bar)
CTRL+I (Open the Favorites bar)
CTRL+L (Open the Open dialog box)
CTRL+N (Start another instance of the browser with the same Web address)
CTRL+O (Open the Open dialog box, the same as CTRL+L)
CTRL+R (Update the current Web page)
CTRL+ CTRL+P (Open the Print dialog box)
W (Close the current window)

Note Some keyboard shortcuts may not work if StickyKeys is turned on in Accessibility Options, Some of the Terminal Services client shortcuts that are similar to the shortcuts in Remote Desktop Sharing are not available when you use Remote Assistance in Windows XP Home Edition.

Thanks to The New Tech for the original forum posting.

Microsoft Office run commands
If the Microsoft Office is installed you can use following run commands to run its components:

winword – Microsoft Word
excel – Microsoft Excel
powerpnt – Microsoft PowerPoint
msaccess – Microsoft Access
outlook – Microsoft Outlook
ois – Microsoft Picture Manager

Microsoft Office Questions and Answers

1. When you save an Access project, what file format do you use?

a. .adp b. .xm. c. .mdb d. All of above

2. Which of the following criterion would find records whose personality field does not equal “Nice”?

a. <>Nice b. NOT Nice c. <>”Nice” d. IS NOT Nice

3. According to the Access timeline on Microsoft.com, which version of Microsoft Access first included the Northwind Traders sample database?

a. 1.0 b. 2.0 c. 7.0 for Windows 95 d. All of above

4. Which version of Access first provided ODBC connectivity to Oracle databse?

a. 1.1 b. 2.0 c. 97 d. All of the above

5. What was the lagest database size allowed by Access 1.0?

a. 128 MB. b. 256 MB c. 512 MB d. None of above

6. What is the maximum length of a text field can be?

a. 512 characters b. 50 characters c. No limit d. 255 characters.

7. What is the maximum character field size you can set for a field that has a text data type?

a. 64 b. 255 c. 512 d. All of above

8. Which of the following fields would not make a suitable primary key

a. A date field b. An invoice number

c. An autoNumber field d. A customer’s social security number

9. Auto reports can contain each of the following elements except:

a. A detail section b. A page footer c. A group header d. All of the above

10.Need to see all the information from two tables on one form? Insert:

a. A page break b. A subform c. A linked command button d. None of the above

11.What is the primary difference between a pivot table report and a cross tab query?

a. A pivot table report can contain sums, counts, and averages while a cross tab query cannot.

b. You can’t pivot a cross tab query

c. A cross tab query lets you group similar items. A pitot table report does not

d. None of above

12.The largest unit of a database is

a. A record b. A field c. A subfield d. None of above

13.What’s the best Access object for an invoice you’ll mail to customers?

a. A report b. A form c. A table d. All of the above

14.What is a Grouped Report?

a. A type 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

15.A(n) …., or command is the basic building block of a macro

a. Action b. Expression c. Function d. Procedure

16.Which field allow to select items from drop down list?

a. An OLE field b. A Memo Field c. A lookup Field d. A hyperlink field

17.What did the first Table Analyzer do?

a. Analyze the data in a set of flat files and automatically create a relational database system from that information

b. Provide a graphic way to design relational databases

c. Automate process of connecting tables to SQL Server d. None

18.Pivot Table reports are good for:

a. Analyzing large amounts of data b. Turning tables upside down

c. Breaking spreadsheet data into multiple worksheet d. None of above

19.A report form

a. Appears on the computer monitor during data entry

b. Is used during report generation to format data

c. Both a and b d. All of above

20.Which of the following columns can not be found in the macro design window?

a. Arguments column b. Comment column

c. Conditions column d. Actions column

21. The ascending order of a data hierarchy ios:

a. Bit, byte, field, record, file, database b. Bit, byte, record, field, file, database

c. Byte, bit, field, record, file, database d. Byte, bit, record, field, file, database

22. A good query system

a. Can accept English language commands

b. Allows non-programmers to access information stored in a database

c. Can be accessed only by data prssing professionals

d. Both a and b

23. How do you freeze a field a column or field in Microsoft Access?

a. Click anywhere in the column and select Edit>Freeze Column form the menu

b. Place an ice cube in the column

c. Click anywhere in the column and click the freeze button on the toolbar

d. Right click the column and select freeze columns from the shortcut menu

24. Within Table Datasheet view, how can you display associated records from another table?

a. Click the expand indicator (+) next to a record b. Double click the record.

c. Apply the filter by form command d. None

25. Which of the following is not a command to find specific word or phrases in a database?

a. Click the find button on the toolbar

b. Click the find button on the record navigation button area

c. Press Ctrl+F d. Select Edit>Find from the menu.

26. One of the type libraries that you can use to programmatically connect to Microsoft Access data is:

a. Collaborative Data Objects b. ActiveX Data Objects

c. Dynamic Data Interfaces d. None of the above

27. The data in a Pivot Table report is categorized using:

a. Column headings b. Items from the Pivot Table field list

c. Header rows d. All of above

28. Which of the following are common ways to enforce data validation when entering data into an Access form?

a. Create an input mask to restrict the kind of value that can be entered in positions across the field.

b. Define a validation rule for that field c. A and b d. none of the above

29. The purpose of the Add-in Manager is to

a. Create macros and automate data processing b. Add or remove data in an existing database

c. Add or remove templates, macros, and wizards d. All of above

30.Sub-schema can be used to

a. Create very different, personalized views of the same data

b. Present information in different formats

c. Hide sensitive information by omitting fields from the subschema’s description

d. All of the above

31.If you are entering data in a form, quick way to copy value from the previous record is to press

a. Ctrl+’ b. F6 c. Ctrl+D d. None of the above

32.what is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?

a. DASD b. FMS c. EMMS d. DBMS

33.A repository for data, usually covering some specific topic is called

a. Data acquisition b. Data bank c. Real time d. Database

34. A notation for defining the form and structure of data is known as

a. Data description language b. Binary language

c. Data channels d. Data definition language

35. A data item, which is not broken down into smaller units, is

a. Data element b. Elementary data item c. Data entry d. Database management

36.Which of the following terms refers to the degree to which data in database system are accurate and correct?

a. Data security b. Data validaity c. Data independence d. Data integrity

38.A set of programs that handle firm’s data base responsibilities is called a

a. Database Management System (DBMS) b. Database Processing System (DBPS)

c. Data Management System (DMS) d. All of above

39.Which of the following is not a relational database?

a. dBase IV b. 4^th Dimension c. FoxPro d. Reflex

40.Which is used to provide the sight information to the right person at the right time for proper decision making

a. DBMS b. MIS c. ISO d. PSO

41. Dbase-III was developed by

a. Dec b. IBM c. Ashton-tate d. All of the above

42. the modify operation is likely to be done after

a. delete b. look up c. insert d. all of above

43. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper

a. Display records between the dates 1/2/99 and 1/1/00

b. Display records between the dates 1/1/99 and 12/31/99

c. Display records whose dates equaled 1/1/99 or 12/31/99

d. All of the above

44. DDP stands for

a. Distributed Double Processing b. Double Decimal Processing

c. Distributed Data Programming d. Distributed Data Processing

45. To see sales amount figures totaled, into which drop area would you drag that field?

a. Drop column fields here b. Drop row fields here

c. Drop data items here d. None of the above

46. Which access feature do you use to develop applications that host access data on the web?

a. Dynamic web data b. Data access pates c. Html data pages d. None of the above

47. What is the common name for a column of data within an Access table?

a. Field b. Record c. Row d. None of the above

48. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called

a. Field b. Bead c. Database d. Data collection

49. A group of characters used to identify a given low level instruction is

a. File b. Record c. Key field d. Label

50. One or more characters used to identify a data field in a computer program is

a. File name b. Database c. Label d. Group

51. In Form view, which command displays records alphabetically?

a. Find b. Advanced Filter/Sort c. Sort d. All of the above

52. Where do report and forms get their information form?

a. Forms b. Modules c. Tables d. Queries

53.the number of logical records in a physical record is

a. group b. blocking factor c. sector d. field

54. A top to bottom relationship among the items in a database is established by a

a. Hierarchical schema b. Network Schema

c. Relational schema d. All of the above

55.A command that lets you change one or more fields in a record is

a. Insert b. Modify c. Look up d. All of the above

56.A logical schema

a. Is the entire database

b. Is a standard way of organizing information into accessible parts

c. Describes how data is actually stored on disk d. All of the above

57.What is the purpose of the page field on a pivot table report?

a. It creates a new page for each type of data

b. It allows the data within the Pivot Table report to be filtered

c. It displays a title for the Pivot Table report

d. None of the above

58.What does the Special Effect button on the formatting toolbar do?

a. It lets you add animation to your forms and reports to make them more entertaining and amusing

b. None of these

c. It applies a 30d effect to a selected control

d. It lets you select a transitional effect for how a form opens and closes.

59.Pivot Table report data must meet which of the following criteria?

a. It must be in tabular form, have unique column labels, and each row must represent a unique piece of data

b. Any dates should be formatted with the data format and blank rows or columns should be removed

c. It must be in tabular form, have unique column lagels, and all rows must be sorted

d. Both a and b

60.Customers, Orders. What’s their best relationship?

a. Many-to-many b. One-to-one c. One-to-many d. All of the above

61. Which control does access use to link data access page components to access data?

a. Microsoft Dynamic Data Control b. Microsoft Data Connection Control

c. Microsoft Office Data Source Control d. None of the above

62. Which program do you use to edit code for data access pages?

a. Microsoft script editor b. Microsoft code editor

c. Microsoft data access pages editor d. None of above

63. The way a particular application views the data from the database that the application uses is a

a. Module b. Relational model c. Schema d. Sub-schema

64. Which of the following is a database management system?

a. Ms-Word b. Lotus 1-2-3 c. Oracle d. None of above

65. What is the corresponding text for the <#1/1/95# validation rule setting?

a. Neter a value less or more than 1,195 b. Value must be less than 95 characters

c. Enter a date before 1995 d. All of above

66. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?

a. Object Viewer b. Object Browser c. Type Library Spy d. None of above

67. A computer language for informing the DBMS regarding the data structure used is

a. PASCAL b. DDL c. PROLOG d. FORTRAN

68. Which of the following is not a data type

a. Picture/graphic b. Data/time c. Text d. Number

69. The executive responsible for the data processing function in an organization is

a. PM b. DBMS c. DP d. DPM

70.Which of the following is NOT a type of Microsoft Access database object?

a. Queries b. Workbooks c. Forms d. Tables

71.A file containing relatively permanent data is

a. Random file b. Transaction file c. Master file d. Sequential file

72.The complete picture of data stored in database is known as

a. Record b. Scheme c. System flowchart d. DBMS

73.A subset of characters within a data field is known as

a. Record b. File c. Data string d. Byte

74.Data items groped together for storage purposes are called a

a. Record b. Title c. List d. string

75.Which of the following terms does not describe a database structure used by a DBMS to link data from several files?

a. Relational b. Structural c. Network d. All of the above

76.In a relational schema, each table is divided into fields called

a. Relations b. Domains c. Queries d. All of the above

77.How do you filter by selection?

a. Right click the field value and select filter by selection from the shortcut menu

b. Find and double click the value on which you want to base the filter

c. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

d. None

78.What is a fast way t adjust the width of a column?

a. Right click the left side of the column heading

b. Double click the left side of the column heading

c. Double click the right side of the column heading

d. Select tools>adjust column width from the menu

79.What are the columns in a Microsoft Access table called?

a. Rows b. Fields c. Cells d. Records

80.How do you update Pivot Table report data after changes are made to the source data?

a. Save your changes, close the workbook, and then reopen it.

b. Select the Pivot Table worksheet and press F9 on the keyboard

c. Click the report, and on the Pivot Table toolbar, click the refresh data button

d. All of the above

81. What method can you use to add a new table to your database?

a. Use Design View to create a table b. Enter data directly by using a datasheet

c. Both of above d. All of the above

Correct Answer: c

82. Which action do you use in a macro to automatically send a report snapshot in an email message?

a. Use mail b. Send object c. Run macro d. All of the above

3. How can you display sales grouped by country, region, and salesperson, all at the same time?

a. Use the Sort Descending command. b. Use the Pivot table view command

c. Use the find command on specified groups d. All of above

84. The checking operation performed on input data is called the

a. Validation of data b. Verification of data

c. Cross check d. Control of data

85. A form defines

a. Where data is placed on the screen b. The width of each field

c. Both a and b d. All of the above

86. All formula in Excel start with

a. % b. + c. = d. -

87. You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

a. & (ampersand) b. = (equal sign) c. (space) d. All of the above

88. Two common wildcard characters that Excel recognizes are

a. * and ? b. <> c. ^ and / d. + and -

89. The divide symbol is

a. / b. D c. \ d. )

90. The multiplication arithmetic operator is represented by which of the following symbols?

a. ^ b. * c. / d. X

91. To add two cells (A1 and A2) together you use the following formula

a. =A1 + A2 b. =Add(A1+A2) c. =together(A1:A2) d. A1 plus A2

92. To make a number in cell C1 10% smaller than the number in C3 you enter

a. =C3*1.10 b. +C3*110 c. =C3%10 d. =C3*.90

93. On an excel sheet the active cell in indicated by …

a. A dark wide boarder b. A dotted border c. A blinking border d. None of above

94. Using the F11 shortcut key to create a chart on chart sheet creates

a. A default chart b. A 2-dimensional column chart

c. A 2-dimensional bar chart d. A 3-dimensional line chart

95. You can print

a. A range of cells by range name b. An entire worksheet

c. A single worksheet d. All of the above

96. You can create only a horizontal page break by first selecting

a. A row below the row where you want the page break to occur

b. A cell in row 1 c. A cell in column A d. a and c

97. You can create hyperlinks from the Excel workbook to

a. A webpage on company internet b. A web page on the internet

c. Other Office 97 application documents d. All

98. The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……

a. B1-G10 b. B1.G10 c. B1;G10 d. B1:G10

99. The advantage of using a spreadsheet is:

a. calculations can be done automatically. b. changing data automatically updates calculations

c. more flexibility d. all of the above

100. The intersection of a row and column is called :

a. data b. a field. c. a cell d. an equation.

101. There are three types of data found in a spreadsheet.

a. data, words, numbers b. equations, data, numbers

c. words, numbers, labels d. numbers, formulas, labels

102. To select a column the easiest method is to……

a. Double click any cell in the column

b. Drag from the top cell in the column to the last cell in the column

c. click the column heading d. click the column label

103. If you press ……, the cell accepts your typing as its contents.

a. Enter b. Ctrl+Enter c. Tab d. Insert

104. which of the following special function keys allow the content in cell

a. esc b. shift c. return d. Tab

a. Spelling options

b. Grammar options

c. Synonyms and Antonyms

d. Opposite Words

c. : Thesaurus is a tool application in MS-Word that lets you look for antonym or synonym words of selected word.

302. What is the function of Drop Cap?

a. It does not allow capital letters to be used in the documents.

b. It does not allow capital letters to be used in the documents apart from the first letter of every sentence.

c. It lets you begin a paragraph with a large dropped initial capital letter.

d. It automatically starts all paragraphs and sentences with capital letters.

c. : Drop cap is the first character or word of a paragraph that is large, dropped below the current line. This is used for designing a paragraph.

303. How can you insert a sound file in your word document?

a. From Insert -> Object menu option

b. From Insert -> Sound menu option

c. From Insert ->File menu option

d. By right clicking the document and choosing 'Add Sound' option

a. : We choose Object from Insert menu to insert whether sound or video that are not created from MS-Word application.

304. A bookmark is an item or location in document that you identify a name for future reference. Which of the following task is accomplished by using bookmarks?

a. To quickly jump to a specific location in the document

b. To add hyper links in a web page

c. To add anchors in a web page

d. To mark the ending of a page of document

a. ; You can mark a location in document and save it with a name so that you can make a quick jumps to that location later on. Bookmarks are used in creating hyperlinks in document.

305. What are sections used for in a word document?

a. To divide the document into parts so that each part may be independently printed when the print command is given.

b. To divide the document into parts so as to allow certain parts of the document to display data from a table.

c. To divide the document into parts so as to allow certain parts of the document to display data from the Internet.

d. To vary the layout of a document within a page or between pages by dividing the document into parts, and then allow formatting of each part the way you want.

d. : Sections are logical division of a document that share common layout. You need to create new section when you need to create different layout in same document such as different sets of headers and footers, different page number format, different column formats and so on.

306. What process should be used to recall a document saved previously?

1. Copy b. Save c. Open d. Enter

c. : To retrieve a document that was saved previously we use Open command. This will load the document from disk into Word Application, ready to be edited, formatted or printed.

307. Desktop publishing is a more sophisticated form of which of the following types of software?

1. Spreadsheet b. Graphing c. Word processing d. Database

c. : Word-processing is the process of creating document such as letters, reports, thesis, books and so on. But still the more advanced and sophisticated form of word processing is desktop publishing which further deals with publishing tasks such as pagination, paper layout and many more.

308. What print command should be selected to print first 5 pages of document?

1. Print preview b. Page setup c. Print all d. From___To___

d. : Print dialog box provides different options to suite your printing needs. To print first 5 pages of your document you can choose From 1 to 5 in the print dialog box.

309. Which word processing utility could you use to find the synonym of a word?

1. Spell checker b. Thesaurus c. Out-liner d. Grammar checker

b. : Whether you need to look for synonym or antonym of a word you will use Thesaurus.

310. A word processor would most likely be used to do which of the following?

1. Keep an account of money spent c. Maintain an inventory
2. Do a computer search in media center d. Type a biography

d. : Among the given options, typing a biography needs a wordprocessor.

311. WordStar, Word Perfect and Professional Write all are Word Processors run in DOS mode?

1. True b. False

312. Which of the following application is not included in Office Package?

1. Access. B. Excel. C. Word Perfect d. Power Point

Answer C. :- Microsoft Word is included in Office Package but not Word Perfect.

313. For which of the following task MS Word is not best suited?

1. Writing Thesis with 100s of pages
2. Automatically formatting pre-written document
3. Creating Slides to show in a workshop or seminar
4. Combine main document and data source to send letters too many recipients.

Answer C. :Office Package has PowerPoint for creating presentations. MS-Word is not good enough for creating presentations.

314. Which of the following is not the feature of MS-Word?

1. Margins and page length can be adjusted as desired
2. Spelling can be checked and modified through the spell check facility
3. Provides tools such as data consolidation, goal seek, scenario etc.
4. Multiple document/files can be merged

Answer C. : These tools are available in Excel for managing and analyzing data. They are not available in MS-Word

315. Macros are?

1. Small add-on programs that are installed afterwards if you need them.
2. Programming language that you can use to customize MS-Word.
3. Large tools in Word such as Mail Merge.
4. Small programs created in MS-Word to automate repetitive tasks by using VBA.

Answer D. :We can create macro once and use it whenever needed for the repetitive type of tasks. Macros are stored in VBA language and can be edited if needed.

316. What process should be used to recall a document saved previously?

1. Copy b. Save c. Open d. Enter

Answer C. :Open command retrieves the stored document previously.

317. Which of the following bar is not available in MS-Word?

1. Toolbar b. Formula Bar c. Status Bar d. Menu Bar

Answer B. : Formula Bar is available in Excel and not in Word. Word is not good enough to apply formula or performing calculations.

318. While working in Ms-Word you have to work with

1. Mouse only b. Keyboard Only c. Both Mouse and Keyboard

Answer C. :Without keyboard, it would be difficult to enter text for document. We use mouse to give commands by clicking on the menu items or tool buttons.

319. In Ms- Word every command is available in?

1. Letter b. Icon c. Printer d. Menu

Answer D. :All the commands in MS-Word are available in Menu. Most frequently used commands are available in toolbars too but all commands are in Menu.

320. Menu Item in dim color (gray) indicate that the menu is?

1. Unavailable for current context c. Toggle Menu
2. Not much required menu d. Over Used Menu

Answer A. :Gray colored menu or dimmed menu indicate that they are inactive and not available in current context.

321: Which view in MS-Word can't display graphics?
a. Normal View b. Page Layout View c. Print Preview d. None of these

322: If you need to edit header or footer of a document which menu should you access?
a. Insert b. Edit c. View d. Tools

323: Which menu should you access to create new footnotes?
a. Insert b. Edit c. View d. Tools

324: Text in a cell of a table in Word needed to be printed vertical, how can you perform this?
a. Click the free rotate button on drawing toolbar and rotate it to make vertical.
b. Select Flip Vertical from Draw Menu. c. Choose Text Direction from Format Menu
d. None of these

325: Background color or picture applied from Format >> Background is not printed
a. True b. False

326: Using View option you can perform editing functions such as cut, copy, paste, find and replace etc
a. True b. False

327: Using the Edit option you can switch over from Normal mode to Out line mode
a. True b. False

328: Using Insert menu you can insert various objects such as page numbers, footnotes, picture frames etc
a. True b. False

329: Using Tools menu you can access to various utilities of word such as spell check, macros and mail merge etc
a. True b. False

330: Window menu allows you to work with two documents simultaneously
a. True b. False