facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Working with Images & Graphical Elements Excel Test
Excel 2010 Training - Graphical Elements in Excel
Free Online Microsoft Excel Test

* How to Insert an Image
* How to Insert Shapes
* Working with SmartArt
* Changing the Background Color

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Working with Images & Graphical Elements Excel Test


1) How do you insert a phot that you have saved on your computer into an Excel worksheet?
a) By clicking on the Insert tab and select the photo from the Photo Gallery group.
b) By clicking on the Insert tab, selecting Picture and locating the photo on your PC to select and insert.
c) By clicking on the Images contextual tab and selecting the photo on your PC to insert.
d) You cannot insert photos into an Excel worksheet.

Question 2 Image: Working with Images & Graphical Elements Excel Test
2) Study the screenshot above.  What happens if you click and drag the handle circled in orange towards the left?
a) The image will be rotated to the left.
b) The image will be resized to the left.
c) The image will be moved to the left.
d) All of the options listed above are correct.



3) What is SmartArt?
a) It is special formatting that you can apply to images and photos in Excel that allows you to draw and add color.
b) It is a type of mathematical diagram that is used in Excel for special calculations.
c) It is a way of inserting scanned drawings, graphics and charts into an Excel worksheet.
d) It is a predesigned graphical and visual representation of lists, hierarchical structures, processes, cycles and more.

4) Where on the Ribbon will you find the option to insert SmartArt?
a) Under the Insert tab in the Charts group.
b) Under the Insert tab in the Shapes group.
c) Under the Insert tab in the Illustrations group.
d) All of the options listed above are correct.


Question 5 Image: Working with Images & Graphical Elements Excel Test
5) Study the image above.  What is the quickest and easiest method of adding text to this SmartArt diagram?
a) By clicking on the arrow to the left of the diagram to launch the textbox and typing text directly into this box.
b) Dragging and dropping text on the shape.
c) Inserting separate text box shapes with the text in them into the diagram.
d) All of the above options are correct.

Question 6 Image: Working with Images & Graphical Elements Excel Test
6) Study the screenshot above.  What will happen if you drag the corner handle (circled in yellow) upwards and to the right?
a) This will rotate the selected shape to the right.
b) This will move the selected shape upwards and to the right.
c) This will launch the SmartArt textbox.
d) This will enlarge the selected shape.


7) Lucy created a SmartArt diagram and now wishes to change the design.  For some reason the SmartArt Tools Design tab is not visible.  What is the problem?
a) It is a contextual tab that will only be visible if the SmartArt diagram is selected.
b) It needs to be enabled as a tab on the Ribbon via the Excel Options dialogue box.
c) The SmartArt options have expired.  You are only able to edit it for up to 90 days after creating it.
d) None of the options listed above are correct.


Question 8 Image: Working with Images & Graphical Elements Excel Test
8) Study the screenshot above.  What happens if you click the arrow circled in yellow?
a) The selected diagram will be inserted into the worksheet.
b) The SmartArt Layouts Gallery will expand.
c) The Ribbon will be hidden.
d) None of the options listed above are correct.


9) How do you change the background color of a worksheet?
a) You cannot change the background color of a worksheet in Excel.
b) You have to change the background color setting in the Excel Options dialogue box under Background Settings.
c) Select the whole worksheet.  In the Fonts group under the Home tab, pick a color from the Fill Color Gallery.
d) All of the options listed above are correct.

10) How do you remove a background image from a worksheet?
a) Select the whole worksheet and press delete.
b) Click on the Fill Color Gallery button and select White from the options.
c) Change the Theme of the worksheet to No Background – Text Only.
d) Click on the Page Layout tab and in the Page Setup group, click No Background.