Exam 6: Excel 1: Getting Started With Excel 2016

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. Which of the following is NOT a valid formula for use in cell B13 for finding the average of Test 1?

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

A(n) ____ is an entry in a cell that contains text such as "2016 Sales" or "Travel Expenses."

In Excel, a worksheet is contained in a file called a ____.

All Excel formulas begin with the ____.

To quickly jump to the first cell in a worksheet press ____.

The ____ option helps fit the data on a single page without making changes to individual margins.

You can use Excel's ____________________ feature to automatically save your work as often as you want.​

Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet. ____________________

A(n) ____ is a built-in formula that uses arguments to calculate information.

The entry in cell B15 is =SUM(B5:B 14) which is a ____.

In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

Discuss the five guidelines for creating calculations in Excel.

Labels are numbers, formulas, and functions that can be used in calculations. _____________________

Arguments are Excel's built-in formulas.

Charts are updated automatically in Excel whenever data changes.

Clicking the ____________________ button sums the adjacent cell range above or to the left.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

Any time you use a worksheet to ask the question "what if?" you are performing ____________________ analysis.