Question 1You can enter the correct range in a function by typing the beginning and ending cell references separated by...

Question 1You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. Question 1 options:semi-colon (;)colon (:)period (.)none of the aboveQuestion 2How many chart types does Excel offer? Question 2 options:5112950Question 3In Excel, a number can contain the characters _____. Question 3 options:0 1 2 3 4 5 6 7 8 9+ - ( ) , /. $ % E eall of the aboveQuestion 4To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or

you can type _____.

 Question 4 options:6,000T6K0006Q6E15Question 5What effect does the Comma Style format have on the selected cells? Question 5 options:Converts decimals to commas within a cellConverts decimals to commas within merged cellsDisplays cell contents with two decimal places and commas as thousands separatorsAllows for substitution of selected charactersQuestion 6To enter data in a cell, you must first select or activate the _____. Question 6 options:rowworksheetcolumncellQuestion 7Pressing the _____ key to complete an entry activates the adjacent cell to the right. Question 7 options:RIGHT ARROWLEFT ARROWUP ARROWDOWN ARROWQuestion 8Clicking the _____ box completes an entry. Question 8 options:CancelFormulaEnterTabQuestion 9By default, text is _____ in a cell. Question 9 options:left-alignedcenteredjustifiedright-alignedQuestion 10The _____ is the small black square located in the lower-right corner of the heavy border around the active cell. Question 10 options:selection handlesizing handlefill handlecopy handleQuestion 11

In the accompanying figure, the _____ identifies the colors assigned to each bar in the chart on a worksheet.

 Question 11 options:color codeidentifierexplanationlegendQuestion 12To cancel an entire entry before entering it into the cell, press the _____ key. Question 12 options:ALTESCCTRLTABQuestion 13

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

 Question 13 options:rangebunchnearby cellneighborQuestion 14What effect does the Accounting Number Format have on the selected cells? Question 14 options:Converts alphabetic characters to numbersDisplays cell contents with two decimal places that align verticallyPerforms tax calculationsCopies the numbers of one cell to anotherQuestion 15The first step in creating an effective worksheet is to make sure you _____. Question 15 options:apply font formattingunderstand what is requiredinsert a chartenter the dataQuestion 16Which of the following calculations multiplies 23 by 0.01? Question 16 options:=23%=23=23+.01=24-.01Question 17Which of the following happens when you enter the formula =G15 into a cell? Question 17 options:Excel recalculates all formulas in the worksheetExcel assigns the sum of the values in the previous 15 cells to the active cellExcel assigns the value in cell G15 to the active cellNothing; =G15 is an invalid formulaQuestion 18To start a new line in a cell, press the _____ keys. Question 18 options:CTRL+ENTERTAB+ENTERALT+ENTERSHIFT+ENTERQuestion 19To copy cell contents, you can select the cell and then press the _____ keys. Question 19 options:CTRL+VCTRL+XCTRL+BCTRL+CQuestion 20When you enter a two-digit year that is less than 30, Excel changes the year to _____. Question 20 options:20xx30xx18xx19xxQuestion 21Which of the following is the path to the Conditional Formatting button? Question 21 options:(Home tab | Editing group)(Styles tab | Formatting group)(Formatting tab | Styles group)(Home tab | Styles group)Question 22You can select a range using the keyboard by pressing the _____ key and then an ARROW key. Question 22 options:F2F4F6F8Question 23Which of the following is the path to the Spelling button? Question 23 options:(Home tab | Proofing group)(Proofing tab | Spelling group)(Review tab | Proofing group)(Review tab | Checking group)Question 24All of the following are valid Excel arithmetic operators except _____. Question 24 options:^*%>Question 25The adjusted cell references in a copied and pasted formula are called _____ references. Question 25 options:relatedrelativepastedalternativeQuestion 26Which of the following is not a valid format symbol? Question 26 options:semi-colon (;)percent sign (%)dollar sign ($)comma (,)Question 27_____ refers to cells not wide enough to display the entire entry. Question 27 options:#####&&&&&$$$$$+++++Question 28Which of the following formulas contains an absolute cell reference? Question 28 options:=$B4=B$4=$B$4=B4Question 29

In the accompanying figure, the split double arrow mouse pointer _____.

 Question 29 options:indicates a hidden columnallows text to be entered at that locationis the result of moving the mouse pointer to the boundary between column heading A and column heading Bindicates the proposed width of column AQuestion 30The _____ function is useful when you want to assign a value to a cell based on a logical test. Question 30 options:IFNOWANDORQuestion 31When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values. Question 31 options:logicalconstantconsistentcalculatedQuestion 32If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.