menu-iconExamlexExamLexServices

Discover

Ask a Question
  1. All Topics
  2. Topic
    Computing
  3. Study Set
    Your Office Microsoft Office
  4. Exam
    Exam 10: Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions
  5. Question
    If a Formula References Cell A1 and Is Copied Down
Solved

If a Formula References Cell A1 and Is Copied Down

Question 3

Question 3

Multiple Choice

If a formula references cell A1 and is copied down one row and to the right one column,the new formula will reflect B2 if the cell reference is a(n) ________ reference.


A) absolute
B) relative
C) mixed
D) constant

Correct Answer:

verifed

Verified

Related Questions

Q1: Match the answer to the appropriate definition.Each

Q2: Excel facilitates taking tabular data and converting

Q4: Information organized into rows and columns is

Q5: The function that allows users to determine

Q6: Values should be hard-coded wherever possible.

Q7: A(n)_ allows users to perform basic mathematical

Q8: The _()function is essentially the same as

Q9: Not all formulas start with the equal

Q10: A value in a cell referenced by

Q11: A cell has exactly three alignments: left-aligned,centered,and

Examlex

ExamLex

About UsContact UsPerks CenterHomeschoolingTest Prep

Work With Us

Campus RepresentativeInfluencers

Links

FaqPricingChrome Extension

Download The App

Get App StoreGet Google Play

Policies

Privacy PolicyTerms of ServiceHonor CodeCommunity Guidelines

Scan To Download

qr-code

Copyright © (2025) ExamLex LLC.

Privacy PolicyTerms Of ServiceHonor CodeCommunity Guidelines