Final Exam INF 101
In using video in PowerPoint it is always set to play when the slide is shown in the presentation. it is always better to use the online version of video (as opposed to the locally stored video). the rectangular box that plays the video is adjustable. it is easier to use non-YouTube videos than YouTube videos.
the rectangular box that plays the video is adjustable.
In the Report Layout group (pick all of the correct answers) the compact form option places the totals at the bottom of the selected field. the outline form is "busier" than the tabular form. the outline form puts the totals at the bottom of each group. the tabular form puts the totals at the bottom of each group.
the tabular form puts the totals at the bottom of each group.
In using pivot tables with transaction data, it is best to use limited data sets because Excel cannot handle large data sets. the order of the fields dragged into the rows (or columns) quadrant is not important. the only useful calculation is the sum (or total) calculation. time is often an important element.
time is often an important element.
You can calculate a variety of results by the Show Values as option. using the Summarize Values by option. dragging the Cost field into the values quadrant. Dragging the Cost field into the filters quadrant.
using the Summarize Values by option. dragging the Cost field into the values quadrant.
When formatting numbers it is important to select all of the numbers before formatting them. we should click one number and then apply the Number formatting option.
we should click one number and then apply the Number formatting option.
In using SmartArt if the SmartArt icon you have chosen has four places for text, you can only use four textual entries. you could move the individual elements around by grouping them. you can separate the individual elements by ungrouping them. you cannot change the fill colors of the individual elements of SmartArt.
you can separate the individual elements by ungrouping them.
In doing a frequency distribution using a pivot table: you use the group option for the distribution count column. you use the group option for the grading scale column.
you use the group option for the distribution count column.
The Presenter View Can be activated using ctrl-F5. Has a zoom in option. Shows a preview of the upcoming slide. Can use one or two monitors.
Has a zoom in option. Shows a preview of the upcoming slide.
The VLOOKUP function Often uses absolute references because the formula is often copied in a column of cells. Should not use a named range because the formula is never copied. Cannot use a named range because the formula is often copied in a column of cells. Does not need absolute references when the formula is copied in a column of cells.
Often uses absolute references because the formula is often copied in a column of cells.
TCP/IP Includes the destination address but not the source address in its packets sent across the Internet. Includes the source address but not the destination address in its packets sent across the Internet. Hides both addresses. Sends both addresses in plain text.
Sends both addresses in plain text.
Google indexes approximately a. 3% of the world's websites. b. 7% of the world's websites. c. 15% of the world's websites. d. 20% of the world's websites.
a
The Deep Web a. Is a sinister place. b. Is typically data protected by a login.
b
The Screen Recording function a. Is a very robust software application with many features. b. Allows us to record our voices along with actions taken with software.
b
The domain name service (DNS) a. Translates numbers to names. b. Translates names to numbers.
b
David Phillips: a. Believes that PowerPoint is flawed which causes "Death by PowerPoint." b. Believes that adding more content to slides is preferable to adding more slides. c. Believes that the number of slides in a presentation is not a problem in itself. d. Likes a certain amount of "busyness" in a slide.
c
Stacked column charts are good at showing total sales. are good for comparing individuals sales figures from month to month. are difficult to create. have only a 2-D option.
are good at showing total sales.
A best-effort kind of service a. Provides the best service possible. b. Does not guarantee delivery of messages (packets).
b
Slicers a. Sort data. b. Display pivot charts. c. Import data. d. Filter data.
d
Pivot tables (pick all of the correct answers) require well-formed data to work properly. cannot use data that is placed at the top or on the side of a spreadsheet. do not like white space around the cells containing the data. do like white space around the cells containing the data.
require well-formed data to work properly. do like white space around the cells containing the data.
The Screen Recording function Is a very robust software application with many features. Allows us to record our voice along with actions taken with software.
Allows us to record our voice along with actions taken with software.
In using multiple worksheets (pick all the correct answers) Formulas can include cells from different worksheets. The names of the cells include references to the name of the worksheet. The name of the worksheet is the title at the top of the sheet. Summary worksheets require the user to manually enter totals (not link totals to other worksheets).
Formulas can include cells from different worksheets. The names of the cells include references to the name of the worksheet.
The Internet Had its beginnings in creating a network for communications by the Department of Defense. In its early days had little university use. In its early days used onion routing. In its early days used switches and not routers.
Had its beginnings in creating a network for communications by the Department of Defense.
A Google index Helps in locating websites. Is a stock market indicator.
Helps in locating websites.
The Deep web Is a sinister place. Is typically data protected by a login.
Is typically data protected by a login.
Select the correct answer(s). Switches work with physical addresses. Routers work with IP addresses.
Routers work with IP addresses.
In creating passwords, it is good practice to Use all lowercase letters. Use all numbers. Use only uppercase and lowercase letters. Use some special characters.
Use some special characters.
When you use multiple worksheets and you retrieve information from one to go into the other Start by using the = in the cell where you wish to put the information. Use the = in the cell where you wish to retrieve the information. After locating the desired cell (with the information you wish to put in a different worksheet) and clicking on it, press Enter. That information is often useful in summary sheets.
Start by using the = in the cell where you wish to put the information. After locating the desired cell (with the information you wish to put in a different worksheet) and clicking on it, press Enter. That information is often useful in summary sheets.
Cryptocurrency gets rid of banks as the middleman.
T
If objects are ungrouped, each can be animated separately.
T
In formatting a table using pivot tables, Excel provides a way to have the totals at the top or at the bottom of a category.
T
OneNote searches use optical character recognition.
T
PowerPoint printing options include printing notes pages
T
T/F Charts are considered to be a more effective way of displaying selected data than tables when doing presentations.
T
T/F Pivot tables handle transaction data well.
T
The PMT function has these five variables. (Select all the correct answers) (Rate, Nper, Pv, Fv, Type) The Rate entered should be the yearly rate. The Nper is the number of payments for the loan. The Pv is the value of the loan paid off (zero). The Type is optional.
The Nper is the number of payments for the loan. The Type is optional.
Pick the correct answers. The Screen Recording feature and the Slide Show Recording feature are the same. The Screen Recording feature allows using a web camera. The Slide Show Recording option shows us using other software so that we can demonstrate its use. The Screen Recording feature records our voice while we are demonstrating software.
The Screen Recording feature records our voice while we are demonstrating software.
In the combo chart The columns represent sales and expenses. The column values are read on the vertical column on the right. The line values are read on the Y-axis on the left. The line values are read on the Y-axis on the right.
The columns represent sales and expenses The line values are read on the Y-axis on the right.
In preparing data for use with pivot tables (choose all true answers) The data should include totals. The data should be a list. The data should have headings. The data can be adjacent (side to side) with other data if there is no space in between.
The data should be a list. The data should have headings.
In the VLOOKUP function The exact match option is often used to select a range of numbers. The exact match requires matching unique identifiers. You use the word false to require an exact match. You use the word true to require an exact match.
The exact match requires matching unique identifiers. You use the word false to require an exact match.
In the following vLookup formula (select all that apply) =vlookup(A3, Faculty_Data,2,False) The number 2 refers to a column in a table. The number 2 refers to a column in the Faculty_Data named range. The reference A3 refers to a unique identifier.
The number 2 refers to a column in a table. The number 2 refers to a column in the Faculty_Data named range. The reference A3 refers to a unique identifier.
In the VLOOKUP function: The number in the formula refers to rows in the table. The number in the formula refers to columns in the table.
The number in the formula refers to columns in the table.
Pick all the correct statements. The Normal View is used for sorting many slides at a time. The Slide Sorter View has a large pane to the right with thumbnail images to the left. In creating a slide, we use the Slide Sorter View. To organize many slides, we use the Slide Sorter View.
To organize many slides, we use the Slide Sorter View.
The two variable table (select all that apply) Uses both options in the Data Table dialog box. ) Requires a formula reference cell. Can use any two variables in a three-variable formula.
Uses both options in the Data Table dialog box. ) Requires a formula reference cell. Can use any two variables in a three-variable formula.
In the PowerPoint record Slide Show feature We can record our image on the screen while narrating the slide show. We can pause recording and then resume recording. If we have a web camera we must use it during recording. The sound file must be separate from the PowerPoint file.
We can record our image on the screen while narrating the slide show. We can pause recording and then resume recording.
When using the PMT function (choose all answers that apply) We need to know four variables. We need to know three variables. The rate of interest is fixed. The rate of interest is variable.
We need to know three variables. The rate of interest is fixed.
In using the Morph transition We can now accomplish this with one slide. We use a modified duplicate slide. We use it only for objects. It makes a smooth transition from one object to another object (or location).
We use a modified duplicate slide. It makes a smooth transition from one object to another object (or location).
In using video in PowerPoint: a) It is always set to play when the slide is shown in the presentation. b) It is always better to use the online version of video (as opposed to the locally stored video). c) The rectangular box that plays the video is adjustable. d) It is easier to use non-Youtube videos than Youtube videos.
c
Public wifi hotspots a. Are very secure. b. Should be used for sensitive transactions. c. Are vulnerable to Man in the Middle attacks. d. Use strong encryption.
c
Column charts (pick all of the correct answers) are considered unhelpful by data analysts. can be edited. must include overall totals. are flexible because data sources can be selected and deselected.
can be edited. are flexible because data sources can be selected and deselected.
Shapes in PowerPoint (pick all the true answers) can contain no text. can be placed anywhere on the slide. can be copied. can be rotated horizontally.
can be placed anywhere on the slide. can be copied. can be rotated horizontally.
Bullet points add little value to slides. can help keep text concise. are usually better to use than plain text. can have different list levels.
can help keep text concise.
In using pivot tables (chose all answers that are correct) the plus sign beside a field indicates that the detailed data is shown. click the minus sign to reduce the data shown. the down arrow beside a field label indicates that data can be filtered. click the plus sign to reduce the data shown.
click the minus sign to reduce the data shown. the down arrow beside a field label indicates that data can be filtered.
1. PowerPoint does not include. a. Inserting videos. b. Inserting audio. c. Record screen demonstrations. d. Prezi-like controls.
d
Alt-shift-d in OneNote a. Deletes an object but it can be pasted elsewhere. b. Duplicates an object for use elsewhere. c. Creates a new Section in OneNote. d. Inserts a date stamp.
d
Copyright a. Is meant to protect the user of creative works. b. Allows us to use creative works of others without permission. c. Always requires the copyright symbol to provide protection for the work. d. Protects the creator a work of art, an image, a manuscript, and many other items.
d
David Phillips: a. Dislikes images in slides because they detract from text. b. Believes that eight objects in a slide are fine. c. Thinks that small fonts can draw our attention. d. Thinks that contrast can draw our attention.
d
Histograms a. Typically have thin columns. b. Have columns separated by spaces. c. Can have numeric values between the columns. d. Never have numeric values between columns.
d
How would one drill down to see detail data on the following pivot table report? a. Click on the down arrow by Row Labels. b. Click one of the Sums. c. Double-click the Grand Total. d. Double-click one of the bike categories (Commuter, Gravel, and so on).
d
If you use the Tor network and Bitcoin together a. Your financial transactions are public, and others can see who bought what goods and services. b. Your communications are public, but your transactions are private. c. Others can see the services you are using on the Internet. d. You use a special kind of browser.
d
In a pie chart when using the following options in the format Data Series "Angle of first slice" "Pie Explosion" a. Changing the angle of the first slice moves it away from the rest of the slices. b. After selecting one slice, increasing the pie explosion percent moves all the slices away from each other. c. Changing the angle of the first slice makes it more like a Frisbee shape. d. One can use the Angle of the first slice to rotate a desired slice towards the front.
d
In creating passwords it is good practice to a. Use all lowercase letters. b. Use all numbers. c. Use only uppercase and lowercase letters. d. Use some special characters.
d
In selecting the range of data used by an Excel pivot table a. If there is a title above the column headings, be sure to select that in the range. b. If totals appear at the bottom of the data, include those totals in the range. c. Always take what Excel populates in the range. d. Include the column headings in the range.
d
In the context of reusing a slide the keep source formatting option means: a. The formatting of the slide being added to the presentation will change to resemble the formatting of the presentation. b. The images in the slide retain their formatting but the rest of the slide changes. c. The colors remain the same as the original slide but the fonts change. d. The slide being copied retains all its formatting.
d
OneNote is a. Virtually identical to Word. b. Intended to be used only sparingly. c. Always private and not shared. d. Searchable.
d
People were attracted to the Silk Road because a. All transactions were open and public. b. They could use their credit cards. c. It used an ordinary browser. d. All transactions were private.
d
TCP/IP a. Includes the destination address but not the source address in its packets sent across the Internet. b. Includes the source address but not the destination address in its packets sent across the Int c. Hides both addresses. d. Sends both addresses in plain text.
d
The Man in the Middle attack a. Inserts a virus on users' computers. b. Diverts surface web searches to deep web searches. c. Diverts deep web searches to surface web searches. d. Inserts a web page that looks authentic so that it will be used by users of the Internet.
d
To find the percentage of each category of the total sales, one would right-click on one of the numbers of Sum of Cost2 corresponding to Type and Bike a. Pick Summarize values by and choose an option. b. Pick Show Values As and pick % of Row Total. c. Pick Show Values As and pick % of Parent Total. d. Pick Show Values As and pick % of Grand Total.
d
Transitions a. Control the movements of individual items on a slide. b. Never use sound. c. Must be applied to all slides at once. d. May be subtle or dramatic.
d
When calculating with OneNote a. Use a space between the numbers and the equal sign. b. Use the alt-shift key to trigger the calculation. c. Always use an equation editor. d. Press the spacebar after the equals sign to trigger the calculation.
d
When using video: a. The video always plays when one first enters a slide during the slide show. b. The video must always be clicked before it will play after entering a slide during the slide show. c. There must always be an embed code used to play a video. d. The On click option plays the video only when the presenter clicks on the slide.
d
When using video: a. The video must always be on the local hard drive or flash drive. b. The video must always have a good Internet connection. c. The video must have a Creative Commons license. d. The video could use a local drive or an Internet connection.
d
Which is the correct answer? a. The Screen Recording feature and the Slide Show Recording feature are the same. b. The Screen Recording feature allows using a web camera. c. The Slide Show Recording option shows us using other software so that we can demonstrate its use. d. The Screen Recording feature records our voices while we are demonstrating software.
d
Which statement is true about histograms. a. Histograms are line charts. b. Histograms are pie charts. c. Histograms are always appropriate. d. Histograms have no space between columns
d
Histograms typically have thin columns. have columns separated by spaces. can have numeric values between the columns. never have numeric values between columns.
never have numeric values between columns.
Slide Masters (choose all of the correct answers) save time because a change to the Slide Master makes changes to all of the slides used by the Slide Master. should rarely be used because they affect all of the slides in one's collection of PowerPoint presentations. are good for adding images to slides, but not good for reformatting text. are difficult to use to make changes.
save time because a change to the Slide Master makes changes to all of the slides used by the Slide Master.
Pick all the correct answers. The latest version of PowerPoint Allows us to record both video and audio. Allows us to record only video or only audio. Allows us to pick microphone options (if there are two microphones connected to the computer). Allow us to clear the recording.
Allows us to record both video and audio. Allows us to record only video or only audio. Allows us to pick microphone options (if there are two microphones connected to the computer). Allow us to clear the recording.
Firewalls (select all true answers) Can block designated computers from sending messages into a network. Can restrict the services accessed by computers that are working remotely. Cannot look inside packets. Cannot allow designated computers to have access to many services.
Cannot allow designated computers to have access to many services.
In using charts in PowerPoint The best charts are from Excel, so you should bring in Excel charts. PowerPoint now has an extensive collection of charts, so for the most part one no longer needs to bring in charts from Excel. Data entry for charts is very difficult in PowerPoint, so users should use Excel instead. Data entry in PowerPoint is now quite like data entry in Excel.
PowerPoint now has an extensive collection of charts, so for the most part one no longer needs to bring in charts from Excel. Data entry in PowerPoint is now quite like data entry in Excel.
In using the PMT function (select all that apply) If the loan is paid off monthly, the yearly rate of interest should be divided by 12 for the Rate entry. The Pv is the amount borrowed. The Fv is the value of the loan paid off (zero).
If the loan is paid off monthly, the yearly rate of interest should be divided by 12 for the Rate entry. The Pv is the amount borrowed. The Fv is the value of the loan paid off (zero).
Onion routing Is called onion routing because everything is in plain text but wrapped in layers. Involves layers of encrypted instructions.
Involves layers of encrypted instructions.
Cybercurrency Is currency guaranteed by many different governments. Is currency whose value is dependent on market forces.
Is currency whose value is dependent on market forces.
A virtual private network (which answer is incorrect?) Is the same as a firewall. Can help provide secure transactions when using public Wi-Fi. Enables users to work on university and business networks remotely. Uses encryption.
Is the same as a firewall.
In terms of privacy (which statement is incorrect?) Smart TVs protect your privacy when you agree to their terms. Apps using GPS on your smartphone can share more than you want to share. New cars have event data recorders. Color printers put identifying information on printed pages.
Smart TVs protect your privacy when you agree to their terms.
Grouping and ungrouping. SmartArt images can be ungrouped and modified. Animation only works on ungrouped objects. We need to ungroup a PowerPoint shape object before including text. We often need to group objects before animating them.
SmartArt images can be ungrouped and modified. We often need to group objects before animating them.
Excel makes it possible to rotate text (pick all answers that are correct). So that text can be completely vertical. So that text can rotate up or down. So that text can only rotate up. So that text can be manually rotated or rotated to some preset angles.
So that text can be completely vertical. So that text can rotate up or down. So that text can be manually rotated or rotated to some preset angles.
T/F The PV (present value) in the PMT function is the amount of the loan.
T
T/F The VLOOKUP function is useful for data extraction.
T
T/F The VLOOKUP function works well with transaction data.
T
The Reading view in PowerPoint is useful for Online presentations.
T
The Record Slide Show option now allows a video image of the presenter to appear on the screen.
T
The VLOOKUP function uses the word false for an exact match.
T
The word pivot in pivot tables indicates the ease of switching rows and columns.
T
Using screen clips is an effective way to bring in images of other computer applications into PowerPoint.
T
When using the Morph transition one needs to duplicate the slide.
T
A correct sequence in OneNote is 1. Notebook, section, page. 2. Notebook, page, section.
1
1. To use the Web Clipper 1) Use ctrl-v to insert the object on the page. 2) Use the OneNote image on the ribbon.
2
The Powerpoint Status bar Is a toggle to add Notes to a slide or to remove the Notes option for a slide. The book-like icon is of the Reading View. Also includes the number of the slide being shown. All of the above
All of the above
Cybercurrency/cryptocurrency Relies heavily on government support. At its core relies on an algorithm to conduct all transactions and maintain records (is all software). Is not accepted by any major retailer. Reveals who conducts transactions.
At its core relies on an algorithm to conduct all transactions and maintain records (is all software).
Animation Refers to the transitions from one slide to another slide. Can be used to bring in objects onto a slide. Can be used when removing objects from a slide. Can be used for motion while staying on a slide.
Can be used to bring in objects onto a slide. Can be used when removing objects from a slide. Can be used for motion while staying on a slide.
The VLOOKUP function (select all correct answers) Can extract data from transaction files. Can extract data from multiple columns at once. Uses an approximate match for ranges of numbers. Uses exact match for ranges of numbers.
Can extract data from transaction files. Uses an approximate match for ranges of numbers.
Transitions Control the movements of individual items on a slide. Never use sound. Must be applied to all slides at once. May be subtle or dramatic.
May be subtle or dramatic.
A two-variable table Uses one entry in the dialog box. Must use interest as one variable and loan amount as the other variable. Must include the formula or reference to the formula in the two-variable table itself. Must have the formula or reference to the formula outside of the two-variable table itself.
Must include the formula or reference to the formula in the two-variable table itself.
An SSID could have a name like Superfan.
T
When using the PMT function (select all the correct answers) The result will show up red (if nothing is done to alter the result). The interest rate must be a fixed interest rate. The interest rate can be a variable interest rate. The payments can be mixed (sometimes quarterly and sometimes monthly) in the same loan.
The result will show up red (if nothing is done to alter the result). The interest rate must be a fixed interest rate.
Google The tracking log of your Google searches lasts "forever." The tracking log of your Google searches can be deleted. Searches users' Gmail account for keywords. Indexes your purchasing activity.
The tracking log of your Google searches can be deleted. Searches users' Gmail account for keywords.
The Internet Uses TCP/IP protocol. Did not have a browser at its very beginning. Had best-effort service at the beginning. All the above.
All the above
Digital citizens Respect copyright. Have good passwords. Understand that digital messages can last "forever" on the Internet servers. All the above.
All the above.
The s in HTTPS Stands for static. Stands for secure.
Stands for secure.
After customizing a tag it will appear in the results of the search pane.
T
The one variable table Uses both options in the dialog box. Uses the Row input cell. Uses the Column input cell. Uses a formula reference cell but not the Data Table dialog box.
Uses the Column input cell.
In animating objects The same effect must be applied to each object. You can use the Animation Pane to review the animation effects. You can use the Animation Pane to reorder the animation effects. You can automate the animation or activate it by mouse clicks.
You can use the Animation Pane to review the animation effects. You can use the Animation Pane to reorder the animation effects. You can automate the animation or activate it by mouse clicks.
Bubble charts: a. Show data for two variables. b. Show data for three variables. c. Show data for four variables. d. Are called combo charts by Excel.
b
Cybercurrency a. Is currency guaranteed by many different governments. b. Is currency whose value is dependent on market forces.
b
Onion Routing a. Is called onion routing because everything is in plain text but wrapped in layers. b. Involves layers of encrypted instructions.
b
The Ring of Gyges a. Is a real ring in Ancient Greece. b. Had magical powers.
b
When formatting numbers in pivot tables a. Select all the numbers before formatting them. b. Click one number and then apply the Number formatting option.
b
As Sali Kaceli says: a. Special effects are so important that one should work on them first. b. When in a hurry it is best to start with blank slides and build them manually from scratch. c. Because content is so important, enter the content first. d. Text is secondary, so enter that last.
c
Combo charts combine a. Stacked column charts with a line chart. b. Bar charts with a line chart. c. Column charts with a line chart. d. A bubble chart with a line chart.
c
In the OneNote structure a. A page may have many sections. b. A Notebook may have many pages and no sections. c. A page may link to another page. d. A Notebook may have a sub-notebook.
c
In using SmartArt: a) If the SmartArt icon chosen has four places for text, one can only use four textual entries. b) One can move the individual elements around by grouping them. c) One can separate the individual elements by ungrouping them. d) One cannot change the fill colors of the individual elements of SmartArt.
c
Animation Has controls for duration. Can bring in two objects at the same time. Is never overused. Can not be reordered after it is created.
Has controls for duration. Can bring in two objects at the same time.
The Dark Web (which answer is correct?) Is the same thing as the Deep Web. Is no different from the Surface Web. Has legal and illegal goods and services. Is never used for good purposes.
Has legal and illegal goods and services.
Creative Commons Provides licensing so that others can use creative works without fear of copyright violation. Has a license that allows others to modify the creative work. Has a license that allows others to profit from the creative work. Has licenses more restrictive than copyright
Has licenses more restrictive than copyright
A best-effort kind of service Provides the best service possible. Does the best it can but does not guarantee delivery of messages (packets).
Does the best it can but does not guarantee delivery of messages (packets).
Calculations using OneNote are done using the shift key after the = sign.
F
Creating charts in PowerPoint is not recommended because the Excel charting features are so much better.
F
In doing a frequency distribution using a pivot table, one needs to use the Bins group.
F
One benefit of OneNote is that the interface is the same for all devices and versions
F
OneNote does not search for dates.
F
OneNote does not translate handwritten notes into text.
F
OneNote, like PowerPoint, has a screen recording option.
F
Slicers provide overall totals across categories.
F
T/F Bubble charts show two dimensions.
F
T/F If you are in one worksheet and want to reference a cell in another worksheet, you use the = key and then go to the desired cell in the other worksheet and press Ctrl.
F
T/F In doing the two-variable table, first fill in the what-if dialog box and then select the table range for the results.
F
T/F In general to use Excel charts we need to select the chart type first and then select the data.
F
T/F In the one variable table, we insert the PMT function just outside of the table and then we select the table range for the results.
F
T/F Line charts show differences between sales persons.
F
T/F Microsoft created pivot tables just recently.
F
T/F Pie charts feature two data sets
F
T/F The VLOOKUP function uses a row in the table lookup.
F
T/F When creating pivot tables from a spreadsheet that has totals, one should include the totals in the range of data.
F
T/F When using pivot tables for frequency distributions, only one item in the values quadrant is needed.
F
T/F creating a two-variable table uses a CSE function.
F
Text boxes are always horizontal.
F
Text boxes cannot have bullet points.
F
The WebClipper extension for OneNote captures only recipes.
F
The export options are limited to the OneNote format or the Word format.
F
To do multiple calculations using the same field, one needs to drag the same field into the filters quadrant multiple times.
F
When presenting a Slide Show in PowerPoint there is no way to see the notes on the screen.
F
The Presenter View: Can only be activated from the ribbon. Has a pen option (to use during a presentation). (correct) Includes an option for the presenter to view all the slides at once (or many slides at once if there are many slides). Has an option to show notes to the audience but not the presenter.
Has a pen option (to use during a presentation) Includes an option for the presenter to view all the slides at once (or many slides at once if there are many slides).
In grouping and ungrouping objects: You can work with individual objects after ungrouping them. You can change individual parts of objects when they are grouped. You can copy individual objects when they are grouped. You can animate the object as a single object when it is grouped.
You can work with individual objects after ungrouping them. You can animate the object as a single object when it is grouped.
1. If you drag the following Field headings into the row column so they are in the order shown (Sales Person, Type, Customer): a. the data would be grouped first by sales person, then by type, and then by customer. b. the data would be grouped first by customer, then by type, and then by sales person.
a
A Google index a. Helps in locating websites. b. Is a stock market indicator.
a
PowerPoint shapes a. Can be animated. b. Cannot have text and different fill colors. c. Cannot be sized in different ways. d. Cannot have special effects.
a
Slide Masters: a) Save time because a change to the slide master makes changes to all the slides used by the slide master. b) Should rarely be used because they affect all of the slides in one's collection of PowerPoint presentations. c) Are good for adding images to slides, but not good for reformatting text. d) Are difficult to use to make changes.
a
Stacked column charts a. Are good at showing total sales. b. Are good for comparing sales figures of individual sales persons from month to month. c. Are difficult to create. d. Have only a two-dimensional option.
a
What type of chart best makes data comparisons (for individual categories) according to data analysts? a. Bar charts. b. Column charts. c. Stacked columns. d. Pie charts.
a
When working with pivot tables if one switches the Quarter and the Sales Person fields in the Rows Quadrant a. The quarter will be on the top row for each section and the sales people would be listed below the quarters. b. The sales people will be listed at the top row for each section and the quarters would be listed below them.
a