Exam 6: Getting Started With Excel

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed. -One of the entries Tyler enters into the spreadsheet automatically right-aligns in the cell. Which entry does this?

You can move to the previous or next sheet by pressing the ____ keys.

In the figure above, which box displays the highlighted cells used in the function?

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders. -Samantha wants to find out how much money she will make on her largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be ____.

Explain the following Excel 2013 terms: spreadsheet, cell, worksheet, and active cell.

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

____________________ removes the data from the row or column as well as removes the row or column itself.

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed. _________________________

What is the syntax for a SUM formula adding the values of cell F6 to F9?

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders. -Samantha will add the number of orders. She chooses to use the ____ function from the AutoSum feature.

____ enters text based on patterns it finds in the data.

MATCHING -Displays the cell reference of the active cell

A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.

MATCHING -A group of worksheet cells

To switch to ____ mode, you double-click the cell.

MATCHING -Multiplication before addition

A(n) ____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.