RibbonĮxplanation: Users can utilize the ribbon or keyboard shortcuts in order to cut, copy, and paste in Excel. Users can utilize which items to cut, copy, and paste in Excel 2016? Choose two answers. The key is present on Apple and PC keyboards. Which key allows users to quickly highlight cell ranges in Excel 2016 in order to cut, copy, or paste data? ShiftĮxplanation: The Shift key allows users to quickly highlight cell ranges in Excel in order to cut, copy, or paste data. TrueĮxplanation: Excel 2016 makes it easy to remove conditional formatting since users do not need to highlight data in order to remove it.Ĭonditional formatting is removed in the same area as where it is added. The user does not need to highlight data within an excel worksheet in oder to remove conditional formatting. Users can also apply cell formats from this tab.

Conditional formatting is performed from which tab in Excel 2016? HomeĮxplanation: Conditional Formatting is performed from the Home tab in Excel 2016. TrueĮxplanation: Excel will not be able to ungroup any grouped data that is not selected.ĭata is ungrouped in the same area it is grouped. In order to ungroup a cell range, the range will need to be selected. These items can be configured under the Design tab. MarkesĮxplanation: The style of a sparkline can be customized and markers can be added to sparklines in Excel. Users can customize sparklines in Excel 2016 using which items? Choose two answers. This action makes it easy to pick and choose which cells get certain formats Which are the three types of sparklines in Excel 2016? -ColumnĮxplanation: Line, column, and win/loss are the three types of sparklines in Excel 2016.Ī sparkline can be thought of as a miniature chart. CtrlĮxplanation: When applying cell formats in Excel, users can hold down the Ctrl key to select individual cells they wish to apply formats to. When applying cell formats in Excel 2016, users can hold down the _ key to select individual cells they wish to apply formats to. This item can be altered from the Number group of the Home tab.

Users can alter where the _ is for any number in Excel 2016 DecimalĮxplanation: Users can alter where the decimal is for any number in Excel.

Remove drop down menu in excel 2016