Spreadsheet Applications for Business

2 PointsThe ____ function returns the last character or characters in a text string, based on the number of characters specified.

1. LEFT
2. CHARACTER
3. RIGHT
4. NUMBER

2 PointsA common way of storing data so that it is usable in other programs is to save it in a ____ file.

1. comma-delimited
2. comma-limited
3. comma-delineated
4. comma-lineated

2 PointsWith the SEARCH function, if you searched for Dad, you could get the result ____.

1. Dad
2. dad
3. either a or b
4. neither a nor b

2 PointsTo add a new row to an XML table, you use the handle in the lower-right cell of the XML table to ____. You can then type or copy values into the cells.

1. increase the size of the table
2. open a menu
3. rotate the bottom row
4. none of the above

2 PointsA ____ is an automated method for retrieving information from a Web page without having to copy and paste it into an application.

1. Web query
2. Web search
3. Web find
4. Web task

2 PointsIn the FIND function, ____ is the text that you want to find.

1. find_text
2. find_words
3. text_find
4. words_find

2 PointsYou can use a text function to ____ or concatenate the information from multiple cells into one cell.

1. look up
2. link together
3. transform
4. calculate

2 PointsThe maximum number of rows and columns in a worksheet limits the number of records and fields you can have in your list to ____ rows and 16,384 columns.

1. 16,384
2. 48,576
3. 148,576
4. 1,048,576

2 PointsYou can open the Export XML dialog box using the Export button in the XML group on the ____ tab.

1. Developer
2. Web
3. Programming
4. Web Query

2 PointsXML documents are organized in a running tabular form with each element occupying ____.

1. one line
2. one map
3. one column
4. one table