FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Excel 1: Getting Started With Excel 2016

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

In a worksheet, the ____ is called the formula prefix.

A) minus sign (-)
B) plus sign (+)
C) pound sign (#)
D) equal sign (=)

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

In an electronic spreadsheet, you need to manually recalculate when you change the entries.

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

Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. ____________________

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Explain the difference between Normal view and Page Layout view in Excel.

The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.​

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

You can use a named range instead of a cell address in a formula.

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 created 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 the Total row, cell C8 to calculate the second quarter sales for the three stores.

____ operators perform mathematical calculations such as adding and subtracting.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​

To open an Excel file, click Open Other Workbooks on the navigation bar, click This PC, and then click Browse to open the Open dialog box.

The Excel operator for division is ____.

A named range must begin with a letter or a(n) _____.​

You can use ____ to move around in a document that is too large to fit on the screen at once.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.