Exam 8: Using Complex Formulas, Functions, and Tables

When you copy a formula from one cell to another, Excel automatically adjusts the cell references in the copied formula to reflect the new formula location.

(True/False)

4.7/5

(33)

Question 61

You can sort up to ____ levels in the Sort dialog box.

(Multiple Choice)

4.9/5

(31)

Question 62

Describe how dates are calculated using serial values.

(Essay)

4.9/5

(37)

Question 63

In the accompanying figure, the Total Sales Less Returns column has ___ applied to its cells.

(Multiple Choice)

4.9/5

(34)

Question 64

In a complex formula, addition and subtraction are performed before multiplication and division.

(True/False)

4.7/5

(38)

Question 65

To insert a(n) absolute cell reference, select the cell you want to use for this purpose, and then press F4.

(True/False)

4.8/5

(30)

Question 66

Showing 61 - 66 of 66

When you copy a formula from one cell to another, Excel automatically adjusts the cell references in the copied formula to reflect the new formula location.

You can sort up to ____ levels in the Sort dialog box.

Describe how dates are calculated using serial values.

In the accompanying figure, the Total Sales Less Returns column has ___ applied to its cells.

In a complex formula, addition and subtraction are performed before multiplication and division.

To insert a(n) absolute cell reference, select the cell you want to use for this purpose, and then press F4.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Creating and Enhancing a Worksheet

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters