• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Other

Excel 2016 Essential Training

Document preview thumbnail
Preview 1 out of 4 pages

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


Document information

Uploaded on
June 26, 2024
Number of pages
4
Written in
2023/2024
Type
Other
Person
Unknown
$10.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TOPDOCTOR
5.0
(1)
Sold
10
Followers
5
Items
3387
Last sold
1 year ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.