Random me

ODESK\ ELANCE MS EXCEL 2007 Test

2012-03-25T00:31:00.000+06:00

ODESK\ ELANCE MS EXCEL 2007 Test

SET 1

Q:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans:Hold down the CTRL key during startup

Q:How does the AutoComplete feature in Excel help you save time?

Ans: It automatically completes abbreviated words

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?

Ans: It copies the formatting properties from one cell to another

Q:The figure shows the AutoFit Selection menu option. What function does it perform?

Ans: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Ans: It is used to add a hyperlink

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans: Apply the Text Format to empty cells, and then type the numbers

Q:What is the quickest way to select all the columns on a worksheet?

Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans: A_B

Q:How can you select all the blank cells in your worksheet?

Ans: This must be done manually as it is not automated through any built-in feature

Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q:Which of the following functions would return a value of 8?

Ans: b and c

Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans: 3 new rows will be inserted after row 9

Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?

Ans: It inserts a Diagram or Organization Chart in the worksheet

Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Ans: TRUE

Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

Ans: Select the cells, open the Window menu and click on Hide

Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans: DATEVALUE

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?

Ans: It adds up the values in the selected cells

Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Ans: #N/A

Q:Which of the following function you will use to find the highest number in a series of numbers?

Ans: MAX(B1:B3)

Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans: Date

Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans:#N/A

Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans: TRUE

Q:What does the NOW() function returns?

Ans: Returns the serial number of the current date and time

Q:Which toolbar is shown in the figure?

Ans: Forms toolbar

Q:When you clear the contents from a cell, the formatting of the cell is also lost.

Ans: FALSE

Q:You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans: b

SET 2

Q1: when a part of a formula is replaced with its calculated value, it cannot be restored.

a. True.

Q2: When you sign the stamp signature line in an office document, you add both a visible stamp and a document signature.

a. True

Q3: Refer to the given image, what will be the result if the formula =B3&”, ”&A3 is applied to the given table?

d. Both b and c

Q4: How will you reverse the direction of a Smart art graphics?

c. Under SmartArt tools, on the Design tab, in the Create Graphic group, click on Right to Left

Q5: Which of the following chart have no axes?

c. C-both a and b

Q6: Which of the following is not true regarding column width?

d. all of the above are true

Q7: Which chart type is displayed in the given picture?

b.A surface chart

Q8:What does the red icon indicate as shown in the given picture?

b. it tells the user that the document contains signatures

Q9: Which among the following is not true regarding a calculated column?

d. Additional formulae cannot be entered in a calculated column as exceptions

Q10: What does the screen tip displaying “Showing all” mean?

a. It means that a filter has been applied.

Q11: Which chart displays axes but can not display axis titles?

a. Radar chart

Q12: Which file format is typically used to remove printer corruption?

c. SYLK format

Q13: Which of the following methods would you follow to remove subtotals?

a. On the Data tab, in the Outline group, click on Subtotal. The subtotal dialog box is displayed. Click Remove all

Q14: When does triangle appear in the Top-left corner of the cell, as shown in the picture?

c. When there is an error in the formula

Q15: Which lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

b. VLOOKUP

Q16: Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

c. Scoping by value field

Q17: Where can the “Show all comments” command be found?

c. On the Review tab

Q18: Which of the following is not true about an offline cube file

b. The file format for an offline cube file is .CUE

Q19: What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?

b. It signifies that the cell contains a comment.

Q20: Which of the following is not true regarding naming a cell?

a. Names are case sensitive.

Q21: Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?

a. A (MAP NETWORK DRIVE)

Q22: Which of the following charts shows numerical values on the vertical (value) axis and textual groupings (or categories) on the horizontal axis?

c. Area charts

Q23: Which of the following options would you choose to clear a PivotChart report?

a. On the Analyze tab, in the Data group, click on Clear and then click “Clear All”.

Q24: Which of the following wildcard characters can be used as comparison criteria for Text Filters?

d. All of the above.

Q25: Which tab should be used to display or hide axes?

b. Layout tab

Q26: When would you use smart graphic?

a. List information b. create a matrix illustration c. Show a relationship between parts, such as overlapping concepts

Q27: Which tab is required to work with Macros?

b. Developer tab. e. View tab

Q28: Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.

b. B General options

Q29: Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have change3d since the last time?

d. None of above.

Q30: Refer to the given image Which line style option should be used to specify the style used for the end of the line?

c. C

Q31: Which of the following is not true about the Watch Window?

c. There can be two Watch windows per cell.

Q32: How would you select an entire PivotalTable report?

b. On the Options tab, in the Actions group, click Select, and then click Entire PivotTable.

Q33: A Macro can be digitally signed.

a. True

Q34: What would be the result, when =T(A4) is applied on the given table?

a. The text TRUE is returned

Q35: When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

a. True

Q36: Which among the following options displays Legend entries in the given picture?

c. C

Q37: What is the purpose of using the Keep text flat option, as shown in the picture?

a. It prevents the text inside the wordart from rotating when rotate wordArt is rotated.

Q38: Which of the given methods would you follow to add an alternative text to a picture?
a. Right-click the picture, click Size and Properties.Click the Alt Text tab, and then in the Alternative text box, enter your text.

Q39: Some data is to be refreshed in an imported XML file. Where can the command on the Ribbon be found?

c. On the Developer tab

Q40: Refer to the given image Which of the following password options uses an encryption method?

c. Both a and b

SET 3

Q2: Refer to the given picture, which option causes the last row in the table to appear and displays the word Total in the leftmost cell?

b. B (total row)

Q3: What is the option on the Document Inspector that finds the content type information?

c. Document Properties and Personal Information

Q7: How will you find cells with data validation?

a. On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go -To Special. Click on Data Validation, and then click All

Q8: For XY (scatter) and bubble charts, error bars for the x values, the y values , or both can be displayed.

a. true

Q9: How should blank cells be inserted on a Worksheet?

c. Both a and b

Q11: Case-sensitive sorting of text in Excel2007 can be performed.

a. True

Q12: Which of the following is true about a freeform shape?

d. All of the above is true

Q13: Which keyboard shortcut should be used to enter the current time?

b. CTRL+SHIFT+:

Q:20 Deleting the PivotChart report automatically deletes the associated PivotTable report.

b. False

Q21: Which of the following is a default method of a PivotTable report for scoping the conditional format of a fields in the values area?

a. By selection

Q22: Which method will you use to update table data from a Sharepoint list?

c. In the Design tab, On the External Data Tools group, Click Refresh

Q23: How will you display the Go To dialog box?

b. You will press F5

Q25 Which part of the formula displays references in the given picture?

b. B

Q27: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?

a. Automatically updated properties

Q29: Which keyboard shortcut should be used to minimize or restore the ribbon?

c. CTRL+F1

Q32: When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

a. True

Q33: If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic

a. True

Q34: Which of the following operators is not a type of calculation operator?

d. equation

Q36: Which Consolidate option would you choose when you want to arrange data in all the worksheets in identical order and location?

a. Consolidate by position

Q38: Which option would you choose to display a list of formula used in the current PivotTable report?

c. On the Options tab, in the Tools group, click on Formula, and then click “List Formula”

Q39: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?

-Automatically updated properties

Q40: When does the error, as shown in the picture, occur?

d. All of the above.

Q41: Refer to the given, What is the purpose of the cell denoted as 'A' in the worksheet?
a. It selects all the cells in the worksheet.

Q42. Refer to the given image, which formula should be written on the given table to display "Nancy Davolio"?
c. =PROPER(A2)

Q43: How would you assign a Macro to a graphic
c. On the worksheet, right-click on the graphic, then click "Assign Macro" on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

Q44: No data is deleted when an outline is hidden or removed.
a. True.

Q45: Refer to the given image, which of the following Fill options should be used to add color and transparency to a shape?
a. A (No fill)

Q46: Which among the following settings is the default macro setting?
c. Disable all macros with notification.

Q47: Which type of additional information is stored within the digital signature?
d. All of the above.

Q48: When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
d. It enters the time as AM.

Q46: Which of the following is not a valid file extension in which an Excel file can be saved?
c. PXL

Q47: When would the data validation command be unavailable on the data tab?
d. All of the above.

SET 4

How can a chart be modified?

-By modifying a legend

-By modifying the display of chart axes

-By modifying titles and data labels

-All of the above

This question is based upon the figure shown below

When does the triangle appear in the top-left corner of the cell, as shown in the picture?

-When the cell contains hidden information

-When the cell contains the Time function

-When there is an error in the formula

-None of the above

Which database function estimates variance based on a sample from selected database entries?

-DSTDEV

-DSUM

-DVAR

-DVARP

Which chart displays axes but cannot display axis titles?

-Radar chart

-Doughnut chart

-Pie chart

-All of the above

How will you reverse the direction of a SmartArt graphic?

-Right-click on the SmartArt graphic, select Reverse

-Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse

-Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left

-All of the above

Which database function estimates variance based on a sample from selected database entries?

-DSTDEV

-DSUM

-DVAR

-DVARP

How would you locate the last cell on a worksheet?

-Click anywhere in the worksheet, and then press CTRL+HOME

-Click anywhere in the worksheet, and then press CTRL+INSERT

-Click anywhere in the worksheet, and then press CTRL+END

-None of the above

Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?

-Consolidate by position

-Consolidate by category

-Consolidate by formula

-None of the above

Which of the following options is not available on the Status bar?

-Cell mode

-Selection mode

-End mode

-Start mode

Odesk Photoshop CS3 test/Elance Photoshop CS3 test

2011-12-29T08:53:00.000+06:00

Test Syllabus

Workspace
Working with Images, Retouching and Transforming
Color Management
Color and Tonal Adjustments
Using Selection and Drawing
Layers
Filters and Saving Images
Type
Working With Web, Video and Animation
Automating Tasks and Keyboard Shortcuts

Question:

Which of the following is not a kind of text type?

a.	Point Type
b.	Paragraph Type
c.	Type on a path
d.	Line type

Question:

State whether True or False:

You cannot arrange the stacking order of the Auto slices.

a.	True
b.	False

Question:

State whether True or False:

A working space is an intermediate color space used to define and edit color in Adobe applications.

a.	True
b.	False

Question:

State whether True or False:

The Out Of Gamut option works only on RGB and Lab images.

a.	True
b.	False

Question:

Channels can not be added to which of the following image modes?

a.	RGB
b.	CMYK
c.	Bitmap
d.	Lab

Question:

A Motion Picture film has a frame rate of how many fps?

a.	29.97
b.	23.976
c.	25
d.	24

Question:

Which of the following is not true about Filters?

a.	Filters cannot be applied to Bitmap-mode or indexed-color images
b.	All filters can be applied to 8-bit images
c.	Filters are applied to the active, visible layer or a selection
d.	None of the above

This question is based upon the figure shown below

Question:

Refer to the given image.

Which of the given options displays the Modal control in the Actions palette?

a.	A
b.	B
c.	C
d.	D

Question:

State whether True or False:

The mask created by the Replace Color command is permanent.

a.	True
b.	False

This question is based upon the figure shown below

Question:

Refer to the given image.

Which of the following options displays Temporary Work Path in the Paths palette?

a.	A
b.	B
c.	C
d.	All of the above

Question:

State whether True or False:

Changing units on the Info Palette automatically changes the units on Rulers.

a.	True
b.	False

Question:

Which type of images are resolution-dependent?

a.	Bitmap images
b.	Vector images
c.	Both a and b
d.	None of the above

This question is based upon the figure shown below

Question:

Refer to the given image.

In which of the given instances, a caution icon appears next to the layer comp name as shown in the picture?

a.	When you delete a layer
b.	When you merge a layer
c.	When you convert a layer to a background
d.	All of the above

This question is based upon the figure shown below

Question:

Refer to the given image.

Which of the given options displays left indent in the Paragraph palette?

a.	A
b.	B
c.	C
d.	D

Question:

What is meant by Contact Sheet?

Contact Sheets let you easily preview and catalog groups of images by displaying a series of thumbnails on a single page

Contact Sheets let you use a variety of images to create a multipage document or slide show presentation

Contact Sheets let you place multiple copies of a source image on a single page

All of the above

Question:

Which of the following features is supported by the EPS file format?

a.	It supports the Grayscale and Bitmap color modes
b.	It supports the Support Alpha Channels
c.	It supports the Clipping paths
d.	All of the above

Question:

Which option is not turned off by the Extras command in the View menu?

a.	It does not turn off the Guide feature
b.	It does not turn off the Grid feature
c.	It does not turn off the Smart Guide feature
d.	It does not turn off the Rulers feature

Question:

Which option will you select to display a file at 100% size?

a.	Choose View > Actual Pixels
b.	Choose View > Fit on Screen
c.	Choose View > Print Size

d.	All of the above

Question:

What is the use of the Make Work Path command in the Paths palette ?

a.	It eliminates any feathering applied to the selection
b.	It can alter the shape of a selection
c.	Both a and b
d.	None of the above

question is based upon the figure shown below

Question:

Refer to the given image.

Which of the following Lock options in the Layers palette prevents modification of the layer’s pixels using the painting tools?

a.	A
b.	B
c.	C
d.	None of the above

Question:

Refer to the given image.

Which of the given options displays the Set Tsume option in the Character Palette?

a.	A
b.	B
c.	C
d.	D

Question:

Refer to the given image.

When will the Dynamic shortcuts appear in the Character Palette Menu as shown in the picture?

a.	When you are entering the Point type
b.	When you are entering the Paragraph type
c.	When the I-beam is in text
d.	All of the above

This question is based upon the figure shown below

Question:

Refer to the given image.

Which option adjusts Highlights in the Levels dialog box?

a.	A
b.	B
c.	C
d.	None of the above

Question:

Which of the following is not true about the Curves dialog box?

a.	You can use the Curves dialog box to adjust the entire tonal range of an image
b.	The Curves dialog box lets you adjust up to 14 different points throughout an image’s tonal range *
c.	In the Curves dialog box, the tonal range is represented as a straight diagonal baseline
d.	None of the above

Question:

Refer to the given image.

In which format will you save your document to preserve the Perspective Plane Information in an image while working with the vanishing point, as shown in the given picture?

a.	PSD
b.	TIFF
c.	JPEG
d.	All of the above

Question:

Which of the following is not a Color Adjustment command?

a.	Adjustment command
b.	Color Balance command
c.	Selective Color command
d.	Levels command

Question:

Refer to the given image.

Which of the following options displays the Spot Channels in the Channels palette?

a.	A
b.	B
c.	C
d.	All of the above

Question:

Which of the following is not a type of Variable?

a.	Image variables
b.	Visibility variables
c.	Pixel Replacement variables
d.	Text Replacement variables

Question:

Which keyboard shortcut (windows) will you choose to permanently Clear History (no Undo)?

a.	Control + Shift + Z
b.	Control + Alt + Z
c.	Shift + Clear History
d.	Alt + Clear History

Question:

Which among the following blending modes is available only for the Apply Image and Calculations commands?

a.	Add
b.	Subtract
c.	Both a and b
d.	None of the above

Question:

Which among the following Slices cannot be divided?

a.	User slices
b.	Auto slice
c.	Layer-based slices
d.	All of the above

Question:

Which among the following is not a Duotone mode type?

a.	Pantone
b.	Monotone
c.	Tritone
d.	Quadtone

Question:

State whether True or False:

You cannot create Work paths from the fonts that do not include the outline data.

a.	True
b.	False

Question:

Refer to the given image.

What is the colored box in the Navigator Palette known as?

a.	View area
b.	Proxy area
c.	Navigation area
d.	Proxy preview area

Question:

Refer to the given image.

Which of the given options displays Converts to Timeline mode in an Animation palette?

a.	A
b.	B
c.	C
d.	D

Question:

State whether True or False:

You cannot change the order of the Vector masks or working paths in the Paths palette.

a.	True
b.	False

Question:

Which of the following Filters cannot be applied to a Smart Object?

a.	Stylize
b.	Texture
c.	Pattern Maker
d.	All of the above

Question:

Which keyboard shortcut (windows) will you choose to select the History Brush tool?

a.	Y
b.	R
c.	O
d.	H

Question:

Which among the following files, saved in the Adobe Photoshop format, is used by the filter to create the displacement maps?

a.	Flat file
b.	Bump file
c.	Flattened file
d.	Displace file

Question:

Which of the Saving commands is available for an image that is managed by a Version Cue Workspace?

a.	Save
b.	Save As
c.	Check In
d.	Save For Web & Devices

ANOTHER SET

Question:
Which of the following file formats supports embedded color profiles?

c. TIFF

Question:
Which Filter embeds a Digital watermark into an image to store a copyright information?

b. Digimarc filters

Question:
Color Dodge, Color Burn, Lighten, Darken, Difference, and Exclusion blending modes does not work on Lab images.

a. True

Question:
Which keyboard shortcut( windows) will you choose for Auto leading?

c. Control+Shift+ALT+A

Question:
The Healing Brush Tool cannot be applied to video or animation frames.

b. False

Question:
You cannot create Work paths from the fonts that do not include the outline data

a. True

Question:
Which icon indicates Type 1 kind of fonts?

b. B

ANOTHER SET

Question:
Which among the following QuickTime Video formats is supported by Photoshop extended?

d. All of the above

Question:
Which of the following options displays Temporary Work path in the Paths Palette?

b. B

Question:
The Rotate canvas command does not work on which of the following?

d. All of the above.

Question:
Variable names contain spaces and special characters

a. True

Question:
Channels cannot be added to which of the following image modes?

c. Bitmap

Question:

Which type of character is generated by Photoshop when the font does not include Superscript or subscript characters?

c. Both a and b

Question:
Which among the following slices cannot be divided?

c. Layer-based slices

Question:
Which option, when in a checked state, displays a message whenever you opened an untagged document?

c. C

Question:
Layer styles cannot be applied to which of the following options?

d. All of the above.

Question:
Which option will you select to apply the Extrude filter?

a. Select Filter>Stylize>Extrude.

Question:
You cannot transform the background layer

a. True

Question:
Which of the following Slices created with the Slice Tool?

b. user slices

Question:

Why do we select Remember Palette Locations option as shown in the given image?

a. To display palettes on their last locations on startup

Question:
Which option will you select to export layers?

a. Choose File>Scripts>Export Layers to Files

Question:
With which of the given option does the Signal Strength Meter appear?

b. It appears when you read watermark.

Question:
Which option will you choose to convert Document Colors into another profile?

B. Choose Edit>Convert to profile

Question:
The individual Histograms in the all Channels View does not include which of the following?

d. All of the above

Question:
Which file format saves a documents of any size as well as preserves all the Photoshop features?

b. PSD

ANOTHER SET

Question:
Which of the following is not true about multichannel mode?

d. None of the above

Question:
The Match Color command works only in the RGB modes.

a. True

Question:
Which among the following files, saved in the Adobe Photoshop format is used by the filter to create displacement map?

d. Flattened file

Question:
Which among the following lock options in the Layers palette prevents modification of the layer’s pixels using the painting tools?

b. B

Question:
Video layers do not work in the Frame mode.

a. True

Question:

Which option adjusts Highlights in the Levels dialog box?

c. C

Question:
Which among the following blending modes is available only for the Apply image and Calculations commands?

a. Add

b. Subtract

c Both a and b

Question:
Hanging Punctuation control the alignment of the punctuation marks for a specific paragraph.

a. True

Question:
Which of the given options displays Converts to Timeline mode in an animation palette?

d. D

Question:
Which option will you choose to select all layers of a similar type?

b. Select one of the layers. Right click and choose Select Similar Layers from the list.

Question:
Auto Blend Layers is available for which of the following Modes?

a. RGB

b. Gray scale Image

c. both a & b

d. none of the above.

Question:

Which of the given options displays the Modal control in the Actions palette?

d. D

Question:

Which animation mode shows the frame duration and Keyframed layer properties of the videos and animations in a time line?

a. Timeline

Question:

You cannot change the order of the vector masks or working paths in the path palette.

a. True.

Question:

Which option will you select to remove an effect from a style?

a. In the Layers palette, drag the Effects bar to the Delete icon.

Question:
Which among the following is not a right option for selecting web-safe color from the Color Palette?

c. Choose Current Color from the Color Palette Menu.

Question:

Which type of information is not displayed by the info palette?

d. none of above.

Question:

Photoshop supports a maximum pixel dimension of 300,000 by 300,000 pixels per image.

a. True

Question:

What is the use of the Make Work Path command in the Paths Palette?

c. Both a and b

Question:

When you create a new image with the transparent content, the image does not have a background layer.

a. True

Question:

In which of the given instances, a caution icon appears next to the layer comp name as shown in the picture?

d. All of the above.

Question:

Which option will you choose to Refresh a Histogram?

d. All of the above.

Question:

Which option will you select to convert Types to Shapes?

d. Both b and c

Question:
Which of the given options displays left indent in the paragraph palette?

b. B

Question:

Changing units on the info palette automatically changes the units on Rulers.

a. True

Question:

Which of the given options displays an Action Safe Area?

a. A

Question:

Which of the given options displays the Set Tsume option in the Character Palette?

b. B

Question:
Which option will you choose to convert Document Colors into anther profile?

b. Choose Edit>convert to profile

Question:

Which view will you choose to display a Histogram with no Controls or Statistics?

b. Compact view

Question:

Which among the following is/are not true about the Fill pixels (Drawing mode) as shown in the picture?

b. In this mode, you can create vector images

c. Both b and c

Question:
You cannot transform the background color.

a. True.

Question:

Which of the following is not true about a Droplet?

d. none of the above.

Question:
The mask created by the Replace Color command is permanent.

b. False

Question:

Which keyboard shortcut (windows) will you choose to select the History Brush tool?

a. Y

Question:
You cannot arrange the stacking order of the Auto Slices

a. True

Question:

A working space is an intermediate color space used to define and edit color In Adobe application.

a. True

Question:
Which type of images are resolution-dependant?

a. Bitmap images.

Question:
What do you mean by Kerning?

a. It is the process of adding and subtracting spaces between specific pairs of characters.

Question:

Which file format can be used to save Lab images?

d. All of the above.

Question:

Which among the following methods adds pixels by averaging the color values of the surrounding pixels and produces medium-quality results?

a. Bilinear

Question:

When is the Canvas Extension Color Menu not available as shown in the given image?

a. When an image does not contain a background layer.

ANOTHER SET

Question:

Ø Which of the Saving commands is available for an image that is managed by a Version Cue Workspace?

Check In

Question:

Ø Which option will you choose to select all layers of a similar type?

All of the above

Question:
Ø Which of the following Filters cannot be applied to a Smart Object?

Pattern Maker

Question:

Ø With which of the given options does the Signal Strength Meter appear?

It appears when you choose 'merge to hdr command'

Question:

Ø Channels can not be added to which of the following image modes?

Bitmap

Question:

Ø Which among the following Modes does not support layers?

All of the above

Question:

Ø Which of the following is not true about Filters?

None of the above

Question:

Ø Which of the following is not true about the Curves dialog box?

The Curves dialog box lets you adjust up to 14 different points throughout an image's tonal range

Question:

Ø Which of the following Slices is created with the Slice Tool?

User slices

Question:

Ø Which of the following features is supported by the EPS file format?

It supports the Grayscale and Bitmap color modes

Question:

Ø Which among the following blending modes is available only for the Apply Image and Calculations commands?

Both a and b

Question:

Ø What is the use of the Make Work Path command in the Paths palette ?

It can alter the shape of a selection

Question:

Ø Which type of information is not displayed by the Info Palette?

It does not display the opacity of the current layer

Question:

Ø Which among the following is not a right option for selecting a web-safe color from the Color Palette?

Choose Current Color from the Color Palette Menu

Question:

Ø Anti-aliasing option is available for which of the given Tools?

All of the above

Question:

Ø Which of the following options displays the Spot Channels in the Channels palette?

Question:

Ø What happens when Use Legacy is selected as shown in the given picture?

It is used to apply proportionate (nonlinear) adjustments to image pixels

Question:

Ø Which option will you select to open the Levels dialog box?

Choose Image > Adjustments > Levels

Question:

Ø Which type of images are resolution-dependent?

Vector images

Question:

Ø Which Liquify Tool is used to reconstruct a part of a distorted image?

Question:

Ø In which Format will you save your file to preserve the Alpha channels?

All of the above

Question:

Ø Which of the following is not a kind of text type?

Line type

Question:

Ø Which option will you select to convert Types to Shapes?

Both b and c

Question:

Ø The mask created by the Replace Color command is permanent.

FALSE

Question:

Ø Which of the following Layer properties can be animated?

All of the above

Question:

Ø Which View will you choose to display a Histogram with no controls or statistics?

All of the above

Question:

Ø Which of the given options displays left indent in the Paragraph palette?

Question:

Ø Which keyboard shortcut (windows) will you choose to group Layers?

Control + G

Question:
Ø Which among the following QuickTime Video formats is supported by Photoshop extended?

All of the above

Question:

Ø The Rotate Canvas command does not work on which of the following

All of the above

Question:

Ø When will the Dynamic shortcuts appear in the Character Palette Menu as shown in the picture?

All of the above

Question:

Ø Hanging Punctuation controls the alignment of the punctuation marks for a specific paragraph.

TRUE

Question:
Ø Which of the following is not a Color Adjustment command?

Adjustment command

Question:

Ø By default, Masks applied to Smart objects are linked to Smart object layers. .

FALSE

Question:

Ø Changing units on the Info Palette automatically changes the units on Rulers.

TRUE

Ø A working space is an intermediate color space used to define and edit color in Adobe applications.

FALSE

Question:

Ø Which option will you select to remove the existing profile from the document in the given image?

Question:

Ø You cannot change the order of the Vector masks or working paths in the Paths palette.

FALSE

Question:

Ø The Color Replacement Tool does not work in which of the following Image modes?

All of the above

Question:

Ø In which of the following Modes can you draw while working with the Shape or Pen tools?

All of the above

Question:

Ø The Out Of Gamut option works only on RGB and Lab images

TRUE

Question:

Ø Which keyboard shortcut (windows) will you choose to close a Path?

None of the above

odesk ms word 2007 test

2011-12-22T19:02:00.000+06:00

Question:

Edit tracking changes are typically formatted in the following manner: (1) deletions—red strikethroughs, (2) additions—green and underlined, and (3) formatting changes are made bold in almost any other desired color. Where in Word 2007 could you set your own custom formatting options for tracking changes?

a.	Select the Office button and then select Word Options. In the Word Options dialog box, select Proofing and then set your formatting options.
b.	Select the Review ribbon and then select the triangle by Track Changes. In the drop-down menu, select “Change Tracking Options” and then set your formatting options in the Track Changes Options dialog box.
c.	Select the Office button and then select Track Changes. Set your formatting options in the Track Changes Options dialog box.
d.	Select the Office button and then select Word Options. In the Word Options dialog box, select Customize and then set your own customized formatting options.

Question:

Which among the following options should be used to start a bulleted list automatically?

a.	Type * (asterisk) and then press spacebar or the Tab key.
b.	Type # and then press the spacebar key.
c.	Type # and then press Enter.
d.	None of the above

Question:

Which among the following is NOT true about content controls?

a.	They are individual controls that can be used in templates, forms, and documents.
b.	They can be reused.
c.	Customized content controls cannot be distributed.

Question:

Which keyboard shortcut inserts a hyperlink?

a.	CTRL+H
b.	CTRL+M
c.	CTRL+P
d.	CTRL+K

Question:

Which among the following options is not true regarding a macro?

a.	A macro is used to automate a complex series of tasks.
b.	The macro recorder is used to record a sequence of actions, or to create a macro from scratch by entering a code in the Visual Basic Editor.
c.	To work with macros in Word 2007, the Review tab needs to be opened.

Question:

The Ribbon is a new feature for Microsoft Office 2007. There are several ways to turn off the Ribbon in order to save space on your computer. Which of the following can optionally turn off the Ribbon in Word 2007?

a.	Click the Down arrow to the right of the Quick Access toolbar button and select “Minimize the Ribbon.”
b.	Select the View tab and select the “Document Map” check box option in the Show/Hide group.
c.	Press Ctrl+F1. (Press Ctrl+F1 a second time to make it reappear again.)
d.	Double-click the currently active tab (the tab that is in focus) above the Ribbon.
e.	All of the above

Question:

How will you set the default font so that every time you open Microsoft Word it will use the settings that you had selected?

a.	Click on the Microsoft Button and select Word options. Click on Display and then select “Default font settings.”
b.	Select the Home tab, and then click the Font Dialog Box Launcher. Select the font style and size. Click on Default… and then click Yes.
c.	Both a and b
d.	None of the above

Question:

How will you change the author name in an existing document?

a.	Click on the Microsoft Office Button, select Prepare, and then click Properties. Type the author name in the Author box.
b.	Click on the Microsoft Office Button, click on Word Options, and click Popular. Under “Personalize your copy of Office,” type the author name in the “User name box.”
c.	Right click on the customize status bar and select Author Name from the list and then type a new one.
d.	All of the above

Question:

Which among the following wildcards should be used to select any single character?

a.	<
b.	>
c.	?
d.	*(its for group of character)

Question:

State whether true or false:A building block can be added to as many galleries as you want.

a.	True
b.	False

This question is based upon the figure shown below

Question:

Refer to the given picture. Which of the following buttons is used to show paragraph marks and other hidden formatting symbols?

a.	A
b.	B
c.	C
d.	D

Question:

State whether true or false:New text animation effects can be applied in Microsoft Word 2007.

a.	True
b.	False

Question:

Which among the following is a correct way to make your file “Read-only?”

a.	Click on Open from the Microsoft Office Button. Click on Tools, select the Read-only recommended check box. Click OK.
b.	Select the text you have typed, right click on the mouse and select the “As Recommended” option and save it.
c.	Click “Save As” from the Microsoft Office Button. Click on Tools and then click General Options. Select the Read-only recommended check box. Click OK. Click on Save.
d.	None of the above

Question:

State whether true or false:Changes that are made on the Worksheet are automatically updated in the chart.

a.	True
b.	False

This question is based upon the figure shown below

Question:

What does the icon marked with ‘A’ on the status bar on the bottom of the page indicate in the given picture?

a.	It indicates that the document contains a virus.
b.	It indicates a watermark.
c.	It indicates that Mail Merge is over.
d.	It indicates that the document contains a signature.

Question:

Which among the following is not true regarding the use of a pie chart?

a.	A pie chart could be used when there is only one data series to be plotted.
b.	A pie chart could be used when the data points in a pie chart are displayed as a percentage of the whole pie.
c.	A pie chart could be used when none of the values that need to be plotted on the chart is negative.
d.	A pie chart should be used when there are more than seven categories.

This question is based upon the figure shown below

Question:

Which feature has been used from the Picture Pane on Picture1 to achieve the same result as Picture2?

a.	Compress Picture
b.	Set contrast to −40%
c.	Set brightness to +40%
d.	Recolor

Question:

Which among the following charts do not have axes?

a.	Bar charts
b.	XY (Scatter) charts
c.	Doughnut charts
d.	Area charts

Question:

Which of the following is not a type of “Section Breaks?”

a.	First Page
b.	Next Page
c.	Continuous Page
d.	Even Page(another type is odd page)

Question:

What is meant by Enhanced ScreenTips?

a.	Enhanced ScreenTips are small windows that display descriptive text when the pointer is rested on a command or control.
b.	Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic.
c.	Enhanced ScreenTips are a type of Font Style that can be customized according to the requirements.
d.	None of the above

Question:

State whether true or false: When you save a document as a Web page, the textures and gradients are saved as JPEG files and the patterns are saved as GIF files.

a.	True
b.	False???????????????????????

Question:

What does the command “Winword.exe /f MyDocument.docx” mean?

a.	This command instructs Word to run a macro which is stored in a file named Mydocument.docx.
b.	This command instructs Word to close a file named Mydocument.docx.
c.	This command instructs Word to start and immediately open a file named MyDocument.docx.
d.	This command instructs Word to start and shows the contents of a file named MyDocument.docx on the Web.

Question:

Which among the following options will you use to add a command to the Quick Access Toolbar?

a.	Click on Customize Quick Access Toolbar and then click “More Commands” and choose the command from the list to be customized.
b.	Click on the Microsoft Button and then select Word Options. Click on Customize.
c.	On the Ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar. Right-click on the command, and then click on “Add to Quick Access Toolbar” on the shortcut menu.
d.	All of the above

Question:

Suppose you want to insert a cross reference at the current cursor position in the document to a heading (located elsewhere in the document). Which of the following methods would do this in Word 2007?

a.	Select the Add-Ins tab. In the Hyperlinks section, click Cross-reference. Select the desired heading among all those displayed in the dialog box. After you have made your selection, click Insert. Close the dialog box.
b.	Select the Insert tab. In the Links section, click Cross-reference. Select Headings under Reference type. Select the appropriate heading from those displayed in the bottom pane. After you have made your selection, click Insert. Close the dialog box.
c.	Select the Add-Ins tab. In the Links section, click Hypertext. Select the desired heading among all those displayed in the dialog box. After you have made your selection, click Insert. Close the dialog box.
d.	None of the above. Word 2007 cannot do cross references.

Question:

Which method determines the position of the “Envelope” while printing, in the Envelope options dialog box?

a.	Rotation method
b.	Feed method
c.	Position method
d.	None of the above

Question:

Which keyboard shortcut is used to make the text size smaller?

a.	ALT+SHIFT+X
b.	CTRL+SHIFT+>
c.	CTRL+SHIFT+<
d.	ALT+SHIFT+I

This question is based upon the figure shown below

Question:

For what purpose is the SmartArt graphic control used, as shown in the picture?

a.	It is used to rotate the SmartArt graphic.
b.	It is used to add a watermark on shapes.
c.	It shows the Text Pane on clicking the control.
d.	None of the above

Question:

Which of the following charts display “Error bars” for x values, y values, or both?

a.	XY (Scatter) charts
b.	Bubble charts
c.	Both a and b
d.	None of the above

Question:

Which of the following line-spacing options sets fixed line spacing that Word does not adjust?

a.	Doubled
b.	Exactly
c.	At least
d.	Multiple

This question is based upon the figure shown below

Question:

Refer to the picture given above. Which of the following options should be selected to scroll both documents together?

a.	A
b.	B
c.	C
d.	None of the above

Question:

Which keyboard shortcut could be used to switch to Draft View?

a.	ALT+CTRL+P
b.	ALT+CTRL+O
c.	ALT+CTRL+N
d.	None of the above

Question:

Which among the following is a keyboard shortcut to underline blank spaces for a form?

a.	Ctrl + Hyphen(-)
b.	Shift + Hyphen(-)
c.	Alt + Hyphen(-)
d.	All of the above

Question:

Which view(s) could be used to view the Equation placeholders in the Document Views group?

a.	Print Layout view
b.	Web Layout view
c.	Draft view
d.	All of the above

Question:

State whether true or false:Placeholder citations appear in the bibliography.

a.	True
b.	False

Question:

Which option(s) should you select to remove a chart or axis title from a chart?

a.	To remove a chart title, select the Layout tab. In the Labels group, click on Chart Title and then click None.
b.	To remove a chart or axis title, click on the title and press Delete.
c.	To remove an axis title, select the Layout tab. In the Labels group, click on Axis Titles, click the type of axis title, and then click None.
d.	All of the above

Question:

State whether true or false:Cover pages are always inserted at the beginning of a document, no matter where the cursor appears in the document.

a.	True
b.	False

Question:

State whether true or false:Gridlines do not print when a document is printed.

a.	True
b.	False

This question is based upon the figure shown below

Question:

Which among the following settings should be applied in the “Format Drawing Canvas” dialog box, as shown in the picture, to remove a border from a drawing object?

a.	Change Dashed to none
b.	Change Weight to 0 pt
c.	Change Line — Color to No Color
d.	Change Style to none

This question is based upon the figure shown below

Question:

How does the “Gutter margin” help while using Page Setup, as shown in the picture?

a.	It ensures that the text is not obscured by binding.
b.	It prevents the “Full Screen Reading” view from opening automatically.
c.	It displays the field results instead of field codes.
d.	All of the above

Question:

State whether true or false:Switches and parameters are not case-sensitive.

True

False

Question:

Which of the following options is the reason of text deletion at the insertion point when you type a document?

a. The”Mark formatting inconsistencies” is unchecked in word options.

b. The “Use the insert key for paste” is turned off in word options.

c. The “Show add-in interface errors” is turned on in word options

d. The “Over type” mode is turned on in word options.

Question:

The question is based upon the figure shown below:

Refer to the given image which options should be selected to

a. A

b. B

c. C

d. D

Question:

The draft view was called the normal view in versions of word prior to word 2007. The draft view can help with setting the page and section breaks for the document. Which of the following could be used to select the draft view for a document?

a.Open the view ribbon. Click draft in the document views group.

b.Select the office button and then select word options. In the word options dialogue box, select display and check draft check box under page display options.

c. Click draft icon on the status bar

Question:

Which among the following options would you choose to automatically enter the current date?

a. Select the insert tab and then select date and time in the text group. Choose one of the available formats in the date and time dialog box.

b.    Type the first four characters of the current day of the week.
c.      Select the home tab and then select date in the text group. Choose one of the available formats in the date dialog box.
d.     None of the above.

Question:

The question is based upon the figure shown below:

Which chart type does the given picture represent?

a. Surface charts

b. Stock charts

c. XY(scatter) charts

d. Area charts

Question:

The question is based upon the figure shown below

In the given picture the “The keep text flat” option has been selected. What is the use of this feature?

a. When this option is selected , the text inside the shape follows the shape’s front surface as it rotates

b. It moves the shape backward or forward in 3-D space.

c. It prevents text inside the shape from rotating when the shape is rotated.

d. All of the above.

Question:

State whether true or false

Gridlines do not print when a document is printed

a. True

b. False

Question:

The question is based upon the figure shown below

The given picture shows the list items being at different level rather than at one level. What is this list known as?

a. Bullets

b. Numbering

c. Line spacing

d. Multilevel

Question:

How will you insert text boxes for a printed form?

a. Select the insert tab, in the header & footer group select the Text box

b. Select the insert tab, In the text group, click on Text box and then select draw text box.

c. Select the page layout tab, in the page setup group, select the Text box.

d. None of the above.

Question:

Which among the following options will you use to add a command to the quick access toolbar?

a. Click on customize quick access toolbar and then click “more command” and choose the command from the list to be customized.

b. Click on the Microsoft button and then select word options. Click on customized.

c. on the ribbon, click the appropriate tab or group to display the command that you want to add to the Quick access toolbar. Right click on the command and then click on “Add to quick access toolbar” on the shortcut menu.

d. All of the above.

Question:

Which of the following is not true about “format painter”?

a. Format painter is used to apply text formatting and some basic graphics formatting, such as border and fills.

b. Format painter works best with drawing objects, such as autoshapes.

c. Format painter can copy the font and font size on WordArt text.

Question:

Which among the following options will be select a paragraph at once with the help of a mouse?

a. Double-click anywhere on the word.

b. Triple-click anywhere in the paragraph

c. Click at the start of the selection

d. None of the above.

Question:

Just as in Word 2003 or prior word versions, the default standard view for word 2007 is the draft view ( and is still also called the normal view in Word 2007)

a. True

b. False

Question:

To enter a symbol or special character into your document (to where the cursor is located), which of the following method could you employ in word 2007?

a. Open the home ribbon, click special characters in the symbol group ( open e menu displaying special characters). Choose the special character (or symbol) that you want and then click insert and click close.

b. Open the insert ribbon. Click special character in the text group (opens a menu displaying special characters) Choose the special character (or symbol) that you want and then click ok.

c. Open the insert ribbon, click symbol in the symbols group. A menu will appear with a small selection of symbols. If you don’t see the symbol or character you’d like to insert, click more symbols. Choose the special character (or symbol) that you want then click insert and click close.

d. Open the home ribbon, click symbol in the text group. A menu will appear with a small selection of symbol. If you don’t see the symbol or character you’d like to insert, click more symbols. Choose the special character (or symbol) that you want and then click ok.

Question:

The question is based upon the figure shown below

Refer to the given image, which option should be chosen to select the styles that appear by default in the recommended list while formatting?

a. A

b. B

c. C

d. None of above

Question:

Refer to the given image in picture 1, axes appear on the left side, which setting should you use to make them appear on the right side, as shown in picture 2?

a. Change the axes value in the format tab

b. Select the axis options tab in the format axis dialogue box. Set the axis levels: field to high

c. Right click the mouse and select format chart area and change the axis value.

d. None of the above.

Correct method → right click on the chart→ format axes→ axes option→tik mark on “CATEGORIES IN REVERSE ORDER”

Question:

What is the maximum number of columns that can be created in the columns dialog box as shown in the picture?

a. 3

b. 9

c. 13

d. 19

Question:

Which among the following is a keyboard shortcut to cut a table?

a. CTRL+A

b. CTRL+V

c. CTRL+C

d. CTRL+X

Question:

Which of the given options shows the “command button” (active X control) in the given picture?

a. A

b. B

c. C

d. D

Question:

State whether true or false

Once a bullet is removed from the “Bullet Library” and it is no longer available in the “Documents bullets” area, the bullet cannot be added back to the bullet library.

a. True

b. False

ANOTHER SET

Q.Which among the following macro settings is meant for developers only?

d. Trust access to the VBA project object model

Q.Which of the following can be reason for the appearance of the red X, as shown in picture?

????????

Q. Which among the following is a keyboard shortcut to underline blank spaces for a form?

b. Shift+Hyphen(-)

Q. Why is the “Different First Page” option used in the Page Setup dialog box as shown in the given picture?

d. All of the above.

Q. Which among the following options should be used to number the cells in a table?

c. Select the table cells that need to be numbered. On the Home tab, in the Paragraph group, click on Numbering.

Q. In the given picture, The “Washout” option has been selected. What purpose does it serve?

??????

Q. How will the Message Bar alert be enabled as shown in the given picture?

b. Select Word Options from the Microsoft Office Button. Click on the Trust Center, then click Trust Center Settings and then click Message Bar.

Q. What steps should be followed to replace a shape with other shape?

a. Select the shape to be changed. Select the Format tab; use the “Change Shape” button in the Shape Style group.

Q. Which among the following options could be used to turn off the Office Clip Board?

d. All of the above

Q. Which among the following methods would you select when you want to add protection to parts of a template?

d. All of the above

Q. An existing table cannot be copied and pasted into another table.

a. True (not sure)

Q. With the help of which view will the watermark not be seen?

b. Full screen reading view???????????

c. Web layout view??????????????

Q. What is the purpose of the “Demote” button as shown in the diagram?

d. All of the above.

Q. Which of the following is not a Content Control?

d. Chart

Q. Refer to the given image, How could the Quick Access Toolbar be moved?

c. Click on “Customized Quick Access Toolbar”, in the list, click on “Show Below the Ribbon”.

Q.Which of the following types of charts are not supported by either Lines or Bars, as shown in the picture?

b. Stacked Bar in 3d