Best describes a mixed cell reference

Assignment Help Other Subject
Reference no: EM13927021

Question 1. Question : An absolute cell reference:
causes a potential error.
indicates a cell's specific location and the reference does not change when you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing the formula.
contains both an absolute and a relative cell reference.

Question 2. Question :Which of the following best describes a mixed cell reference?
Occurs when a formula directly or indirectly refers to the cell containing the formula.
Causes a potential error.
Contains absolute or relative cell references, but not both.
Contains both an absolute and a relative cell reference.

Question 3. Question : The rules for constructing a function can be referred to as the function's _____.
synthesis
synergy
synchronization
syntax

Question 4. Question :To display the current date on each page of an Excel worksheet, use the _____ function.
PRESENT
TODAY
CURRENT
SET

Question 5. Question :The _____ function returns a result based on a condition.
MAX
TODAY
FIND
IF

Question 6. Question :The MAX function identifies the _____.
highest value in a range.
number of blank cells in a range.
lowest value in a range.
midpoint value in a range.

Question 7. Question : The NOW function would perform which of the following?
Contains another function embedded inside one or more of its arguments.
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
Evaluates true or false.
Displays the current date and time.

Question 8. Question : The _____ number is the number of the column in the lookup table that contains the return values.
lookup value
column index
lookup table
random

Question 9. Question :To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell.
sizing handle
pointer
fill handle
insertion point

Question 10. Question : To simplify entering ranges in formulas, you can use _____.
range names
a cell's relative location
both an absolute and a relative cell reference
a cell's specific location

Question 11. Question :When calculating a PMT function, the RATE would be described best by which of the following?
It is the periodic interest rate, such as a monthly interest rate.
It is the total number of payment periods.
It is a word or a string of characters that represent one or more cells.
It is the present value of the loan.

Question 12. Question : A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.
theme
style
template
macro

Question 13. Question :The process of protecting a worksheet requires you to enter a(n) _____.
user name
e-mail address
IN user key
password

Question 14. Question :You must _____ the recording of the macro when you have completed the tasks it was designed to do.
begin
stop
copy
paste

Question 15. Question :To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.
View
Data
Insert
Developer

Reference no: EM13927021

Questions Cloud

Highly competitive business environment : In this highly competitive business environment, businesses are constantly seeking ways to gain traction and understand what is on the minds of current customers and potential customers in order to increase business efficiency. Many companies have..
A company had a quick ratio of 1.4 and a current ratio : A company had a quick ratio of 1.4 and a current ratio of 3.0 An inventory turnover of 6 Current assets of 810,000
What are some examples of known deficient processes : For this discussion, answer the following questions in your initial post: What company are you planning to use for your process improvement plan? What are some examples of known deficient processes
What is tax inversion and its details : What is tax inversion and its details ? how its done ? why its done ? examples about companies , countries that use tax inversion in this research paper , it must be at least 13 pages without the resource page .
Best describes a mixed cell reference : Which of the following best describes a mixed cell reference?
Explain hypothesis testing : The volume of milk in a jug of milk is 128 oz. The value 128 is from a discrete data set.
Identify the best value discipline : Write a paper of no more than 1,400 words that evaluates alternatives your organization must consider to realize growth. Identify the best value discipline, generic strategy, and grand strategy for your organization.
How can employees benefit from alternative work arrangements : How can employees benefit from alternative work arrangements? Why? What are some of the possible negative outcomes for employers and/or employees regarding alternative work arrangements? Please explain your answer
Should sexual education be abstinence only : An outline for persuasive essay topic should sex education be taught in public schools? Should sexual education be abstinence only? Please use a visual organizer in a bullet form and integrate one of these sources, Douglas Kirby and J Barzelatto,..

Reviews

Write a Review

 

Other Subject Questions & Answers

  Non-participation on electoral process

Identify and discuss 5 reasons why people do not vote in state and local elections in the US. Your answer to each written response question should contain a minimum 200-300 word response.

  In this assignment students will create an entry-level

in this assignment students will create an entry-level resume promoting current skills and qualifications.nbspstudents

  Ethnic groups have adopted various crazy holistic

Different immigrant/ethnic groups have adopted various crazy holistic or home remedies (Your book specifically talks about this during its discussion of Puerto Ricans), although the one I mentioned in class appears to not have been a real one.

  When measuring moral dilemmas-hypothetical dilemmas

When measuring moral dilemmas, Kohlberg suggests the use of hypothetical dilemmas. However, Straughan disagrees and states that hypothetical dilemmas do not evoke the same reactions as familiar dilemmas and, hence, the findings are not as useful in m..

  Find the pressure gradient force

An air parcel with mass = 150 kg is traveling at 15 m s-1 due east at 38ºN at an altitude of 5500 m. The parcel also has a downward velocity of 2 m s-1. Assume that the parcel is at the 500 mb level within a horizontal pressure field that increases t..

  Contrast elasticity of demand, cross-price elasticity

Contrast Elasticity of demand, Cross-price elasticity (include substitutes and complements), and Income elasticity (include normal and inferior goods).

  Corporate strategy

What is adidas's corporate strategy? Was there a common strategic approach used in managing the company's lineup of sporting goods businesses prior to its 2005-2006 restructuring? Has the corporate strategy changed with restructuring?

  The key to the rogerian therapy process

the key to the Rogerian therapy process.

  Research credit default swaps

Research credit default swaps.Write a one paragraph summary describing these instruments. Also, do you think they were the number one cause of the Financial Crisis of 2007? Write one paragraph supporting your opinion.

  Believe the characteristic reflects nature or nurture

Describe 1 characteristic that you possess that you believe is due to nature and another characteristic that you believe is due to nurture. Explain why you believe the characteristic reflects nature or nurture.

  Write an essay on fdi in nigeria

Write an essay on FDI in Nigeria.

  Influence of drugs over nervous system

How do drugs influence the nervous system? How are the neurological processes altered due to the presence of drugs? Please reply.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd