N350 Project 1 Linkedin Learning Quiz
PowerPoint Essentials: SmartArt is a good choice to easily create _______. a. Freehand drawings b. Images c. Charts d. Diagrams
Diagrams
Data Visualization: Stories about change over time must always include time as a component in the story. True False
False
Data Visualization: There is one right way to analyze every data set. True False
False
Data Visualization: Great data stories can be delivered as text-only stories. True False
True
Data Driven Presentations: When a chart object is pasted as a link, how is it typically formatted? a. the same as the object that is embedded. b. using the Link theme c. using the destination theme d. as it is in the source workbook
As it is in the source workbook
Data-Driven Presentations: When you paste content like a chart from an Excel workbook into a PowerPoint presentation, the default paste option uses the _____ theme. a. destination b. source c. all of these answers d. Office
Destination
PowerPoint Essentials: You cannot change the layout of a slide if you already have content on it. True False
False
PowerPoint Essentials: Why is putting a text box over an image a good idea? a. You may need to hide elements of the image b. it helps the image fit better on the slide c. it looks nicer d. It makes text stand out
It makes text stand out
PowerPoint Essentials: The Arrange tool aligns objects to _____. a. themselves or the slide b. themselves c. a preset anchor point that you specify d. just the slide
themselves or the slide
Excel Essentials: Which of the following is NOT a typical use for Excel? a. tracking patient information b. creating a budget c. designing a website
c. designing a website
Data Visualization: Which of the following is an example of a neutral word? a. lullaby b. orange c. table d. coffee
c. table
Data Visualization: Often, data is only useful as a _____, which provides the context to make it interesting and relevant to an audience. a. reference point b. comparison c. starting point d. graphic element
comparison
PowerPoint Essentials: Where are stored templates stored? a. By navigating to the folder where you saved the template on your computer b. By changing to the View tab and choosing Templates c. By finding it in OneDrive d. By changing to the Custom tab when creating a new presentation.
d. By changing to the Custom tab when creating a new presentation. Feedback
Data Visualization: Select the tool that is LEAST effective for sketching and storyboarding. a. pencil and paper b. simple sketching software c. whiteboard d. full-featured graphics software
full-featured graphics software
PowerPoint Essentials: Where is the Format Painter tool located? a. on the Home ribbon tab b. on the Drawing ribbon tab c. on the Format ribbon tab d. on the Design ribbon tab
on the Home ribbon tab
PowerPoint Essentials: Which of the following is NOT a source of video you can use? a. YouTube b. From the computer c. A webcam d. Taking a screen recording
A webcam
Data Visualization: Recruiters of data analysts cite communications as the number one skill they're seeking in job candidates. True False
True
Data Visualization: When trying to make data relatable to an audience, you have to explain how it impacts them. True False
True
PowerPoint Essentials: You can change the chart type even if it's already embedded onto a presentation. True False
True
Data Driven Presentations: When pasting an Excel chart into PowerPoint, what is the default option? a. Use destination theme and embed workbook b. Paste as picture c. Use destination theme and link to workbook d. Use source theme and link to workbook
Use destination theme and embed workbook
Excel Essentials: In Excel, a standalone file is called a _______ a. Page b. Worksheet c. Cell d. Workbook
Workbook
Data Driven Presentations: You want to add a table that included formulas into a presentation. What is NOT a good approach? a. All of these are good ways to add this table. b. Create the table in Excel then copy/paste into PowerPoint. c. Create the table in Word then copy/paste into PowerPoint. d. Insert an Excel spreadsheet in PowerPoint and create the table there.
Create the table in Word then copy/paste into PowerPoint.
Excel Essentials: A fast way to make a copy of a sheet in the same workbook is to drag the sheet tab while holding down the _____ key. a. Shift b. Alt c. Tab d. Ctrl
Ctrl
Excel Essentials: How can you insert new cells in a row into your data without disturbing an adjacent set of data on the same sheet? a. Right-click a row above/below where you'd like to place the new row, and then click Insert. b. Highlight only the cells where you'd like to insert a row. Right-click > Insert > Shift cells down. c. Right-click a row above/below where you'd like to place the new row. Click Insert, then specify the cells. d. Click a row above/below where you'd like to place the new row. Home ribbon tab > Insert > Insert Cells.
Highlight only the cells where you'd like to insert a row. Right-click > Insert > Shift cells down.
Data Visualization: Which of the following is not a real acronym learned in the Data Visualization Tutorial? a. KWYRWTS b. KYWDIS c. KWYMADWTS d. KWYANTH
KWYMADWTS
Excel Essentials: All of the following are ways to print your spreadsheets with greater efficiency, EXCEPT: a. Specify your print area. b. Change the page layout to Landscape orientation. c. Remove all headers and footers. d. Hide columns that you do not need.
Remove all headers and footers.
Excel Essentials: What is the keyboard shortcut to launch the Help system? a. Ctrl + H b. Right Arrow c. F1 Key d. ESC Key
Right Arrow
Data Visualization Storytelling: Why is story such a powerful and necessary component of communications? a. Stories occur in a branching-tree structure, which is how the human mind constructs and remembers new ideas. b. Story triggers emotions which leads to better retention of ideas. c. Story helps keep the listener from getting bored and checking their phone. d. Story is an evolutionary imperative that humans have used to adapt and survive.
Story is an evolutionary imperative that humans have used to adapt and survive.
Excel Essentials: What happens if you double-click the right side of a column's header? a. The column width adjusts to fit the largest entry in that column. b. All cells in the column are selected. c. All data in the column is centered d. The column is hidden.
The column width adjusts to fit the largest entry in that column.
Data Driven Specializations: Your data range is formatted as a table, but the Table Tools Design tab is not displayed. What is the most likely reason? a. The ribbon has been customized to hide the Table Tools Design tab. b. The currently selected cell(s) is not the in table. c. you did not enable the Table Tools Design tab before or while creating the table.
The currently selected cell(s) is not the in table.
PowerPoint Essentials: Which one does NOT contain a proper source for images? a. The local computer, online search, Flickr, 3D models b. The local computer, online search, screenshots c. The local computer, 3D models, online pictures, screenshots d. The local computer, online search, 3D models, a photo album
The local computer, online search, Flickr, 3D models
Excel Essentials: If you highlight a column and then click the button to Sort Alphabetically (A-Z), what happens? a. You will be prompted with a dialog box asking how you would like to sort. b. The entire sheet is sorted according to that column. c. The first row will be sorted. d. Only the data in the column is sorted.
You will be prompted with a dialog box asking how you would like to sort.
PowerPoint Essentials: What happens when you choose Rehearse a Presentation? a. Your slideshow automatically launches b. You begin to record audio c. You click Resume Recording to begin d. A menu appears to set the amount of time you would like to spend on each slide.
Your slideshow automatically launches
PowerPoint Essentials: How do you bring an old revision back? a. All of the above b. View the old revision and make the current version look the same c. Copy and paste the slide from the old revision to the current one d. Click Restore to save the old version as a separate file.
a. All of the above
PowerPoint Essentials: If you are exporting your slides as a video, which type has the largest file size and highest quality? a. Ultra HD b. HD c. Standard d. Full HD
a. Ultra HD
PowerPoint Essentials: What is a good technique to bring more attention to text on a shape? a. Use the same shape in a lighter color behind it b. Do not have text on a shape to begin with c. Use a different shape
a. Use the same shape in a lighter color behind it
PowerPoint Essentials: What are some benefits to setting the background as an image? a. all of these answers b. You can easily put text and other objects over the image c. Slides will automatically resize the image to fit the entire slide d. You can't accidentally nudge the photo out of alignment
a. all of these answers
PowerPoint Essentials: What can you fill a shape with? a. all of these answers b. a picture c. a gradient d. a solid color
a. all of these answers
Data Visualization: Which of the following is not a critical component of a linear story? a. interactivity b. flow c. logic d. end
a. interactivity
Data Visualization: Another term for progressive depth stories is _____. a. martini glass structure b. pan and zoom c. kardashian/kant structure d. sedimentary layering
a. martini glass structure
PowerPoint Essentials: What is the easiest way to rearrange a large presentation? a. Manually drag each slide up the navigation pane. b. Change to Slide Sorter view and move them around. c. Delete and recreate the slide in the correct spot. d. Put them in the right order the first time.
b. Change to Slide Sorter view and move them around.
Excel Essentials: You can add items to the Quick Access Toolbar (top left corner) using its drop-down arrow or by taking this action: a. Drag any icon into the Quick Access Toolbar b. Right-click on any icon, then click 'Add to Quick Access Toolbar' c. Double-click any icon d. Hover over any icon then click 'Add to Quick Access Toolbar'
b. Right-click on any icon, then click 'Add to Quick Access Toolbar'
Excel Essentials: The most effective way to add up five different cells in a row is to _____. a. Click on each cell, and put a plus sign in between each. b. Use the SUM function c. type each cell location and type a plus sign between each
b. Use the SUM function
Data Visualization: You might use a flow diagram to visualize your data when you have a _____ to explain or want to show _____. a. method; progress b. process, hierarchy c. data set; linearity d. variable; representation
b. process, hierarchy
Excel Essentials: To create a chart, you begin by _____. a. determining whether you would like a 2-D or 3-D chart b. selecting data c. selecting only column and row headings d. making your headers bold
b. selecting data
Excel Essentials: What is the main purpose of the Freeze Panes command? a. to keep data inside the printable area b. to keep information from scrolling off the screen c. to glue together two or more cells of data d. to lock information so it isn't accidentally changed
b. to keep information from scrolling off the screen
Data Driven Presentations: Use this summary function with any column to display the number of items in a table or group: a. MIN b. COUNT c. AVERAGE d. SUM
b. COUNT
PowerPoint Essentials: What is the difference between a theme and a template? a. A template is a design scheme and a theme comes with ready made text. b. A template and a theme are the same thing. c. A template is a design scheme and a theme comes with ready made text. d. A theme is a design scheme and a template comes with ready made text.
d. A theme is a design scheme and a template comes with ready made text.
PowerPoint Essentials: How do you edit slide design before saving it as a custom theme? a. By adding your company logo to all the slides b. By changing the slide background c. By adding a header or footer d. By editing the Slide Master
d. By editing the Slide Master
Excel Essentials: If you notice that a worksheet displays columns A, B, C, E, F, and G, what happened to column D? a. Column D was merged with column C. b. Column D was relocated farther to the right. c. Column D was deleted. d. Column D is hidden.
d. Column D is hidden.
PowerPoint Essentials: Where is the option to disable Designer from making suggestions? a. View > Designer b. Design > Designer c. File > Tools > Designer d. File > Options > General
d. File > Options > General
PowerPoint Essentials: If you are looking to manipulate an object, what is the best Ribbon tab to look for? a. Home b. Draw c. View d. Format
d. Format
Excel Essentials: When moving data from one cell to another, in order to maintain the formulas of the original cell you must _____. a. re-write the formulas after copying the data. b. lock the formulas through the button on the Data ribbon tab. c. first right-click on the data to lock the formulas. d. simply complete the action. Excel maintains the formulas for you.
d. simply complete the action. Excel maintains the formulas for you.
Data Driven Presentations: The choices that appear in a slicer control are normally _____. a. values (numbers) b. labels (text) c. all of these answers d. values (dates)
labels (text)
Data Visualization: All stories are _____. a. mysteries b. linear c. character-driven d. fast-paced
linear
Data Visualization: What is the primary reason that interactivity works as a storytelling mechanism? a. clean user interface b. people love computers c. narcissism d. mobile-friendly
narcissism
Data Visualization: In a visualization, you should label _____. a. nothing b. the vast majority of datapoints c. only what makes the story clear d. every data point
only what makes the story clear
Excel Essentials: Locking or unlocking cells in a worksheet has no meaningful effect until you _____ the worksheet. a. remove formulas from b. hide c. protect d. share
protect
Data Driven Presentations: A column containing _____ data can be filtered using either a slicer or a timeline. a. date b. percentage c. text d. integer
A. Date
Data-Driven Presentations: What is included in the Theme for a workbook? a. a pair of fonts b. effects for graphic objects c. a color palette
All of these are correct!!!!!!!!!!!
Excel Essentials: You've selected a range of cells and now want to generate a chart. What keyboard shortcut can you use to create the chart? a. Ctrl + C b. Ctrl + F1 c. F12 d. Alt + F1
Alt + F1
Excel Essentials: Workbooks containing _____ cannot be shared. a. Tables b. Conditional Formatting c. Sparklines
Tables
PowerPoint Essentials: How can you have audio play throughout the presentation? a. Click a photo slideshow and choose to loop the audio. b. Choose Loop Audio in the settings screen c. Click Add Audio on the Home ribbon tab d. Choose Play in Background on the audio icon.
Choose Play in Background on the audio icon.
PowerPoint Essentials: Which of the following is NOT something you can see with Presenter view? a. Speaker notes b. Elapsed time c. Comments made by co-creators d. What slide you are on
Comments made by co-creators
Data Driven Presentations: A custom format like 0.0, can compactly display large numbers without changing _____. a. formatting for nearby cells b. the underlying value c. your workbook theme d. formatting of dependent cells
B. The underlying value
PowerPoint Essentials: How do you leave the Slide Master area? a. Change to the Slide Master ribbon tab, click Close Master View b. Change to the Slide Master ribbon tab, click Normal View. c. Change to the Design ribbon tab, click Close Master View.
Change to the Slide Master ribbon tab, click Close Master View
Data Driven Presentations: To create an infographic where each image represents a specific number of units, apply the image to the series, then choose this option: a. Stack b. Automate c. Stack and Scale d. Stretch
C. Stack and scale
Data Driven Presentations: After you paste a table from Excel into PowerPoint as a link, where is future editing for the table done? a. in the browser editor b. all of these answers c. in PowerPoint d. is the linked workbook in Excel
D. Is the linked workbook in Excel
Data Driven Presentations: Excel tables are not usually animated. But what is a good reason to animate a table? a. the table does not fit on the screen b. the table was linked rather than embedded. c. that table contains print that is too small to read d. the table is boring
The table does not fit on the screen
Excel Essentials: Source data for a PivotTable needs to meet several types of criteria. What is NOT on of these criteria? a. Source data should be organized as a list or table. b. Headings should be in a single row at the top of the source data. c. There should be no empty rows or columns within the data. d. There should be no empty cells within the source data.
There should be no empty cells within the source data.
PowerPoint Essentials: If you are trying to share a file but can't, what prerequisite did you probably miss? a. To make sure sharing is turned on b. To make sure the file is saved to OneDrive c. To make sure the file is saved as a PowerPoint template d. To create a sharing link first
To make sure the file is saved to OneDrive
PowerPoint Essentials: To crop an image: a. Click Crop from the view menu, then select the image you want to crop b. Click on the image and select Crop from the Insert menu. c. Click on the image, go to the Format tab and select the crop tool d. Click Crop, then select the image you want to crop.
c. Click on the image, go to the Format tab and select the crop tool
PowerPoint Essentials: How can animation help make your message more impactful? a. It shows off your presentation making skills. b. People respond well to flashy objects. c. It brings storytelling aspect to your message. d. It makes your presentation look more polished.
c. It brings storytelling aspect to your message.
PowerPoint Essentials: What do you need to know about the Morph tool in order to find it? a. It is an animation b.It is on a button on the Home ribbon tab. c. It is slide transition d. It is a button on the Design ribbon tab
c. It is slide transition
PowerPoint Essentials: When is Zoom as a slide summary best used for? a. presentations without a lot of talking b. photo slideshows c. long presentations d. short, quick presentations
c. long presentations
