Where is the option to insert a PivotTable in Excel 2019 located?
Where can the options for inserting form fields and other document controls be found?
Where are options to add a border around the outside of a chart found?
Karen would like to apply a group of colors, fonts, effects, and styles very quickly to a document that she has created.Which of these styles should she use?
Which method deletes a footer from a document?
Elan needs to ensure that he can control the order of operations in his formulas. Which characters are used to provide the highest precedence?
Lonnie has several workbooks that contain financial and sales data. He needs to ensure that if the data in a single cell in one workbook changes that it is automatically updated and reflected in another workbook.What should Lonnie create?
Seneca needs to combine multiple cells into a single column heading. Which option should she use?
Ryan has inserted an image into a Word document, but the image is too large. There are sections of the image that he would like to eliminate to decrease the overall size of the image.Which option should Ryan use?
Fiona is starting to utilize the protection capabilities of Excel 2019. For the Lock or Unlock Cells function to work, which option should be enabled?
Which option should not be considered a security feature because the option can easily be removed, and additional edits can be made to a document?
Which of these functions may be used with positional arguments? Select four options.AVERAGECOUNTIFCOUNTSUMMAX
Carla needs to be able to quickly switch back and forth between open worksheets. Which option should she use?
Which option represents the location of the Goal Seek function?
What options does the Table Tools Layout contextual tab contain? Select three options.modify text directionchange fontinsert rows and columnsadd border and shadingsplit table
Stephen needs to insert a field into a building block that will contain variable data. Which keyboard shortcut can he use to toggle between data and the field codes?
Lira has typed up a document and now she wants to adjust the irregular right edge of the text so that it is even. How can she accomplish this?
Which sparkline type is best for displaying trends in data changes over time?
Jin needs to add a row into his spreadsheet, but he does not want to remove any existing data. Which combination of options should he use?
Nadia would like to find text in her current document that differentiates CompanyABC from companyabc.Which option should she use?
Did you find these answers helpful?