Description
Question 1
The function REPLACE replaces part of a text string with a new text string based on the number of characters specified in ____.
num_chars
range
text
start_num
Question 2
The syntax for the CONCATENATE function is as follows: ___.
=CON(text1,text2,…)
=CONCATENATE(text1,text2,…)
CONCATE(text1,text2,…)
LINK(text1,text2,…)
Question 3
Case-Based Critical Thinking Questions Case 7-2
Robert has imported some data from Access and is using the Query Wizard to filter the data.. Please refer to this figure as you answer the questions below.
Robert is looking for all the customers who are both in the state of IL and who have a 312 area code. He would create a(n) ____.
And query
Or query
either a or b
neither a nor b
Question 4
An XML table is similar in appearance and functionality to an Excel table, but the data in an XML table is mapped to ____ elements.
SGML
XML
HTML
Excel
Question 5
XML documents are organized in a running tabular form with each element occupying ____.
one line
one map
one column
one table
Question 6
You can change the calculation used in the Values area by right-clicking a value in the Values area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.
Value Field
Value Settings
Field Settings
Value Field Settings
Question 7
The ____ function converts a text string that represents a number (a number, date, or time) to a number.
VALUE
NUMBER
CONVERT
NEW
Question 8
The FIND function returns the ____ of one text value within another text value.
starting position
ending position
middle position
comma between
Questio
and not the elements from the ____.
XML graphic
XML map
XML group
XML category
Question 10
Case-Based Critical Thinking Questions Case 7-2
Robert has imported some data from Access and is using the Query Wizard to filter the data.. Please refer to this figure as you answer the questions below.
If Robert wanted to find all records with the value IL in the state field, he would click State in the Column to filter list box, click the State list arrow, and then click ____. Click the list arrow for the second list box, and then select IL.
equals
find
IL
search
