Excel 2016 Essential Training
Right-click - answer-provides a context-specific short cut menu CTRL + n - answer-creates a new workbook what is the mini-toolbar? - answer-It is a limited-feature bar that contains many of the features contained on the Home tab of the toolbar. How can you access Insights, which takes you outside of Microsoft and into the web? - answer-the Smart Lookup feature in a drop-down menu on the ribbon You would like to add commands to the Quick Access Toolbar that you use frequently. Where on a drop-down menu can you access the full list of available commands? - answer-in All Commands You are using your mouse (or cursor) within your Excel sheet. If you slide leftward and put it on a boundary between rows, what does your cursor look like? - answer-a two-way up-down arrow The zoom slider bar lets you enlarge or shrink the data shown on screen. Where is it located? - answer-status bar at bottom of screen Suppose you highlight a column of data in an Excel worksheet. In the Status bar below, what WON'T you see by default? - answer-Min and max values Darren needs his team to use a standard template for reporting expenses. What advice do you give him? - answer-Use one of the templates that is already built Data entries are numbers and by default they____. - answer-line up on the right side of the cell Karl is trying to figure out what he should name his Excel file before saving it. What should be avoided when creating file names? - answer-Avoid using asterisks While Undo is a valuable feature to avoid losing important data, what limitation does it have? - answer-You can only undo actions consecutively and cannot select an action You have created a short summary of your department's budget; however, you noticed that certain entries are not aligned correctly. What is the general rule you should follow? - answer-Numbers are always right-aligned, and text is left-aligned You have received a worksheet from a coworker who told you there are a number of comments you need to review. How do you first know there are comments in the worksheet? - answer-There is a little triangle in the upper right-hand corner of the cell What key opens the Format Cells dialog box? - answer-CTRL + 1 How do you quickly create a table? - answer-CTRL + T How do you quickly create a list? - answer-CTRL + L Your worksheet has a column labeled Profit. When you set up the column in dollar sign and comma format, you notice there is some space to the right of the numbers. Why is this? - answer-to allow for parentheses if the number is negative Ajaypal has added a couple of shapes and a logo to his worksheet. He holds the shift key down as he places these items in the location he wants. What does this do? - answer-This makes the item larger or smaller while maintaining that ratio of height to width What happens if you double-click the right side of a column's header? - answer-The column width adjusts to fit the largest entry in that column You have a worksheet with numbers represented as dollars, percentages, and normal formatting. What happens when you try to realign some of these? - answer-The format of the numerical entry will determine whether the alignment occurs If you want to set up Data Bars, Color Scales, or Icon Sets, where should you go? - answer-Home Conditional formatting What does it mean that Conditional Formatting is dynamic? - answer-If you change a value in a cell, the formatting will apply automatically Mike wants to insert a new row into his data without disturbing an adjacent set of data on the same sheet. He right-clicks his mouse and sees Insert with three dots. What will happen? - answer-When he clicks on that, he will see a dialog box where he can shift cells down. You notice that a worksheet displays columns A, B, C, E, F, and G. What happened to column D? - answer-column D is hidden Kumar just received a lengthy worksheet with the work status of all employees. He is interested in a particular employee named James. What should he do to narrow the list down? - answer-He needs to set the Match case when doing a Find. If you are satisfied with the print preview of a worksheet you set up in Landscape, why might you not be as satisfied if you change it to Portrait? - answer-You might find the column or columns to the right going onto a second page if you use Portrait. What does the solid blue line indicate in Page Break Preview mode? - answer-the boundary between data that that will and won't print If there are negative values in your data, why would you not want to use a pie chart type? - answer-negative values are not shown on a pie chart Your data is in six rows. If you create a sparkline using columns, what caution is there in making comparisons? - answer-you cannot use height of the sparkline columns to compare data between rows Steve is making a chart of data from his worksheet. He has selected his data and inserted a chart; however, the visual of the numbers is distorted. What is the likely cause of this issue? - answer-He selected the totals from his worksheet to include in the chart Kathy needs to edit the chart she just made. She clicks on the title and enters =A1 from her worksheet. What is the result? - answer-The title from the worksheet in cell A1 is added to the chart title text box To create a chart, you begin by _____. - answer-selecting data If you use the Alt+F1 shortcut to create a chart, which chart type will appear? - answer-a clustered column chart You are giving a presentation of your sales for the year across all regions and by all months. Why are you considering using outlining? - answer-Outlining can collapse the spreadsheet into, for example, only quarterly totals to make the spreadsheet easier to read You want to keep columns A and B visible while you scroll through your other worksheet data. How will you do this? - answer-Position the active cell as C1, go to Freeze Panes on the View tab of the ribbon, and then select Freeze Panes Jake has a worksheet with many columns of data. He wants to see different parts of a list at the same time. Which action would be best for him to take? - answer-split vertically You used the Tiled selection under Arrange All to display three open workbooks. To more easily work with the data, you want a particular workbook to fill the screen. What can you do? - answer-Select the Maximize button for that workbook Jhane is the regional manager for 10 states in the Northeast. She is presenting her region's sales and has used a formula in her worksheet: =sum('Maine:Pennsylvania'!) What is this formula doing? - answer-adding data for Maine through Pennsylvania into a new worksheet For some reason, such as an interruption, you selected Delete in the warning pop-up for a sheet that you were not sure you wanted to delete. What have you done? - answer-You have deleted the sheet, and you will not be able to use Undo to undo the delete when creating an IF function, a ___ separates the logical test from the value if true/false. - answer-comma Wha
Información del documento
- Subido en
- 26 de junio de 2024
- Número de páginas
- 4
- Escrito en
- 2023/2024
- Tipo
- Otro
- Personaje
- Desconocido