Deck 3: Performing Calculations With Formulas and Functions

Question 1

When you create a text box by clicking the Text Box button on the Insert tab and then drag on the slide, the text does not wrap in the box. Instead, the box gets wider to fit the text you type.

Answer 1

False

Question 2

Which type of chart shows trends over a continuous period of time?

A) Column
B) Line
C) Pie
D) X Y (Scatter)

Answer 2

B

Question 3

If you add a picture to the slide background, you cannot change its transparency.

Answer 3

False

Question 4

If you apply formatting to a text box, you can set that formatting to be the default for new text boxes that you create in the presentation.

Question 5

Which type of chart shows values as a percentage of the whole?

A) Column
B) Line
C) Pie
D) X Y (Scatter)

Question 6

To see how an animation looks in Normal view, you can preview it.

Question 7

If a data label, title, or legend in a chart is difficult to read, you can format them as bold, but you cannot change the font size.

Question 8

Every slide in a PowerPoint presentation has a background, which is the area behind the text and graphic.

Question 9

In an Excel worksheet, what is the intersection of a row and a column called?

A) Data box
B) Graphic
C) Text box
D) Cell

Question 10

If a photo on a slide looks too orange or too blue, what can you do to fix this?

A) Change the saturation.
B) Sharpen the photo.
C) Soften the photo.
D) Change the tone.

Question 11

When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?

A) An Excel worksheet
B) A legend
C) A hyperlink to an Excel worksheet
D) A PowerPoint table

Question 12

If you need to change the order in which animations on a slide occur, you must remove the animations, and then reapply them in the correct order.

Question 13

If a photo on a slide looks somewhat blurry and out of focus, what action can you take to fix this?

A) Change the saturation.
B) Sharpen the photo.
C) Soften the photo.
D) Change the tone.

Question 14

Jia needs to change the order in which objects on a slide in her presentation animate. Which of the following is the best method to do this?

A) After selecting an object with an animation applied to it, she can drag the object before or after the other objects on the slide.
B) After selecting an object with an animation applied to it, she can click the Move Earlier or Move Later button on the Animations tab.
C) She can change the effect options of each animation.
D) She can change the duration of each animation.

Question 15

In which view can you preview an animation?

A) Normal view
B) Slide Sorter view
C) Slide Show view
D) Notes Page view

Question 16

As you enter data in the Excel worksheet that opens when you insert a chart, you can see the chart change on the slide.

Question 17

How would you proportionally resize a text box that contains WordArt?

A) Press and hold SHIFT as you drag a corner sizing handle.
B) Press and hold ALT as you drag a corner sizing handle.
C) Type a new value in the Shape Height box on the Drawing Tools Format tab.
D) Drag a corner sizing handle, being careful to drag it diagonally and not in one direction or the other.

Question 18

If you want to change text in a text box by changing the text fill and outline and the shape of the text, which of the following should you change it to?

A) Bold text
B) WordArt
C) SmartArt
D) Table

Question 19

You can move a chart to a new position on a slide in the same manner that you move any other object on a slide.

Question 20

If you need to present numerical data on a slide, which of the following can you insert to show the data as a graphic?

A) Table
B) SmartArt
C) Chart
D) Grid

Question 21

If you want to quickly change the colors of a chart on a slide and whether chart elements, such as a legend and data labels appear, which of the following can you do? Select all the options that apply.

A) Change the chart title.
B) Apply a chart style.
C) Change the chart layout.
D) Add more data to the chart.

Question 22

One of the slides in Darrell's presentation contains a title text box that is center-aligned horizontally and a table that is positioned so that its left edge is aligned with the left side of the title text box. He thinks the slide would look better if the table was centered horizontally on the slide. Which of the following will accomplish this? Select all the options that apply.

A) Drag the table and make a guess about where to position it.
B) Click the Align button on the Drawing Tools Format tab, and then click Align Center.
C) Click the Align Text button on the Home tab.
D) Drag the table and position it when the Smart Guide appears to indicate that the center of the title text box and the center of the table are aligned.

Question 23

Becky wants to format a picture so it looks similar to a painting by an artist. Which button should she use?

A) Color button
B) Artistic Effects button
C) Pictures button
D) Corrections button

Question 24

When you draw on a slide during a slide show, the ink is red; you cannot change the color.

Question 25

During the slide show, Paul wants to add markings to a slide that will stay on the slide after he finishes the slide show. What should he do?

A) Use the Laser Pointer tool.
B) Use the Slide Markup tool.
C) Use the Pen tool.
D) Use the Slide Show Drawing tool.

Question 26

Which of the following can you apply to change the way a SmartArt graphic looks?

A) SmartArt Border
B) SmartArt Theme
C) SmartArt Design
D) SmartArt Style

Question 27

A slide in Casey's presentation contains three shapes that should be treated as one shape. Which of the following commands should Casey use to combine the three shapes so they can be resized or moved together?

A) Bind
B) Form
C) Group
D) Connect

Question 28

If you want to combine two or more shapes to create an entirely new shape, which of the following commands would you use to do this?

A) Merge
B) Customize
C) Outline
D) Layer

Question 29

Which type of chart compares values over a period of time? Select all the options that apply.

A) Column
B) Line
C) Pie
D) X Y (Scatter)

Question 30

If you need to add additional text to a slide and that text is not part of the title or the bulleted list, which of the following is the best choice?

A) Insert SmartArt.
B) Insert a chart.
C) Insert a text box.
D) Insert a table.

Question 31

You can resize WordArt the same way you resize which of the following?

A) A shape
B) A table
C) A letter
D) A SmartArt graphic

Question 32

b,When you add a picture to a slide background, which of the following actions can you take to modify the image?

A) Change the brightness and contrast.
B) Change the tone and saturation.
C) Change the dimensions.
D) Change the transparency.

Question 33

If text in a shape is too close to the sides of the shape, what can you adjust so that there is more space between the text and the sides?

A) Outline weight
B) Font size
C) Shape width
D) Margins

Question 34

You cannot change a shape to a different shape.

Question 35

You cannot create multiple columns in a text box.

Question 36

Wes is creating a new layout for the slide master in his presentation. He inserted four content placeholders and wants to align them. Which of the following can he use to do this?

A) Gridlines spaced one inch apart on a slide.
B) Smart Guides that appear when you drag an object.
C) Guides that you can show on a slide.
D) The ruler that you can show on a slide.

Question 37

How do you draw on a slide during a slide show?

A) Click the Pen and laser tools button on the toolbar in the lower-left corner of the screen in Slide Show or Presenter view, click Pen, and then drag the pointer on the slide.
B) Press P during the slide show, and then drag the mouse pointer on the slide.
C) Purchase a screen certified pen at an office supplies store, and then draw directly on the screen during the slide show.
D) Switch to Touch Mode, and then drag your finger across the screen.

Question 38

Which of the following is the space between the edge of the text and the edges of a text box or a shape that contains text?

A) Margins
B) Leading
C) Paragraph spacing
D) Line spacing

Question 39

If a text box contains many list items, you can format the text box so that the items appear in multiple columns.

Question 40

When you format text on a slide as WordArt, which of the following can you change? Select all the options that apply.

A) Text fill
B) Text outline
C) Special effects, such as adding shadows, bevels, and reflections
D) The shape using Transform options

Question 41

What will the Promote command do to a selected shape?

A) Move it to a higher level.
B) Move it to a lower level.
C) Move it right.
D) Move it left.

Question 42

Which of the following is text in a chart that identifies the numeric value of each data marker?

A) Data bars
B) Axis titles
C) Data labels
D) Legend

Question 43

Isla inserted a chart on a slide. A few days later, a colleague sent her updated data. How

A) Double-click the chart, and then edit the data in the spreadsheet.
B) Click the Edit Data button on the Chart Tools Design tab, and then edit the data in the spreadsheet.
C) Click the data marker on the chart that corresponds to the number that you need to change, type the new number, and then press ENTER.
D) You cannot edit chart data, so Isla must delete and then recreate the chart.

Question 44

What happens when you click the Demote command in Create graphic group?

A) The selected shape will move to a higher level.
B) The selected shape will move to a lower level.
C) The selected shape will be rearranged on the same level as the one above it.
D) The selected shape will be rearranged on the same level as the one below it.

Question 45

Which of the following is a way that you can customize bullets? Select all the options that apply.

A) You can change the symbol used.
B) You can change the color.
C) You can change the size.
D) You can change them to pictures.

Question 46

One way to draw attention to a data point or category in a pie chart is to explode the slice corresponding to that data point or category.

Question 47

Which of the following identifies how data is represented in a chart?

A) Data labels
B) Legend
C) Axis titles
D) Chart title

Question 48

Gary has added some text on a PowerPoint slide as smart art. He wants to change the color of the smart art to a darker one to make sure the text is clear when the presentation is projected on a screen. On which of the following tabs can he find the Change Colors button?

A) Format
B) Design
C) Sheets
D) Home

Question 49

Liam wants to identify the data series in his column chart to be identified in a box to the right of the chart. What is this box called?

A) Trendline
B) Axis titles
C) Legend
D) Data labels

Question 50

What will happen to a selected shape when you hold the CTRL key while pressing the UP ARROW?

A) It will move down in small amounts.
B) It will immediately move to the desired location.
C) It will move and align itself to the shape below it.
D) It will align itself to the nearest text below it.

Question 51

In a pie chart, what is the box that identifies each slice of the pie chart by listing the category names next to the colors of each pie slice?

A) Legend
B) Data series
C) Data labels
D) Data table

Question 52

If you want to format a chart element, you need to select it first.

Question 53

Once a legend is added to a chart, you cannot change its position in the chart.

Question 54

Abby wants the values of each data marker to appear on her chart. What should she add to the chart?

A) Trendline
B) Axis titles
C) Legend
D) Data labels

Question 55

Which of the following actions can you tale to change the look of a chart? Select all the options that apply.

A) Change the chart layout.
B) Change the chart colors.
C) Change the chart style.
D) Change the color of data series.

Question 56

When pressing which of these keys will a shape move up in the desired direction?

A) UP ARROW
B) RIGHT ARROW
C) CTRL + UP ARROW
D) CTRL + LEFT ARROW

Question 57

Katia wants to add a bullet to a SmartArt shape she placed on a PowerPoint slide. Which of the following options on the Design tab should she click on to do so?

A) Include Bullet
B) Insert Bullet
C) Add Bullet
D) Select Bullet

Question 58

Which of the following options, that appear on clicking the Add Shape button, is correctly matched to its function?

A) Add Shape After-Add an identical shape under a selected shape.
B) Add Shape Before-Add an identical shape before a selected shape.
C) Add Shape Above-Add an identical shape overlapping a selected shape.
D) Add Shape Below-Add an identical shape after a selected shape.

Question 59

Mia wants the cells in a table on a slide in her presentation to have a 3D effect. Which effect should she apply?

A) Bevel
B) Reflection
C) Shadow
D) Border

Question 60

How is Standard color palette under the command More Fill Colors different from its Custom color palette?

A) the Custom color palette has colors chosen and saved from the Standard color palette by the user.
B) The Standard color palette has a defined number of color options while the Custom color palette allows you to mix your own colors.
C) Colors in the Standard color palette are used for background whereas colors in the Custom color palette are used for text.
D) Colors in the Standard color palette are used for solid fill backgrounds whereas colors in the Custom color palette are used for gradient fill backgrounds.

Question 61

We can increase or decrease the volume of audio clips in PowerPoint 2019 only in the intervals of 25%.

Question 62

To change the brightness of a picture, click Corrections in the Adjust group, on the Format tab, in Picture tools.

Question 63

Loretta has to play an audio clip in the background in a PowerPoint presentation. To do this, she needs to first select Video on the Insert tab, and then Audio on My PC.

Question 64

Trim Audio option is found on the under Audio Tools on the Playback tab.

Question 65

Under which options will you select Hide during Show to hide audio during a slide show?

A) Audio
B) Video
C) Playback
D) Volume

Question 66

To run the accessibility checker in Windows, select File, then click on Info, then select the Check for Issues button and finally choose Inspect Document.

Question 67

To change a picture click Change Picture in the Adjust group, on the Format tab, under Picture Tools.

Question 68

Which of the following is a line that represents the general direction in a series of data?

A) Trendline
B) Data table
C) Axis title
D) Legend

Question 69

To insert an audio clip from a file into a PowerPoint presentation, click the arrow under Audio in the Media group. In the list, click Audio from file, locate and select the required audio clip, and then click Insert.

Question 70

To quickly change the elements displayed in a chart, you can change the chart layout.

Question 71

Which of the following is a series of data points on a line that represents the general direction in a series of data?

A) Data table
B) Line chart
C) Gridline
D) Trendline

Question 72

Adding a bevel to table cells gives the cells a 3D appearance.

Question 73

To adjust the color saturation of an image, click the required picture, then click the Format Picture tab. Next under Adjust, click Redesign, and last under Color Saturation, choose the required option.

Question 74

Gregg wants to record audio simultaneously while giving a PowerPoint-based presentation. For this, he clicks on X > Record Slide Show > Record From Beginning… What can X in the procedure be?

A) Format tab
B) Slide Show tab
C) Animations tab
D) Transitions tab

Question 75

If a slide in your presentation contains a column chart, what can you add to the chart to predict future developments?

A) Error bars
B) Tick marks
C) Trendlines
D) Up bars

Question 76

What action should you take to show the SmartArt text pane?

A) Select the SmartArt text pane and then press Delete.
B) Click on Close button on the Text pane and deselect the SmartArt graphic.
C) Point the double-headed arrow pointer to any edge of the text pane and drag it.
D) Click the control with two arrows along the left side of the selected SmartArt graphic.

Question 77

Choose the correct order you will click to increase the size a SmartArt shape.

A) SmartArt shapes -> Format -> Shapes -> Larger
B) SmartArt shapes -> Shapes -> Graphics -> Larger
C) SmartArt shapes -> Design -> Shapes -> Larger
D) SmartArt shapes -> Shapes -> Reset Shapes -> Larger

Question 78

To remove the background of an image, select the image, go to the Format tab, and click Remove Background.

Question 79

Which portion of an audio clip will get trimmed if you click its start point under the Trim Audio dialog box and drag the two-headed arrow to a new position on it?

A) Middle
B) Beginning
C) End
D) A desired section