Microsoft Excel 365 - Fundamentals (DCDEXL365C)

To work effectively, you should explore the Excel 365 interface and familiarize yourself with it's features. Match each description to the excel 365 workbook element it describes.

-A. Provides the co-ordinates for a selected cell. -B. Offers access to a selected few frequently-used commands. -C. Consists of tabs and groups of related tools. -D. Contains the data of an Excel workbook. -C. Ribbon. -B. Quick Access Toolbar. -D. Worksheet. -A. Name Box.

Which two actions can you take if you don't find the Excel 365 template you're looking for?

-Browse for More templates on the home Page. -Search for a template via the Search field on the Home page.

One method to delete content in Excel 365 is to select a cell, select the Formula Bar, and press Backspace repeatedly. What are two more ways to delete items in an Excel 365 workbook?

-Choose the cell and press the Delete key. -Select a cell and choose Clear Contents on the Ribbon.

How can you open an existing workbook in Excel 365?

-Go to the Open page in the Backstage view and browse to the workbook you'd like to open.

When can you use the Share button on the Ribbon in Excel 365 to start sharing an Excel 365 workbook?

-If you haven't yet saved the workbook online and would like to make it accessible to others

Identify two ways to increase the size of columns and rows in an Excel 365 worksheet.

-Place the cursor between two rows and drag downward to increase the row height. -Place the cursor at the vertical divider after the narrower column and drag from left to right.

In what ways can you copy data in Excel 365?

-Right-click the data and select Copy. -Choose the Copy tool and the home tool.

Considering the image below, identify two methods to input data into cell A5 of a worksheet, in Excel 365.

-Select cell A5, select the Formula Bar, type the data, and press Enter. -Double-click cell A5, type the data into the cell, and press Enter.

Where are two places you can find a function in Excel 365 if it's not in any of the default Function Library categories?

-Via of the subcategories in the more functions menu. -Via the search for a function text field in the insert function window.

Identify a way to undo an action in Excel 365.

Press the keyboard shortcut Ctrl + Z

If you're saving an Excel 365 workbook for the first time, what happens if you click the Save tab in the backstage view?

You're redirected to the Save As page