User Account

All Pages

Which of the following best describes the count function

Assignment Help Accounting Basics
Reference no: EM13929187

Question 1.1.(TCO 2)

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.2.(TCO 2)

In Excel, a function can be defined as a _____.

predefined formula that performs a calculation

cell reference or a value

list of values and defined names as you enter data into a spreadsheet

set of rules that govern the structure and components for a formula

Question 3.3.(TCO 2)

=$E2-G$4 contains examples of _____ cell references

Absolute

Mixed

Relative

Constant

Question 4.4.(TCO 2)

Which of the following describes the SUM function?

Identifies the midpoint value in a set of values.

Calculates the total of values contained in two or more cells.

Calculates the arithmetic mean or average of values in a range.

Displays the lowest value in a range.

Question 5.5.(TCO 2)

The MEDIAN function would identify the ____.

lowest value in a range.

midpoint value in a range.

highest value in a range.

total number of cells in a range.

Question 6.6.(TCO 2)

Which of the following best describes the COUNT function?

Tallies the number of cells in a range that are not empty.

Tallies the number of blank cells in a range.

Displays the current date.

Tallies the number of cells in a range that contain values.

Question 7.7.(TCO 2)

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.8.(TCO 2)

A(n) _____ is tested in an IF function to determine if it is true or false.

feature

formula

condition

option

Question 9.9.(TCO 2)

Arithmetic operations, cell references, and _____ can be used in Excel formulas.

constants

macros

programs

procedures

Question 10.10.(TCO 2)

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.11.(TCO 2)

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.12.(TCO 7)

A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed

income statements for all 12 months in a year.

template

macro

web query

function

Question 13.13.(TCO 7)

To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.

home

page layout

data

view

Question 14.14.(TCO 7)

Which of the following file formats can store macros?

xlsm

csv

xml

xlsx

Question 15.15.(TCO 7)

By default, Excel automatically _____ macros and displays a security warning when a file containing

macros is opened.

saves

deletes

runs

disables

Reference no: EM13929187

Questions Cloud

Robert devlin and neil parish are portfolio managers : Robert Devlin and Neil Parish are portfolio managers at the Broward Investment Group. At their regular Monday strategy meeting, the topic of adding international bonds to one of their portfolios came up. The portfolio, an ERISA-qualified pension acco..
How frameworks help company avoid faulty e-commerce strategy : Develop a 150 to 200 word posting that responds to the following question: How might the value process frameworks help companies avoid faulty e-commerce strategies?
Calculate the mean and standard deviation of sales people : Calculate the mean and standard deviation of # of sales people (x) and sales (y). Find sample size n.
Confidence interval for the mean number : Another sample of candies was opened and recorded. The sample size was 20. Below is the summary of the sample.
Which of the following best describes the count function : ndicates a cell's specific location and the reference does not change when you copy the formula.
Having a sole proprietorship : What are the advantages and disadvantages associated with having a sole proprietorship?
Determine the expected completion time : Determine the expected completion time for each activity. Draw the network diagram for this project. Determine the expected completion time for this project, in days. Which activities are on the critical path?
The exchange rate channel of monetary policy : Understand belowed statements' explanations "a) "If countries fix their exchange rate, the exchange rate channel of monetary policy does notexist." Is this statement true, false or uncertain? Explain.
What is target policy regarding : What is Target's policy regarding when to write off credit card receivables?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Question based on managerial accounting

Surprise Corporation's sales budget showed expected sales of 13,400 widgets. Starting finished goods contained 1,200 widgets. The firm determined that 14,100 units should be produced.

  Scenario a - jesse aaron began his management consulting

scenario a - jesse aaron began his management consulting business on january 1 2010. he organized the business as a c

  Amount of total stockholders equity

At the beginning of the year, Albers, Inc., has total stockholders' equity of $840,000 and 40,000 outstanding shares of a single class of capital stock.

  Assume that the company implements a 2-for-1 stock split

on june 30 2011 quinn corporations common stock is priced at 30.0 per share before any stock dividend or split and the

  Standards of business conduct information for starbucks

Go to the Web sites just listed and print the Standards of Business Conduct information for (1) Starbucks Corp. and (2) McDonald's Corp. Read the two statements.

  At the end of the year x company can accept a special order

at the end of the year x company can accept a special order that will result in immediate profit of 28000. however if

  As a result of a thorough physical inventory hastings

as a result of a thorough physical inventory hastings company determined that it had inventory worth 270000 at december

  Journalize the adjusting entrees to be made by baumgarder

baumgardner companys bank statement from last national bank at august 31 2010 shows the following information.balance

  Determining annual financial statements

The company prices its inventory at the lower of cost or market. If the market price for jet fuel at the end of the year is $4.50, how would this situation be reflected in the annual financial statements?

  What is the effect of each of these items on ws basis

Partner A performs $5,000 of contract-type Code Sec. 707(a) services for the ABC partnership in December of 2009, but does not get paid until January of 2010. A and ABC are both calendar-year taxpayers, but A is on the cash basis and ABC is on the..

  On january 1 2011 palmer company leased equipment to woods

on january 1 2011 palmer company leased equipment to woods corporation. the following information pertains to this

  Journal entry to record the employer payroll liability

Prepare the general journal entry to record the employer's payroll liability. Prepare the general journal entry to record the employer's payroll tax liability.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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