Exam 6: Excel 1: Getting Started With Excel 2016

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have create a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in  cells B6 through E6.  Write the complete formulas for finding the Yearly Sales figures in cell F4 for the Downtown store.

A named range can begin with a letter or number.

You can use the ____ key(s) on the keyboard to navigate a worksheet.

You can edit the contents of the active cell by ____.

Excel recognizes an entry as a value if it is a number or it begins with ____.

The cell in which you are working is called the ____________________ cell.

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. You want to put a formula in cells D4 through D11 for finding the difference between the two test scores for each student. You enter =C4-B4 in cell D4 and then use what feature to copy the formula down the column through cell D11?

Possible paper orientations for printing a worksheet are landscape and ____.

You are in Edit mode any time you are entering or changing the contents of a cell.

Office Lite includes simplified version of the apps found in the Office 2016 suite.​ ____________________

Critical Thinking Questions Case 1-2 You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. You realize that you have made an error in the spreadsheet. Graham's score for test 2 should be 76, not 67. To fix this error, navigate to cell C4, type 76, and then press what key?

One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon . ______________________

To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.​