Match between columns Premises: Negation comes first in this.

The Answer of function and order of operations and circular is...

Exam 10: Excel: Formulas, Functions, and Formatting

Explore all topics

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

(Multiple Choice)

4.8/5

(22)

Question 101

The equal sign (=) precedes a formula.

(True/False)

4.9/5

(39)

Question 102

Explain what circular references, direct circular references, and indirect circular references are.

(Essay)

4.7/5

(31)

Question 103

You can press the ____________________ key to quit Range Finder.

(Short Answer)

4.8/5

(34)

Question 104

The default view in Excel is called ____ view.

(Multiple Choice)

4.8/5

(35)

Question 105

To paste copied cell contents, you can press the ____ keys.

(Multiple Choice)

4.8/5

(37)

Question 106

To start a new line in a cell, press the ____ keys.

(Multiple Choice)

4.9/5

(37)

Question 107

The AVERAGE function requires that the argument be included within parentheses following the function name.

(True/False)

5.0/5

(23)

Question 108

You can choose from 12 categories of formats in the Format Cells dialog box.

(True/False)

4.9/5

(28)

Question 109

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

Premises:

Negation comes first in this.

Responses:

function

order of operations

circular reference

Correct Answer:

Verified

Negation comes first in this.

(Matching)

4.8/5

(24)

Question 110

Clicking the ____ opens the Insert Function dialog box.

(Multiple Choice)

4.8/5

(31)

Question 111

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

(True/False)

4.9/5

(42)

Question 112

Showing 101 - 112 of 112

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

The equal sign (=) precedes a formula.

Explain what circular references, direct circular references, and indirect circular references are.

You can press the ____________________ key to quit Range Finder.

The default view in Excel is called ____ view.

To paste copied cell contents, you can press the ____ keys.

To start a new line in a cell, press the ____ keys.

The AVERAGE function requires that the argument be included within parentheses following the function name.

You can choose from 12 categories of formats in the Format Cells dialog box.

Clicking the ____ opens the Insert Function dialog box.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Excel: Creating a Worksheet and a Chart

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters