Deck 1: Getting Started With Excel

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

D

Question 4

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

Question 5

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 6

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

Question 7

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 8

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 9

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

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

Question 10

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 11

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 12

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

Question 13

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 14

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

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

Question 15

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

Question 16

How many actions does the Undo button let you reverse?

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

Question 17

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

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

Question 18

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

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

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

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 22

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 23

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 24

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 25

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 26

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

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

Question 27

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 28

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 29

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 30

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 31

The default worksheet text is _____-point Calibri.

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

Question 32

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

Question 33

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 34

In formulas,calculations in square brackets are calculated first.

Question 35

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 36

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 37

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 38

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 39

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

Question 40

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 41

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 42

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

Question 43

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 44

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 45

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

Question 46

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 47

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 48

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 49

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 50

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 51

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 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 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 54

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 55

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

Question 56

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 57

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 58

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 59

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 60

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 61

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 62

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

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 65

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 66

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 67

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 68

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 69

Miley wants to perform calculations on four worksheets with identical structures at the same time.So,in order to group them and perform the task faster,she can press the Ctrl + Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

Question 70

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 71

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

Question 72

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

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

Question 73

Which worksheet view shows headers,footers,and rulers?

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

Question 74

Which of the following appears in Page Layout view?

A) Text box containing the header
B) Margins
C) Page number indicator
D) Blue dotted lines indicating page breaks

Question 75

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 76

Which of the following methods copies an existing worksheet within the same workbook?

A) Drag its sheet tab to a new location.
B) Press and hold CTRL and drag its sheet tab to a new location.
C) Press and hold SHIFT and drag its sheet tab to a new location.
D) Press and hold ALT and drag its sheet tab to a new location.

Question 77

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 78

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

Question 79

A worksheet named Income (2)is most likely which of the following?

A) a deleted worksheet
B) a worksheet with no calculations
C) a repositioned worksheet
D) a copy of another worksheet named Income

Question 80

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