Deck 2: Excel 2019

Question 1

To go to a previous comment, use the Previous button in the Comments group on the Review tab.

Answer 1

True

Question 2

Linda wants to change the color of the SmartArt that she has used in her spreadsheet. To do so, she clicks on the shape in the SmartArt graphic. She then clicks on the arrow next to Shape Fill under Drawing Tools, on the Format tab, in the Shape Styles group. Linda then selects an option from the menu that appears, and under the Colors Dialog box and Standard, she chooses the color she wants the SmartArt to be and clicks OK. What can the option that she selected from the menu under Shape Fill be?

A) No Fill
B) Theme Colors
C) Standard Colors
D) More Fill Colors

Answer 2

D

Question 3

It is possible to go to the next comment using the Next button in the Comments group on the Review tab.

Answer 3

True

Question 4

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

Question 5

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer. He can do so by clicking on Page Layout > Save As > (Enter name in ) File name box > Save As type list > PDF > Minimum Size (publishing online) > Options > OK > Save.

Question 6

Which of these series of clicks will you select to add text to a SmartArt?

A) Insert tab > Illustrations group > Online Pictures > Insert pictures > Select from menu > [Text] in Text pane > Type text
B) Insert tab > Illustrations group > SmartArt > Choose a SmartArt Graphic dialog box > Select type and layout >[Text] in Text pane > Type text
C) Insert tab > Illustrations group > Shapes > Recently used shapes > Select type and layout > [Text] in Text pane > Type text
D) Insert tab > Illustrations group > Take a Screenshot > Available Windows > Select from the menu > [Text] in Text pane > Type text

Question 7

Colin wants to apply a Quick Style to a SmartArt graphic. To do so, he clicks on the following series: SmartArt graphic > X > SmartArt Styles group > SmartArt Tools > Select SmartArt style of choice. Which of these can X be in the following series of clicks?

A) Insert tab
B) Format tab
C) Design tab
D) Review tab

Question 8

To detect language automatically, you should select the Detect language automatically check box in the Language dialog box.

Question 9

Tyler wants to add SmartArt graphic to his file to make a visual representation of information in his file. He clicks/selects the following series to do so: Insert tab > Illustrations group > SmartArt > X > Select the type and layout of choice. What can X in this series of clicks/ selections be?

A) Stars and Banners
B) Screen Clipping
C) Recently Used Shapes
D) Choose a SmartArt Graphic dialog box

Question 10

To edit a comment in a cell, select the cell that contains the comment, right-click on it and select the Edit Comment option from the menu.

Question 11

In order to reject changes made by all users in a workbook, click/enter information in the following series: Review tab > Changes group > Track Changes > Accept or Reject Changes > OK (if prompted to save the workbook) > Select Changes to Accept or Reject dialog box > Select Where check box > OK > Review information about each change in the dialog box > Reject > OK.

Question 12

Brielle wants to increase the size of a SmartArt graphic in her worksheet. To do so, she clicks the following series: Shape > Format tab > SmartArt tools . What should she do next to resize the object proportionally?

A) Drag a middle handle.
B) Click the Larger button.
C) Click the Edit in 2-D button.
D) Click the Arrange button and select a arrange button options.

Question 13

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Question 14

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?

A) Calculate Now
B) Calculate Sheet
C) Watch Window
D) Calculation Options

Question 15

To provide suggestions to other people using your document, select the text you want to comment on, then click New Comment on the Review tab and type your comment.

Question 16

What would you choose as X in the given series of clicks to calculate formulas automatically: File

A) Formulas
B) Proofing
C) Language
D) Advanced

Question 17

Nathan wants to create multiple charts for a table Power View, beginning with a pie chart. What should he select as X in the series of clicks to do this: Design tab > X > Other Charts > Pie Chart?

A) Tiles
B) Options
C) Other Chart
D) Switch Visualization

Question 18

How can you add a new picture to a SmartArt graphic?

A) Click the SmartArt button on the Insert tab, then click Picture, click a layout, and then click OK.
B) Select a picture, click the Picture Layout button on the Format tab under Picture Tools, and then select a layout.
C) Select a picture, click the Insert tab under Picture Tools, click the Insert Picture, and then select a layout.
D) Under SmartArt Tools, click the Design tab, then click the Add Shape button arrow, and then select the picture you want to add.

Question 19

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

Question 20

Misha wants to set the brightness of a picture to 40% and contrast to 20%. She clicks the picture, then clicks on Corrections in the Adjust group on the Format tab under Picture Tools. What should she select from the drop-down menu that appears on clicking Corrections and then select the thumbnail that fulfils her purpose?

A) Color Tone
B) Sharpen/Soften
C) Color Saturation
D) Brightness/Contrast

Question 21

When you print in portrait orientation, the page is wider than it is tall.

Question 22

A good practice is to move the most important worksheets to the end of the workbook.

Question 23

Stella wants to merge two workbooks. She begins by opening the workbooks, then selects the worksheets she wants to copy by clicking on the first sheet tab that she wants to copy, pressing and holding the Shift key, and then clicking on the last sheet tab. Then she right-clicks on one of the selected tabs and selects an option from the menu. Which of the following can her selection be?

A) Insert
B) Rename
C) View Code
D) Move or Copy

Question 24

When you use the Windows Start menu to start Excel, it opens in Backstage view.

Question 25

When you enter a number, date, or time in a cell, it is left-aligned by default.

Question 26

Lilia wants to mark a workbook as final to let users know that it is a Read-Only file. To do so, she can click File > Info > Protect (Document, Presentation, or Workbook) > Protect Current Sheet > OK.

Question 27

To show all comments in a worksheet, click Review tab > Comments group > Show All Comments.

Question 28

To embed an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Question 29

Ernie wants to add a screenshot of an entire window into his file. To do so, he clicks on the document at the location where he wants to add the screenshot, then clicks Screenshot in the Illustrations group on the Insert tab. What will he do when the Available windows gallery appears next?

A) Click the thumbnail image of the window whose screenshot he wants to insert.
B) Click Screen Clipping, then press and hold the left mouse button to drag and capture the window screen.
C) Select a thumbnail of the required window, then press and hold the left mouse button to drag and capture the window screen.
D) Click Screen Clipping, and when the pointer becomes a hand icon, capture the window screen.

Question 30

Annemarie wants to save a workbook as a shared workbook to allow several users to work on it simultaneously. For this, she clicks X > Y > Share Workbook > Editing tab > Allow changes by more than one user at the same time > OK > Save the shared workbook on a network location for other users to access it in Save As dialog box. What can X and Y be in the series of clicks?

A) X- View tab, Y- Show group
B) X- Insert tab, Y- Links group
C) X- Review tab, Y- Changes group
D) X- Developer tab, Y- Controls group

Question 31

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013. To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Question 32

You can set a scaling option to resize a worksheet to fit within a single page.

Question 33

Which of these will you select as X in the following series of clicks to inspect a workbook and remove unwanted information before distributing it: File tab > Info > Check for Issues > Inspect Document > Select the types of data to find in the document > X button in Dialog box?

A) Erase All
B) Clear All
C) Delete All
D) Remove All

Question 34

To print a worksheet, you begin by going to Backstage view.

Question 35

To insert an object from another application, click Insert > Object > (Dialog box) > Create New > Object Type (select the application you want to use) > OK.

Question 36

To turn track changes on in an Excel sheet, click Review tab > Changes group > Track Changes command > Highlight Changes > Highlight Changes dialog box > Check box next to Track changes while editing > Ensure that box is checked for Highlight changes on screen > OK > OK (if prompted to allow Excel to save the workbook).

Question 37

What is the default number of days for Excel change history?

A) 15
B) 30
C) 60
D) 90

Question 38

To delete comments, select the cell that contains comments, right-click on it and select Delete Comment option from the menu.

Question 39

To show a comment in an active cell, select the cell, then click Review tab > Comments group > Show/Hide Comment.

Question 40

Esther wants to accept track changes in a file. To do this, she clicks at the beginning of the document and then clicks X in the Comments group on the Review tab. She then clicks Accept to accept the track change. What can X in the procedure be?

A) Next
B) Delete
C) Previous
D) New Comment

Question 41

Which of the following is the temporary storage area that holds selections you copy or cut?

A) Clipboard
B) Backstage
C) Name box
D) Worksheet window

Question 42

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

A) The Undo button on the Quick Access toolbar
B) The Cancel button on the Formula bar
C) The Enter button on the Formula bar
D) The Save button on the Quick Access toolbar

Question 43

Which of the following is a built-in formula that helps you perform complex calculations?

A) clipboard
B) mode indicator
C) named range
D) function

Question 44

Which of the following tabs lets you set worksheet print options?

A) Preview
B) Home
C) Page Layout
D) View

Question 45

When you click the File tab and then click Print, which of the following elements appears in the preview of the worksheet printout?

A) row headings
B) column headings
C) gridlines
D) worksheet data

Question 46

If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.

A) deleting
B) hiding
C) renaming
D) moving

Question 47

Which of the following options can you set to make sure a worksheet will print on one page?

A) Zoom percentage
B) Scaling
C) Print selection
D) Gridlines

Question 48

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

A) The formula =B6+B7+B8+B9+B10.
B) The formula =TOTAL(B6-B10)
C) The formula =SUM(B6:B10)
D) The formula +SUM(B6-B10)

Question 49

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

A) =25+10*50
B) 25/(10*50)
C) 50*25+10
D) (25+10)*50

Question 50

Which of the following functions inserts the total of a range?

A) ROUND
B) AUTOSUM
C) AVERAGE
D) SUM

Question 51

How can you reverse your most recent action in Excel?

A) Click the Redo button.
B) Click the Reverse button.
C) Click the Escape button.
D) Click the Undo button.

Question 52

To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider.

Question 53

Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?

A) Hide the column headings.
B) Insert a function.
C) Copy columns to the next page.
D) Change the page orientation to landscape.

Question 54

You can edit cell contents in the formula bar or in the cell itself.

Question 55

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

A) argument
B) function
C) label
D) active cell

Question 56

To enter a typed number into a cell, you can press Tab or Backspace .

Question 57

Which of the following keys do you press to copy cells while dragging them?

A) ALT
B) SHIFT
C) TAB
D) CTRL

Question 58

To select a single worksheet cell so you can work with it, which of the following would you do?

A) Click the cell.
B) Move the cell pointer over the cell.
C) Click the status bar.
D) Click the Name box.

Question 59

Which of the following lets you edit the contents of a cell?

A) Click the cell, click the status bar, and press Enter.
B) Click the cell and click in the status bar.
C) Double-click the cell, click in the status bar, or just start typing.
D) Double-click the cell or click in the formula bar.

Question 60

Which of the following views shows how a worksheet will appear when printed?

A) Page Layout view
B) Page Break Preview
C) Normal view
D) Reading view

Question 61

In a complex formula, how does Excel determine which calculation to perform first?

A) It calculates the leftmost formulas first.
B) It calculates operations outside parentheses first.
C) It follows the order of operations.
D) It calculates functions first.

Question 62

Changing a worksheet window to Normal view changes the contents of the worksheet.

Question 63

The _____ displays the cell reference of the active cell.

A) formula bar
B) Name box
C) worksheet title
D) status bar

Question 64

Which of the following statements is true about COUNT functions?

A) The COUNT function returns the number of calls in a range that are not blank.
B) The COUNT function returns the number of calls in a range that contain any data at all.
C) Using the COUNT function is useful for computing the average of a cell range.
D) The COUNT function returns the number of cells in a range that contain numeric data.

Question 65

Flash Fill enters text based on patterns it finds in the data.

Question 66

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

A) deleted
B) hidden
C) cut
D) conditionally formatted

Question 67

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Question 68

Which of the following indicates the column and row where a cell is located?

A) cell reference
B) active cell
C) column heading
D) formula bar

Question 69

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

A) Normal view
B) Page Layout view
C) Page Break Preview
D) Print Preview

Question 70

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

A) =COUNT(B1:B20)
B) =COUNTIF(B1:B20)
C) =SUM(B1:B20)
D) =CALCULATE(B1:B20)

Question 71

In formulas, calculations in square brackets are calculated first.

Question 72

Louis has entered a column of expense values. What feature can he use to insert the total expenses at the end of the column?

A) AutoSum button
B) absolute reference
C) reference operator
D) mode indicator

Question 73

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

Question 74

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?

A) =COUNT(B1:B20)
B) =COUNTIF(B1:B20)
C) =COUNTA(B1:B20)
D) =DCOUNTA(B1:B20)

Question 75

Which of the following is true about adding cell borders?

A) You cannot apply borders to all worksheet cells.
B) A cell border underlines the cell text, not the entire cell.
C) You can add a border to the left, top, right, or bottom edge of a cell or range.
D) Borders are always single black lines.

Question 76

Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?

A) Business Intelligence
B) Flash fill
C) Quick Analysis tools
D) What-if analysis

Question 77

The default worksheet text is _____-point Calibri.

A) 10
B) 11
C) 12
D) 14

Question 78

When you double-click the right border of a column heading, which of the following occurs?

A) The column is deleted.
B) AutoFit resizes the column to 8.43 characters wide.
C) A column is added to the right of the current column.
D) AutoFit resizes the column to the widest cell entry.

Question 79

When you click a cell to insert a cell reference in a formula, you must type a(n) number to lock the cell reference in the formula.

Question 80

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

A) delete
B) conditionally format
C) edit
D) hide