Exam 1: Getting Started With Excel

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

You have three college bound children and you would like to keep track of each of the costs related to tuition.Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?

Ctrl + G is used to access the ____.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

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.

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

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

-In the above figure,which box displays the formula in the formula bar?

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?

Speed Fill enters text based on patterns it finds in the data.

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Numeric data is any number that can be used in a mathematical calculation.

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

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.

____ displays the location of the different page breaks within the worksheet.

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 has entered several formulas in her worksheet.All of a sudden,she realizes that the cells that once displayed the formula results are now displaying the formulas and all of the columns are wider.She must have switched to ____.

A formula is written using $\underline { \text { operands } }$ that combine different values,resulting in a single value that is then displayed in the cell._________________________