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
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?
Free
(Multiple Choice)
4.8/5
(31)
Correct Answer:
D
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
(36)
Correct Answer:
A
To embed an object from another application,click Insert > Object > (Dialog box)> Create New > Object Type (select the application you want to use)> OK.
Free
(True/False)
4.9/5
(27)
Correct Answer:
False
Which of the following should be clicked to change the caption of a control after right-clicking on it?
(Multiple Choice)
4.8/5
(43)
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.8/5
(39)
Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously.For this,she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box.What can X and Y be in the series of clicks?
(Multiple Choice)
4.9/5
(31)
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.8/5
(45)
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)
4.9/5
(32)
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
(25)
While moving a picture in Excel,one can select it and hover the mouse over it until the pointer changes into a particular shape,then click the image and drag it to the required location.What is the shape into which the mouse pointer changes during this procedure?
(Multiple Choice)
4.8/5
(32)
To edit a comment in a cell,right-click on the cell containing the comment,select Edit Comment in it,then make the necessary changes in it and click on the cell again.
(True/False)
4.9/5
(36)
To go to a previous comment,use the Previous button in the Comments group on the Review tab.
(True/False)
4.8/5
(33)
Kimani is working on a data set in which she has to add pictures into cells adjacent to the respective names of objects in her file.To do so,she clicks on the following series: Insert tab > X > Pictures > Insert Picture dialog box > Locate the picture that she wants to insert into a cell in Excel > Insert > Format tab > Y > Edit height and width to fit into cell > Place picture into cell.What can X and Y in the series of clicks/entries be?
(Multiple Choice)
4.8/5
(39)
Which of the following should be selected in the Quick Access Toolbar to email a workbook as an attachment?
(Multiple Choice)
4.9/5
(40)
To show a comment in an active cell,select the cell,then click Review tab > Comments group > Show/Hide Comment.
(True/False)
4.9/5
(38)
To highlight track changes in a worksheet,go to the Highlight Changes dialog box and check the box for Highlight changes on screen,then click OK.
(True/False)
4.9/5
(28)
Jenny wants to change the style of a SmartArt in her worksheet.To do so,she clicks the shape in the SmartArt graphic.She then clicks on an option under SmartArt Tools,on the Format tab,in the Shape Styles group and then selects the thumbnail she wants.What can the option that she selected under SmartArt Tools be?
(Multiple Choice)
4.8/5
(45)
Which of the following does the Accessibility Checker look for? Select all the options that apply.
(Multiple Choice)
4.7/5
(24)
To accept a suggested spelling for that instance only,which of the following would you click?
(Multiple Choice)
4.8/5
(35)
Which of the following steps will you take to demote a shape on your spreadsheet?
(Multiple Choice)
4.8/5
(35)
Showing 1 - 20 of 53
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)