Exam 15: Collaborating with Your Team.(Digital Only).
Exam 1: Getting Started With Excel93 Questions
Exam 2: Formatting Workbook Text and Data58 Questions
Exam 3: Performing Calculations With Formulas and Functions37 Questions
Exam 4: Analyzing and Charting Financial Data47 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 Graphics.(Digital Only).10 Questions
Exam 14: Introducing Power BI (Digital Only).3 Questions
Exam 15: Collaborating with Your Team.(Digital Only).53 Questions
Select questions type
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
(89)
To edit a comment in a cell,select the cell that contains the comment,right-click on it and select the Edit Comment option from the menu.
(True/False)
4.8/5
(75)
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.8/5
(89)
To delete comments,select the cell that contains comments,right-click on it and select Delete Comment option from the menu.
(True/False)
4.8/5
(85)
Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010,or 2013.To do so,he can click File > Info > Check for Issues > Check Compatibility > OK.
(True/False)
4.7/5
(82)
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)
5.0/5
(88)
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.8/5
(84)
To check your workbook for features that assist people with disabilities,you can use the Ability Checker.
(True/False)
4.8/5
(99)
To make your workbooks usable by people with disabilities,you can add alternative text to worksheet images.
(True/False)
4.9/5
(82)
Lilia wants to mark a workbook as final to let users know that it is a Read-Only file.To do so,she can click File > Info > Protect (Document,Presentation,or Workbook)> Protect Current Sheet > OK.
(True/False)
4.8/5
(80)
Johnson doesn't like the organization of information in a SmartArt graphic and wants to change its layout to fit the content better.To do so,he follows this series of clicks: SmartArt graphic > Design tab > X > More drop-down menu > Select layout of choice.Which of the following can X be?
(Multiple Choice)
4.7/5
(87)
Which of these series of clicks will you use to promote a shape in an Excel sheet?
(Multiple Choice)
4.8/5
(82)
Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.
(True/False)
4.8/5
(80)
Which of the following will you select as X in the following series of clicks to apply a shape style: Shape > Format tab > Shape Styles > X > Style (of your choice)?
(Multiple Choice)
4.8/5
(77)
What is the default number of days for Excel change history?
(Multiple Choice)
4.8/5
(83)
Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file.He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice.What can X in this series of clicks/ selections be?
(Multiple Choice)
4.9/5
(89)
To provide suggestions to other people using your document,select the text you want to comment on,then click New Comment on the Review tab and type your comment.
(True/False)
4.8/5
(78)
Return value comments help others understand what values are returned by a procedure.
(True/False)
4.7/5
(84)
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
(82)
Showing 21 - 40 of 53
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)