Exam 26: Entering Worksheet Formulas

Explore all topics

When you need to edit a worksheet with many formulas, you can specify ____________________ calculation, which lets you determine when Excel calculates the formulas.

Free

(Short Answer)

4.8/5

(31)

Question 1

Correct Answer:

Verified

manual

To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual.

Free

(Multiple Choice)

4.8/5

(42)

Question 2

Correct Answer:

Verified

COUNT CELLS determine how many entries are included in the range.

Free

(True/False)

4.9/5

(31)

Question 3

Correct Answer:

Verified

False

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

A constant (text or number) or cell reference used in a formula.

Relative cell reference

Adjusts to its new location when copied or moved.

Operand

A symbol that indicates the type of calculation to perform.

Operator

Correct Answer:

Verified

A constant (text or number) or cell reference used in a formula.

Adjusts to its new location when copied or moved.

A symbol that indicates the type of calculation to perform.

Does not change when copied or moved to a new cell.

Cell reference that contain both relative and absolute references.

(Matching)

4.9/5

(36)

Question 4

The sequence used to calculate the value of a formula is called the ____.

(Multiple Choice)

4.9/5

(37)

Question 5

Please briefly describe these three summary calculation options and provide an example of when it would be used: Average, Minimum, and Maximum.

(Not Answered)

Question 6

This question doesn't have any answer yet

Ask our community

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

(Multiple Choice)

4.8/5

(36)

Question 7

Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands .

(True/False)

4.9/5

(44)

Question 8

The results of the calculation appear in the cell in which the formula is entered.

(True/False)

4.9/5

(37)

Question 9

To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group.

(Multiple Choice)

4.8/5

(34)

Question 10

The formula = E6/4 is an example of a(n) ____ operation.

(Multiple Choice)

4.8/5

(32)

Question 11

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section. He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use?

(Multiple Choice)

4.8/5

(30)

Question 12

The Calculations tab on the Ribbon contains all the buttons you need when working with manual calculations.

(True/False)

4.8/5

(39)

Question 13

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

(Multiple Choice)

4.8/5

(35)

Question 14

The Sum button is located in the ____ group on the Home tab of the Ribbon.

(Multiple Choice)

4.8/5

(34)

Question 15

Formulas can include more than one operator.

(True/False)

4.8/5

(28)

Question 16

The formula =B5+C5 is an example of a multiplication operation.

(True/False)

4.9/5

(40)

Question 17

The formula = B3^3 is an example of a(n) ____ operation.

(Multiple Choice)

4.7/5

(38)

Question 18

You cannot enter a formula with an incorrect structure in Excel. If you attempt to do so, a(n) ____ appears, explaining the error and providing a possible correction.

(Multiple Choice)

4.9/5

(37)

Question 19

The SUM function that adds the numbers in the range D5:D17 is ____.

(Multiple Choice)

4.9/5

(32)

Question 20

Showing 1 - 20 of 46

Exam 26: Entering Worksheet Formulas

When you need to edit a worksheet with many formulas, you can specify ____________________ calculation, which lets you determine when Excel calculates the formulas.

To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual.

COUNT CELLS determine how many entries are included in the range.

The sequence used to calculate the value of a formula is called the ____.

Please briefly describe these three summary calculation options and provide an example of when it would be used: Average, Minimum, and Maximum.

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands .

The results of the calculation appear in the cell in which the formula is entered.

To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group.

The formula = E6/4 is an example of a(n) ____ operation.

The Calculations tab on the Ribbon contains all the buttons you need when working with manual calculations.

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

The Sum button is located in the ____ group on the Home tab of the Ribbon.

Formulas can include more than one operator.

The formula =B5+C5 is an example of a multiplication operation.

The formula = B3^3 is an example of a(n) ____ operation.

You cannot enter a formula with an incorrect structure in Excel. If you attempt to do so, a(n) ____ appears, explaining the error and providing a possible correction.

The SUM function that adds the numbers in the range D5:D17 is ____.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters