DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Navigate to the Data tab on the ribbon
|
|
|
Right-click or access the context menu on a chart or sparkline
|
|
|
Select a range of cells
|
|
|
Select Conditional Formatting from the Home tab on the ribbon
|
|
|
None
|
Detailed explanation-1: -Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Or, press Ctrl + Q.
Detailed explanation-2: -Click the Quick Analysis Smart Tag icon or press Ctrl + Q. A gallery appears with tabs across the top and buttons below each tab. Click the Totals tab. Point to the button with the type of total calculation you would like to use such as Sum (if you simply point to the button, you will see a live preview).
Detailed explanation-3: -To access the Quick Analysis tool for Excel, select the cells that contain the data you want to analyze. You’ll see the Quick Analysis tool button appear at the bottom-right of your selected data. After you click the icon, you’ll see the Quick Analysis menu.