Download Data Visualization Exam Review: Charts, Pivot Tables, and PowerPoint and more Exams Nursing in PDF only on Docsity!
INF 101 Final Exam Review
How can you use data sources to create column charts? - correct answer You select the placeholder cell first, then highlight the data that you want to use in the chart. You can then select what type of chart you want to create. In this case, it would be a column chart. How can column charts be edited and formatted? - correct answer You can change the fill to the bars to make them look different, you can pre-select specific data, you can change the chart title and axes titles, you can create a clustered column chart that displays individual amounts for a specific set and the totals for each, and you can also remove the totals. Which axis is used to read the two different data displays when using combo charts?
- correct answer The Y-axis on the left and right Can the ranges of the X and Y-axes be adjusted (combo charts)? - correct answer Yes Why do people use pie charts instead of other charts? (pie chart strengths) - correct answer They are visually attractive and effectively emphasize specific categories Charts: What is a cross icon and what is it used for? - correct answer It lets you choose which chart elements you want to show Charts: What is a pen icon and what is it used for? - correct answer It lets you change the style of the chart Charts: What is a funnel icon and what is it used for? - correct answer It lets you chose which values you want to use Bubble chart: What variable is typically represented by the size of the bubble? - correct answer The third value
Pie chart: When using the Format Data Series dialog box, what does changing the angle of the first slice do? - correct answer It rotates whichever slice you want so you can position it where you want Pie chart: When using the Format Data Series dialog box, what does changing the degree of a pie explosion do? - correct answer It separates the slice you want from the rest of the pie chart so that it's more noticeable or emphasized vLookup: When should you use an exact match? - correct answer When you have unique identifiers vLookup: When should you use an approximate match? - correct answer When you have a range of numbers Pivot tables: How do you drill down to the detail data? - correct answer You can double click on any of the categories or hit the plus sign that's directly to the left to them Pivot tables: What choices are available when you choose to "Summarize values by"? - correct answer sum, count, average, max, min, product Pivot tables: What choices are available when you choose to "Show values as"? - correct answer basically the % of anything with the word total in it, but also difference from, ranking smallest to largest or largest to smallest, and index Pivot tables: What are the rules that pivot tables need to conform to? - correct answer the categories have to go into the correct fields in the correct order, you have to change the values to what you want them to be, the numbers have to be formatted correctly Pivot tables: Do you include the headings when you select the data for the pivot tables? - correct answer Yes
number format in the drop-down, select the currency format and pick the number of decimal places you want Pivot tables: What typically goes into the values quadrant? - correct answer the cost of something Pivot tables: What happens if you drag a text field into the values quadrant? - correct answer you get an error; it won't work How does the PowerPoint create new slide button function? - correct answer clicking on the new slide button will create a new and clear slide that has the same layout as the slide you were just on, but if you hit the down arrow you can pick a different layout for the new slide What can you do with PowerPoint shapes? - correct answer you can animate them, add special effects, change their colors, add text to them, and add borders What are David Phillips central design principles when creating PowerPoint slides? - correct answer only have one message per slide, elements should reinforce each other, control the focus, control the contrast, and display six items at most on the slide How does one use SmartArt? - correct answer you can insert a SmartArt item onto the slide via the insert tab and add text to it after, or you can select bulleted text and concert it to SmartArt via the drawing tools format tab Can SmartArt be ungrouped? - correct answer Yes PowerPoint: What are the various ways that text boxes can be manipulated, formatted or used? - correct answer they can be placed anywhere on the slide, increase or decrease the indent, change the font size, change the shape styles (theme styles), you can change the fill color, add a border, rotate it, and bring it forward to overlap other objects
PowerPoint: Why are master slides used? - correct answer to put something on multiple slides without having to manually do it PowerPoint: What are some of the main types of Creative Commons licenses? - correct answer all creative commons, commercial use allowed, modifications allowed, commercial use and modifications allowed, no known copyright restrictions, or U.S. Government works PowerPoint: What are the advantages of using a Creative Commons license? - correct answer you can use an image without paying a fee, sometimes you can change the image, and you might even be able to make money off of the image What are the ways in which video can be used with PowerPoint? - correct answer you can directly link in a video from the internet or you can upload a video that's already downloaded to your computer What are the various types of bullet points available in PowerPoint? - correct answer dots, filled squares, empty squares, arrows, diamonds, check marks, circles PowerPoint: What does increase indent and decrease indent do with bullet points? - correct answer if you increase the indent it will make the bullet points go further to the right, and if you decrease the indent it will make the bullet points go further to the left (within limits of the text-box) What is the use for the normal view in PowerPoint? - correct answer when you're first creating the PowerPoint What is the use for the outline view in PowerPoint? - correct answer to view and edit text; also so you can have the information that's on the slides without having to pull up the actual presentation; you can print the outline or copy it into a document What is the use for the slide sorter view in PowerPoint? - correct answer to arrange the slides, delete some slides
Internet: Why was TCP added to IP for network traffic? - correct answer to fix the problems that IP had when it was by itself (TCP numbers the data when it breaks into packets, reassembles the packets when they arrive out of order, slows down the transmission of data if it's too fast, and sends a message to resend packages if they're lost) Internet: What is the function of routers? - correct answer they connect networks Internet: How are routers different from switches? - correct answer routers use IP addresses, while switches need to know physical addresses Internet: What is the difference between a VPN and a Firewall? - correct answer a VPN is a private network that works by encrypting all traffic, while a firewall is used to filter and block things that could be dangerous Why would one use a Creative Commons license with using images on the Internet?
- correct answer so that you don't get in trouble for using someone else's creative work How does Creative Commons help with copyright issues? - correct answer it sets clear boundaries so that a person knows what they can do with an image and what the consequences are if they don't follow the regulations Internet: What kinds of information does Google track? - correct answer things on the surface web Internet: What are event data recorders? - correct answer they log information without consent; in a car it logs our speed at the time of an accident, whether we had a seat-belt on, whether we were breaking, etc. Internet: How are whitelists different from blacklists? - correct answer a whitelist allows all traffic and all protocols from specific computers, while a blacklist disallows any traffic from specific computers
Internet: How is the dark web different from the deep web? - correct answer the dark web is a subset of the deep web; the dark web is an extremely private area of the web and can be used anonymously; the deep web entails things protected by a password or where transactions occur
