Excel Chapter 1.docx

**Excel Chapter 1:** 1\) New workbooks typically contain how many worksheets? A\) 0 **B) 1 \*** C\) 2 D\) 3   2\) What is the small green square in the bottom right of a cell called? A\) Sizing handle **B) Fill handle \*** C\) Copy/Paste handle D\) Move Cell handle   3\) What feature in...

**Excel Chapter 1:** 1\) New workbooks typically contain how many worksheets? A\) 0 **B) 1 \*** C\) 2 D\) 3   2\) What is the small green square in the bottom right of a cell called? A\) Sizing handle **B) Fill handle \*** C\) Copy/Paste handle D\) Move Cell handle   3\) What feature in Excel allows you to begin with a 1 in A1 and a 2 in A2 and complete the sequence through the number 30 in A30 without having to type in the entire sequence? A\) Auto Copy B\) There is no such feature in Excel. C\) Auto Complete **D) Auto Fill \***   4\) What do you adjust if you see \#\#\#\#\#\# displayed in a cell? A\) Number format B\) Row height C\) Formula in the cell **D) Column width \***   5\) Which of the following is *not* true about a Fill color? A\) It is color that displays behind the data in the cell. B\) It can help the data stand out. **C) It *cannot* be applied to an entire row or column. \*** D\) It should contrast with the font color.   6\) Which of the following would *not* be considered text? A\) Phone number (111.111.1111) B\) Social Security number (111-11-1111) C\) Part number (PT111) **D) =2\*2 \***   7\) What does pressing the Enter key while in a cell, do? A\) The current active cell remains the active cell B\) The cell to the right becomes the active cell **C) The cell below becomes the active cell \*** D\) The action is the same as pressing the Tab key         8\) Which keyboard shortcut puts the user in cell edit mode? **A) F2 \*** B\) Shift F2 C\) F3 D\) Shift F3   9\) Which of the following is *not* true of the Formula bar? A\) You can edit cell contents there. B\) It is to the right of the Insert Function command. **C) It allows you to pick from an assortment of formulas. \*** D\) It displays the contents stored in the active cell.   10\) How is text aligned by default? **A) Left \*** B\) Center C\) Right D\) Decimal   11\) Which of the following is *not* a valid formula? A\) =D3 B\) =2\*2 C\) =sum(1,2,3,4,5) **D) =\#12/31/2018\#-\#12/31/2019\# \***   12\) What can the phrase \"Please Excuse My Dear Aunt Sally\" help you remember? A\) How to do date calculations **B) Order of operations \*** C\) Naming convention for cell ranges D\) The various printing options available in Excel   13\) In the formula, =1+(2-3)+5/6-6\^2, what will Excel evaluate first? A\) 5/6 B\) 1+ **C) (2-3) \*** D\) 6\^2   14\) In the formula, =1+(2-3)+5/6-6\^2, what will Excel evaluate second? A\) 5/6 B\) 1+ C\) (2-3) **D) 6\^2 \***       15\) What is the true about an input area? **A) It is used when certain values are used repeatedly throughout the worksheet. \*** B\) It is useful when your values change frequently throughout the worksheet. C\) It should be located below the rest of your data. D\) It should only contain one input cell.   16\) What should you do if there are columns you need, but do not want to display? A\) Delete the columns you do not want to display then undo your action when finished. B\) Move the columns you want to see so that they are together then move them back to their original locations with finished. C\) Cut and paste the columns you do not want to display to another area of the worksheet. **D) Hide the columns you do not want to display, then unhide them when finished. \***   17\) What does it mean when you see \#\#\#\#\#\#\# in a cell? A\) Your formula is incorrect. B\) At least one of the cell references in your formula is pointing to an empty cell. **C) Your column is not wide enough. \*** D\) Your row is not tall enough.   18\) One point is how big? **A) 1/72 of an inch \*** B\) 1/36 of an inch C\) The same as a pixel D\) The same as one character   19\) Which of the following is *not* a way to widen a column? A\) Drag the line between the column headings to the desired size **B) Click on the Column label and drag it to the right \*** C\) Double-click the line between the column headings D\) Right-click a column heading and select Column Width   20\) A range is specified by its \_\_\_\_\_\_\_\_. A\) top and bottom row and left and right column B\) top row and leftmost column C\) top right and bottom left cells **D) top left and bottom right cells \***   21\) What is the best practice to switch the columns and rows in a range? A\) Cut the range, then use the Paste Special option called Values **B) Cut the range, then use the Paste Special option called Transpose \*** C\) Cut the range, then use the Paste Special option called Switch D\) Cut the range, paste it into a blank area, then cut and paste each cell where you want it         22\) Which is *not* a valid range? **A) A1:A3, B1:B3 \*** B\) A1:A9 C\) A1:F1 D\) A1:F9   23\) Which Paste option would you choose if you wanted to flip the rows and columns? **A) Transpose \*** B\) Rotate C\) Flip D\) Formulas   24\) Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact? A\) Paste B\) Values C\) Values & Number Formatting **D) Values & Source Formatting \***   25\) What Paste option would you choose if you wanted to maintain the formatting of the copied cell, but not its contents? **A) Formatting \*** B\) Keep Source Formatting C\) Paste D\) Keep Formatting Only   26\) Where can you find more alignment options? **A) Format Cells dialog box \*** B\) Format Alignment dialog box C\) Format dialog box D\) Format Rows and Columns dialog box   27\) Which of the following is *not* included when you use a cell style? A\) Font **B) Cell protection \*** C\) Alignment D\) Borders   28\) What is the best practice for centering a title over multiple columns? A\) Enter the title in the center column of the range B\) Use the Merge Title feature **C) Use the Merge & Center alignment \*** D\) Use the Combine and Center alignment       29\) If you have too many words in a cell, but you cannot allow them to bleed over into the next cell, you would use the \_\_\_\_\_\_\_\_ feature in Excel. **A) wrap text \*** B\) truncate text C\) shorten text D\) merge text   30\) The default number format is \_\_\_\_\_\_\_\_. A\) Number B\) Left aligned C\) Two decimal places **D) General \***   31\) Which of the following is *not* a valid number format? A\) \$1,000.00 **B) \$       1,000.000 \*** C\) (1,000.00) D\) \$       -1,000.00 ??   32\) What can you *not* do within the worksheet tabs shortcut menu? **A) Format the worksheet \*** B\) Add color to the tab C\) Insert a worksheet D\) Delete a worksheet   33\) Which of the following names would be best for a worksheet tab? A\) Sheet 1 B\) Jan **C) January Payroll Information \*** D\) JPAE   34\) The best way to apply Page Setup options to multiple worksheets is to \_\_\_\_\_\_\_\_. **A) group the worksheets \*** B\) use the Format Painter C\) copy and Paste the formatting codes from one sheet to another D\) use the Apply to Selected Sheets formatting command   35\) What is the best way to make sure your worksheet prints on only one page? A\) Limit the amount of data you put on each worksheet B\) Make the font sizes smaller C\) Make the margins as small as possible **D) Use the \"Fit to\" option \*** 36\) What would *not* be a typical item to have in a header or footer? A\) The spreadsheet designer\'s name B\) The filename or file path **C) The file size \*** D\) The page number   37\) What can you *not* do from the Page Setup, Sheet tab? **A) Set margins \*** B\) Set a print area C\) Print gridlines D\) Change the page order   38\) What can you *not* do directly from the Backstage, Print screen view? **A) Switch to formula view and print formulas \*** B\) Select which printer you want to use C\) Select how much of the worksheet will be printed D\) Set the page orientation