Getting Started with Excel 100%

Gina's teacher has sent her a Word document that contains the names of all the students who are participating in the Spelling Bee. Her teacher wants her to enter these names in a spreadsheet. Which strategy is the best way for Gina to enter these names? by typing the names one by one down a column in the Excel spreadsheet by typing the first two names in a column and then using the Autofill feature by typing the names in two different columns and then using the Flash Fill feature by copying the names from the Word document and pasting them into the Excel spreadsheet

by copying the names from the Word document and pasting them into the Excel spreadsheet

What purpose would the AutoFill feature be most helpful for? completing the items in a series sharing a document with other users performing calculations fixing the spelling of authors' names

completing the items in a series

What is the name of the small square in the bottom right-hand corner of a selected cell or range called?

fill handle

Amara created a workbook to track the number of minutes she reads each week. Each day, she entered the number of minutes into the workbook. Identify the types of data in the workbook using the drop-down menus.

25: value 105: formula Wed: label

Why does the phrase "compatibility mode" appear when opening a workbook?

A version older than Excel 2016 was used to create the workbook.

Marcus wants to create a spreadsheet with names, street addresses, city, and state for a mailing list. All those on the list will have the same city and state. Which tool would be the best to use to quickly enter that information?

Autofill

Use the drop-down menu to identify which command is used to do the activities. Saving updates on a workbook Saving a workbook on OneDrive Changing the file name of an existing workbook Saving an existing workbook in a different location Assigning an initial location for the workbook to be saved

Both Save and Save As Save As Save As Save As Both Save and Save As

Use the drop-down menu to complete the steps for using the Autofill feature. Click the .......... Click the .......... Drag the .......... to the desired range. Click the Autofill option you want to use.

Cell Fill handle Fill handle

Which steps do you need to follow to create a new Excel workbook? Check all that apply. Click the Create tab. Click the New tab. Click the New Workbook tab. Go to the Backstage View.

Click the New tab Go to the Backstage View

How can you get access to Help? Click all that apply.

F1 Lightbulb Tell me what you want to do the ? on the top-right corner in the Backstage View

What are the purposes of Flash Fill? Click all that apply.

Flash Fill recognizes patterns across rows for easy data entry. Flash Fill copies a pattern down a column of entries. Flash Fill can be used to combine entries or parts of entries.

Luis receives a workbook from a classmate. When he opens the workbook, it opens in compatibility mode. How does this mode affect what he can do with the workbook?

Luis can use some of the features of Excel 2016.

Which statements describe OneDrive?

OneDrive is available to subscribers of Office 365. The OneDrive browser allows access to Excel online New documents can be created and uploaded on OneDrive. OneDrive ensures that changes in files are updated in the computer and the cloud.

Which statement compares the Autofill and Flash Fill features? Only the Flash Fill feature is based on a recognizable pattern. Only the Flash Fill feature can combine data from other cells. Only the Autofill feature automatically adds data to the workbook. Only the Autofill feature is available on the desktop version of Excel.

Only the Flash Fill feature can combine data from other cells.

Use the table and the drop-down menus to order the steps. Click on the New tab. Click on the Save or Save As tab. Click on the Blank workbook image. Type data into the columns and rows. Create file name and choose location of file.

Step 2 Step 6 Step 3 Step 4 Step 7

Jose needs to find out how to delete cells from his workbook. Which method is the quickest way for Jose to get step-by-step directions? Do research on the internet. Press F1 and type "delete cells" in the search bar. Click the ? on the top-right corner in the Backstage View. Type "delete cells" in the "Tell me what you want to do" bar.

Type "delete cells" in the "Tell me what you want to do" bar.