Question 1

(TCO 8) Which of the following is a file type that cannot be imported into Excel?

• PDF

• Text file

• CAD

• TIFF

Question 2

(TCO 8) When importing an Access database table, Excel _____.

• imports the data as text.

• formats the data in default table style.

• imports the data in delimited format.

• imports the data is CSV format.

Question 3

(TCO 8) Which of the following tools is best suited for setting up a connection to a table on a web page?

• Hyperlink

• Web query

• 3-D formula

• Web inquiry

Question 4

(TCO 8) Which of the following options will refresh connections within an Excel workbook?

• Click Refresh All on the Connections group.

• Click Refresh in the Backstage area.

• Click anywhere in the connected data.

• Click Refresh in the Insert tab.

Question 5

(TCO 8) Where is the Text to Columns Wizard located in Excel?

• Data tab

• Insert tab

• Formulas tab

• Backstage

Question 6

(TCO 8) ) Which of the following functions does not manipulate text?

• CONCATENATE

• PROPER

• UPPER

• INDEX

Question 7

(TCO 8) Which of the following is an alternative to using the CONCATENATE function?

• &

• +

• SUM

• :

Question 8

(TCO 8) Which of the following is a required element of XML?

• Tag

• Title

• Link

• Anchor

Question 9

(TCO 7) Where is the Template gallery located?

• Insert tab

• Backstage

• Data tab

• Formulas tab

Question 10

(TCO 7) Where is the Insert Background feature located?

• Backstage

• Page Layout tab

• Formulas tab

• Insert tab

Question 11

(TCO 7) Which of the following is not controlled with cell style formats?

• Font attributes

• Print settings

• Cell-protection settings

• Border and fill styles

Question 12

What is the default save location for templates?

• C:\Users\username\Documents\CustomOfficeTemplates

• C:\Users\MyDocuments

• C:\templates

• C:\Users\templates

Question 13

(TCO 7) What is the password character limit in Excel?

• 325

• 255

• 355

• 100

Question 14

(TCO 7) Which of the following formats does not support macros?

• .xlsm

• .xlsb

• xltm

• xlsx

Question 15

(TCO 7) Which of the following is the proper beginning for a sub procedure named Test?

• Sub ()

• Sub (Test)

• (Test)

• Sub Test()