Excel for Microsoft 365: The Complete Beginner-to-Advanced Guide | 2025/26 UPDATES.
About This Guide:
This Excel Microsoft 365 resource is designed to help you build real-world spreadsheet skills, whether
you're brand new to Excel or looking to sharpen your knowledge of functions, formulas, charts,
PivotTables, Power Query, and more. Includes step-by-step tutorials, practice files, and quick-reference
guides for faster learning.
A user wants to quickly format a cell and right-clicks the cell to use the features seen in the image. Which
Excel tool is being used? - ✔✔-Mini Toolbar
An Excel workbook tracks the sales data for a company. A pivot table is in the adjacent tab and provides
a high level view of the sales by department. The sales numbers are updated in the workbook, but the
pivot table is not reflecting these changes. What is most likely causing this problem? - ✔✔-You need to
refresh the pivot table to include the updated data.
As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will
Excel take with this? - ✔✔-Excel will display it as 6/31/2019, but it will be left-justified and just a set of
numbers and dashes, not an actual date.
Before you create a chart in Excel, how would you have the chart appear? - ✔✔-Remove any totals next
to your data.
How can you quickly add a border around a set of cells covering 3 rows and 12 columns? - ✔✔-Use
Draw Border under Border on the ribbon under Home.
How can you remove a split other than by clicking the Split button under View? - ✔✔-by double-clicking
the split line
How would you most efficiently test a layout adjustment before printing on paper? - ✔✔-Use Print
Preview as a trial and error.
If you accidentally delete a sheet that you wanted to keep, which action should you take? - ✔✔-Retrieve
the sheet from a saved version of the file.
, If you have a worksheet containing data you do not want to be sorted, what must you do before sorting? -
✔✔-Delineate the data you do not want to be sorted (Insert at least one empty column or a couple of
empty rows between the data you want to be sorted and the data you do not want sorted).
In the image below, what is most likely the reason the work order and status columns are left-aligned
while the cost column is right-aligned? - ✔✔-By default, cells with alpha characters are left-aligned and
while numeric characters are right-aligned.
In the image below, which cells would you use to create a chart to represent the sales data? - ✔✔-A2:D6
(exclude the cells with the totals)
In the worksheet shown below, you click in cell E4 and then click Autosum. What will be the result? -
✔✔-The formula =SUM(E2:E3) will be added to the cell to add the total sales and costs.
In the worksheet shown below, you want to move the ID before the employee name. What is the fastest
way to move this data? - ✔✔-Click B to highlight the column then hold the Shift key down and drag the
column in front of the Employee column.
In the worksheet shown below, you want to use the XLOOKUP function to find the employee whose
number appears in cell I2. Using the data in columns A and B, what formula is needed in cell J2? - ✔✔-
=XLOOKUP((I2,B:B,A:A)
- (The XLOOKUP formula will search for the ID in I2 in column B and will return the name in column
A)
One of the number cells in your worksheet shows as ###. What does this mean? - ✔✔-The content in the
cell is wider than the cell width.
The worksheet shown below tracks badge numbers assigned to a company with 5,000 employees. How
would you quickly find who is assigned a specific badge number? - ✔✔-Use the Find tool, enter the
badge number, and check the box next to Match Case and Match Entire Cell Contents.
What is the difference between a workbook and worksheet? - ✔✔-A workbook is the file and a worksheet
is the individual tab within the workbook.
About This Guide:
This Excel Microsoft 365 resource is designed to help you build real-world spreadsheet skills, whether
you're brand new to Excel or looking to sharpen your knowledge of functions, formulas, charts,
PivotTables, Power Query, and more. Includes step-by-step tutorials, practice files, and quick-reference
guides for faster learning.
A user wants to quickly format a cell and right-clicks the cell to use the features seen in the image. Which
Excel tool is being used? - ✔✔-Mini Toolbar
An Excel workbook tracks the sales data for a company. A pivot table is in the adjacent tab and provides
a high level view of the sales by department. The sales numbers are updated in the workbook, but the
pivot table is not reflecting these changes. What is most likely causing this problem? - ✔✔-You need to
refresh the pivot table to include the updated data.
As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will
Excel take with this? - ✔✔-Excel will display it as 6/31/2019, but it will be left-justified and just a set of
numbers and dashes, not an actual date.
Before you create a chart in Excel, how would you have the chart appear? - ✔✔-Remove any totals next
to your data.
How can you quickly add a border around a set of cells covering 3 rows and 12 columns? - ✔✔-Use
Draw Border under Border on the ribbon under Home.
How can you remove a split other than by clicking the Split button under View? - ✔✔-by double-clicking
the split line
How would you most efficiently test a layout adjustment before printing on paper? - ✔✔-Use Print
Preview as a trial and error.
If you accidentally delete a sheet that you wanted to keep, which action should you take? - ✔✔-Retrieve
the sheet from a saved version of the file.
, If you have a worksheet containing data you do not want to be sorted, what must you do before sorting? -
✔✔-Delineate the data you do not want to be sorted (Insert at least one empty column or a couple of
empty rows between the data you want to be sorted and the data you do not want sorted).
In the image below, what is most likely the reason the work order and status columns are left-aligned
while the cost column is right-aligned? - ✔✔-By default, cells with alpha characters are left-aligned and
while numeric characters are right-aligned.
In the image below, which cells would you use to create a chart to represent the sales data? - ✔✔-A2:D6
(exclude the cells with the totals)
In the worksheet shown below, you click in cell E4 and then click Autosum. What will be the result? -
✔✔-The formula =SUM(E2:E3) will be added to the cell to add the total sales and costs.
In the worksheet shown below, you want to move the ID before the employee name. What is the fastest
way to move this data? - ✔✔-Click B to highlight the column then hold the Shift key down and drag the
column in front of the Employee column.
In the worksheet shown below, you want to use the XLOOKUP function to find the employee whose
number appears in cell I2. Using the data in columns A and B, what formula is needed in cell J2? - ✔✔-
=XLOOKUP((I2,B:B,A:A)
- (The XLOOKUP formula will search for the ID in I2 in column B and will return the name in column
A)
One of the number cells in your worksheet shows as ###. What does this mean? - ✔✔-The content in the
cell is wider than the cell width.
The worksheet shown below tracks badge numbers assigned to a company with 5,000 employees. How
would you quickly find who is assigned a specific badge number? - ✔✔-Use the Find tool, enter the
badge number, and check the box next to Match Case and Match Entire Cell Contents.
What is the difference between a workbook and worksheet? - ✔✔-A workbook is the file and a worksheet
is the individual tab within the workbook.
