Excel Microsoft 365

You have a worksheet with multiple hidden columns and you need to view all of the data that is hidden. What is the best way to unhide the columns?

Select the entire worksheet and double-click any column boundary.

You are adding dates in the spreadsheet shown below. What will happen when you press Enter after entering the date as shown in cell C9?

The date will appear as 8/1/2020 and will be right-aligned.

Which feature can only be accessed from the Format Cells dialog box?

Double Accounting

Which action will edit locked cells in a protected worksheet?

Enter the password to turn off the protection.

You want to view how your worksheet will print and make edits to the worksheet in this mode. What is the easiest way to accomplish this?

Click Page layout on the bottom of the page in the status bar.

What is the first step in creating a chart with Excel Office 365?

Highlight the data you want to show in the chart.

You can _____ multiple sheets at the same time by _____ them first.

edit; grouping

You created a bar chart with the bars for the products and the colors for the salesperson. If you click Switch Row Column, what will happen?

The bars will change to salespeople, and the colors will change to products.

How would you most efficiently test a layout adjustment before printing on paper?

Use Print Preview as a trial and error.

Which primary function does the Excel Ideas feature serve?

You can explore charting variations for your data sets.

You are working in the worksheet shown below. What formula in cell B4 will calculate the profit in January?

=B2-B3

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.

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.

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)

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)

How can you remove a split other than by clicking the Split button under View?

by double-clicking the split line

What is the difference between a workbook and worksheet?

A workbook is the file and a worksheet is the individual tab within the workbook.

Your worksheet includes data for your company's IT department. How can you use Find and Select to quickly capitalize the many instances of IT appearing in the worksheet?

Use the Match entire cell contents option under Replace.

You are working in the most recent version of Excel provided by your company. Why would you use the Save as type pull-down menu?

You are saving the file for someone with an older version of Excel.

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products?

by typing =d5-d6

You are working in your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a worksheet "2018 Profit," how will the new worksheet appear?

with the same formatting as "2018 Sales" before you made any changes

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.

When would you use Excel for a task?

when creating a list of employees with their ID numbers (Excel is commonly used for creating and maintaining lists).

You want to add an average in the worksheet shown below. You want to learn more about the average function in Excel and think that a video will assist you. How can you access training from the workbook?

Click Help from the menu bar.

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

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.

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.

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.

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.

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.

You manage the worksheet shown below. You want the building number in column B to be edited by anyone who has access to the sheet. You do not want any other information to be edited by others. How can you configure the worksheet to achieve this protection?

You will lock the cells in all columns except column B and generate a password to protect the worksheet.

You are using a button on the ribbon, and you are interested in learning more about its functionality. How can you access "Tell me more"?

Hover over the button, then click Tell me more at the bottom of the information displayed.

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).

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.

You would like to add some frequently used buttons to the Quick Access Toolbar. How can you do this?

Right-click the button on the ribbon and select Add.

Which action CANNOT be reversed using the Undo command?

deleting a tab in the workbook

You are entering Sales data for each month in 2018. How can you quickly enter all 12 months in columns?

Type in "January," point to the lower right-hand corner of the cell, hold down the left mouse button, and drag across the next 11 rows.

You are reviewing data in the worksheet shown below. You need to view the employee name and the first row of the worksheet as you scroll through the information. What action will you take?

Click in cell B2 and click Freeze Panes from the View menu (When clicking the Freeze Panes option, the data above and to the left of the selected cell will freeze. By selecting cell B2, you will freeze the top row and column A with the employee names).

You want to change the columns in the worksheet shown below to the best fit for the data. What is the fastest way to accomplish this?

Highlight the entire worksheet then double-click the boundary between any two columns.

You are working in the worksheet shown below. What will happen in cell C4 if you use the fill handle to drag cell B4 to C4? (Formula in cell B4 is =B2-B3)

The formula =C2-C3 will appear in cell C4.

You click the Save icon at the top of an Excel workbook. The image below shows what appears on your screen. Why do you see this screen?

This is a new file that has not previously been saved.