Which statement describes what the Conditional Formatting option in Excel 2016 allows users to do?
Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?
Shreya has combined all the cells in a single leftmost column in a table. Instead of identifying the category multiple times, she would like to combine these cells and then structure the word "Appliances” vertically in the cell.Where will Shreya find these options?
Priya has created a document and will now create a table of contents.Which statement describes the items that will automatically be added into the table of contents?
What are the different options in a page layout feature? Select three options.create multiple columnsadd images and shapesadd section breakscreate table of contentsadd line numbers
Which step ensures that the page margins are not too narrow?
Which formula represents the correct arguments for the SUMIF function?
Robert needs to apply formatting from one set of text to multiple other sets of text throughout the document.Which option should he use?
Naomi would like to reorder the worksheets in a workbook. What is the easiest method of doing this?
Which command suppresses the visibility of a particular row or column in a worksheet?
Did you find these answers helpful?