Adobe Photoshop CS3 UpWork Test Answers

Question:
How would you select an entire PivotTable report?
None of the above  

Question:
Which among the following options displays Legend entries in the given picture?    
b.B

Question:
When does the error, as shown in the picture, occur?
c.It occurs when a negative time is used

Question:
Which keyboard shortcut should be used to minimize or restore the ribbon?
b. CTRL+F2   

Question:
Which of the following options would you choose to clear a PivotChart report?
c. None of the above

Question:
State whether true or false:
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
a. True       

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

Question:
What is the option on the Document Inspector that finds the content type information?
d.  Hidden Rows and Columns

Question:
State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet. 
b. False

Question:
State whether true or false:
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
b.False

Question:
When would the data validation command be unavailable on the data tab?
c. When the workbook is shared or protected 

Question:
Refer to the given image. What will be the result if the formula =B3&", "&A3 is applied on the given table?
b. It will display Fuller Andrew

Question:
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
a.  Consolidate by position

Question:
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?
c. None of the above

Question:
Which file format is typically used to remove printer corruption?
c.  SYLK format 

Question:
State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.
a.True

Question:
Which chart displays axes but cannot display axis titles?    
d.  Pie chart

Question:
How will you find cells with data validation?    
b. On the View tab, in the Windows group, click Data Validation

Question:
Where can the 'Show All Comments' command be found?
c.  On the Review tab 

Question:
Which of the given methods would you follow to add an alternative text to a picture?
b.     Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text 

Question:
As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
d.     None of the above 

Question:
How should blank cells be inserted on a Worksheet?
a.  Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'

Question:
Which of the following charts have no axes?    
c. Both a and b

Question:
Refer to the given image. What is the purpose of the cell denoted as 'A' in the worksheet? 
b. It selects a large range of cells in the worksheet 

Question:
Which of the following is not true regarding naming a cell?
d.  Some keyboard characters can cause unexpected results if used in cell names    

Question:
Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
c.  By value field  

Question:
What is the purpose of using the Keep text flat option, as shown in the picture???
b. It prevents the text from blurring 

Question:
How would you assign a Macro to a graphic?
b.  On the View tab, click on Macros and then click 'Assign Macro' on the shortcut menu. In the Macro name box, click on the macro that you want to assign                --

Question:
What does the screen tip displaying "Showing All" mean?
b. It means that Filtering has been enabled but not applied  

Question:
State whether true or false:
A Macro project can be digitally signed.
b.   False 

Question:
Which of the following is not a valid file extension in which an Excel file can be saved?
d. All of the above are valid 

Question:
Which of the following is not true regarding column width?
b. A column width between 0 to 255 can be specified 

Question:
Which among the following settings is the default macro setting?
d.  Enable all macros 

Question:
Which keyboard shortcut should be used to enter the current time?
b.  CTRL+SHIFT+: 

Question:
Which tab should be used to display or hide axes?
c. Insert tab 

Question:
Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
b.  B 

Question:
State whether true or false:
No data is deleted when an outline is hidden or removed.
b.  False 

Question:
How will you reverse the direction of a SmartArt graphic?
c.  Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left  

Question:
What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
c.  It signifies that the cell contains a macro 

Question:
State whether true or false:
A Macro project can be digitally signed.
a.   True