Excel Certification Exam Questions And Answers

Every cell in a Microsoft Excel worksheet has a cell address that notes the row and column where the cell lives. What is this address called? - Answer- cell reference What is a quick way to search for blank data in a column? - Answer- Highlight the first cell in the column and press Ctrl-[down arrow] to highlight to the first empty cell in that column. What is one way to preserve the value of a calculation without retaining the calculation in the cell? - Answer- Select the cells, copy, and use the Paste Special option to paste the values of the calculations, not the calculations themselves, in the cells. Microsoft Excel's auto-sequencing capabilities enable you to number rows or columns sequentially without typing each of the numbers. How do you auto-sequence a row of numbers? - Answer- Type the first cell of numbers (1), click on the "magic box" in the lower right corner of the cell, press the Ctrl key, and drag across the number of cells you want numbered automatically. A powerful tool in Microsoft Excel automatically enters data when it senses a pattern in what you are entering. What is the name of this tool? - Answer- Flash Fill What is the purpose of the Convert Text to Columns wizard? - Answer- It splits data in a single column containing multiple pieces of data into multiple columns of data. What does the From Web button enable you to do? - Answer- Import data from a web page into Microsoft Excel If you sort one column of data in a table without sorting all of the columns, what happens? - Answer- Only the column you sorted will sort, which will mean rows of information are now out of alignment. If you are creating a formula and want column N to be absolute and row 95 to be relative, how do you enter the cell into the formula? - Answer- $N95 Every formula needs to begin a specific way to indicate that it is a formula. How do formulas begin? - Answer- With an equal sign (=) In creating worksheets and analysis, what task likely requires the most time? - Answer- Data preparation and cleanup What does the Flash Fill feature do? - Answer- Fills out subsequent data when it senses a pattern in