which of the following option buttons gives options for filling cells following a fill operation?

which of the following option buttons gives options for filling cells following a fill operation?

Asked by 2 years ago
9.9k points


table class="table table-hover">

In Excel, a number can contain the characters ______All of the aboveA thin red border indicates the active cellTrueA (n) _____ window is an open window hidden from view but that can be displayed quickly by clicking the window's program button on task bar (dock)AdministeredChoose a type of chart that relays the message that you want to conveyTrueIf you inadvertently rename a file that is associated with certain programs, the programs may not be able to find the file and may not execute properlyTrueA ___ is an icon on the desktop that provides a user with immediate access to a program or fileShortcutThe AutoCorrect feature can automatically capitalize the first letter in the names of daysFalseA(n) _____ chart is drawn on the same worksheet as the dataembeddedA ___ helps you manage multiple folders and files stored in various locations on a computerLibraryA(n) ___ on a menu performs a specific action, such as saving a fileIndicatorExcel can display characters in only three font colors: black, red, blueTrueBoth the Cancel box and the Enter box appear on the formula bar when you begin typing in a cellTrueTo enter data in a cell, you must first select or activate the ____CellClicking the ___ box completes an entryEnterTo cancel an entire entry before entering it into a cell press the ___ keyALTTo draw a chart, first select the data to be charted and then click the Chart tool tabFalseCombining two or more selected cells into one cell is called ____ cellsMergingA cell is referred to by its cell ____referenceWhen you click the Tab key to complete an entry in a cell, the active cell moves down to the next cell in the same columnFalseIn Microsoft Office applications, each ____ contains a collections of groups, each of which contains related commandsTabOne method of changing the size of a window is to drag the window bordersTrueMicrosoft Office programs use ____ dialog boxes for performing actions such as opening and saving filesCommonThe first step in creating an effective worksheet is to make sure you ____Understand what is requiredA ____ consists of a drive letter and colon, to identify the storage device, and one or more folder namesPathExcel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTEr keyLeft ParenthesisA ____ is a pre-written formula that is built into excelFunctionWhich of the following option buttons gives options for filling cells following a fill operationAuto Fill OptionsThe ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three postitions to the left of the decimal point, and displays numbers to the nearest centAccounting StyleYou can use ____ to check which cells are referenced in the formula assigned to the active cellRange FinderToo obtain the formulas version of a worksheet use the ____ keysCTRL + ACCENT MARK (COMMAND ACCENT MARK)Which of the following calculations multiplies 23 by 0.01=23%You can clear cell contents and the formatting by clicking the Clear Contents on the Clear button menuTruePoint mode allows you to select cells for use in a formula by using the keyboardFalseThe Insert Options button lists formatting optionsFalseYou can click the ___ button to undo an automatic correctionAuto Fill OptionsYou should ___ a function name in the Formula AutoComplete list to select the functiondouble-clickThe ___ function sums the numbers in the specified range and then divides the sum by the number or cells with numeric values in the rangeAverageWhich of the following happens when you enter the formula =G15 into a cellExcel assigns the value in cell G15 to the active cellThe equal sign (=) precedes a formulaTrueExcel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric dataFalseThe ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal signFormulaAs in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculationsFalseThe arithmetic opertaor ^ directs Excel to perform the division operationFalseAn asterisk (*) following a cell reference in a formula us the arithmetic operator that directs Excel to perform the division operationFalseTo paste copied cell contents, you can press the ____ keysCTRL + V (COMMAND V)Which of the following is the path to the Copy and Paste buttons(Home Tab- Clipboard Group)All of the following are valid Excel arithmetic operators except____^You can use the arrow keys to complete an entry Keyboard modeTrueWith Excel in Edit mode, you can edit cell content directly in the cellTrueA relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination areaTrueThe ___ function is useful when you want to assign a value based on a logical testIFA worksheet header is the same as a worksheet titleFalseA paste option can allow the copying of the format onlyTrueThe comparision means greater thanFalseIf the contents of cell A1 containing 410 and A2 containing 430 are copied using the fill handle, then the next three values of an extended series can be: 450, 470, 490TrueA(n) ___ IF function is one in which the action to be taken for the true or false case includes yet another IF functionIncludedWhen you rest the mouse pointer over a chart item such as the legend, Excel displays a chart tip containing the name of an itemTrueYou can ensure correctness by in your formulas by using the ___Range FinderThe copy button copies the contents and format of the source area to the office _____, a reserved place in the computers memory...Rotates text allows you to fit more text into a smaller column widthTrueWhich comparision operator means "not equal to"?
which of

Your Answer

Surround your text in *italics* or **bold**, to write a math equation use, for example, $x^2+2x+1=0$ or $$\beta^2-1=0$$

Use LaTeX to type formulas and markdown to format text. See example.

Sign up or Log in

  • Answer the question above my logging into the following networks
Sign in
Sign in
Sign in

Post as a guest

  • Your email will not be shared or posted anywhere on our site

Views: 30
Asked: 2 years ago