Deck 2: Excel 2019

Question 1

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

Answer 1

True

Question 2

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

Answer 2

A

Question 3

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Answer 3

False

Question 4

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 5

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

Question 6

Where can you adjust page layout settings and see how they affect a preview of the printed worksheet?

A) Page Layout view
B) Normal view
C) Web Preview
D) Backstage view

Question 7

When you enter a value in a worksheet cell, it is automatically left-aligned.

Question 8

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

Question 9

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

A) mode indicator
B) Page Break Preview
C) scroll bar
D) Fill handle

Question 10

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

Question 11

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

Question 12

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 13

To have Excel enter the lowest price from a range of prices, which of the following would you use?

A) MAX function
B) COUNT function
C) MIN function
D) COUNTA function

Question 14

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

Question 15

To find the largest value in a cell range, use the MIN function.

Question 16

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

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

Question 17

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

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

Question 18

You can use the DELETE key to clear cell contents.

Question 19

You can use the I-beam pointer to move cell contents into adjacent cells.

Question 20

To print worksheet contents across the length of a page, you can use portrait orientation.

Question 21

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 22

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

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

Question 23

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

Question 24

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

Question 25

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 26

To print more than one copy of your worksheet, which tab would you go to?

A) View
B) Page Layout
C) Insert
D) File

Question 27

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

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

Question 28

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

A) Normal pointer
B) I-beam pointer
C) Move pointer
D) Copy pointer

Question 29

When you copy and paste a formula to a new location, the formula's relative references do not change.

Question 30

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 31

Which of the following is a predefined procedure that returns a value?

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

Question 32

Which of the following inserts a function into a cell?

A) mode indicator
B) AutoSum button
C) argument
D) formula prefix

Question 33

In formulas, calculations in square brackets are calculated first.

Question 34

What feature inserts a function that totals the cells above or to the left of the selected cell?

A) AutoSum button
B) Fill button
C) Paste options button
D) Flash Fill

Question 35

How many actions does the Undo button let you reverse?

A) 24
B) 50
C) 75
D) 100

Question 36

To view a worksheet without headers, margins, and rulers, use Page Layout view.

Question 37

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 38

Which of the following lets you search for a function or select one from a category?

A) Function Arguments dialog box
B) clipboard
C) formula bar
D) Insert Function dialog box

Question 39

When you cut or copy a cell, it is cut or copied to which of the following?

A) Neither the Windows or Office Clipboard
B) Both the Windows and Office Clipboard
C) Only the Office Clipboard
D) Only the Windows Clipboard

Question 40

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 41

Why is it necessary to use care when inserting worksheet cells?

A) It might automatically change the functions you are using.
B) It can change relative references to absolute references in formulas.
C) You will have to manually correct cell references in formulas.
D) It may disturb row or column alignment, which can affect worksheet accuracy.

Question 42

To see how copied contents will look with both values and number formatting, you would use Paste Numbers .

Question 43

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

A) A5
B) $A$5
C) $A5
D) A$5

Question 44

Which of the following is not a way to move cell contents?

A) clicking the Cut and Paste buttons on the Home tab
B) pressing the CTRL+X keys
C) holding the CTRL key while dragging the selected cells
D) using drag-and-drop

Question 45

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 46

In the formula =B6*$B$2, which of the following describes $B$2?

A) Relative cell reference
B) Absolute cell reference
C) Function
D) Average

Question 47

In the formula =A8*$A$1, which of the following describes A8?

A) Relative cell reference
B) Absolute cell reference
C) Function
D) AutoSum

Question 48

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

Question 49

Which of the following is true when you copy and paste formulas using the fill handle?

A) The Paste Options button lets you paste only specific elements of the copied selection.
B) The AutoFill Options button lets you fill cells with specific elements of the copied cell.
C) The formula is placed on the Office clipboard.
D) You need to change the cell references to reflect the new formula location.

Question 50

Which of the following is true about inserting cells in a worksheet?

A) Excel automatically adjusts cell references to reflect new formula locations.
B) You need to adjust cell references in all formulas that have moved.
C) You cannot insert cells in a worksheet.
D) Cells below the inserted cells are always moved downward.

Question 51

Which of the following is true about moving cell contents?

A) You can move cells using the Copy command.
B) You cannot move cells from one worksheet to another.
C) When you move cell contents, they remain in their original location.
D) You can move cells using the drag-and-drop feature.

Question 52

Which of the following is true when you delete a cell?

A) When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.
B) Row and column alignment will not be affected.
C) You need to manually adjust cell references in surrounding formulas.
D) You can use the Delete command on the Insert tab.

Question 53

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

Question 54

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

A) The Paste Options button then lets you paste specific elements of the copied cells.
B) The formula is copied with cell references you must adjust to avoid worksheet errors.
C) The Auto Fill Options button appears.
D) Pointing to the destination cell causes a preview of the cell contents to appear.

Question 55

When should you use relative cell references?

A) When you want to preserve the exact cell address in a formula.
B) When you want to preserve the relationship to the formula location.
C) When you want to insert a function.
D) When you want to enter sequential values in a range of cells.

Question 56

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

A) If it needs an absolute cell reference.
B) If it needs a relative cell reference.
C) If it needs landscape orientation.
D) If it needs a function.

Question 57

To paste only a copied cell's formats, you can click the Paste Options button and select the appropriate option.

Question 58

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

A) To erase the cell value from the clipboard.
B) To paste the value's number formatting only.
C) To paste all items on the clipboard.
D) To compute the results of a function.

Question 59

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 60

Where can you see a brief description of a selected function?

A) Formula bar
B) Insert Function dialog box
C) Insert dialog box
D) Insert tab

Question 61

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Question 62

To save a workbook for the first time, you use the Save As dialog box.

Question 63

Which of the following would you use to print only one page of a multipage worksheet?

A) Page Layout tab
B) Formulas tab
C) Backstage view
D) Page Setup dialog box

Question 64

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

A) Leave the workbook closed.
B) Open the workbook, change the first worksheet, and save it using the Save command.
C) Open the workbook, make changes, and then save it using the same name.
D) Open the workbook, make changes, and then save it using a different name.

Question 65

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

A) reverse
B) transpose
C) fill
D) merge

Question 66

To change the background color of a cell, you use the Background color button.

Question 67

Which worksheet view shows headers, footers, and rulers?

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

Question 68

Where do you rename a workbook and adjust its save location?

A) Save As dialog box
B) Home tab
C) Name box
D) Active cell

Question 69

Currency is an example of a number format.

Question 70

When you open a workbook, it contains one or more worksheets.

Question 71

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

Question 72

The Clipboard task pane shows the contents of the _____.

A) Office Clipboard
B) Table Styles gallery
C) Quick Analysis tool
D) Recently-Used Add-Ins

Question 73

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

Question 74

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

A) Gridlines View
B) Gridlines Print
C) Headings View
D) Headings Print

Question 75

Which of the following lets you fill a cell with only specific elements of a copied cell?

A) relative cell reference
B) Auto Fill Options button
C) argument
D) mode indicator
E) SHEET

Question 76

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Question 77

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

A) sheet tabs
B) arguments
C) scroll bars
D) operators

Question 78

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.

Question 79

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Question 80

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.