34.When you copy a formula that contains an absolutereference to a new location, the reference ____.a.is updatedautomaticallyc.becomesboldb.does notchanged.has a dottedoutline in itscellANS:BPTS:1REF:EX 123 Show 35.Use ____ references when you want different formulas torefer to the same cell.PTS:1REF:EX 126 Get answer to your question and much more 36.One of the most common statistical approaches is to____ the sample data.PTS:1REF:EX 130 Get answer to your question and much more 37.Another name for the middle value is the ____ value.PTS:1REF:EX 130 Get answer to your question and much more 38.The ____ is most often used with data that has only a fewpossible values.a.modec.middleb.mediand.sumANS:APTS:1REF:EX 130 39.____ arguments may provide more control over thereturned value.PTS:1REF:EX 128 Get answer to your question and much more 40.FUNCTION(argument1,argument2, ...) is ____. Get answer to your question and much more Get answer to your question and much more 41.Arguments can be ____.PTS:1REF:EX 117 Get answer to your question and much more 42.If an optional argument is not included, Excel assumesa(n) ____ value for it.a.defaultc.staticb.genericd.absoluteANS:APTS:1REF:EX 128 43.Excel functions are organized into ____ categories.PTS:1REF:EX 128 Get answer to your question and much more 44.Which of the following is not an Excel function category?____PTS:1REF:EX 128 Get answer to your question and much more 45.Lookup & Reference is ____. Get answer to your question and much more c.an Excel function categoryd.a reference panel found onthe Office ButtonANS:CPTS:1REF:EX 12846.The ____ function category retrieves data frommultidimensional databases involving online analyticalprocessing or OLAP.a.Databasec.Textb.Cubed.FinancialANS:BPTS:1REF:EX 128 47.Which function counts how many cells in a range containnumbers, wherevalue1,value2, and so forth are text,numbers, or cell references?PTS:1REF:EX 129 Get answer to your question and much more 48.In “SUM(number1[,number2,number3, ...])”, number 1,number 2, and number 3 may be numbers or ____.PTS:1REF:EX 129 Get answer to your question and much more 49.Which category of Excel functions returns informationabout the format, location, or contents of worksheetcells? ____ Get answer to your question and much more Get answer to your question and much more Upload your study docs or become a Course Hero member to access this document Upload your study docs or become a Course Hero member to access this document What is cell reference Excel quizlet?In Excel and other spreadsheets, an absolute cell reference identifies the location a cell or group of cells.Cell references are used in formulas, functions, charts , and other Excel commands.An absolute cell reference consists of the column letter and row number surrounded by dollar signs ( $ ) Tap the card to flip 👆
When creating formulas What is a mixed reference quizlet?A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row. operands can be values, cell references, names, labels, and functions. operator.
Which of the following is not an Excel function category ___?The correct answer is "ALT".
When you copy a formula that contains an absolute reference?If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.
|