Which tab in the Excel ribbon contains options for formatting numbers?, Formulas, Data, Home, Insert, What happens when you double-click the fill handle of a cell containing a formula?, It deletes the formula., It copies the formula down to adjacent cells., It moves the cell content., It changes the cell color., How do you select a contiguous range of cells?, Click each cell individually., Click the first cell, hold Shift, and click the last cell., Right-click and drag., Double-click the first cell., What symbol do you start a formula with in Excel?, #, $, =, &, How do you insert a new row in Excel?, Select a column and press Enter., Select a row, right-click, and choose "Insert"., Click the "+" sign at the bottom., Go to Formulas > Insert Row., Excel automatically writes the SUM function for you., AutoFormula, AutoAdd, AutoSum, SUM(), What happens if a number divided either by zero (0) or by a cell that contains no value., #DIV/0!, #DIV/0, #DIVISION!, #DIV/VALULE!, Excel displays this error when a column is not wide enough., #wide-error, ####, ^^^^^, &&&&, This error is displayed when Excel does not recognize text in a formula., #NAME?, #VALUE!, #NULL!, #REF!, Excel displays this error when a value is not available to a function or formula., #N/A, #REF!, #NAME?, #NULL!, Excel can display this error if your formula includes cells that contain different data types., #N/A, #VALUE!, #NAME?, #NULL!, Excel displays this error when a cell reference is not valid., #N/A, #VALUE!, #NAME?, #REF!, Excel displays this error when a formula or function contains invalid numeric values., #N/A, #NUM!, #NAME?, #REF!, Excel displays this error when you specify an intersection of two areas that do not intersect (cross)., #N/A, #NUM!, #NAME?, #NULL!

18-Excel Formula and Error Code

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?