Excel Essential Training (Office 365/Microsoft 365) chapter quiz questions

Enter the password to turn off the protection.

Which action will edit locked cells in a protected worksheet?

Track Changes is located under the Customize Quick Access Toolbar.

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

by double-clicking the split line

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

Create a line chart and make the chart more narrow than the default.

You are creating a chart using the data shown below. What is the best chart type and style to use in order to make the upward sales trend most obvious?

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 entering Sales data for each month in 2018. How can you quickly enter all 12 months in columns?

edit; grouping

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

Delineate the data you do not want to be sorted.

If you have a worksheet containing data you do not want to be sorted, what must you do before sorting?

CTRL + right arrow

Keyboard shortcut that takes you to the end of a row

Line Chart

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

Click highlight ID column then hold the Shift key down and drag the column in front of the Employee column.

You want to move the ID before the employee name in two columns. What is the fastest way to move this data?

X LOOKUP

Function that is used to reconcile information in multiple lists to a single list

Use slashes for dates and colons for time.

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

Formulas

Excel equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more in a worksheet

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

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

Double Accounting

What is a feature can only be accessed from the Format Cells dialog box?

from the arrow to the right of Font on the ribbon

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

deleting a tab in the workbook

Which action CANNOT be reversed using the Undo command?

Double-click the sheet tab, and then type the new name.

Which shortcut can you use to rename a worksheet?

Attempted correct option Print the first page.

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?

Click in cell B2 and click Freeze Panes from the View menu.

You are reviewing data in a worksheet showing the employee name in column A and a header row in row 1 with a lot of additional data. How can you freeze column A and the header row so you scroll through the information.

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

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?

Attempted correct option You are changing the content in the formula to the content in cell D8.

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

Check for data you have previously hidden.

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?

Click Help from the menu bar

You want to add an average in the worksheet. 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?

Best Fit

means that the width of the column will be increased or decreased so the widest entry will fit in the column

when creating a list of employees with their ID numbers

When would you use Excel for a task?

CTRL + S

keyboard shortcut for Save

Totals

When creating a chart with data, what should you leave out?

Use the Find tool, enter the badge number, and check the box next to Match Case and Match Entire Cell Contents.

How would you quickly find who is assigned a badge number Ax239g21 in a worksheet?

Use Draw Border under Border on the ribbon under Home.

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

You need to refresh the pivot table to include the updated data.

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?

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

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?

You manage the worksheet shown below and it contains information for the company's 1500 employees. You are asked to provide a list of all of the employees who are full time and make more than $45,000 per year. What is the best way to create the list?

Use the Filter option to filter by full time employees and use the Numbers filter to select greater than $45,000.

Fill Handle

The small black square in the lower right corner of a selected cell

Pivot Table

The tool used in Excel to create a summary table.

CTRL + A

Keyboard Shortcut for Select All

CTRL + P

Keyboard shortcut for Print

CTRL + down arrow

Keyboard shortcut that takes you to the bottom of a column

CTRL + Home

Keyboard shortcut to upper left corner

By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned.

What is most likely the reason the work order and status columns are left-aligned while the cost column is right-aligned?

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

What is the difference between a workbook and worksheet?

Use the Match entire cell contents option under Replace.

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?

You must share the workbook to track changes.

How does tracking changes relate to sharing a workbook in Excel?

Highlight the data you want to show in the chart.

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

You can track changes.

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

Formula Bar

A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.

Attempted correct option as a spreadsheet

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

CTRL + T

Keyboard shortcut to create a table in Excel

C1

The worksheet below has the split feature active as shown by the vertical line between columns B and C. Which cell was selected when split was chosen by the user?

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.

As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will Excel take with this?

You will either have to click Refresh on the Analyze ribbon or click Alt+F5.

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?

Use Print Preview as a trial and error.

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

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

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?

Click in the tab name of the worksheet, hold the Ctrl key, and drag the worksheet.

You have a workbook with multiple worksheets and want an exact copy of one of the worksheets. How can you duplicate this sheet within the same workbook?

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

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?

ctrl + drag

Keyboard shortcut to copy selected data in a new spot on a worksheet

F1

Keyboard shortcut to Help box

Use a light-color fill.

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

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

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

The content in the cell is wider than the cell width.

One of the number cells in your worksheet shows as ###. What does this mean?

You must add the feature to the Quick Access Toolbar.

What statement is accurate in regards to sharing workbooks?

Ctrl and Shift

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

CTRL + Y

keyboard shortcut for Redo

You can explore charting variations for your data sets.

Which primary function does the Excel Ideas feature serve?

Alt + F1

Keyboard shortcut that creates an embedded chart of the data in the current range.

Up and then left

The Autosum function always looks

Autosum

A function that automatically identifies and adds ranges of cells in your worksheet.

Regions

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

Mini Toolbar

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?

toggle button

A button that can be turned on by clicking it once, and then turned off by clicking it again.

You manage the worksheet shown below that contains a list of employees and a list of building numbers. The employee list is 1500 rows of data. What is the easiest way to sort the employee list without affecting the building number list?

Add a blank column between columns B and C, click in cell A2, and select Sort.

Status Bar

Bar at the bottom of a worksheet that includes page layout and page break preview

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

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

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

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?

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

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?

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

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

by typing =d5-d6

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?

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

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?

colon (:)

The autosum formula will use the ______ versus the plus (+) symbol in the formula.

CTRL + Z

keyboard shortcut to undo the previous action

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

Correct answer Make sure your date has no empty rows or columns.

Retrieve the sheet from a saved version of the file.

If you accidentally delete a sheet that you wanted to keep, which action should you take?

row 3, column 4

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