MC WORD XL QUIZ.

Microsoft Word Practice Quiz
Set 01

1. Which of the following is not valid version of MS Office?

 A) Office XP

 B) Office Vista

 C) Office 2007

 D) None of above

2. You cannot close MS Word application by

 A) Choosing File menu then Exit submenu

 B) Press Alt+F4

 C) Click X button on title bar

 D) From File menu choose Close submenu

3. The key F12 opens a

 A) Save As dialog box

 B) Open dialog box

 C) Save dialog box

 D) Close dialog box

4. What is the short cut key to open the Open dialog box?

 A) F12

 B) Shift F12

 C) Alt + F12

 D) Ctrl + F12

5. A feature of MS Word that saves the document automatically after certain interval is available on

 A) Save tab on Options dialog box

 B) Save As dialog box

 C) Both of above

 D) None of above

6. Where can you find the horizontal split bar on MS Word screen?

 A) On the left of horizontal scroll bar

 B) On the right of horizontal scroll bar

 C) On the top of vertical scroll bar

 D) On the bottom of vertical scroll bar

7. Which of the following is not available on the Ruler of MS Word screen?

 A) Tab stop box

 B) Left Indent

 C) Right Indent

 D) Center Indent

 E) All of them are available on ruler

8. What is place to the left of horizontal scroll bar?

 A) Tab stop buttons

 B) View buttons

 C) Split buttons

 D) Indicators

 E) None of above

9. Which file starts MS Word?

 A) Winword.exe

 B) Word.exe

 C) Msword.exe

 D) Word2003.exe

10. How many ways you can save a document?

 A) 3

 B) 4

 C) 5

 D) 6

11. If you want to keep track of different editions of a document which features will you use?

 A) Editions

 B) Versions

 C) Track Change

 D) All of above

12. Background color or effects applied on a document is not visible in

 A) Web layout view

 B) Print Layout view

 C) Reading View

 D) Print Preview

13. What is a portion of a document in which you set certain page formatting options?

 A) Page

 B) Document

 C) Section

 D) Page Setup

14. Borders can be applied to

 A) Cells

 B) Paragraph

 C) Text

 D) All of above

15. Which of the following is not a type of page margin?

 A) Left

 B) Right

 C) Center

 D) Top

16. What is the default left margin in Word 2003 document?

 A) 1"

 B) 1.25"

 C) 1.5"

 D) 2"

17. What is gutter margin?

 A) Margin that is added to the left margin when printing

 B) Margin that is added to right margin when printing

 C) Margin that is added to the binding side of page when printing

 D) Margin that is added to the outside of the page when printing

18. Portrait and Landscape are

 A) Page Orientation

 B) Paper Size

 C) Page Layout

 D) All of above

19. If you need to change the typeface of a document, which menu will you choose?

 A) Edit

 B) View

 C) Format

 D) Tools

20. Which of the following is not a font style?

 A) Bold

 B) Italics

 C) Regular

 D) Superscript

Answers

1-B, 2-D, 3-A, 4-D, 5-A, 6-C, 7-D, 8-B, 9-A, 10-A, 11-B, 12-D, 13-C, 14-D, 15-C, 16-B, 17-C, 18-A, 19-C, 20-D,

Microsoft Word Practice Quiz
Set 02

1. Pressing F8 key for three times selects

 A) A word

 B) A sentence

 C) A paragraph

 D) Entire document

2. What happens if you press Ctrl + Shift + F8?

 A) It activates extended selection

 B) It activates the rectangular selection

 C) It selects the paragraph on which the insertion line is.

 D) None of above

3. How can you disable extended selection mode?

 A) Press F8 again to disable

 B) Press Del to disable

 C) Press Esc to disable

 D) Press Enter to disable

4. What does EXT indicator on status bar of MS Word indicate?

 A) It indicates whether the external text is pasted on document or not

 B) It indicates whether extended add-ons are installed on MS Word or not

 C) It indicates whether Extended Selection mode is turned on or off

 D) None of above

5. What is the maximum number of lines you can set for a drop cap?

 A) 3

 B) 10

 C) 15

 D) 20

6. What is the default number of lines to drop for drop cap?

 A) 3

 B) 10

 C) 15

 D) 20

7. What is the shortcut key you can press to create a copyright symbol?

 A) Alt+Ctrl+C

 B) Alt + C

 C) Ctrl + C

 D) Ctrl + Shift + C

8. How many columns can you insert in a word document in maximum?

 A) 35

 B) 45

 C) 55

 D) 65

9. What is the smallest and largest font size available in Font Size tool on formatting toolbar?

 A) 8 and 72

 B) 8 and 64

 C) 12 and 72

 D) None of above

10. What is the maximum font size you can apply for any character?

 A) 163

 B) 1638

 C) 16038

 D) None of above

11. Which of the following is graphics solution for Word Processors?

 A) Clipart

 B) WordArt

 C) Drop Cap

 D) All of above

12. The keystrokes Ctrl + I is used to

 A) Increase font size

 B) Inserts a line break

 C) Indicate the text should be bold

 D) Applies italic format to selected text

13. A character that is raised and smaller above the baseline is known as

 A) Outlined

 B) Raised

 C) Superscript

 D) Subscript

14. What is the purpose of inserting header and footer in document?

 A) To enhance the overall appearance of the document

 B) To mark the starting and ending of page

 C) To make large document more readable

 D) To allow page headers and footers appear on document when printed

15. Which of the following function key activates the speller?

 A) F5

 B) F7

 C) F9

 D) Shift + F7

16. The minimum number of rows and columns in MS Word document is

 A) 1 and 1

 B) 2 and 1

 C) 2 and 2

 D) None of above

17. Thesaurus tool in MS Word is used for

 A) Spelling suggestions

 B) Grammar options

 C) Synonyms and Antonyms words

 D) All of above

18. Why Drop Caps are used in document?

 A) To drop all the capital letters

 B) To automatically begin each paragraph with capital letter

 C) To begin a paragraph with a large dropped initial capital letter

 D) None of above

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

 A) To add anchors in web page

 B) To mark the ending of a paragraph of document

 C) To quickly jump to specific location in document

 D) To add hyperlinks in webpage

20. A word processor would most likely be used to do

 A) Keep an account of money spent

 B) Do a computer search in media center

 C) Maintain an inventory

 D) Type a biography

Answers

1-B, 2-B, 3-C, 4-C, 5-B, 6-A, 7-A, 8-B, 9-A, 10-B, 11-A, 12-D, 13-C, 14-D, 15-B, 16-A, 17-C, 18-C, 19-C, 20-D,

Microsoft Word Practice Quiz
Set 03

 1. What happens when you click on Insert >> Picture >> Clip Art

 A) It inserts a clipart picture into document

 B) It lets you choose clipart to insert into document

 C) It opens Clip Art taskbar

 D) None of above

2. Which option is not available in Insert Table Autofit behavior?

 A) Fixed Column Width

 B) AutoFit to Contents

 C) Autofit to Window

 D) Autofit to Column

3. To autofit the width of column

 A) Double click the right border of column

 B) Double click the left border of column

 C) Double click the column header

 D) All of above

4. From which menu you can insert Header and Footer?

 A) Insert Menu

 B) View Menu

 C) Format menu

 D) Tools Menu

5. After typing header text, how can you quickly enter footer text?

 A) Press PageDown key and type the text for footer

 B) Click on Switch between Heder & Footer then type the text

 C) Both of above

 D) None of above

6. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that?

 A) From format menu choose bullets and Numbering and configure necessary setting

 B) From Insert menu choose Page Number and specify necessary setting

 C) Click on Page Number Format tool and specify required setting

 D) All of above

7. Which of the following statement is false?

 A) You can set different header footer for even and odd pages

 B) You can set different page number formats for different sections

 C) You can set different header footer for first page of a section

 D) You can set different header and footer for last page of a section

8. Where can you change the vertical alignment?

 A) Formatting toolbar

 B) Paragraph dialog box

 C) Page Setup dialog box

 D) Standard toolbar

9. To get to the ‘Symbol’ dialog box, click on the ______ menu and choose ‘Symbol’.

 A) Insert

 B) Format

 C) Tools

 D) Table

10. Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?

 A) Wingdings

 B) Wingdings 3

 C) Webdings

 D) Symbol

11. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:

 A) unassigned

 B) Located on the ten-key pad section of your keyboard.

 C) Assigned to another task.

 D) From the same font family as the symbol.

12. Suppose you wanted to create an AutoCorrect entry that would type the words ‘We regret to inform you that your submission has been declined’ Of the following choices, which would be the best name you could assign to this entry?

 A) Regret

 B) Subdual

 C) We regret to inform you that your submission has been declined

 D) 11

13. If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:

 A) Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box.

 B) Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect.

 C) AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry.

 D) Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.

14. AutoCorrect was originally designed to replace _________ words as you type.

 A) Short, repetitive

 B) Grammatically incorrect

 C) Misspelled

 D) None of the above

15. Which of the following is the second step in creating a macro?

 A) Start recording

 B) Using your mouse or keyboard, perform the task you want to automate

 C) Assign a keyboard shortcut to the macro

 D) Give the macro a name

16. If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.

 A) Embed Fonts

 B) Embed True Type Fonts

 C) Save True Type Fonts

 D) Save Fonts

17. In Word, the mailing list is known as the ____________.

 A) Data sheet

 B) Source

 C) Data source

 D) Sheet

18. Which of the following is not one of the three ‘Mail Merge Helper’ steps?

 A) Merge the two files

 B) Create the main document

 C) Set the mailing list parameters

 D) Create the data source

19. Which of the following button will allow you to add, delete, or change records in your Data Source?

 A) ‘Data Source’ button

 B) ‘Edit’ button

 C) ‘Edit Data Source’ button

 D) ‘Data editing’ button

20. It is possible to _______ a data source before performing a merge.

 A) Create

 B) Modify

 C) Sort

 D) all of the above

Answers

1-C, 2-D, 3-A, 4-B, 5-B, 6-C, 7-D, 8-C, 9-A, 10-D, 11-A, 12-B, 13-A, 14-C, 15-C, 16-B, 17-C, 18-C, 19-C, 20-D, 

Microsoft Word Practice Quiz
Set 04

1. What is the default font size of a new Word document based on Normal template?

 A) 10 pt

 B) 12 pt

 C) 14 pt

 D) None of above

2. What is the default font used in MS Word document?

 A) Times New Roman

 B) Arial

 C) Algerian

 D) Preeti

3. Which tab in Font dialog box contains options to apply font effects?

 A) Font tab

 B) Character Spacing

 C) Text Effects

 D) Standard Toolbar

4. If you need to double underline a word, how will you do that?

 A) Go to Format menu and then Font option. Open Underline Style and choose Double Underline

 B) From Format menu choose Font option and then from Font tab open Underline Style and select Double Underline

 C) Select the text then choose Format >> Font and on Font tab open Underline Style and choose Double Underline

 D) Click double underline tool on formatting toolbar

5. DropCap means

 A) All Caps

 B) Small Caps

 C) Title case

 D) None of above

6. What is the short cut key to open Font dialog box?

 A) Ctrl + F

 B) Alt + Ctrl + F

 C) Ctrl + D

 D) Ctrl + Shift + D

7. How can you access the font size tool on formatting toolbar?

 A) Ctrl + S

 B) Ctrl + Shift + S

 C) Ctrl + P

 D) Ctrl + Shift + P

8. How can you make the selected character superscripted?

 A) Ctrl + =

 B) Ctrl + Shift + =

 C) Alt + Ctrl + Shift + =

 D) None of above

9. What does Ctrl + = key effect?

 A) Superscript

 B) Subscript

 C) All Caps

 D) Shadow

10. What happens if you mark on Hidden check box of Font dialog box after you select some text?

 A) The text is deleted from document and you need to bring from Recycle Bin if required again.

 B) The text is hidden and you need to bring it by removing the check box if needed again

 C) The text is deleted and cannot be returned back

 D) The text is hidden and cannot be returned back

11. How can you increase the font size of selected text by one point every time?

 A) By pressing Ctrl + ]

 B) By pressing Ctrl + [

 C) By pressing Ctrl + }

 D) By pressing Ctrl + {

12. Which of the following line spacing is invalid?

 A) Single

 B) Double

 C) Triple

 D) Multiple

13. How can you apply exactly the same formatting you did to another text?

 A) Copy the text and paste in new location. Then type the new text again.

 B) Copy the text and click on Paste Special tool on new place

 C) Select the text then click on Format Painter and select the new text

 D) All of above

14. What should you do if you require pasting the same format in many places?

 A) Click the Format painter and go on pasting in many places holding Alt Key

 B) Double click the format painter then go on pasting in many places

 C) Click the format painter then go on pasting to many places holding Ctrl Key

 D) All of above

15. On which toolbar can you find Format Painter tool?

 A) Standard toolbar

 B) Formatting toolbar

 C) Drawing Toolbar

 D) Picture Toolbar

16. Which indent marker controls all the lines except first line?

 A) First Line Indent Marker

 B) Left Indent Marker

 C) Hanging Indent Marker

 D) Right Indent Marker

17. How can you remove tab stop markers from ruler?

 A) Double click the tab marker and choose Clear All

 B) Drag the tab stop marker out of the ruler

 C) Right click the tab stop marker and choose remove

 D) All of above

18. Which operation you will perform if you need to move a block of text?

 A) Copy and Paste

 B) Cut and Paste

 C) Paste and Delete

 D) Paste and Cut

19. What is the extension of Word files?

 A) FIL

 B) DOT

 C) DOC

 D) TXT

20. Which of the following option is not available in Insert >> Picture?

 A) Chart

 B) Word Art

 C) Clip Art

 D) Graph

Answers

1-B, 2-A, 3-A, 4-C, 5-D, 6-C, 7-D, 8-B, 9-B, 10-B, 11-A, 12-C, 13-C, 14-B, 15-A, 16-B, 17-B, 18-B, 19-C, 20-D,

Microsoft Word Practice Quiz
Set 05

1. To insert a drop cap in one of the paragraph you should access

 A) Insert Menu

 B) Format

 C) Tools

 D) None of above

2. How many different positions can you set for drop cap?

 A) 1

 B) 2

 C) 4

 D) 6

3. What is the maximum number of lines you can set for lines to drop box?

 A) 3

 B) 5

 C) 10

 D) 15

4. Which of the following can NOT be used to create parallel style column?

 A) Format Tabs

 B) Table Insert Table

 C) Insert Textbox

 D) Format Columns

5. Which of the following is used to create newspaper style columns?

 A) Format Tabs

 B) Table Insert Table

 C) Insert Textbox

 D) Format Columns

6. Columns dialog box can be opened from

 A) Format menu Columns submenu

 B) Double click on column space in ruler

 C) Press Alt + O + C

 D) All of above

7. You can jump to the next column by

 A) Clicking with your mouse on the next column

 B) Press Alt + Down-arrow

 C) Both of above

 D) None of Above

8. How can you break the current column and start a new column immediately?

 A) Press Ctrl + Shift + Enter

 B) Press Alt + Enter

 C) Press Ctrl + Enter

 D) Press Alt + Shift + Enter

9. What is the smallest width of a column?

 A) 0"

 B) 0.5"

 C) 1"

 D) 1.5"

10. If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?

 A) in the left margin

 B) in the right margin

 C) both in left and right margin

 D) None of Above

11. The other Col# are inactive when you’ve select 3 columns. How will you activate those boxes?

 A) double click on spacing box

 B) double click on inactive Col#

 C) Remove mark from Line between checkbox

 D) Remove mark from Equal Column Width check box

12. How much space in minimum must be provided between columns?

 A) 0"

 B) 0.5"

 C) 1"

 D) 1.5"

13. To open Columns dialog box quickly

 A) double click on the left margin area of ruler

 B) double click the space between area on ruler

 C) double click the right margin in ruler

 D) All of above

14. Which of the following command is not available in Tools menu?

 A) Auto text

 B) Autocorrect

 C) Auto summarize

 D) Macro

15. To move the cursor page to page of document

 A) Ctrl+PgDn

 B) Ctrl+PgUp

 C) Both of above

 D) None of above

16. Text boundary can be displayed or hidden from

 A) Auto text option from Insert menu

 B) Options from Tools menu

 C) Customize from Tools menu

 D) All of above

17. Which of the following are word processing software?

 A) WordPerfect

 B) Easy Word

 C) MS Word

 D) All of above

18. MS Office provides help in many ways, which of these is one of them?

 A) What is this?

 B) Office Assistant

 C) Help menu

 D) All of the above

19. You wished to justify text over the height of paper, which option will you choose

 A) Page Setup from File menu

 B) Paragraph from Format menu

 C) From formatting toolbar

 D) Font from Format menu

20. Which of the following is not of the merge process?

 A) Sort the data source records

 B) Format a main document

 C) Edit a data source

 D) Merge the two files to print or create a new document

Answers

1-B, 2-B, 3-C, 4-D, 5-D, 6-D, 7-C, 8-A, 9-B, 10-D, 11-D, 12-A, 13-B, 14-A, 15-C, 16-B, 17-D, 18-D, 19-A, 20-A,

Microsoft Word Practice Quiz
Set 05

1. There can be many ways to insert page number in a document. Which of the following lets you insert page number

 A) Page number from Insert menu

 B) Page Setup from file menu

 C) Footnote from Insert menu

 D) Both a & c

2. Which is not a data source component?

 A) mail merge toolbar

 B) header row

 C) data fields

 D) data records

3. Which of the following is not the part of standard office suite?

 A) Word Processor

 B) Database

 C) Image Editor

 D) File manager

4. Where can you find the Draw Table tool button?

 A) Standard toolbar

 B) Formatting toolbar

 C) Drawing toolbar

 D) Tables and Formatting toolbar

5. Which of the following option in File pull down menu is used to close a MS Word document?

 A) Quit

 B) Close

 C) Exit

 D) New

6. You need to jump to the next column breaking current column right at the cursor position. How can you break column?

 A) Pressing Ctrl+Enter

 B) Pressing Alt+Shift+Enter

 C) Break command from Insert menu

 D) Both b and c

7. Superscript, subscript, outline, emboss, engrave are known as

 A) font styles

 B) font effects

 C) word art

 D) text effects

8. Shimmer, Sparkle text, Blinking Background etc. are known as

 A) font styles

 B) font effects

 C) word art

 D) text effects

9. The feature of Word that automatically adjusts the amount of space between certain combination of characters so that an entire word looks more evenly spaced. What is that feature called?

 A) Spacing

 B) Scaling

 C) Kerning

 D) Positioning

10. Which of the following is not available in Font Spacing?

 A) Normal

 B) Loosely

 C) Condensed

 D) Expanded

11. Which of the following position is not available for fonts on MS Word?

 A) Normal

 B) Raised

 C) Lowered

 D) Centered

12. What is the maximum scale percentage available in Scale drop down box?

 A) 500

 B) 200

 C) 100

 D) 90

13. Bold, Italic, Regular are known as

 A) font styles

 B) font effects

 C) word art

 D) text effects

14. Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What’s the difference between the two?

 A) Both are same. They are only two different ways of capitalize text.

 B) It is faster to convert from Change Case than from Font dialog box

 C) Change Case makes conversion permanent but All Caps on Font can always be reverted

 D) All Caps on Font dialog box makes the change permanent where Change Case can be always reverted

15. If you need to hide some paragraphs, how can you do it?

 A) From Paragraph dialog box

 B) From Font dialog box

 C) From Options Dialog box

 D) None of above

16. Which of the following is the latest version of MS Word?

 A) Word 2000

 B) Word 2007

 C) Word 2010

 D) Word 2011

17. Changing the appearance of a document is called

 A) Proofing

 B) Editing

 C) Formatting

 D) All of above

18. In a document what is the maximum number of columns that can be inserted in MS Word Table?

 A) 35

 B) 15

 C) 63

 D) 65

19. You can detect spelling and grammar errors by

 A) Press Shift + F7

 B) Press Ctrl + F7

 C) Press Alt+ F7

 D) Press F7

20. A screen element of MS Word that is usually located below the title bar that provides categorized options is

 A) Menu mar

 B) Tool Bar

 C) Status Bar

 D) All of the above

Answers

1-A, 2-A, 3-D, 4-D, 5-B, 6-C, 7-B, 8-D, 9-C, 10-B, 11-D, 12-B, 13-A, 14-C, 15-B, 16-C, 17-C, 18-C, 19-D, 20-A,

  

MS Excel MCQ Quiz Set 1

1. You can use the formula pallette to


 A) format cells containing numbers
 B) create and edit formula containing functions
 C) enter assumptions data
 D) copy a range of cells




2. When a range is selected, how can you activate the previous cell?


 A) Press the Alt key
 B) Press Tab
 C) Press Enter
 D) None of above




3. Which tool you will use to join some cells and place the content at the middle of joined cell?


 A) From Format Cells dialog box click on Merge Cells check box
 B) From Format Cells dialog box select the Centered alignment
 C) From Format Cells dialog box choose Merge and Center check box
 D) Click on Merge and Center tool on formatting toolbar




4. Tab scroll buttons are place on Excel screen


 A) towards the bottom right corner
 B) towards the bottom left corner
 C) towards the top right corner
 D) towards the top left corner




5. The Name box on to the left of formula bar


 A) shows the name of workbook currently working on
 B) shows the name of worksheet currently working on
 C) shows the name of cell or range currently working on
 D) None of above




6. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?


 A) work sheet
 B) chart sheet
 C) module sheet
 D) data sheet




7. Which of the following is not the correct method of editing the cell content?


 A) Press the Alt key
 B) Press the F2 key
 C) Click the formula bar
 D) Double click the cell




8. You can merge the main document with data source in Excel. In mail merge operation, Word is usually


 A) server
 B) source
 C) client
 D) none




9. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?


 A) F8
 B) F9
 C) F10
 D) F11




10. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?


 A) Custom List
 B) Auto Fill Options
 C) Fill Across Worksheet
 D) Fill Series




11. Where can you change automatic or manual calculation mode in Excel?


 A) Double CAL indicator on status bar
 B) Go to Tools >> Options >> Calculation and mark the corresponding radio button
 C) Both of above
 D) None of above




12. How can you show or hide the gridlines in Excel Worksheet?


 A) Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
 B) Click Gridline tool on Forms toolbar
 C) Both of above
 D) None of above




13. Which of the following Excel screen components can NOT be turned on or off?


 A) Formula Bar
 B) Status Bar
 C) Tool Bar
 D) None of above




14. What happens when you press Ctrl + X after selecting some cells in Excel?


 A) The cell content of selected cells disappear from cell and stored in clipboard
 B) The cells selected are marked for cutting
 C) The selected cells are deleted and the cells are shifted left
 D) The selected cells are deleted and cells are shifted up




15. Which of the following option is not available in Paste Special dialog box?


 A) Add
 B) Subtract
 C) Divide
 D) SQRT




16. Which command will you choose to convert a column of data into row?


 A) Cut and Paste
 B) Edit >> Paste Special >> Transpose
 C) Both of above
 D) None of above




17. It is acceptable to let long text flow into adjacent cells on a worksheet when


 A) data will be entered in the adjecent cells
 B) no data will be entered in the adjacent cells
 C) there is no suitable abbrevition for the text
 D) there is not time to format the text




18. Which of the cell pointer indicates you that you can make selection?


 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above




19. Which of the cell pointer indicates that you can fill series?


 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above




20. Which of the cell pointer indicate that you can move the content to other cell?


 A) Doctor’s symbol (Big Plus)
 B) small thin plus icon
 C) Mouse Pointer with anchor at the tip
 D) None of above




Answers

1-B, 2-D, 3-D, 4-B, 5-C, 6-D, 7-A, 8-C, 9-B, 10-A, 11-B, 12-C, 13-D, 14-B, 15-D, 16-B, 17-B, 18-A, 19-B, 20-C,


  

MS Excel MCQ Quiz Set 2

 1. You can auto fit the width of column by

 A) double clicking on the column name on column header
 B) Double click on the cell pointer in worksheet
 C) Double clicking on column right border on column header
 D) Double clicking on the column left border of column header




2. Long text can be broken down into many lines within a cell. You can do this through


 A) Wrap Text in Format >> Cells
 B) Justify in Edit >> Cells
 C) Text Wraping in Format >> Cells, Layout tab
 D) All of above




3. MS Excel provides the default value for step in Fill Series dialog box


 A) 0
 B) 1
 C) 5
 D) 10




4. When a row of data is to be converted into columns


 A) Copy the cells in row, select the same number of cells in row and paste
 B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
 C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
 D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.




5. Ctrl + D shortcut key in Excel will


 A) Open the font dialog box
 B) Apply double underline for the active cell
 C) Fill down in the selection
 D) None of above




6. The short cut key Ctrl + R is used in Excel to


 A) Right align the content of cell
 B) Remove the cell contents of selected cells
 C) Fill the selection with active cells to the right
 D) None of above




7. The command Edit >> Fill Across Worksheet is active only when


 A) One sheet is selected
 B) When many sheets are selected
 C) When no sheet is selected
 D) None of above




8. Which of the following series type is not valid for Fill Series dialog box?


 A) Linear
 B) Growth
 C) Autofill
 D) Time




9. Which of the following you can paste selectively using Paste Special command?


 A) Validation
 B) Formats
 C) Formulas
 D) All of above




10. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?


 A) Square
 B) Percentage
 C) Goal Seek
 D) Divide




11. Edit >> Delete command


 A) Deletes the content of a cell
 B) Deletes Formats of cell
 C) Deletes the comment of cell
 D) Deletes selected cells




12. To remove the content of selected cells you must issue ______ command


 A) Edit >> Delete
 B) Edit >> Clear >> Contents
 C) Edit >> Clear >> All
 D) Data >> Delete




13. The Delete key of keyboard is assigned to which command in Excel?


 A) Edit >> Clear >> Contents
 B) Edit >> Clear >> All
 C) Edit >> Delete
 D) All of above




14. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must


 A) From Edit menu choose Clear and then Formats
 B) From Edit menu choose Delete
 C) Click on Remove Formatting tool on Standard Toolbar
 D) Double click the Format Painter and then press Esc key in keyboard




15. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?


 A) Right click on Sheet Tab of third sheet and choose Delete from the context menu
 B) Click on Sheet 3 and from Edit menu choose Delete
 C) Both of above
 D) None of above




16. Which of the following action removes a sheet from workbook?


 A) Select the sheet, then choose Edit >> Delete Sheet
 B) Select the sheet then choose Format >> Sheet >> Hide
 C) Both of above
 D) None of above




17. While Finding and Replacing some data in Excel, which of the following statement is valid?


 A) You can Find and Replace within the sheet or workbook
 B) Excel does not have option to match case for find
 C) Both are valid
 D) None are valid




18. Which of the following is not true about Find and Replace in Excel


 A) You can search for bold and replace with italics
 B) You can decide whether to look for the whole word or not
 C) You can search in formula too
 D) You can search by rows or columns or sheets




19. You can move a sheet from one workbook into new book by


 A) From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
 B) From Edit menu choose Move of Copy then choose (Move to end) and click OK
 C) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
 D) None of above




20. What is the short cut key to replace a data with another in sheet?


 A) Ctrl + R
 B) Ctrl + Shift + R
 C) Ctrl + H
 D) Ctrl + F




Answers

1-C, 2-A, 3-B, 4-D, 5-C, 6-C, 7-B, 8-D, 9-D, 10-D, 11-D, 12-B, 13-A, 14-A, 15-A, 16-A, 17-A, 18-D, 19-C, 20-C,


  

MS Excel MCQ Quiz Set 4

1. Which of the following is invalid regarding the Protection in Excel?


 A) Protect Sheet
 B) Protect Workbook
 C) Protect Workspace
 D) All of above are valid




2. The Trace Precedence on Auditing shows


 A) Which cells are used in current formula
 B) In which formula the current cell is used
 C) Which cells are used in this formula and in which formula this cell is used
 D) None of above




3. The Trace Dependence in auditing shows


 A) Which cells are used in current formula
 B) In which formula the current cell is used
 C) Which cells are used in this formula and in which formula this cell is used
 D) None of above




4. The arrows created by Auditing can be removed by


 A) Click on the arrow and press Delete
 B) Click on Remove All arrows on Formula Auditing toolbar
 C) Both of above
 D) None of above




5. Which of the following options is not available to remove arrows of Formula Auditing?


 A) Remove all precedent arrows
 B) Remove all dependent arrows
 C) Remove all arrows
 D) Remove all arrows for this cell




6. Excel is a good application for What IF analysis. Which of the following tool help you for this?


 A) Formul Auditing
 B) Research
 C) Track Change
 D) Goal Seek




7. Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?


 A) Formul Auditing
 B) Research
 C) Track Change
 D) Goal Seek




8. To apply Goal Seek command your cell pointer must be in


 A) The Changing cell whose value you need to find
 B) The Result Cell where formula is entered
 C) The cell where your targeted value is entered
 D) None of above




9. Which of the following is not What IF analysis tool in Excel?


 A) Goal Seek
 B) Scenarios
 C) Macros
 D) None of above




10. You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?


 A) F9
 B) F5
 C) F8
 D) F11




11. By default the cell pointer moves down when you press Enter. From where can you change this setting?


 A) Tools >> Options >> View tab
 B) Tools >> Options >> Calculation tab
 C) Tools >> Options >> Edit tab
 D) Tools >> Options >> Transition tab




12. When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as


 A) AutoFill
 B) AutoCorrect
 C) AutoComplete
 D) AutoFormat




13. How many recent files you can display on File menu at maximum?


 A) 4
 B) 6
 C) 9
 D) 12




14. The default and maxium number of sheets for a new workbook in Excel 2003 is


 A) 3 and 255
 B) 3 and 256
 C) 1 and 255
 D) 1 and 256




15. When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?


 A) AutoComplete
 B) AutoFormat
 C) Custom List
 D) Calculation Automatic




16. The minimum and maximum value you can set for Save AutoRecovery Info in Excel are


 A) 1 and 120 minutes
 B) 0 and 120 minutes
 C) 2 and 60 minutes
 D) 1 and 10 minutes




17. Which of the following can not be hidden from Tools >> Options then View tab?


 A) Startup Task Pane
 B) Formula bar
 C) Status bar
 D) Scroll Bar




18. What happens if you remove the check mark from Row & Column headers on Options dialog box?


 A) This will remove row headings and column headings of your data
 B) This will remove the column headings (A, B, C,
 C) This will remove row and column heading of chart
 D) This will remove row and column heading of table




19. The default font size in Excel worksheet is


 A) 10 points
 B) 12 points
 C) 14 points
 D) None of above




20. The default font used in Excel is


 A) Arial
 B) Algerial
 C) Times New Roman
 D) Preeti




Answers

1-C, 2-A, 3-B, 4-B, 5-D, 6-D, 7-D, 8-B, 9-C, 10-A, 11-C, 12-C, 13-C, 14-B, 15-C, 16-A, 17-D, 18-B, 19-A, 20-A,

81. Hyperlinks can be

a. Text

b. Drawing objects

c. Pictures

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

82. To activate the previous cell in a pre-selected range, press

a. The Alt key

b. The Tab key

c. The Enter key

d. None of the above

Correct Answer: d

Collection on http://www.psexam.com

83. Which button do yu click to add up a series of numbers?

a. The autosum button

b. The Formula button

c. The quicktotal button

d. The total button

Correct Answer: a

Collection on http://www.psexam.com

84. When the formula bar is active, you can see

a. The edit formula button

b. The cancel button

c. The enter button

d. All of the above

Correct Answer: d

Collection on http://www.psexam.com

85. To copy formatting from one area in a worksheet and apply it to another area you would use:

a. The Edit>Copy Format and Edit>Paste Format commands form the menu.

b. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.

c. There is no way to copy and apply formatting in Excel – You have to do it manually

d. The Format Painter button on the standard toolbar

Correct Answer: d

Collection on http://www.psexam.com

86. In a worksheet you can select

a. The entire worksheet

b. Rows

c. Columns

d. All of the above

Correct Answer: b

Collection on http://www.psexam.com

87. When you link data maintained in an excel workbook to a word document

a. The word document can not be edit

b. The word document contains a reference to the original source application

c. The word document must contain a hyperlink

d. The word document contains a copy of the actual data

Correct Answer: b

Collection on http://www.psexam.com

88. Which area in an excel window allows entering values and formulas

a. Title bar

b. Menu bar

c. Formula bar

d. Standard toolbar

Correct Answer: c

Collection on http://www.psexam.com

89. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

a. Unfreeze panes command on the window menu

b. Freeze panes command on the window menu

c. Hold titles command on the edit menu

d. Split command on the window menu

Correct Answer: b

Collection on http://www.psexam.com

90. To edit in an embedded excel worksheet object in a word document

a. Use the excel menu bar and toolbars inside the word application

b. Edit the hyperlink

c. Edit the data in a excel source application

d. Use the word menu bar and toolbars

Correct Answer: a

Collection on http://www.psexam.com

91. To create a formula, you can use:

a. Values but not cell references

b. C ell references but not values

c. Values or cell references although not both at the same time

d. Value and cell references

Correct Answer: d

Collection on http://www.psexam.com

92. Status indicators are located on the

a. Vertical scroll bar

b. Horizontal scroll bar

c. Formula bar

d. Standard toolbar

Correct Answer: c

Collection on http://www.psexam.com

93. Which of the following is the oldest spreadsheet package?

a. VisiCalc

b. Lotus 1-2-3

c. Excel

d. StarCalc

Correct Answer: a

Collection on http://www.psexam.com

94. Rounding errors can occur

a. When you use multiplication, division, or exponentiation in a formula

b. When you use addition and subtraction in a formula

c. Because excel uses hidden decimal places in computation

d. When you show the results of formulas with different decimal places that the calculated results

Correct Answer: a

Collection on http://www.psexam.com

95. You can copy data or formulas

a. With the copy, paste and cut commands on the edit menu

b. With commands on ta shortcut menu

c. With buttons on the standard toolbars

d. All of the above

Correct Answer: d

Collection on http://www.psexam.com

96. You can not link excel worksheet data to a word document

a. With the right drag method

b. With a hyperlink

c. With the copy and paste special commands

d. With the copy and paste buttons on the standard toolbar.

Correct Answer: d

Collection on http://www.psexam.com

97. Which of the following is a popular DOS based spreadsheet package?

a. Word

b. Smart cell

c. Excel

d. Lotus 1-2-3

Correct Answer: d

Collection on http://www.psexam.com

98. An excel workbook is a collection of

a. Workbooks

b. Worksheets

c. Charts

d. Worksheets and charts

Correct Answer: d

Collection on http://www.psexam.com

99. Excel files have a default extension of

a. Xls

b. Xlw

c. Wk1

d. 123

Correct Answer: a

Collection on http://www.psexam.com

100. You can use the format painter multiple times before you turn it off by

a. You can use the format painter button on ly one time when you click it

b. Double clicking the format painter button

c. Pressing the Ctrl key and clicking the format painter button

d. Pressing the Alt key and clicking the format painter button

Correct Answer: b

61. Which of the following methods can not be used to enter data in a cell

a. Pressing an arrow key

b. Pressing the Tab key

c. Pressing the Esc key

d. Clicking on the formula bar

Correct Answer: c

Collection on http://www.psexam.com

62. Which of the following will not cut information?

a. Pressing Ctrl + C

b. Selecting Edit>Cut from the menu

c. Clicking the Cut button on the standard

d. Pressing Ctrl+X

Correct Answer: a

Collection on http://www.psexam.com

63. Which of the following is not a way to complete a cell entry?

a. Pressing enter

b. Pressing any arrow key on the keyboard

c. Clicking the Enter button on the Formula bar

d. Pressing spacebar

Correct Answer: d

Collection on http://www.psexam.com

64. You can activate a cell by

a. Pressing the Tab key

b. Clicking the cell

c. Pressing an arrow key

d. All of the above

Correct Answer: d

Collection on http://www.psexam.com

65. Text formulas:

a. Replace cell references

b. Return ASCII values of characters

c. Concatenate and manipulate text

d. Show formula error value

Correct Answer: c

Collection on http://www.psexam.com

66. How do you insert a row?

a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b. Select the row heading where you want to insert the new row and select Edit >Row from the menu

c. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d. All of the above

Correct Answer: a

Collection on http://www.psexam.com

67. Which of the following is not a basic step in creating a worksheet?

a. Save workbook

b. Modifiy the worksheet

c. Enter text and data

d. Copy the worksheet

Correct Answer: d

Collection on http://www.psexam.com

68. How do you select an entire column?

a. Select Edit > Select > Column from the menu

b. Click the column heading letter

c. Hold down the shift key as you click anywhere in the column.

d. Hold down the Ctrl key as you click anywhere in the column

Correct Answer: b

Collection on http://www.psexam.com

69. How can you print three copies of a workbook?

a. Select File>Properties form the menu and type 3 in the Copies to print text box.

b. Select File >Print from the menu and type 3 in the Number of copies text box.

c. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

d. Press Ctrl+P+3

Correct Answer: b

Collection on http://www.psexam.com

70. To create a formula, you first:

a. Select the cell you want to place the formula into

b. Type the equals sign (=) to tell Excel that you’re about to enter a formula

c. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d. Choose the new command from the file menu

Correct Answer: a

Collection on http://www.psexam.com

71. To center worksheet titles across a range of cells, you must

a. Select the cells containing the title text plus the range over which the title text is to be centered

b. Widen the columns

c. Select the cells containing the title text plus the range over which the title text is to be enfettered

d. Format the cells with the comma style

Correct Answer: a

Collection on http://www.psexam.com

72. How do you delete a column?

a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b. Select the column heading you want to delete and select Insert Delete from the menu

c. Select the row heading you want to delete and select Edit>Delete from the menu

d. Right click the column heading you want to delet and select delete from the shortcut menu

Correct Answer: d

Collection on http://www.psexam.com

73. How can you find specific information in a list?

a. Select Tools > Finder from the menu

b. Click the Find button on the standard toolbar

c. Select Insert > Find from the menu

d. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Correct Answer: d

Collection on http://www.psexam.com

74. When integrating word and excel, word is usually the

a. Server

b. Destination

c. Client

d. Both b and c

Correct Answer: d

Collection on http://www.psexam.com

75. When a label is too long to fit within a worksheet cell, you typically must

a. Shorten the label

b. Increase the column width

c. Decrease the column width

d. Adjust the row height

Correct Answer: b

Collection on http://www.psexam.com

76. The name box

a. Shows the location of the previously active cell

b. Appears to the left of the formula bar

c. Appears below the status bar

d. Appears below the menu bar

Correct Answer: b

Collection on http://www.psexam.com

77. Comments put in cells are called

a. Smart tip

b. Cell tip

c. Web tip

d. Soft tip

Correct Answer: b

Collection on http://www.psexam.com

78. Which is used to perform what if analysis?

a. Solver

b. Goal seek

c. Scenario Manager

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

79. You can use the horizontal and vertical scroll bars to

a. Split a worksheet into two panes

b. View different rows and columns edit the contents of a cell

c. Edit the contents of a cell

d. view different worksheets

Correct Answer: b

Collection on http://www.psexam.com

80. Multiple calculations can be made in a single formula using

a. standard formulas

b. array formula

c. complex formulas

d. smart formula

Correct Answer: b

41. You can use the formula palette to

a. Format cells containing numbers

b. Create and edit formulas containing functions

c. Enter assumptions data

d. Copy a range of cells

Correct Answer: b

Collection on http://www.psexam.com

42. You can convert existing excel worksheet data an charts to an HTML document by using

a. FTP wizard

b. Internet assistant wizard

c. Intranet wizard

d. Import wizard

Correct Answer: b

Collection on http://www.psexam.com

43. A circular reference is

a. Geometric modeling tool

b. A cell that points to a drawing object

c. A formula that either directly or indirectly depends on itself

d. Always erroneous

Correct Answer: c

Collection on http://www.psexam.com

44. Which of following is Not one of Excel’s what-if function?

a. Goal seek

b. Solver

c. Scenario manager

d. Auto Outline

Correct Answer: d

Collection on http://www.psexam.com

45. When you insert an excel file into a word document. The data are

a. Hyperlinked placed in a word table

b. Linked

c. Embedded

d. Use the word menu bar and toolbars

Correct Answer: b

Collection on http://www.psexam.com

46. Which of the following is not information you can specify using the solver?

a. Input cells

b. Constraints

c. Target cell

d. Changing cells

Correct Answer: a

Collection on http://www.psexam.com

47. Each excel file is called a workbook because

a. It can contain text and data

b. It can be modified

c. It can contain many sheets including worksheets and chart sheets

d. You have to work hard to create it

Correct Answer: c

Collection on http://www.psexam.com

48. Excel probably considers the cell entry January 1, 2000 to be a

Label

Value

Formula

Text string

Correct Answer: b

Collection on http://www.psexam.com

49. You can enter which types of data into worksheet cells?

a. Labels, values, and formulas

b. Labe3ls and values but not formulas

c. Values and formulas but not labels

d. Formulas only

Correct Answer: a

Collection on http://www.psexam.com

50. All worksheet formula

a. Manipulate values

b. Manipulate labels

c. Return a formula result

d. Use the addition operator

Correct Answer: c

Collection on http://www.psexam.com

51. Which of the following is a correct order of precedence in formula calculation?

a. Multiplication and division exponentiation positive and negative values

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

52. The Paste Special command lets you copy and paste:

a. Multiply the selection by a copied value

b. Cell comments

c. Formatting options

d. The resulting values of a formula instead of the actual formula

Correct Answer: d

Collection on http://www.psexam.com

53. The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. 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 everything and manually add the dollar signs, commas, and decimals.

Correct Answer: c

Collection on http://www.psexam.com

54. Which of the following is not a valid data type in excel

a. Number

b. Character

c. Label

d. Date/time

Correct Answer: b

Collection on http://www.psexam.com

55. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

a. Option buttons

b. List boxes

c. Text boxes

d. Combo boxes

Correct Answer: c

Collection on http://www.psexam.com

56. Which of the following options is not located in the Page Setup dialog box?

a. Page Break Preview.

b. Page Orientation

c. Margins

d. Headers and Footers

Correct Answer: a

Collection on http://www.psexam.com

57. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a. Pie chart

b. Row chart

c. Line chart

d. Column chart

Correct Answer: c

Collection on http://www.psexam.com

58. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

a. Press Ctrl +Home

b. Press Home

c. Press Shift + Home

d. Press Alt + Home

Correct Answer: a

Collection on http://www.psexam.com

59. Which of the following methods can not be used to edit the contents of a cell?

a. Press the Alt key

b. Clicking the formula bar

c. Pressing the F2 key

d. Double clicking the cell

Correct Answer: a

Collection on http://www.psexam.com

60. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

a. Press the Erase key

b. Press Esc

c. Press the Enter button

d. Press the Edit Formula button

Correct Answer: b

61. Which of the following methods can not be used to enter data in a cell

a. Pressing an arrow key

b. Pressing the Tab key

c. Pressing the Esc key

d. Clicking on the formula bar

Correct Answer: c

Collection on http://www.psexam.com

62. Which of the following will not cut information?

a. Pressing Ctrl + C

b. Selecting Edit>Cut from the menu

c. Clicking the Cut button on the standard

d. Pressing Ctrl+X

Correct Answer: a

Collection on http://www.psexam.com

63. Which of the following is not a way to complete a cell entry?

a. Pressing enter

b. Pressing any arrow key on the keyboard

c. Clicking the Enter button on the Formula bar

d. Pressing spacebar

Correct Answer: d

Collection on http://www.psexam.com

64. You can activate a cell by

a. Pressing the Tab key

b. Clicking the cell

c. Pressing an arrow key

d. All of the above

Correct Answer: d

Collection on http://www.psexam.com

65. Text formulas:

a. Replace cell references

b. Return ASCII values of characters

c. Concatenate and manipulate text

d. Show formula error value

Correct Answer: c

Collection on http://www.psexam.com

66. How do you insert a row?

a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

b. Select the row heading where you want to insert the new row and select Edit >Row from the menu

c. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d. All of the above

Correct Answer: a

Collection on http://www.psexam.com

67. Which of the following is not a basic step in creating a worksheet?

a. Save workbook

b. Modifiy the worksheet

c. Enter text and data

d. Copy the worksheet

Correct Answer: d

Collection on http://www.psexam.com

68. How do you select an entire column?

a. Select Edit > Select > Column from the menu

b. Click the column heading letter

c. Hold down the shift key as you click anywhere in the column.

d. Hold down the Ctrl key as you click anywhere in the column

Correct Answer: b

Collection on http://www.psexam.com

69. How can you print three copies of a workbook?

a. Select File>Properties form the menu and type 3 in the Copies to print text box.

b. Select File >Print from the menu and type 3 in the Number of copies text box.

c. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

d. Press Ctrl+P+3

Correct Answer: b

Collection on http://www.psexam.com

70. To create a formula, you first:

a. Select the cell you want to place the formula into

b. Type the equals sign (=) to tell Excel that you’re about to enter a formula

c. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d. Choose the new command from the file menu

Correct Answer: a

Collection on http://www.psexam.com

71. To center worksheet titles across a range of cells, you must

a. Select the cells containing the title text plus the range over which the title text is to be centered

b. Widen the columns

c. Select the cells containing the title text plus the range over which the title text is to be enfettered

d. Format the cells with the comma style

Correct Answer: a

Collection on http://www.psexam.com

72. How do you delete a column?

a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar

b. Select the column heading you want to delete and select Insert Delete from the menu

c. Select the row heading you want to delete and select Edit>Delete from the menu

d. Right click the column heading you want to delet and select delete from the shortcut menu

Correct Answer: d

Collection on http://www.psexam.com

73. How can you find specific information in a list?

a. Select Tools > Finder from the menu

b. Click the Find button on the standard toolbar

c. Select Insert > Find from the menu

d. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Correct Answer: d

Collection on http://www.psexam.com

74. When integrating word and excel, word is usually the

a. Server

b. Destination

c. Client

d. Both b and c

Correct Answer: d

Collection on http://www.psexam.com

75. When a label is too long to fit within a worksheet cell, you typically must

a. Shorten the label

b. Increase the column width

c. Decrease the column width

d. Adjust the row height

Correct Answer: b

Collection on http://www.psexam.com

76. The name box

a. Shows the location of the previously active cell

b. Appears to the left of the formula bar

c. Appears below the status bar

d. Appears below the menu bar

Correct Answer: b

Collection on http://www.psexam.com

77. Comments put in cells are called

a. Smart tip

b. Cell tip

c. Web tip

d. Soft tip

Correct Answer: b

Collection on http://www.psexam.com

78. Which is used to perform what if analysis?

a. Solver

b. Goal seek

c. Scenario Manager

d. All of above

Correct Answer: d

79. You can use the horizontal and vertical scroll bars to

a. Split a worksheet into two panes

b. View different rows and columns edit the contents of a cell

c. Edit the contents of a cell

d. view different worksheets

Correct Answer: b

80. Multiple calculations can be made in a single formula using

a. standard formulas

b. array formula

c. complex formulas

d. smart formula

Correct Answer: b

41. You can use the formula palette to

a. Format cells containing numbers

b. Create and edit formulas containing functions

c. Enter assumptions data

d. Copy a range of cells

Correct Answer: b

Collection on http://www.psexam.com

42. You can convert existing excel worksheet data an charts to an HTML document by using

a. FTP wizard

b. Internet assistant wizard

c. Intranet wizard

d. Import wizard

Correct Answer: b

Collection on http://www.psexam.com

43. A circular reference is

a. Geometric modeling tool

b. A cell that points to a drawing object

c. A formula that either directly or indirectly depends on itself

d. Always erroneous

Correct Answer: c

Collection on http://www.psexam.com

44. Which of following is Not one of Excel’s what-if function?

a. Goal seek

b. Solver

c. Scenario manager

d. Auto Outline

Correct Answer: d

Collection on http://www.psexam.com

45. When you insert an excel file into a word document. The data are

a. Hyperlinked placed in a word table

b. Linked

c. Embedded

d. Use the word menu bar and toolbars

Correct Answer: b

Collection on http://www.psexam.com

46. Which of the following is not information you can specify using the solver?

a. Input cells

b. Constraints

c. Target cell

d. Changing cells

Correct Answer: a

Collection on http://www.psexam.com

47. Each excel file is called a workbook because

a. It can contain text and data

b. It can be modified

c. It can contain many sheets including worksheets and chart sheets

d. You have to work hard to create it

Correct Answer: c

Collection on http://www.psexam.com

48. Excel probably considers the cell entry January 1, 2000 to be a

Label

Value

Formula

Text string

Correct Answer: b

Collection on http://www.psexam.com

49. You can enter which types of data into worksheet cells?

a. Labels, values, and formulas

b. Labe3ls and values but not formulas

c. Values and formulas but not labels

d. Formulas only

Correct Answer: a

Collection on http://www.psexam.com

50. All worksheet formula

a. Manipulate values

b. Manipulate labels

c. Return a formula result

d. Use the addition operator

Correct Answer: c

Collection on http://www.psexam.com

51. Which of the following is a correct order of precedence in formula calculation?

a. Multiplication and division exponentiation positive and negative values

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

52. The Paste Special command lets you copy and paste:

a. Multiply the selection by a copied value

b. Cell comments

c. Formatting options

d. The resulting values of a formula instead of the actual formula

Correct Answer: d

Collection on http://www.psexam.com

53. The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. 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 everything and manually add the dollar signs, commas, and decimals.

Correct Answer: c

Collection on http://www.psexam.com

54. Which of the following is not a valid data type in excel

a. Number

b. Character

c. Label

d. Date/time

Correct Answer: b

Collection on http://www.psexam.com

55. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

a. Option buttons

b. List boxes

c. Text boxes

d. Combo boxes

Correct Answer: c

Collection on http://www.psexam.com

56. Which of the following options is not located in the Page Setup dialog box?

a. Page Break Preview.

b. Page Orientation

c. Margins

d. Headers and Footers

Correct Answer: a

Collection on http://www.psexam.com

57. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a. Pie chart

b. Row chart

c. Line chart

d. Column chart

Correct Answer: c

Collection on http://www.psexam.com

58. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

a. Press Ctrl +Home

b. Press Home

c. Press Shift + Home

d. Press Alt + Home

Correct Answer: a

Collection on http://www.psexam.com

59. Which of the following methods can not be used to edit the contents of a cell?

a. Press the Alt key

b. Clicking the formula bar

c. Pressing the F2 key

d. Double clicking the cell

Correct Answer: a

Collection on http://www.psexam.com

60. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

a. Press the Erase key

b. Press Esc

c. Press the Enter button

d. Press the Edit Formula button

Correct Answer: b

percentage in Excel?

 A) 10
 B) 100
 C) 300
 D) 500


2. The spelling tool is placed on ______ toolbar

 A) Standard
 B) Formatting
 C) Drawing
 D) Reviewing


3. If you need a text to show vertically in a cell. How will you achieve this?

 A) Choose Vertical on Text alignment in Format Cells dialog box
 B) Choose 90 Degrees in Orientation of Format Cells dialog box
 C) Choose Distributed from the Vertical drop down list of Format Cells dialog box
 D) Choose Center Across Selection from Horizontal combo box in Format Cells dialog box


4. Can you set 0.5 inch left indentation for a cell in Excel?

 A) Excel does not have indentation feature
 B) You can specify indentation only if you turn the rulers on
 C) Indentation can be set from Format Cells dialog box
 D) The indentation can be specified only when printing


5. You can automatically adjust the size of text in a cell if they do not fit in width by

 A) Double clicking on the right border of column header
 B) From Format choose Columns and then Autofit Selection
 C) From Format Cells dialog box mark Shrink to fit check box
 D) All of above


6. Formatting a cell in Currency, you can specify

 A) Decimal Places
 B) Currency Symbol
 C) Both of above
 D) None of above


7. Formatting a cell in Number format you can’t set

 A) Decimal Places
 B) Use 1000 separator
 C) Negative numbers
 D) Currency Symbol


8. What is entered by the function =today()

 A) The date value for the day according to system clock
 B) The time value according to system clock
 C) Today’s date as Text format
 D) All of above


9. Which function will you use to enter current time in a woksheet cell?

 A) =today()
 B) =now()
 C) =time()
 D) =currentTime()


10. Special category of Number tab in Format Cells dialog box can be used to apply formats like

 A) Zip Code
 B) Phone Number
 C) Both of above
 D) None of above


11. Merge cells option can be applied from

 A) Format Cells dialog box Alignment Tab
 B) Formatting toolbar
 C) Both of above
 D) None of above


12. Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from

 A) from Fromat >> Cells
 B) from Format >> Autoformat
 C) from Table >> Autoformat
 D) All of above


13. Which of the following format you can decide to apply or not in AutoFormat dialog box?

 A) Number format
 B) Border format
 C) Font format
 D) All of above


14. How can you remove borders applied in cells?

 A) Choose None on Border tab of Format cells
 B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
 C) Both of above
 D) None of above


15. Where can you set the shedding color for a range of cells in Excel?

 A) Choose required color form Patterns tab of Format Cells dialog box
 B) Choose required color on Fill Color tool in Formatting toolbar
 C) Choose required color on Fill Color tool in Drawing toolbar
 D) All of above


16. You can set Page Border in Excel from

 A) From Border tab in Format Cells dialog box
 B) From Border tool in Formatting toolbar
 C) From Line Style tool in Drawing toolbar
 D) You can not set page border in Excel


17. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

 A) Use =if() function to format the required numbers red
 B) Apply Conditional Formatting command on Format menu
 C) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
 D) All of above


18. You can check the conditions against __________ when applying conditional formatting

 A) Cell value
 B) Formula
 C) Both of above
 D) None of above


19. Which of the following is not true regarding Conditional Formatting?

 A) You can add more than one condition to check
 B) You can set condition to look for Bold and apply Italics on them.
 C) You can apply Font, border and pattern formats that meets the specified conditions
 D) You can delete any condition from Conditional Formatting dialog box if it is not requried


20. Which of the following is invalid statement?

 A) Sheet tabs can be colored
 B) Some picture can be applied as a background of a sheet
 C) You can set the column width automatically fit the amount of text
 D) The width of a row and be specified manually or fit automatically


Answers

1-D, 2-A, 3-B, 4-C, 5-C, 6-C, 7-D, 8-A, 9-B, 10-C, 11-A, 12-B, 13-D, 14-C, 15-D, 16-D, 17-B, 18-C, 19-B, 20-D,

1. Which of the following is not an option in the spelling dialog box?

a.   Edit

b.   Ignore

c.   Ignore all

d.   Change

Correct Answer: a

2. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

a.   Edit

b.   View

c.   Format

d.   Tools

Correct Answer: c

3. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

a.   Edit

b.   Format

c.   Tools

d.   Data

Correct Answer: c

4. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

a.   Edit

b.   Insert

c.   Format

d.   Tools

Correct Answer: d

5. Which of the following is not a worksheet design criterion?

a.   Efficiency

b.   Auditability

c.   Description

d.   Clarity    

Correct Answer: c

6. To copy cell contents using drag and drop, press the

a.   End key

b.   Shift key

c.   Esc key

d.   None of above

Correct Answer: d

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

a.   Enter

b.   Ctrl + Enter

c.   TAB

d.   Insert

Correct Answer: a

8. The autofill feature

a.   Extends a sequential series of data

b.   Automatically adds a range of cell values

c.   Applies a boarder around selected cells

d.   None of above

Correct Answer: a

9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

a.   F3

b.   F5

c.   F7

d.   F11

Correct Answer: D

10. you can use the formula palette to

a.   format cells containing numbers

b.   create and edit formulas containing functions

c.   entered assumptions data

d.   copy a range of cells

Correct Answer: b

11. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

a.   Format Report

b.   Pivot Table

c.   Refresh Data

d.   Show Detail

Correct Answer: c

12. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

a.   Formula

b.   Field

c.   Data

d.   Query Correct Answer:  

Correct Answer: A

13. “Qtr 1, Qtr 2, Qtr 3” is an example of a

a.   Formula

b.   Function

c.   Series

d.   Syntax

Correct Answer: c

14. You can edit existing Excel data by pressing the

a.   F1 key

b.   F2 key

c.   F3 key

d.   F4 key

Correct Answer: b 

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

a.   G1-G10

b.   B1.G10

c.   B1;G10

d.   B1:G10

Correct Answer: d

16. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

a.   Go to File-Save As – Save As Type – Excel worksheet

b.   Right click on the spreadsheet tab and select DELETE

c.   Right click on the spreadsheet and select Insert – Entire Column

d.   None of above

Correct Answer: b

17. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

a.   Goal Seek

b.   Scenario Summary report

c.   Forecasting

d.   Trend line

Correct Answer: d

18. what term describes a background that appears as a grainy, non smooth surface

a.   gradient

b.   pattern

c.   solid

d.   texture

Correct Answer: a

19. Excel is a

a.   Graphic program

b.   None of these

c.   Word processor

d.   A spreadsheet

Correct Answer: d

20.    To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

a.   HTML

b.   Pivot Table Field List

c.   Pivot Table List

d.   Pivot Table Report

Correct Answer: d

101.    What function  displays row data in a column or column data in a row?

a.   Hyperlink

b.   Index

c.   Transpose

d.   Rows

Correct Answer: c

102.    When you insert an Excel file into a Word document, the data are

a.   Hyperlinked

b.   Placed in a word table

c.   Linked

d.   Embedded

Correct Answer: b. Placed in a word table

103.    Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

a.   IF

b.   AND

c.   OR

d.   NOT

Correct Answer: a

104.    Macros are “run” or executed from the ….. menu.

a.   Insert

b.   Frmat

c.   Tools

d.   Data

Correct Answer: c

105.    You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

a.   Insert

b.   Format

c.   Tools

d.   Data

Correct Answer: d

106.    Each excel file is called a workbook because

a.   It can contain text and data

b.   It can be modified

c.   It can contain many sheets including worksheets and chart sheets

d.   You have to work hard to create it

Correct Answer: c

107.    Which types of charts can excel produce?

a.   Line graphs and pie charts only

b.   Only line graphs

c.   Bar charts, line graphs and pie charts

d.   Bar charts and line graphs only

Correct Answer: c

108.    How are data organized in a spreadsheet?

a.   Lines and spaces

b.   Layers and planes

c.   Rows and columns

d.   Height and width

Correct Answer: c

109.    What does the VLOOKUP function do?

a.   Looks up text that contain ‘v’

b.   Checks whether text is the same in one cell as in the next

c.   Finds related records

d.   All of above

Correct Answer: c

110.    Gridlines

a.   May be turned off for display but turned on for printing

b.   May be turned on or off for printing

c.   The be turned off for display and printing

d.   a, b and c

Correct Answer: d

Collection of Objective Questions or Multiple Choice Questions (MCQs) distributed throughhttp://www.psexam.com. 

---

  

111.    You can print only an embedded chart by

a.   Moving the chart to a chart sheet before you print.

b.   Formatting the chart before you print

c.   Selecting the chart before you print

d.   a  and c

Correct Answer: d

112.    Which of the following is a correct order of precedence in a formula calculation?

a.   Multiplication and division, exponential positive and negative value

b.   Multiplication and division, positive and negative values, addition and subtraction

c.   Addition and subtraction, positive and negative values, exponentiation

d.   None of above

Correct Answer: d

113.    A function inside another function is called a ….. function.

a.   Nested

b.   Round

c.   Sum

d.   Text

Correct Answer: a

114.    How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

a.   On the file menu, point to print area, and then click set print area.

b.   On the file menu, click print, and then click selection under print what

c.   On the view menu, click custom views, then click add

d.   All of above

Correct Answer: b

115.    Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

a.   On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.

b.   On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

c.   Apply a selected background color

d.   All of above

Correct Answer: b

116.    Which function calculates your monthly mortage payment?

a.   PMT (payments)

b.   NPER (number of periods)

c.   PV (present value)

d.   All of above

Correct Answer: a

117.    If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

a.   Point to speech on the tools menu, and then click show text to speech toolbar.

b.   Click validation on the data menu

c.   Point to speech on the tools menu, and then click speech recognition

d.   All of above

Correct Answer: a

118.    Which of the following methods can not be used to enter data in a cell?

a.   Pressing an arrow key

b.   Pressing the tab key

c.   Pressing the Esc key

d.   Clicking the enter button to the formula bar

Correct Answer:   c.

119.    Which of the following will not set text in selected cells to italics?

a.   Pressing Ctrl + I on the keyboard

b.   Using the Tools – Wizard – Web Form menu item

c.   Using the Format – Cells – Font menu item

d.   None of the above

Correct Answer: b

120.    Which of the following methods cannot be used to edit the content of cell?

a.   Pressing the Alt key

b.   Clicking the formula bar

c.   Pressing F2

d.   Double clicking the cell

Correct Answer: a

141.    To drag a selected range of data to another worksheet in the same workbook, use the

a.   Tab key

b.   Alt key

c.   Shift key

d.   Ctrl key

Correct Answer: d

142.    When creating a vertical page break

a.   The active cell must be A1

b.   The active cell can be anywhere in the worksheet

c.   The active cell must be in row 1

d.   The active cell must be in column A

Correct Answer: c

143.    to activate the previous cell in a pre-selected range, press

a.   the Alt key

b.   the Tab key

c.   the Enter key

d.   none of above

Correct Answer: d

144.    When the formula bar is activated, you can see

a.   The Edit Formula button

b.   The Cancel button

c.   The Enter button

d.   All of above

Correct Answer: d

145.    In a worksheet you can select

a.   The entire worksheet

b.   Rows

c.   Columns

d.   a, b, and c

Correct Answer: d

146.    when you print preview a worksheet

a.   the entire worksheet is displayed

b.   the selected range is displayed

c.   the active portion of the worksheet is displayed

d.   a, b and c

Correct Answer: d

147.    You can group noncontiguous worksheets with

a.   The group button on the standard toolbar

b.   The shift key and the mouse

c.   The ctrl key and mouse

d.   The alt+enter key

Correct Answer: c

148.    Weight refers to

a.   The print density of characters

b.   The height of the printed character

c.   Upright or slanted shape

d.   The design and appearance of characters

Correct Answer: a

149.    When you link data maintained in Excel workbook to a Word document

a.   The Word document cannot be edited

b.   The Word document contains a reference to the original source application

c.   The word document must contain a hyperlink

d.   The word document contains a copy of the actual data

Correct Answer: b. The Word document contains a reference to the original source application

150.    When you see a cell with a red triangle in the top right corner, what does this signify?

a.   There is an error in the cell

b.   There is a comment associated with the cell

c.   The font color for text in the cell is red

d.   A formula cannot be entered into the cell

Correct Answer: b

  Collection of Objective Questions or Multiple Choice Questions (MCQs) distributed through http://www.psexam.com.

---

151.    To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

a.   Unfreeze panes command on the window menu

b.   Freeze panes command on the window menu

c.   Hold titles command on the edit menu

d.   Split command on the window menu

Correct Answer: b

152.    Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

a.   Use Ctrl to select all three cells, then click the paste button on the standard toolbar

b.   Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

c.   Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

d.   All of above

Correct Answer: c

153.    To edit data in an embedded Excel worksheet object in a Word document

a.   Use the Excel menu bar and toolbars inside the word application

b.   Edit the hyperlink

c.   Edit the data in a Excel source application

d.   Use the Word menu bar and toolbars

Correct Answer: a. Use the Excel menu bar and toolbars inside the word application

154.    Status indicators are located on the

a.   Vertical scroll bar

b.   Horizontal scroll bar

c.   Formula bar

d.   Formatting toolbar

Correct Answer: c

155.    You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.

a.   View

b.   Insert

c.   Format

d.   Tools

Correct Answer: d

156.    You can open the Sort dialog box by choosing Sort from the ….. menu

a.   View

b.   Format

c.   Tools

d.   Data

Correct Answer: d

157.    when working in the page break preview, you can

a.   view exactly where each page break occurs

b.   add or remove page breaks

c.   change the print area

d.   all of above

Correct Answer: d

158.    A data map is helpful

a.   When you have too much data to chart

b.   To show a geographic distribution of data

c.   To compare data points

d.   To show changes in data over time

Correct Answer: b

159.    Rounding errors can occur

a.   When you use multiplication, division or exponentiation in a formula

b.   When you use addition and subtraction in a formula

c.   Because Excel uses hidden decimal places in computation

d.   When you show the results of formulas with different decimal places than the calculated results

Correct Answer: a

160.    You can copy data or formulas

a.   With the copy, paste and cut commands on the edit menu

b.   With commands on a shortcut menu

c.   With buttons on the standard toolbar

d.   All of the above

Correct Answer: d

1. Which of the following is an absolute cell reference?

a. !A!1

b. $A$1

c. #a#1

d. A1

Correct Answer: b

Collection on http://www.psexam.com

2. What symbol is used before a number to make it a label?

a. “ (quote)

b. = (equal)

c. _ (underscore)

d. ‘ (apostrophe)

Correct Answer: b

Collection on http://www.psexam.com

3. Which symbol must all formula begin with?

a. =

b. +

c. (

d. @

Correct Answer: a

Collection on http://www.psexam.com

4. Which of the following formulas is not entered correctly?

a. =10+50

b. =B7*B1

c. =B7+14

d. 10+50

Correct Answer: d

Collection on http://www.psexam.com

5. Which of the following formulas will Excel Not be able to calculate?

a. =SUM(Sales)-A3

b. =SUM(A1:A5)*.5

c. =SUM(A1:A5)/(10-10)

d. =SUM(A1:A5)-10

Correct Answer: a

Collection on http://www.psexam.com

6. A typical worksheet has …. Number of columns

a. 128

b. 256

c. 512

d. 1024

Correct Answer: b

Collection on http://www.psexam.com

7. How many characters can be typed in a single cell in Excel?

a. 256

b. 1024

c. 32,000

d. 65,535

Correct Answer: d

Collection on http://www.psexam.com

8. A worksheet can have a maximum of …. Number of rows

a. 256

b. 1024

c. 32,000

d. 65,535

Correct Answer: d

Collection on http://www.psexam.com

9. Which of the following is not an example of a value?

a. 350

b. May 10, 2001

c. 57%

d. Serial Number 50771

Correct Answer: d

Collection on http://www.psexam.com

10. The chart wizard term data series refers to

a. A chart legend

b. A collection of chart data markers

c. A set of values you plot in a chart

d. A data label

Correct Answer: b

Collection on http://www.psexam.com

11. The  Chart wizard term data categories refers to;

a. A chart plot area

b. A horizontal axis

c. The organization of individual values with a chart’s data series

d. The data range that supply chart data

Correct Answer: b

Collection on http://www.psexam.com

12. A worksheet range is a

a. A command used for data modeling

b. A range of values such as from 23 to 234

c. A group of cells

d. A group of worksheets

Correct Answer: c

Collection on http://www.psexam.com

13. Getting data from a cell located in a different sheet is called …

a. Accessing

b. Referencing

c. Updating

d. Functioning

Correct Answer: b

Collection on http://www.psexam.com

14. Tab scrolling button

a. Allow you to view a different worksheet

b. Allow you to view additional worksheet rows down

c. Allow you to view additional worksheet columns to the right

d. Allow you to view additional sheets tabs

Correct Answer: d

Collection on http://www.psexam.com

15. A numeric value can be treated as a label value if it precedes with

a. Apostrophe (‘

b. Exclamation (!)

c. Hash (#)

d. Ampersand (&

Correct Answer: a

Collection on http://www.psexam.com

16. Concatenation of text can be done using

a. Apostrophe (‘

b. Exclamation (!)

c. Hash (#)

d. Ampersand (&

Correct Answer: d

Collection on http://www.psexam.com

17. Data can be arranged in a worksheet in a easy to understand manner using

a. auto formatting

b. applying styles

c. changing fonts

d. all of above

Correct Answer: d

Collection on http://www.psexam.com

18. You can use drag-and-drop to embed excel worksheet data in a word document

a. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

b. By dragging a range of excel data to the word button on the taskbar while pressing Shift key

c. By dragging a range of excel data to the word button on the taskbar while pressing Alt key

d. None of above

Correct Answer: a

Collection on http://www.psexam.com

19. The auto calculate feature

a. Can only add values in a range of cells

b. Provides a quick way to view the result of an arithmetic operation on a range of cells

c. Automatically creates formulas and adds them to a worksheet

d. A and c

Correct Answer: b

Collection on http://www.psexam.com

20. Excel uniquely identifies cells within a worksheet with a cell name

a. Cell names

b. Column numbers and row letters

c. Column letters and row numbers

d. Cell locator coordinates

Correct Answer: c

21. to view a cell comment

a. click the edit comment command on the insert menu

b. click the display comment command on the window menu

c. position the mouse pointer over the cell

d. click the comment command on the view menu

Correct Answer: c

Collection on http://www.psexam.com

22. When you want to insert a blank imbedded excel object in a word document you can

a. Click the object command on the insert menu

b. Click the office links button on the standard toolbar

c. Click the create worksheet button on the formatting toolbar

d. Click the import excel command on the file menu

Correct Answer: a

Collection on http://www.psexam.com

23. To save a workbook, you:

a. Click the save button on the standard toolbar from the menu

b. Press Ctrl+F5

c. Click Save on the Windows Start button

d. Select Edit>Save

Correct Answer: a

Collection on http://www.psexam.com

24. You can edit a cell by

a. Clicking the formula button

b. Double clicking the cell to edit it in-place

c. Selecting Edit>Edit Cell from the menu

d. None of above

Correct Answer: b

Collection on http://www.psexam.com

25. You can select a single range of cells by

a. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b. Pressing the Ctrl key while dragging over the desired cells

c. Pressing the Shift key and an arrow key

d. Dragging over the desired cells

Correct Answer: d

Collection on http://www.psexam.com

26. Which elements of worksheet can be protected from accidental modification

a. Contents

b. Objects

c. Scenarios

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

27. You can use the drag and drop method to

a. Copy cell contents

b. Move cell contents

c. Add cell contents

d. a and b

Correct Answer: d

Collection on http://www.psexam.com

28. It is acceptable ot let long text flow into adjacent cells on a worksheet when

a. Data will be entered in the adjacent cells

b. No data will be entered in the adjacent cells

c. There is nt suitable abbreviation of the text

d. Tehere is not time to format the next

Correct Answer: b

Collection on http://www.psexam.com

29. How can you delete a record?

a. Delete the column from the worksheet

b. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button

c. Select Data > Delete Record from the menu

d. Click the Delete button on the Standard toolbar

Correct Answer: b

Collection on http://www.psexam.com

30. Right clicking something in Excel:

a. Deletes the object

b. Nothing the right mouse button is there for left handed people

c. Opens a shortcut menu listing everything you can do to the object

d. Selects the object

Correct Answer: c

Collection on http://www.psexam.com

31. Documentation should include

a. Destination and users of the output data

b. Source of input data

c. Information on the purpose of the workbook

d. All of the above

Correct Answer: d

Collection on http://www.psexam.com

32. Files created with Lotus 1-2-3 have an extension

a. DOC

b. XLS

c. 123

d. WK1

Correct Answer: c

Collection on http://www.psexam.com

33. To delete an embedded objects, first

a. Double click the object

b. Select the object by clicking it

c. Press the Shift + Delete keys

d. Select it and then press the delete key

Correct Answer: d

Collection on http://www.psexam.com

34. Comments can be added to cells using

a. Edit > Comments

b. Insert > Comments

c. File > Comments

d. View > Comments

Correct Answer: b

Collection on http://www.psexam.com

35. Which of the following is not a worksheet design criterion?

a. Efficiency

b. Aditibility

c. Description

d. Clarity

Correct Answer: c

Collection on http://www.psexam.com

36. To copy cell contents using drag and drop press the

a. End key

b. Shift key

c. Ctrl key

d. Esc key

Correct Answer: d

Collection on http://www.psexam.com

37. Which of the following is the latest version of Excel

a. Excel 2000

b. Excel 2002

c. Excel ME

d. Excel XP

Correct Answer: d

Collection on http://www.psexam.com

38. When you copy a formula

a. Excel erases the original copy of the formula

b. Excel edits cell references in the newly copied formula

c. Excel adjusts absolute cell references

d. Excel doesn’t adjust relative cell references

Correct Answer: b

Collection on http://www.psexam.com

39. The autofill feature

a. extends a sequential series of data

b. automatically adds range of cell values

c. applies a boarder around the selected cells

d. none of the above

Correct Answer: d

Collection on http://www.psexam.com

40. Which menu option can be sued to split windows into two

a. Format > window

b. View > window > split

c. Window > split

d. View > split

Correct Answer: c

41. You can use the formula palette to

a. Format cells containing numbers

b. Create and edit formulas containing functions

c. Enter assumptions data

d. Copy a range of cells

Correct Answer: b

Collection on http://www.psexam.com

42. You can convert existing excel worksheet data an charts to an HTML document by using

a. FTP wizard

b. Internet assistant wizard

c. Intranet wizard

d. Import wizard

Correct Answer: b

Collection on http://www.psexam.com

43. A circular reference is

a. Geometric modeling tool

b. A cell that points to a drawing object

c. A formula that either directly or indirectly depends on itself

d. Always erroneous

Correct Answer: c

Collection on http://www.psexam.com

44. Which of following is Not one of Excel’s what-if function?

a. Goal seek

b. Solver

c. Scenario manager

d. Auto Outline

Correct Answer: d

Collection on http://www.psexam.com

45. When you insert an excel file into a word document. The data are

a. Hyperlinked placed in a word table

b. Linked

c. Embedded

d. Use the word menu bar and toolbars

Correct Answer: b

Collection on http://www.psexam.com

46. Which of the following is not information you can specify using the solver?

a. Input cells

b. Constraints

c. Target cell

d. Changing cells

Correct Answer: a

Collection on http://www.psexam.com

47. Each excel file is called a workbook because

a. It can contain text and data

b. It can be modified

c. It can contain many sheets including worksheets and chart sheets

d. You have to work hard to create it

Correct Answer: c

Collection on http://www.psexam.com

48. Excel probably considers the cell entry January 1, 2000 to be a

Label

Value

Formula

Text string

Correct Answer: b

Collection on http://www.psexam.com

49. You can enter which types of data into worksheet cells?

a. Labels, values, and formulas

b. Labe3ls and values but not formulas

c. Values and formulas but not labels

d. Formulas only

Correct Answer: a

Collection on http://www.psexam.com

50. All worksheet formula

a. Manipulate values

b. Manipulate labels

c. Return a formula result

d. Use the addition operator

Correct Answer: c

Collection on http://www.psexam.com

51. Which of the following is a correct order of precedence in formula calculation?

a. Multiplication and division exponentiation positive and negative values

b. Multiplication and division, positive and negative values, addition and subtraction

c. Addition and subtraction, positive and negative values, exponentiation

d. All of above

Correct Answer: d

Collection on http://www.psexam.com

52. The Paste Special command lets you copy and paste:

a. Multiply the selection by a copied value

b. Cell comments

c. Formatting options

d. The resulting values of a formula instead of the actual formula

Correct Answer: d

Collection on http://www.psexam.com

53. The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. 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 everything and manually add the dollar signs, commas, and decimals.

Correct Answer: c

Collection on http://www.psexam.com

54. Which of the following is not a valid data type in excel

a. Number

b. Character

c. Label

d. Date/time

Correct Answer: b

Collection on http://www.psexam.com

55. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

a. Option buttons

b. List boxes

c. Text boxes

d. Combo boxes

Correct Answer: c

Collection on http://www.psexam.com

56. Which of the following options is not located in the Page Setup dialog box?

a. Page Break Preview.

b. Page Orientation

c. Margins

d. Headers and Footers

Correct Answer: a

Collection on http://www.psexam.com

57. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

a. Pie chart

b. Row chart

c. Line chart

d. Column chart

Correct Answer: c

Collection on http://www.psexam.com

58. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

a. Press Ctrl +Home

b. Press Home

c. Press Shift + Home

d. Press Alt + Home

Correct Answer: a

Collection on http://www.psexam.com

59. Which of the following methods can not be used to edit the contents of a cell?

a. Press the Alt key

b. Clicking the formula bar

c. Pressing the F2 key

d. Double clicking the cell

Correct Answer: a

Collection on http://www.psexam.com

60. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

a. Press the Erase key

b. Press Esc

c. Press the Enter button

d. Press the Edit Formula button

Correct Answer: b

Question 1:

In OSI network architecture, the dialogue control and token management are responsibility of

a. session layer

b. network layer

c. transport layer

d. data link layer

e. none of above

Question 2:

In OSI network architecture, the routing is performed by

a. network layer

b. data link layer

c. transport layer

d. session layer

e. none of above

Question 3:

Which of the following performs modulation and demodulation?

a. fiber optics

b. satellite

c. coaxial cable

d. modem

e. none of the above

Question 4:

The process of converting analog signals into digital signals so they can be processed by a receiving computer is referred to as:

a. modulation

b. demodulation

c. synchronizing

d. digitising

Question 5:

How many OSI layers are covered in the X.25 standard?

a. Two

b. Three

c. Seven

d. Six

e. None of above

Question 6:

Layer one of the OSI model is

a. physical layer

b. link layer

c. transport layer

d. network layer

e. none of above

Question 7:

The x.25 standard specifies a 

a. technique for start-stop data

b. technique for dial access

c. DTE/DCE interface

d. data bit rate

e. none of above

Question 8:

Which of the following communication modes support two-way traffic but in only one direction at a time?

a. simplex

b. half duplex

c. three-quarters duplex

d. all of the above

e. none of the above

Question 9:

Which of the following might be used by a company to satisfy its growing communications needs?

a. front end processor

b. multiplexer

c. controller

d. concentrator

e. all of the above

Question 10:

What is the number of separate protocol layers at the serial interface gateway specified by the X.25 standard?

a. 4

b. 2

c. 6

d. 3

3. none of the above

Correct Answers:

1. a

2. a

3. d

4. d

5. b

6. a

7. c

8. b

9. e

10. d

Question 1:

The interactive transmission of data within a time sharing system may be best suited to 

a. simplex lines

b. half-duplex lines

c. full duplex lines

d. biflex-lines

Question 2:

Which of the following statement is incorrect?

a. The difference between synchronous and asynchronous transmission is the clocking derived from the data in synchronous transmission.

b. Half duplex line is a communication line in which data can move in two directions, but not at the same time.

c. Teleprocessing combines telecommunications and DP techniques in online activities

d. Batch processing is the prefered processing mode for telecommunication operation.

Question 3:

Which of hte following is considered a broad band communication channel?

a. coaxial cable

b. fiber optics cable

c. microwave circuits

d. all of above

Question 4:

Which of the following is not a transmission medium?

a. telephone lines

b. coaxial cables

c. modem

d. microwave systems

Question 5:

Which of the following does not allow multiple uses or devices to share one communication line?

a. doubleplexer

b. multiplexer

c. concentrator

d. controller

Question 6:

Which of the following signal is not standard RS-232-C signal?

a. VDR

b. RTS

c. CTS

d. DSR

Question 7:

Which of the following statement is incorrect?

a. Multiplexers are designed to accept data from several I/O devices and transmit a unified stream of data on one communication line

b. HDLC is a standard synchronous communication protocol.

c. RTS/CTS is the way the DTE indicates that it is ready to transmit data and the way the DCW indicates that it is ready to accept data

d. RTS/CTS is the way the terminal indicates ringing

Question 8:

Which of the following is an advantage to using fiber optics data transmission?

a. resistance to data theft

b. fast data transmission rate

c. low noise level

d. all of above

Question 9:

Which of the following is required to communicate between two computers?

a. communications software

b. protocol

c. communication hardware

d. all of above including access to transmission medium

Question 10:

The transmission signal coding method of TI carrier is called

a. Bipolar

b. NRZ

c. Manchester

d. Binary

Answers:

Top of Form

Bottom of Form

1. b

2. d

3. d

4. c

5. a

6. a

7. d

8. d

9. d

10. a

Question 1:

Which data communication method is used to transmit the data over a serial communication link?

a. simplex

b. half-duplex

c. full-duplex

d. b and c

e. None of above

Question 2:

What is the minimum number of wires needed to send data over a serial communication link layer?

a. 1

b. 2

c. 4

d. 6

e. none of above

Question 3:

Which of the following types of channels moves data relatively slowly?

a. wide band channel

b. voice band challen

c. narrow band channel

Question 4:

Most data communications involving telegraph lines use:

a. simplex lines

b. wideband channel

c. narrowband channel

d. dialed service

Question 5:

A communications device that combines transmissions from several I/O devices into one line is a 

a. concentrator

b. modifier

c. multiplexer

d. full-duplex line

Question 6:

How much power (roughly) a light emitting diode can couple into an optical fiber?

a. 100 microwatts

b. 440 microwatts

c. 100 picowatts

d. 10 miliwatts

Question 7:

The synchronous modems are more costly than the asynchronous modems because

a. they produce large volume of data

b. they contain clock recovery circuits

c. they transmit the data with stop and start bits

d. they operate with a larger bandwidth

e. none of above

Question 8:

Which of the following statement is correct?

a. terminal section of a synchronous modem contains the scrambler

b. receiver section of a synchronous modem contains the scrambler

c. transmission section of a synchronous modem contains the scrambler

d. control section of a synchronous modem contains the scrambler

e. none of the above

Question 9:

In a synchronous modem, the digital-to-analog converter transmits signal to the 

a. equilizer

b. modulator

c. demodulator

d. terminal

e. none of aobve

Question 10:

Which of the following communications lines is best suited to interactive processing applications?

a. narrow band channel

b. simplex lines

c. full duplex lines

d. mixed band channels

Answers

1. c

2. b

3. c

4. c

5. c

6. a

7. b

8. c

9. a

10. c

Question:1

A remote batch-processing operation in which data is solely input to a central computer would require

a. telegraphp line

b. simplex lines

c. mixed bad channel

d. all of above

Question 2:

A band is always equivalent to 

a. a byte

b. a bit

c. 100 bits

d. none of above

Question 3:

The loss in signal power as light travels down the fiber is called

a. attenuation

b. progragation

c. scattering

d. interruption

Question 4:

Avalanche photodiode receivers can detect bits of transmitted data by receiving

a. 100 photons

b. 200 photons

c. 2000 photons

d. 300 photons

Question 5:

Communiction circuits that transmit data in both directions but not at the same time are operating in

a. a simplex mode

b. a half duplex mode

c. a full duplex mode

d. an asynchronous mode

Question 6:

An example of a medium speed, switched communications service is

a. series 1000

b. data phone 50

c. DDD

d. All of the above

Question 7:

In communication satellite, multiple repeaters are known as

a. detector

b. modulator

c. stations

d. transponders

Question 8:

While transmitting odd-parity coded symbols, the number of zeros in each symbol is

a. odd

b. even

c. a and b both

d. unknown

Question 9:

Data communications monitors available on the software marked include

a. ENVIRON/1

b. TOTAL

c. BPL

d. Telnet

Question 10:

An example of an analog communication method is

a. laser beam

b. microwave

c. voice grade telephone line

d. all of the above

Answers

1. b

2. d

3. a

4. b

5. b

6. c

7. d

8. d

9. a

10. d

Question:1

Number of bits per symbol used in Baudot code is

a. 7

b. 5

c. 8

d. 9

Question 2:

What is the main difference between DDCMP and SDLC?

a. DDCMP does not need special hardware to final the beginning of a message

b. DDCMP has a message header

c. SDLC has a IP address

d. SDLC does not use CRC

Question 3:

An example of digital, rather than analog, communication is

a. DDD

b. DDS

c. WATS

d. DDT

Question 4:

Terminals are required for 

a. real-time, batch processing & time-sharing

b. real time, time-sharing & distributed message processing

c. real time, distributed processing & manager inquiry

d. real-time,  time sharing & message switching

Question 5:

The receive equilizer reduces delay distortions using a

a. tapped delay lines

b. gearshift

c. descrambler

d. difference engine

Question 6:

Ina synchronous modem, the receive equilizer is known as

a. adaptive equilizer

b. impariment equilizer

c. statistical equilizer

d. compromise equilizer 

Question 7:

The channel in the data communication model can be

a. postal mail services

b. telephone lines

c. radio lines

d. any of the above

Question 8:

A data terminal serves as an

a. Effector

b. sensor

c. both a and b

d. neither a nor b

Question 9:

Which of the following transmission systems provide the highest data rate to in individual device?

a. computer bus

b. telephone lines

c. voice and mode

d. lease lines

Question 10:

A protocol is a set of rules governing a time sequence of events that must take place

a. between peers

b. between an interface

c. between modems

d. across an interface

Answers

 1. b

2. a

3. b

4. d

5. a

6. a

7. d

8. c

9. a

10. a