CGC 1100 MIDTERM

To combine multiple cells into one and center its content, you change the cells' style. True False

f

Which of the following attributes of a shape outline can you change? Select all the options that apply. Weight Color Dashes Shadow

weight,color,dashes

To italicize text, use which of the following keystrokes? A. CTRL+Z B. CTRL+I C. CTRL+SHIFT+I D. CTRL+SHIFT+Z

B

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem? Insert a function. Change the page orientation to landscape. Hide the column headings. Copy columns to the next page.

B

A layout is the effect that occurs when one slide leaves the screen and the next slide appears on the screen during a slide show. false true

F

To apply formats to data when it meets criteria you specify, you can use conditional formatting. True False

T

When a word is marked as misspelled, how does it look different from correctly spelled words? a.Its font color changes to red. b.It does not look different from correctly spelled words. c.It flashes on and off on the screen. dA wavy, red line appears underneath it.

d

When you double-click a cell's right column border, which of the following occurs? A column is added to the right of the column's border. The column is deleted. AutoFit resizes the column to 8.43 characters wide. AutoFit resizes the column to the widest cell entry.

d

During a slide show, all of the items in a bulleted list appear on the slide at the same time with the entrance animation effect Fly In applied. If you want each item in the list to appear one at a time, which effect option should you choose? By Paragraph As One Object From Bottom All at Once

A

If you animate a list on a slide, which of the following is the default way is the first-level items appear? One at a time One word at a time Two at a time All at once

A

To view the document at 100%, which of the following should be done? Select all that apply. a. Click the 100% button. b. Click the Page Width button. c. Click the One Page button. d. Click the Zoom button and select 100%.

A, D

One of the slides in Noah's presentation contains a SmartArt graphic that contains text in a circular shape. Noah wants to change the graphic so that it looks more like a list than a circle. Which of the following actions should he take? Apply a SmartArt style. Resize the SmartArt graphic proportionally. Replace the SmartArt graphic with a bulleted list. Change the SmartArt layout.

D

Which of the following methods do you use to accept a spelling change? A.Right-click the misspelled word, then select Add to Dictionary. B. Right-click the misspelled word, then select Ignore All. C. Right-click the misspelled word, then press ENTER. D. Right-click the misspelled word, then select the desired suggested spelling.

D.

Although you cannot insert a video on a slide, you can create a video effect by applying animations to images. False True

F

After you enter text in a placeholder, what does the placeholder become? object text box block frame

text box

What should you add to describe the data in a chart? A legend A title An animation A chart style

A

When you are entering data in a table, which key can you press to move to the next cell to the right or to the first cell in the next line if the current cell is the last cell in a row? TAB SHIFT+TAB ENTER SPACEBAR

A

You can insert columns and rows into an existing table. True False

T

Joan has a redundant source in her bibliography. What is the best way for her to remove this redundant source from the bibliography? a. Remove all text from the redundant source by editing it in the Source Manager, then update the bibliography. b. Delete the redundant source in the Source Manager, then update the bibliography. c. Manually delete the source from the bibliography.

b

Caleb needs to copy a picture from one document and paste it in another document in such a way that it retains the original appearance. He should use which of the following paste options? a.Use Destination Theme b.Keep Text Only c.Keep Source Formatting

c

To decrease the font size by two points, press CTRL+SHIFT+<. True False

t

To display another slide in Normal view, you can click its thumbnail in the pane on the left. True False

t

To have a picture appear behind text, change the text wrapping of the picture. True False

t

Suppose you inserted a circle on a slide, then inserted a rectangle on top of the circle, and finally inserted a triangle on top of the rectangle. Which of the following commands would you use to have the circle move to the top layer on top of the triangle? Send to Back Bring Forward Send Backward Bring to Front

D

If you don't change the default transition, each slide disappears and the next slide immediately appears. True False

T

Most transitions have an effect that you can modify, such as the direction of the transition. False True

T

To add a shadow to a shape, apply a shape outline. True False

f

In order to enter text in a shape, you must select it first. False True

t

Jeremiah needs to organize information in his document using rows and columns. He should insert a table. True False

t

Press CTRL+SHIFT+> to increase the font size by two points. True False

t

To insert an equation, click on the Object in the Text group on the Insert tab, then click Microsoft Equation 3.0 in the Object type box, and then click OK. True False

t

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button. False True

t

To right-justify text at a tab stop, change the tab stop alignment options. False True

t

Dan needs to view his document as it will appear after being printed. Which view should he use? A. Web Layout B. Read Mode C. Print Layout D. Outline View

C.

Aliya needs her footnotes to be listed as I, II, III... instead of as 1,2,3... She should do which of the following to achieve this? a.Leave the numbering as is. Word does not support Roman numeral numbering in footnotes. b.Change the Number Format in the Footnote and Endnote dialogue box. c.Manually replace the footnote numbering as needed.

b

If a word is marked as misspelled, which of the following does not change how that word is spelled? Add Change Change All Ignore

ignore

When you apply a style to a table on a slide, which of the following options can you choose? Select all that apply. Header row Banded rows Font Total row

ABD

Where can you see a preview of how your worksheet will look when printed, including headers? File preview Normal view Print tab in Backstage view Page Break preview

C

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format. Percentage General Currency Accounting

D

Normal, No Spacing, and Heading 1 are examples of Themes. True False

F

You cannot change a shape to a different shape. True False

F

Which tab on the ribbon contains the themes? a.Design b.Insert c.View d.Home

a

If you want to shade every other row in a PowerPoint table, which of the following options do you select on the Table Tools Design tab? Colored rows Total row Header row Banded rows

d

Terry entered the word "teh" intentionally as a nonsense word, but AutoCorrect changed the word to "the". To change the word back to "teh", he should do which of the following? Select all that apply. a.Press CTRL+Z. b.Hover the cursor over the word, press the AutoCorrect icon, and then select the appropriate option. c.Hover the cursor over the word, press the AutoCorrect icon, and then select the appropriate option. d.Press CTRL+Y.

press CTRL+Z, and hover the cursor over the word, press the Autocorrect Icon, and then select the appropriate option

When the ruler is displayed, the location of the pointer is shown on the ruler by a dotted red line. False True

t

You can change a slide's layout after the slide is created. False True

t

You can change the theme after you create a presentation. True False

t

You can choose a layout before you insert a slide. True False

t

Joanne wants a warmer color palette for the text in her document. Which of the following can she use to obtain a warmer color palette? A.selecting a style from the Styles group B. pressing the Theme Effects button C. using the Page Color button D. changing the theme colors

D

To change the color of cell content, you use the ________ color list arrow. Font Pattern Cell Text

a

To add cells to a table going from left to right, insert a column. ​ False True

f

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. False True

t

Andrew accidentally misspelled a word. To correct the error, he can do which of the following? a.Right-click the word and select the desired suggested spelling. b.Right-click the word and select Smart Lookup. c.Right-click the word and select Link. d.Right-click the word and select Translat

a

Derek needs to change all green text in a document to purple text. Which of the following methods is the most efficient way to locate green text in the document? a. Search for text based on font color. b. Inspect the document. c. Scroll through the document looking for green text.

a

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group? Calculation Options Calculate Sheet Calculate Now Watch Window

C

To change the shading of a cell in a table, which of the following should be done first? a.Select the desired cell. b.Select the desired row. c.Select the table. d.Select the desired column.

a

To ensure your bibliography accurately reflects the sources in your source list, do which of the following? a. Update the bibliography. b. Protect the document. c. Check the document for accessibility. d. Inspect the document.

a

Which of the following is not one of the ways you can switch from one slide to another in Normal view? A.Click the View tab, and then click the button that corresponds to the slide number you want to switch to. BClick the thumbnail of the slide you want to switch to in the pane on the left. C.Click the Next Slide button at the bottom of the vertical scroll bar. D.Click the Previous Slide button at the bottom of the vertical scroll bar.

a

Alexandra wants text to appear within a circle shape in her document. She should do which of the following? a.Select the shape and change the Text Wrapping to In Front of Text. b.Select the shape and start typing the desired text. c.Hover the cursor over the shape and enter the desired text.

b

If a photo on a slide looks somewhat blurry and out of focus, what action can you take to fix this? Change the tone. Soften the photo. Sharpen the photo. Change the saturation.

c

When a comment is no longer useful, you should do which of the following? a. Edit the comment. b. Reply to the comment. c. Delete the comment.

c

Which button do you click to see a transition in Normal view? Rewind Watch Preview Review

c

Which of the following tabs lets you set worksheet print options? Home View File Page Layout

c

Which type of chart compares values over a period of time? Select all the options that apply. Pie X Y (Scatter) Line Column

c,d

To ensure a document with a table can be interpreted by people with vision impairment, make sure to do which of the following? a.Convert the table to text. b.Sort the data in the table. c.Add alt text to the table. d.Apply a table style to the table.

c.

Which button do you click on the status bar to resize the displayed slide so that it fits in the large pane in Normal view? Normal Fit slide to current window Zoom In Zoom Out

fit slide

If one of your slides contains multiple objects that are placed on top of each other, which of the following commands can you use to move the objects through the layers on the slide? Select all the options that apply. Send to Back Bring Forward Send Backward Bring to Front

idk

Which view is the best view to use if you want to add a picture to a slide? Outline Slide Show Normal Slide Sorter

normal

Which of the following Print settings prints each slide at the top of the paper with blank lines below the slide? Handouts Notes Pages Outline Full Page Slides

notes

You can use the DELETE key to clear cell contents. True False

t

Which key or keys do you press to indent a first-level item in a list so it becomes a second-level item? SHIFT+TAB SPACEBAR TAB SHIFT

tab

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____. hidden deleted cut conditionally formatted

A

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so? =COUNTA(B1:B20) =COUNT(B1:B20) =COUNTIF(B1:B20) =DCOUNTA(B1:B20)

A

If you want a specific date to appear every time you open a presentation rather than updating to the current date, which of the following options do you need to select when you add the date to the slides? Fixed Update automatically Today Keep

A

In a complex formula, how does Excel determine which calculation to perform first? It follows the order of operations. It calculates the leftmost formulas first. It calculates operations outside parentheses first. It calculates functions first.

A

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document? Ignore All Change All Change Ignore Once

A

Which of the following functions inserts the total of a range? SUM AVERAGE ROUND AUTOSUM

A

To create a duplicate copy of a picture in a document, which of the following should be done? Select all that apply. a. Select the picture, click Copy, then click Paste. b.Select the picture, then click and drag the picture to the desired location. c.Select the picture, then CTRL+click and drag the picture to the desired location. d.Select the picture, click Cut, then click Paste.

A,C

Enrique applied the Split entrance animation to a picture on a slide in his presentation. The picture appears on the slide starting from the left and right edges until the two sides meet in the middle. He wants to change this so that the center of the picture appears first and then builds out to the sides. Which of the following actions should he take? Change the animation to Wipe. Change the effect option to Vertical Out. Apply the Push transition to the slide. Change the duration of the animation, so the picture appears more quickly.

B

If you want to create a mirror image of a shape to the left or right of the shape, you should duplicate or copy and paste the shape, and then use which of the following commands? Rotate Left 90° Flip Horizontal Flip Vertical Rotate Right 90°

C

Inez is planning a cruise for her family's upcoming reunion. She wants to show family members pictures of the different cabins that are available, so she adds them to slides in a presentation. One of the images shows two views of the same room combined into one picture. Inez thinks this is confusing. Which of the following actions can she take to address this? Cover the unwanted area of the picture with crop marks. Crop the unwanted area of the picture using the Beveled Matte, White picture style. Crop the unwanted area of the picture using the Crop command. Cover the unwanted area of the picture with a shape.

C

To enter a range of text based on examples that are already in your worksheet, which of the following can you use? What-if analysis Business Intelligence Flash fill Quick Analysis tools

C

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic? Language Advanced Formulas Proofing

C

Which of the following inserts a function into a cell? mode indicator argument AutoSum button formula prefix

C

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed? Normal pointer Move pointer Copy pointer I-beam pointer

C

Amelia needs to make similar changes to two slides in her presentation. To ensure that the changes she makes are consistent, she wants to be able to see the two slides side by side. Which of the following is the best method for doing this? A)Save the presentation with a new name, and then open the copy and place that next to the original presentation. B) Split the window in Normal view. C)Open the presentation in a new window. D)Make the changes in Slide Sorter view.

C.

If you want to add the date to every slide in the presentation and you want the date to update to show the current date every time the presentation is opened, which of the following actions would you take? A. Type the date on the title slide so that it appears on all of the slides. B. Open the Header and Footer dialog box, click the Slide tab, click the Date and time checkbox, and then click the Fixed option button. C. Type the date in a placeholder on every slide. D. Open the Header and Footer dialog box, click the Slide tab, click the Date and time checkbox, and then click the Update automatically option button.

D

In the formula =A8*$A$1, which of the following describes A8? AutoSum Function Absolute cell reference Relative cell reference

D

Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual? Language Advanced Proofing Formulas

D

An animation that causes an object to appear on a slide after the slide appears during a slide show is an emphasis animation. False True

F

Karen wants a reference to appear at the bottom of a page. To do so, she should insert an endnote. True False

F

To find the number of words in a document, press the Language button. True False

F

To start PowerPoint, you must click a tile on the Start menu. False True

F

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. True False

F

You can apply date formats to cells by using the Date category in the Format Cells dialog box. True False

T

Jasmine is working on a research paper that needs to be in MLA format. To ensure her bibliography is formatted properly, she should do which of the following? a. Ensure the document meets the style requirements by Inspecting the document. b. Check to ensure the bibliography style is MLA in the Citations & Bibliography group of the References tab. c. Use the Source Manager to edit the sources as needed.

b

Jenna changed the font color of a header with the Heading 1 style to green. She wants all headers with the Heading 1 style in the document to be green. Which of the following is the best way to achieve this? a. Search for text with the Heading 1 style based on formatting, and then change the font color of each instance to green. b. Select the green Heading 1 header, then update the Heading 1 style to match the selection. c. Manually locate all headers with the Heading 1 style in the document and change the font color to green.

b

Joshua needs stylized text in his document to be normal, unformatted text. He should do which of the following? a.Press the Format Painter button. b.Press the Clear All Formatting button. c.Apply the Strong style. d.Apply the Heading 1 style.

b

Alexis needs to remove an entry going from left to right in a table. She first needs to do which of the following? a.Select the table. b. select a column. c.Select a cell. d.Select a row.

d

Amy needs to prevent the last line of a paragraph from being separated from the rest of the paragraph as a result of flowing onto another page. She should do which of the following after selecting the paragraph? a. Enable the keep with next option. b. Enable the page break before option. c. Enable the don't hyphenate option. d. Enable the widow and orphan control option.

d

Jada needs to create a note at the bottom of a page with a reference to the note in the text. She should do which of the following? a.Insert a header. b.Insert an endnote. c.Insert a comment. d. Insert a footnote.

d

Showing the rulers will help you do which of the following? A. make straight lines B. change the zoom level C. change the size of the page D. modify tabs

d

To apply a cell style, you would use the Cell Styles command on the _____ tab. View Insert Layout Home

d

To make the comments in a document invisible, do which of the following? a. Accept all changes in the document. b. Resolve all the comments in the document. c. Delete all the comments in the document. d. Press the Show Comments button.

d

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? The formula +SUM(B6-B10) The formula =TOTAL(B6-B10) The formula =B6+B7+B8+B9+B10. The formula =SUM(B6:B10)

d

Which of the following views does not let you change the order of slides in a presentation? a.Slide Sorter b.Normal c.Outline d.Slide Show

d

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style? Border Color Shape Style

d

Which type of chart shows trends over a continuous period of time? X Y (Scatter) Column Pie Line

d