Deck 1: Getting Started With Excel

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

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

Answer 2

False

Question 3

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

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

Answer 3

A

Question 4

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

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

Question 5

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

Question 6

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 7

Which of the following tabs lets you see exactly how your worksheet looks before printing?

A) Insert
B) View
C) Formulas
D) File

Question 8

Where can you see a preview of how your worksheet will look when printed, including headers?

A) Print tab in Backstage view
B) Page Break preview
C) Normal view
D) File preview

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

How many actions does the Undo button let you reverse?

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

Question 15

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 16

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 17

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

Question 18

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 19

To see a preview of how a pasted value will look, which of the following would you use?

A) Fill button
B) AutoFill Options button
C) Paste button
D) Paste List arrow

Question 20

To fit all worksheet content on one page, you can set page scaling in Backstage view.

Question 21

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 22

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 23

When you double-click a cell's right column border, 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 column's border.
D) AutoFit resizes the column to the widest cell entry.

Question 24

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 25

The default worksheet text is _____-point Calibri.

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

Question 26

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

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

Question 27

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 28

In formulas, calculations in square brackets are calculated first.

Question 29

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

Question 30

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

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

Question 31

Your worksheet is too wide to fit on one portrait page. 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 32

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 33

Which of the following can you use to insert a formula using a function?

A) Insert Function dialog box
B) AutoSum button on the Ribbon
C) AutoSum list arrow on the Ribbon
D) Copy and paste a cell containing a function

Question 34

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 35

To create a new, blank workbook, which of the following can you use?

A) The Open command in Backstage view.
B) The New command in Backstage view.
C) The New command on the File tab.
D) The Open command on the File tab.

Question 36

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) A cell border extends the width of the cell.
D) You can only apply a border to the bottom of a cell.

Question 37

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 38

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

Question 39

To print your worksheet at its actual size, which of the following would you select?

A) Fit to
B) No scaling
C) Fit sheet to one page
D) Scale to fit

Question 40

To enter data in a cell using examples already in your workbook, you can use the flash fill feature.

Question 41

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 42

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 calls in a range that contain numeric data.

Question 43

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

Question 44

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 45

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 46

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 47

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 48

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

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

Question 49

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

A) Normal
B) normal
C) NORMAL
D) ​

Question 50

Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

Question 51

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

Question 52

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 53

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 54

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 55

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

A) the Cut and Paste buttons on the Home tab
B) the fill handle in the lower-right corner of an active cell or range
C) the CTRL key + the Move pointer
D) drag-and-drop

Question 56

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 57

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Question 58

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 59

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 60

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

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

Question 61

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

Question 62

To delete a worksheet column, you can first select it by _____.

A) clicking the column heading
B) double-clicking the column heading
C) clicking anywhere in the column
D) double-clicking anywhere in the column

Question 63

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Question 64

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 65

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so?

A) View tab > Window group > Unhide
B) View tab > Window group > Uncheck box beside Hide > Check box beside Unhide
C) File > Options > Display > Check Show all windows in the Taskbar box
D) Home > Format > Visibility > Hide & Unhide > Hide Sheet

Question 66

You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?

A) Before you paste it, you need to select C1:C5.
B) Before you paste it, you only need to select cell C1.
C) After you paste it, the information is deleted from the Clipboard.
D) After you paste it, the information is deleted from the original location.

Question 67

To move a worksheet, you can drag its sheet tab to the left or right.

Question 68

Which of the following is true about deleting a worksheet? Select all the options that apply.

A) You can right-click a sheet tab and click Delete.
B) You can use the Delete list arrow in the Cells group on the Home tab.
C) You can use the Delete button in the worksheet group on the Insert tab.
D) You cannot delete a worksheet from a workbook.

Question 69

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 70

Boris wants to remove a workbook window from his workplace. What series of clicks can he use to hide it?

A) View tab > Window group > Hide
B) View tab > Window group > Split
C) View tab > Window group > View Side by Side
D) View tab > Window group > Switch Windows > Select a file

Question 71

When you select a cell range, the cells must be adjacent to each other.

Question 72

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

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

Question 73

Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her do so?

A) Sheet tab > Window group > Hide
B) Sheet tab > Window group > Freeze Panes > Hide
C) Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet
D) Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows

Question 74

Which of the following is true about deleting a worksheet row?

A) After you delete a row, the rows below it shift down one row.
B) To delete a row, you can select the row, then press the DELETE key on the keyboard.
C) To delete a row, you can select the row, then use the Delete button in the Cells group.
D) If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.

Question 75

Which of the following is true about changing worksheet column width?

A) In Normal view, the Column Width dialog box lets you set column width to an exact value in inches.
B) In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.
C) When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches.
D) When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels.

Question 76

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

Question 77

After you delete a worksheet column, _____.

A) the columns to its right shift left
B) the columns to its left shift right
C) the row remains but its contents are deleted
D) only its formats are deleted

Question 78

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

A) a row
B) a column
C) a button
D) conditional formatting

Question 79

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 80

To change the name of a worksheet, you rename the _____.

A) sheet columns
B) sheet rows
C) sheet header
D) sheet tab