Excel LinkdIn

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.

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?

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

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.

When would you use Excel for a task?

when creating a list of employees with their ID numbers

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 primary function does the Excel Ideas feature serve?

You can explore charting variations for your data sets.

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

Double Accounting

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.

Which action will edit locked cells in a protected worksheet?

Enter the password to turn off the protection.

Before you create a chart in Excel, how would you have the chart appear?

Remove any totals next to your data.

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.

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.

What is the difference between a workbook and worksheet?

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

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.

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

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.

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.

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

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.

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.

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.

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.

In the image below, which cells would you use to create a chart to represent the sales data?

A2:D6

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.

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 would you most efficiently test a layout adjustment before printing on paper?

Use Print Preview as a trial and error.

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

Which action CANNOT be reversed using the Undo command?

deleting a tab in the workbook

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

edit; grouping

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

Highlight the data you want to show in the chart.

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.

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?

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

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

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 are working in the worksheet shown below. What formula in cell B4 will calculate the profit in January?

=B2-B3

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.