Questions and Answers
How do you check for compatibility issues in a workbook?
What is the process to cut cell B7 and paste it to cell E12?
Select cell, click Cut, then paste.
How do you add the current date to the center section of the header?
Switch to page layout, add header, then select a predefined header.
What steps do you follow to insert a recommended PivotTable?
Signup and view all the answers
How do you add a total row to a table?
Signup and view all the answers
What is the method to switch to the footer?
Signup and view all the answers
How do you display data labels above data markers on a chart?
Signup and view all the answers
What is the process to move a chart to a new chart sheet?
Signup and view all the answers
How do you clear all content and formatting from a selected cell?
Signup and view all the answers
What formula do you use to calculate the average value of cells B2:B6?
Signup and view all the answers
How do you use the SUM function to calculate the total of cells B2 through B6?
Signup and view all the answers
What steps do you take to apply the Accent1 cell style?
Signup and view all the answers
How do you create a 3-D pie chart from selected data?
Signup and view all the answers
What do you do to insert a line chart based on the first recommended chart type?
Signup and view all the answers
How do you use autofill to copy the formula from cell E2 to cells E3:E6?
Signup and view all the answers
What is the method to create named ranges from the selected data table?
Signup and view all the answers
How do you change the chart type to the first stacked bar option?
Signup and view all the answers
How do you apply the total cell style to selected cells?
Signup and view all the answers
Study Notes
Compatibility Checker
- To check for compatibility issues in a workbook, navigate to File > Info > Check for Issues > Check Compatibility.
- Close the Compatibility Checker without making any changes if issues are found.
Moving Cells
- Cut data from cell B7 by selecting it, clicking Cut, and then pasting it into cell E12.
Adding Header Elements
- To display the current date in the center section of the header, go to Page Layout > Header > select a predefined header.
Recommended PivotTable
- Insert a recommended PivotTable by clicking on Insert > Recommended PivotTables and selecting the option that suits your data analysis needs, specifically Sum of Bonus by Employee.
Total Row in Table
- Add a total row to a table by checking the Total Row box in the Table Design tab under Table Style Options.
Switching to Footer
- Change to footer view by selecting Page Layout, then clicking on Go to Footer in the Header/Footer tab.
Chart Data Labels
- Display data labels above data markers on a chart by selecting the chart, then using the Chart Elements button to enable or disable labels.
Moving Chart to New Sheet
- Move a selected chart to its own worksheet by clicking Chart Design > Move Chart > select the New Sheet option.
Clearing Cell Content and Formatting
- Clear all content and formatting from a selected cell by going to Home > Editing > Clear > Clear All.
Calculating Average Value
- Enter a formula to calculate the average of cells B2:B6 by using the Formula tab, selecting Autosum, and choosing Average.
Using SUM Function
- To sum cells B2 to B6, click Recently Used, select Sum, and confirm in the Function Arguments dialog.
Applying Cell Style
- Apply the Accent1 cell style by selecting the cell(s) and choosing the style from the Styles group in the Home tab.
Creating 3-D Pie Chart
- Create a 3-D pie chart by clicking Insert > Insert Pie Chart, then select 3-D Pie.
Inserting Line Chart
- Insert a line chart based on recommendations by going to Insert > Recommended Charts, and selecting the first recommended chart type.
Autofill
- Use autofill to replicate a formula and formatting from cell E2 to E3:E6 by selecting the cells and clicking Fill in the Editing group.
Creating Named Ranges
- Create named ranges from a selected data table (B2:E6) using the labels in row 1 by selecting the range and clicking Create from Selection on the Formula tab.
Changing Chart Type
- Change a chart type to the first stacked bar option via Chart Design > Change Chart Type, and select the desired option from the right pane.
Applying Total Cell Style
- Apply the Total cell style by selecting the relevant cells and clicking the style in the Styles group on the Home tab.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of Excel functions with these flashcards. This quiz covers essential Excel tasks, from checking compatibility to cutting and pasting cells. Perfect for those preparing for Excel assessments!