+1(978)310-4246 credencewriters@gmail.com
  

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

  
error: Content is protected !!