Assuming Victoria is using Adobe
Photoshop to create her brochure, below are the steps she is required to
follow.
She should first open the image on
Photoshop, click on the image option and select duplicate just in case the
resized image is not what she wants.
Still on the image option, she
should select Image size. A screen will pop up at this point, indicating the
image’s current size. For the purposes of image resizing, Victoria should
select Pixel dimensions category.
She should be able to type her preferred
dimensions for both the width and height. She should make sure ‘Constrain
Proportions’ is unchecked to be able to type in separate values.
If she decides to use the photo editing
program, she can simply click on the image, and if resize handles appear around
it, she can click and drag those to the desired size.
Answer:
Following are the solution to this question:
Explanation:
Some of the data is missing in the question, which is defined in the attached file. Please find it.
Follows are the formula which is used in the question:
- EmployeeAnalysis Worksheet IF(C5>49,"Certified","Not Certified")
- Transactions Worksheet IF(F10="No","",0.07)
In the first condition, it checks "C5" is greater than 49 if the condition is true, it will give "Certified" otherwise, it will give "Not Certified".
In the second condition, it checks "F10" is equal to "No" if the condition is true, it will give a blank or space otherwise, it will give "0.07".
She should use a condition-controlled loop. Because it uses a True/False and it will not continue until the task is done
