Excel Essential Training

You created a formula in cell C8. When you copy the formula into cell D8, which action are you taking?

You are changing the contents in the formula to the content in cell D8

Which two keys are commonly used to move or insert data?

Ctrl and Shift

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 shortcut can you use to rename a worksheet?

Double click the sheet tab and then type the new name

You can ___ multiple sheets at a time by ___ them first.

Edit; grouping

Which action will edit locked cells in a protected worksheet?

Enter the password to turn off the protection

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 left-adjusted and as only a set of numbers and dashes, and not an actual date

Where can you access the format cell's Dialog Box launcher?

From the arrow to the right of Font on the ribbon

Which type of chart is preferable when you are dealing with a timeframe?

Line chart

While it might be considered "old-school," which action should you take if you are unsure how a page will print, even after looking at Page Break Preview?

Print the first page

You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list?

Regions

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

Remove any totals next to your data

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

What does it mean that the right mouse button is "context-sensitive"?

The menu items available will differ depending on the context of what you are right-clicking

What is a good rule-of-thumb for using color backgrounds in a worksheet?

Use a light-color fill

How can you access Track Changes in Microsoft Excel Office 365?

Track Changes is located under the Customize Quick Access Toolbar

Which shortcuts can you use for Undo and Redo?

Undo: Ctrl + Z Redo: Ctrl + Y

What is the best practice for entering dates and times in Excel?

Use slashes for dates Use colons for time

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

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

Which primary function does the Excel Ideas feature serve?

You can explore charting variations for your data sets

Why would you set up a workbook to be shared if you are the only one using the workbook?

You can track changes

To use AutoSum with a row of four values, where must your cursor be to have the sum appear in the row if you have not highlighted the cells?

on the first empty cell to the right of the last cell containing a value

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

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 lower right-hand corner of the cell > hold down left mouse button> drag across the next 11 rows

There is 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 > click "Tell me more" at the bottom of the information displayed

To freeze rows 1 and 2, and columns 1, 2, and 3, which cell should you highlight before selecting Freeze Panes?

row 3, column 4

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

Highlight the data you want to show in the chart

How can you quickly add a border around a set of cells covering 3 rows and 12 columns?

Home > Border > Draw Border

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

Use Print Preview as a trial and error

As you are working with a Pivot Table, you decide to change some of your source data. How will the Pivot Table recognize the change?

You will either have to click Analyze > Refresh OR click Alt + F5

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

Use the "Match entire cell contents" option under Replace

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

You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature?

Make sure your data has no empty rows or columns

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

Although it is not a term Excel uses, how do most people think of Excel?

As a spreadsheet

How can you remove a split?

By double clicking the split line OR by clicking the Split button under View

You resurrected an old worksheet. It appears to contain most of the information that you need, but not all of it. Which step should you take next?

Check for data you have previously hidden

You have numerical data across 12 rows and 4 columns. When you highlight this range of cells, and then press Average under AutoSum in the Formula ribbon, which outcome occurs?

The averages will display on the column at the end of each row and below the bottom row of each column