Excel

Question 1

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

a. Page Layout
b. Print Layout
c. Synchronous Scrolling
d. ScreenTips

Answer 1

a. Page Layout

Question 2

Which of the following can you drag or double-click to change the width of a column?

a. Cell pointer
b. Column marker
c. Fill handle
d. Formula bar

Answer 2

b. Column marker

Question 3

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

a. Backstage
b. Print
c. Edit
d. Windows

Answer 3

a. Backstage

Question 4

To change printer, layout, or margin settings, you click the File tab and use which of the following options?

a. Info
b. Options
c. Print
d. Open

Answer 4

a. Info

Question 5

Which of the following is not an arithmetic operator?

a. +
b. −
c. *
d. ]

Answer 5

d. ]

Question 6

Which of the following is an acceptable name for a named range?

a. C7
b. subtotal_west
c. subtotal west
d. subtotal/west

Answer 6

b. subtotal_west

Question 7

Which of the following is an example of an absolute cell reference?

a. A9
b. A$9
c. $A$9
d. A9:E9

Answer 7

c. $A$9

Question 8

Which of the following is an example of a mixed cell reference?

a. A9
b. A$9
c. $A$9
d. A9:E9

Answer 8

b. A$9

Question 9

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

a. AVERAGE
b. AutoSum
c. COUNT
d. MAX

Answer 9

b. AutoSum

Question 10

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

a. MIN
b. AVERAGE
c. COUNT
d. MAX

Answer 10

b. AVERAGE

Question 11

The COUNT and MIN functions are examples of which category of functions?

a. text
b. statistical
c. financial
d. logical

Answer 11

b. statistical

Question 12

Which of the following can you not copy using Format Painter?

a. Font color
b. Bold
c. Font size
d. Cell content

Answer 12

d. Cell content

Question 13

You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

a. Apply another style to the cell.
b. Use the Undo command.
c. Clear the cell’s content.
d. Apply the Normal style to the cell.

Answer 13

c. Clear the cell’s content.

Question 14

Which of the following statements about hidden and unhidden worksheets is correct?

a. Unhidden worksheets cannot contain formulas that refer to hidden worksheets.
b. When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones.
c. A hidden worksheet cannot be inadvertently deleted.
d. Excel creates a minimized window for each hidden worksheet.

Answer 14

c. A hidden worksheet cannot be inadvertently deleted.

Question 15

Which of the following steps is not a method for inserting a worksheet into a workbook?

a. Click the Insert sheet (+) button to the right of the worksheet tabs.
b. On the Home tab, click Insert and then click Insert Sheet.
c. On the Insert tab, click Worksheet.
d. In the Insert dialog box, click Worksheet and then click OK.

Answer 15

b. On the Home tab, click Insert and then click Insert Sheet.

Question 16

In order for you to freeze the first column of a worksheet into a frozen pane:

a. The entire contents of the column must be visible.
b. The first row of the column must be non-blank.
c. Duplicate worksheets must also be able to have their first columns frozen.
d. You can click Freeze First Column in the Freeze Panes menu.

Answer 16

c. Duplicate worksheets must also be able to have their first columns frozen.

Question 17

Which of the following procedures is not a way to sort a table by the contents of one column?

a. Click the Sort button in the Sort & Filter group of the Data tab.
b. Click an AutoFilter button in the total row.
c. Click an AutoFilter button in the field names row.
d. Click the Filter button in the Sort & Filter group of the Data tab.

Answer 17

b. Click an AutoFilter button in the total row.

Question 18

Which of the following is a valid reason for converting a table to a range?

a. To clear the sorting criteria and start over.
b. To prepare for deleting a column.
c. To prepare for importing new data from a non-Excel file.
d. To prepare to change its conditional formatting.

Answer 18

c. To prepare for importing new data from a non-Excel file.

Question 19

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.
b. Only an Auto Outlined worksheet may contain total rows.
c. An Auto Outlined worksheet contains only one button for collapsing and expanding.
d. Only a multi-grouped worksheet can cluster rows and columns.

Answer 19

a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.

Question 20

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?

a. Table[Auction Items(Total Sale)]
b. Auction Items(Total Sale)
c. Auction Items[#Totals]
d. #Totals[Total Sale]

Answer 20

c. Auction Items[#Totals]

Question 21

Which of the following procedures is not a way to filter a table by the contents of one column?

a. Click the criterion button on the slicer.
b. Right-click the cell whose contents you want for the criterion and click Filter in the menu.
c. Click the Filter button in the Sort & Filter group of the Data tab.
d. Click the AutoFilter button in the total row at the bottom.

Answer 21

d. Click the AutoFilter button in the total row at the bottom.

Question 22

Which of the following attributes is not a potential criterion for an AutoFilter sort?

a. Font color
b. Font style
c. Cell color
d. Cell icon

Answer 22

b. Font style

Question 23

Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?

a. There is no difference between an AutoFiltered range of records in a list and a table.
b. A table maintains its sort order after you close and then open it again.
c. A table given a title enables its field names to be used in formulas in place of cell references.
d. A table enables special subtotal functions for total rows.

Answer 23

c. A table given a title enables its field names to be used in formulas in place of cell references.

Question 24

Which of the following characters would not appear on an outline symbol or control for grouped or outlined data?

a. +
b. @
c. 2
d. –

Answer 24

b. @

Question 25

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references? a. You want to preserve the integrity of any cells referenced by formulas in the macro. b. You want the values of any cells copied to the macro to be accurate. c. You want the results of any formulas produced by the macro to be accurate. d. You want the macro to reproduce its results in the same place each time.

Answer 25

d. You want the macro to reproduce its results in the same place each time.

Question 26

Which of the following does Excel not provide features for importing data? a. An active database b. A Web page c. A Web search d. An XML file

Answer 26

c. A Web search

Question 27

Which of the following functions automatically counts cells that meet multiple conditions? a. COUNTIF b. COUNT c. COUNTIFS d. SUMIFS

Answer 27

c. COUNTIFS

Question 28

Which of the following functions automatically counts cells that meet a specific condition? a. COUNTIF b. COUNT c. COUNTIFS d. SUMIFS

Answer 28

a. COUNTIF

Question 29

In the formula =SUMIFS(C5:C16, F5:F16, “<=60”, B5:B16, “>200000”), which of the following is the range of cells to be added? a. =C5:C16 b. =F5:F16 c. =B5:B16 d. =C5:F16

Answer 29

a. =C5:C16

Question 30

Which of the following functions returns one value if a condition is true and a different value when the condition is not true? a. AND b. OR c. IF d. SUM

Answer 30

c. IF

Question 31

Which of the following functions returns a value if all conditions are met? a. AND b. OR c. IF d. SUM

Answer 31

a. AND

Question 32

Which of the following functions searches for a value in the first column of Table array and returns a value in the same row from Col_index_num? a. AVERAGEIF b. VLOOKUP c. MID d. HLOOKUP

Answer 32

b. VLOOKUP

Question 33

Which of the following functions converts text from uppercase to title case? a. UPPER b. PROPER c. LOWER d. TRIM

Answer 33

a. UPPER

Question 34

Which of the following functions joins two or more text strings into a single text string? a. AND b. MID c. TRIM d. CONCATENATE

Answer 34

d. CONCATENATE

Question 35

Adding, deleting, and viewing comments are performed from the commands on which ribbon tab? a. Comments b. Review c. File d. View

Answer 35

b. Review

Question 36

The Protect Workbook button is on which ribbon tab? a. Comments b. Review c. File d. View

Answer 36

b. Review

Question 37

Which of the following is not an option in the Comments group? a. New Comment b. Delete c. Track Changes d. Edit Comment

Answer 37

c. Track Changes

Question 38

Which of the following cannot be used to turn on track changes? a. The Track Changes button b. The Share Workbook button c. The Protect Sheet button d. The Protect and Share Workbook button

Answer 38

c. The Protect Sheet button

Question 39

Which of the following is not on the Review tab? a. Track Changes button b. Share Workbook button c. Protect Cells button d. Protect and Share Workbook button

Answer 39

c. Protect Cells button

Question 40

Which of the following functions allows you to have Excel place a random number between 10000 and 99999 in a cell? a. RAND() b. RANDBETWEEN(10000,99999) c. BYCHANCE(10000,99999) d. RANDOM(10000,99999)

Answer 40

b. RANDBETWEEN(10000,99999)

Question 41

Which of the following actions cannot be performed with comments? a. You can format the text using a different color. b. You can change the background comment box color. c. You can prevent the disclosure of the name of the user who made the comment. d. You can hide the comment.

Answer 41

b. You can change the background comment box color.

Question 42

Which chart type appears on a worksheet with other data? a. Chart sheet b. Embedded c. PivotChart d. Mixed

Answer 42

b. Embedded

Question 43

Which part of a chart do you click when you want to select the entire chart? a. Chart area b. Plot area c. Chart title d. Legend

Answer 43

a. Chart area

Question 44

Which of the following is not found in the Illustrations group on the Insert tab? a. WordArt b. Shapes c. Online Pictures d. SmartArt

Answer 44

a. WordArt

Question 45

The Crop tool is found on which of the following ribbon tabs? a. Drawing Tools Format b. Insert c. Picture Tools Format d. Home

Answer 45

c. Picture Tools Format