Deck 2: Excel-2019

Question 1

You can use the DELETE key to clear cell contents.

Answer 1

True

Question 2

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

Answer 2

C

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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 7

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

Question 8

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

Question 9

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

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

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 15

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 16

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 17

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

Question 18

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

Question 19

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

Question 20

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 21

In formulas, calculations in square brackets are calculated first.

Question 22

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 23

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

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

Question 24

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 25

How many actions does the Undo button let you reverse?

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

Question 26

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 27

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

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

Question 28

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

Question 29

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

Question 30

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 31

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

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

Question 32

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

Question 33

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 34

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 35

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 36

Which of the following inserts a function into a cell?

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

Question 37

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 38

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 39

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

Question 40

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 41

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 42

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 43

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 44

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 45

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 46

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 47

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 48

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

Question 49

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 50

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 51

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 52

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 53

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 54

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

Question 55

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 56

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 57

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 58

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 59

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

Question 60

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

Question 61

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 62

Which worksheet view shows headers, footers, and rulers?

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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 68

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 69

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

Question 70

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

Question 71

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 72

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

Question 73

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

Question 74

Currency is an example of a number format.

Question 75

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 76

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

Question 77

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 78

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 79

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 80

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.