Deck 1: Getting Started With Excel

Question 1

Press CTRL+W to save the document.

Answer 1

False

Question 2

Use ALT to select multiple nonadjacent headings in a document.

Answer 2

False - CTRL
False - ctrl
False - Control
False - control
False - CONTROL

Question 3

Tom took a photo using his webcam and saved it to his desktop. To insert the file in a word document, he can use the Online Pictures button.

Answer 3

False

Question 4

Alejandro needs text to appear as if it were written in cursive. He can change the font of the desired text to achieve this.

Question 5

To modify the color palette of a document, you can change the theme colors.

Question 6

When you close a document, your work is automatically saved.

Question 7

You enter text in the document window.

Question 8

Use Print Layout view to adjust the document margins.

Question 9

Press CTRL+N to create a new blank document.

Question 10

When you use the Redo command, you redo the action that was just completed.

Question 11

If Word suggests a grammar change that you do not want, you can ignore the change.

Question 12

To move text, press and hold the right mouse button over selected text, then drag the text to the desired location.

Question 13

To remove the spelling change indicator under a word, you must accept the suggested change.

Question 14

Pressing DELETE removes the character after the insertion point.

Question 15

Underscore text to have a line appear beneath the text.

Question 16

To provide emphasis to text, you can apply bold.

Question 17

You can use the Mini toolbar to apply bullets to paragraphs.

Question 18

To start Word, press the Windows key and then select Word 2019.

Question 19

Press ALT+P to print a document.

Question 20

Click Save As in the File tab to save a document with a new name.

Question 21

Jane has created a new document and entered some text. What should she do to ensure she does not lose her work?

A) Save the document.
B) Protect the document.
C) Inspect the document.
D) Close the document.

Question 22

Which of the following do you do to better view small, difficult-to-read text in a document?

A) Select One Page in the window group of the View tab to enlarge the document.
B) Drag the Zoom slider to enlarge the document.
C) Use the navigation pane to enlarge the document.
D) Hold SHIFT and use the scroll wheel to enlarge the document.

Question 23

Kate needs to insert 10 text boxes in a document. After inserting the first text box, how can she easily repeat the action nine more times?

A) Right-click the text box border and select Repeat nine times.
B) Press the Redo button nine times.
C) Cut the text box and then paste it.
D) Press CTRL+R nine times.

Question 24

Dan needs to view his document as it will appear after being printed. Which view should he use?

A) Read Mode
B) Print Layout
C) Web Layout
D) Outline View

Question 25

Austin needs to emphasize text by having color appear behind it. Which of the following tools should he use?

A) the Text Highlight Color button
B) the Theme Effects button
C) the Font Color button
D) the Colors button

Question 26

Resize a picture proportionally by dragging a top sizing handle.

Question 27

Which of the following methods do you use to accept a spelling change?

A) Right-click the misspelled word, then select the desired suggested spelling.
B) Right-click the misspelled word, then press ENTER.
C) Right-click the misspelled word, then select Ignore All.
D) Right-click the misspelled word, then select Add to Dictionary.

Question 28

Susan needs all the text in a title to be upper case. Which of the following is the best way to capitalize all the text in the title?

A) Delete the text and retype it using all uppercase.
B) Select the text, press the Change Case button in the Font group of the Home tab, and then select UPPERCASE.
C) Change the font to a font that only has uppercase letters.
D) Select the text, then press the Bold button in the Font group of the Home tab.

Question 29

If you mistakenly undo an action, how do you correct your mistake?

A) click the undo button in the quick access toolbar
B) press CTRL+R
C) click the redo button in the quick access toolbar
D) press CTRL+Z

Question 30

Which preset text effect do you apply when you want the text to have a border color?

A) Outline
B) Shadow
C) Reflection
D) Glow

Question 31

Juana needs to open a document. To access the Open dialogue box, which tab should she use?

A) Home tab
B) View tab
C) File tab
D) Review tab

Question 32

Steve wants a paragraph of text to be surrounded with a line and filled with a color. Which of the following should he use to achieve this?

A) Shading and Borders commands
B) Shapes and Color commands
C) Highlighting and Line commands
D) Box and Fill commands

Question 33

Which of the following should Tim use to italicize text?

A) Select some italicized text in the document, press the Format Painter button, then select the text to be italicized.
B) Select the text that needs to be italicized, press the Format Painter button in the Clipboard group of the Home tab, then select some italicized text in the document.
C) Press the Format Painter button in the Clipboard group of the Home tab, press the Italic button in the Font group of the Home tab, then select the text that needs to be italicized.
D) Select the text to be italicized, then press the Text Effects button in the Font group of the Home tab.

Question 34

Which of the following do you use when you want to apply color behind paragraph text and you want to be able to adjust color margins?

A) Background color
B) Highlighting
C) Font color
D) Shading

Question 35

Which of the following refers to a printed line that surrounds the outer part of a page?

A) Page Border
B) Page Boundary
C) Page Margin
D) Page Edge

Question 36

Which of the following do you do first to change the position of tab stops?

A) scroll to the top of the page
B) switch to Read Mode
C) show the rulers
D) switch to Web Layout

Question 37

Jessica encounters text in a document that appears blue and underlined. When she presses CTRL and clicks the text, she is taken to a website. She wants the text to appear and behave like normal text. Which of the following should she do?

A) Right-click the text and select Remove Hyperlink.
B) Change the font color and remove the underline using buttons in the Font group of the Home tab.
C) Delete the text and then retype it.
D) Leave the text as is; it will appear normal when the document is printed.

Question 38

Jared needs more space between lines of text in a paragraph. Which of the following is the best method to use for this action?

A) Drag the Zoom slider to increase the line spacing.
B) Press ENTER at the end of each line to create a space between lines.
C) Press the Line and Paragraph Spacing button in the Paragraph group on the Home tab, then select the desired amount of spacing.
D) Enter the Indents and Spacing tab of the Paragraph dialogue box and increase the value of the text box labeled "After:".

Question 39

Which of the following do you do to select text?

A) press CTRL+T
B) click and drag across the desired text
C) right-click and drag across the desired text
D) press CTRL+S

Question 40

Julia noticed that she accidentally used the word "then" instead of "than" in a sentence. Word identified the grammar error with a blue double underline. To correct the error, she can do which of the following?

A) accept the suggested grammar change
B) ignore the suggested grammar change
C) delete the word "then"

Question 41

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) changing the theme colors
B) selecting a style from the Styles group
C) using the Page Color button
D) pressing the Theme Effects button

Question 42

Which of the following options allows you to align text so that it is fully flush with both margins?

A) Align Left
B) Center
C) Align Right
D) Justify

Question 43

Showing the rulers will help you do which of the following?

A) change the size of the page
B) make straight lines
C) change the zoom level
D) modify tabs

Question 44

To set an item in a bulleted list at a higher level, which of the following should you do?

A) Drag the appropriate Left Indent tab to the desired position.
B) Press the Increase Indent button on the Paragraph group of the Home tab.
C) Add seven spaces to the beginning of the list item.
D) Press the Decrease Indent button on the Paragraph group of the Home tab.

Question 45

To view the entire page of a document, which of the following should you do?

A) Press the 100% button on the Zoom group of the View tab.
B) Press the One Page button on the Zoom group of the View tab.
C) Press the Page Width button on the Zoom group of the View tab.
D) Slide the Zoom slider toward the plus symbol.

Question 46

Sarah wants to quickly apply a Picture Border and Picture Effect to a picture. Which of the following can she use to do this?

A) Apply a Picture Style.
B) Change the Theme Effects.
C) Apply an Artistic Effect.
D) Apply a Correction.

Question 47

Tom needs to change the font size. He should do which of the following?

A) Select the desired text and press CTRL+SHIFT+> to increase the font size or CTRL+SHIFT+< to decrease the font size.
B) Select the desired text and press CTRL+SHIFT+I to increase the font size or CTRL+SHIFT+D to decrease the font size.
C) Press the Increase Font Size button or the Decrease Font Size button in the Mini toolbar.
D) Press the Increase Font Size button or the Decrease Font Size button in the Font group of the Home tab.

Question 48

Samantha needs to create a numbered series of paragraphs. Which of the following should she do? Select all that apply.

A) Type "1." and then press SPACEBAR to begin numbering.
B) Select the desired paragraphs and then press the Numbering button in the Paragraph group of the Home tab.
C) Enter ">" and then press SPACEBAR to begin numbering.
D) Select the desired paragraphs and then press CTRL+N.

Question 49

Which of the following describes how to change the font color? Select all that apply.

A) Press the Font Color button on the Mini toolbar.
B) Press the Font Color button in the Font group of the Home tab.
C) Press the Fonts button in the Document Formatting group of the Design tab.
D) Press the Theme Effects button on the Document Formatting group in the Design tab.

Question 50

To italicize text, use which of the following keystrokes?

A) CTRL+I
B) CTRL+SHIFT+I
C) CTRL+Z
D) CTRL+SHIFT+Z

Question 51

Which of the following do you use to change the document margins?

A) Use the Orientation button in the Page Setup group of the Layout tab to select the desired option.
B) Use the Margins button in the Page Setup group of the Layout tab to select the desired option.
C) Use the Size button in the Page Setup group of the Layout tab to select the desired option.
D) Use the Columns button in the Page Setup group of the Layout tab to select the desired option.

Question 52

Which view is best for laying out shapes on a page?

A) Web Layout
B) Read Mode
C) Print Layout
D) Outline

Question 53

To underline text, which of the following do you do? Select all that apply.

A) Select the desired text and press CTRL+N.
B) Press the Theme Effects button in the Document Formatting group of the Design tab.
C) Press the Underline button in the Font group of the Home tab.
D) Select the desired text and press CTRL+U.

Question 54

Joe accidentally deleted a paragraph. To restore the paragraph, he needs to do which of the following?

A) Undo the action.
B) Redo the action.
C) Repeat the action.
D) Reenter the text manually.

Question 55

Jasmine needs to select the first sentence of a paragraph and the last sentence of a paragraph simultaneously. The text is nonadjacent. Which of the following should she do?

A) Select the first sentence, then press and hold ALT while selecting the second sentence.
B) Select the first sentence, then press and hold SHIFT while selecting the second sentence.
C) Select the first sentence, then press and hold SHIFT+ALT while selecting the second sentence.
D) Select the first sentence, then press and hold CTRL while selecting the second sentence.

Question 56

A document contains a list of items that appear in no particular order. Which of the following is the best way to format the list?

A) Apply numbering to the list.
B) Apply bullets to the list.
C) Apply multilevel numbering to the list.
D) Manually enter a ">" character at the beginning of each item in the list.

Question 57

Terri needs each word in a paragraph to be capitalized. Which of the following is the simplest method to achieve this?

A) Delete the first character of each word and retype it as a capital letter.
B) Write a Macro to replace the first character in each word with a capital letter.
C) Press the Text Effects and Typography button and select the desired option.
D) Press the Change Case button in the Font group of the Home tab and select Capitalize Each Word.

Question 58

Alyssa needs the text of a paragraph to be centered on the page. Which of the following can she do? Select all that apply.

A) Press CTRL+E.
B) Press the Center button in the Paragraph group on the Home tab.
C) Press CTRL+C.
D) Press the Justify button in the Paragraph group on the Home tab.

Question 59

To change the size of a picture without distorting it, which of the following should you do?

A) drag a corner sizing handle
B) drag the top sizing handle
C) drag the bottom sizing handle
D) drag a side sizing handle

Question 60

Karen has a document with a list of five priorities on separate lines. The priorities are listed in order from most important to least important. Which of the following formatting options is best for this situation?

A) Bulleted list
B) Numbered list
C) Multilevel bulleted list

Question 61

To copy formatting from one selection of text to another, use the Format Painter.

Question 62

To ensure that the edges of several pictures line up, align the pictures.

Question 63

To ensure a document is free of typos, always do which of the following before publishing the document.

A) Check the document for accessibility by clicking the Check Accessibility button.
B) Check the document for spelling and grammar errors by clicking the Spelling & Grammar button.
C) Use Smart Lookup by clicking the Smart Lookup button.
D) Check the document for compatibility by clicking the Check Compatibility button.

Question 64

Jeremy is reading a document about geology when he encounters the word Paleolithic. To conduct research about the Paleolithic era, he should do which of the following?

A) Click the Online Pictures button.
B) Enter the word Paleolithic in the Tell Me box.
C) Right-click the word and select translate.
D) Click the Researcher button.

Question 65

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) Press CTRL+Y.
D) Hover the cursor over the word, press the AutoCorrect icon, and then select the appropriate option.

Question 66

Shauna is preparing a newsletter that will be widely distributed. While checking the document for spelling and grammar errors, she notices that she consistently misspelled the word "disappear". She can correct all instances of the misspelled word by selecting Change All in the Spelling pane.

Question 67

Laila needs the pictures in her document to be distributed vertically. She should do which of the following?

A) Press the Position button and select the desired option.
B) Press the Align button and select the desired option.
C) Press the Wrap Text button and select the desired option.
D) Press the Corrections button and select the desired option.

Question 68

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 One Page button.
C) Click the Zoom button and select 100%.
D) Click the Page Width button.

Question 69

To bold text, which of the following can you do? Select all that apply.

A) Press CTRL+B.
B) Press CTRL+D.
C) Open the Font tab of the Font dialogue box and select Bold in the Font style list.
D) Press the Bold button in the Font group of the Home tab.

Question 70

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 Translate.

Question 71

Jaylen needs a shape in her document to have the same formatting as another shape in her document. She should do which of the following?

A) Use the Clipboard.
B) Use Smart Lookup.
C) Use the Tell Me box.
D) Use the Formatting Painter.

Question 72

To change the font, which of the following can you do? Select all that apply.

A) Press CTRL+F.
B) Press the Font list box and select the desired text.
C) Press the Text Effects and Typography button and select the desired option.
D) Open the Font tab of the Font dialogue box, then select the desired font from the Font list box.

Question 73

Dan is writing a novel that contains the nonsense word "Zerphron", which Word identifies as a spelling error. To prevent Word from identifying "Zerphron" as a misspelled word, he can select the Ignore All option.

Question 74

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

Question 75

To move an inline picture, which of the following should be done?

A) Click and drag the picture to the desired location.
B) CTRL+Click and drag the picture to the desired location.
C) ALT+Click and drag the picture to the desired location.
D) CTRL+SHIFT+Click and drag the picture to the desired location.

Question 76

Aniyah needs to insert the date and time in her document. She should do which of the following?

A) Click the Insert Date and Time button and select the desired option.
B) Click the Cross-reference button.
C) Click the Table button and select the desired option.
D) Click the Link button and select the desired option.

Question 77

Tiana wants a line to appear around a paragraph. She should do which of the following?

A) Add a paragraph border.
B) Add paragraph shading.
C) Apply a text effect.
D) Apply a character style.

Question 78

Use the Tell Me box in the ribbon to perform a desired action in Word, such as increasing the font size.

Question 79

Amy works for a company called Conicore. Many of the documents she creates include the word Conicore. In order to prevent Word from identifying Conicore as a misspelled word, she can add Conicore to the dictionary.

Question 80

To find a word in a document, use the Smart Lookup feature.