Exam 15: Customizing Your Workspace Text and Graphics
Exam 1: Getting Started With Excel101 Questions
Exam 2: Formatting Workbook Text and Data63 Questions
Exam 3: Performing Calculations With Formulas and Functions38 Questions
Exam 4: Analyzing and Charting Financial Data48 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks27 Questions
Exam 6: Managing Data With Data Tools50 Questions
Exam 7: Summarizing Data With Pivottables39 Questions
Exam 8: Performing What-If Analyses22 Questions
Exam 9: Exploring Financial Tools and Functions5 Questions
Exam 10: Analyzing Data With Business Intelligence Tools25 Questions
Exam 11: Exploring Pivottable Design22 Questions
Exam 12: Developing an Excel Application60 Questions
Exam 13: Customizing Your Workspace Text and Graphics10 Questions
Exam 14: Customizing Your Workspace Text and Graphics3 Questions
Exam 15: Customizing Your Workspace Text and Graphics53 Questions
Select questions type
Brielle wants to increase the size of a SmartArt graphic in her worksheet. To do so, she clicks the following series: Shape > Format tab > SmartArt tools . What should she do next to resize the object proportionally?
Free
(Multiple Choice)
5.0/5
(31)
Correct Answer:
A
Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?
Free
(Multiple Choice)
4.9/5
(32)
Correct Answer:
C
Which of these series of clicks will you select to add text to a SmartArt?
Free
(Multiple Choice)
4.9/5
(36)
Correct Answer:
B
Which of these series of clicks will you use to promote a shape in an Excel sheet?
(Multiple Choice)
4.9/5
(33)
Smith creates a basic cycle graphic with five shapes and then decides to add a sixth one below it. To do this, he clicks the down arrow to the right of the Add Shape button on the SmartArt Tools under Design tab, and then selects an option from the menu to finish the task. Which of these must he have selected from the menu options?
(Multiple Choice)
4.9/5
(34)
Colin wants to apply a Quick Style to a SmartArt graphic. To do so, he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice. Which of these can X be in the following series of clicks?
(Multiple Choice)
4.9/5
(40)
Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?
(Multiple Choice)
5.0/5
(33)
Braydon wants to sharpen a picture to the maximum limit to make it more appealing. He clicks on the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools. What should he select from the drop-down menu that appears on clicking Sharpen/Soften?
(Multiple Choice)
4.8/5
(38)
Misha wants to set the brightness of a picture to 40% and contrast to 20%. She clicks the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools. What should she select from the drop-down menu that appears on clicking Corrections and then select the thumbnail that fulfils her purpose?
(Multiple Choice)
4.9/5
(45)
To turn track changes on in an Excel sheet, click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).
(True/False)
4.9/5
(45)
Esther wants to accept track changes in a file. To do this, she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab. She then clicks Accept to accept the track change. What can X in the procedure be?
(Multiple Choice)
4.9/5
(26)
Issac wants to add a border to a picture in a worksheet. To do so, he clicks the following series: Picture > X > Arrow next to Picture Border > Select color of choice. Which of these can X be in the following series of clicks?
(Multiple Choice)
4.7/5
(33)
Margaret wants to resize a shape in a SmartArt graphic in her worksheet proportionally. To do so, she selects the shapes in the shape in the SmartArt graphic to modify and clicks the Format tab under SmartArt Tools. What should she do next to resize the object proportionally?
(Multiple Choice)
4.9/5
(40)
To insert an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.
(True/False)
4.9/5
(36)
Return value comments help others understand what values are returned by a procedure.
(True/False)
4.7/5
(34)
Stephen wants to reduce the sharpness of a picture set to the maximum limit in his worksheet. He clicks the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools. What should Stephen select from the drop down menu that appears on clicking Corrections?
(Multiple Choice)
4.9/5
(35)
Which of the following lets you resize a selected picture on your worksheet?
(Multiple Choice)
4.9/5
(37)
To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.
(True/False)
4.8/5
(45)
In order to reject changes made by all users in a workbook, click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook) > Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.
(True/False)
4.8/5
(31)
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?
(Multiple Choice)
4.7/5
(39)
Showing 1 - 20 of 53
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)