ncorrect Question 4 0 / 1 pts Which of the following can you not use as a separator when converting text to a table? O Commas Paragraphs Periods Tabs For further information, please review Module 8 -
Added by Mike L.
Close
Step 1
Step 1: When converting text to a table, you need to use separators to define the different columns. Show more…
Show all steps
Your feedback will help us improve your experience
James Kiss and 52 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
8) A(n) paragragh is a paragrah that begins with a dot or other symbol. a) headline b) centered c) bulleted d) indexed. 9) the , or typeface , defines the appearance and shape of letters , numbers, and special characters . a) font b) font size c) point d) paragraph formatting 10) are types of changes that occur when text has been omitted from a document and must be inserted later. a) additions b) deletions c) modifications d) all of the above
James K.
Yujie W.
Question 15 (4 points) Examine the attached workbook. The data represents the amount of money a customer has spent, in a quarter, to buy a product. Create a PivotTable based on the (entire) table of data in the Sales worksheet. For Row Labels, choose the Product column. Include Columns C, D, E and F in the Values-area. Add a slicer to the pivot table, based on customers. For which Product did the customer 'ALFKI' spend the most money in Qtr 4? Pivot_table_test.xlsx Question 15 options: Vegie-spread Rössle Sauerkraut Chartreuse verte Spegesild Question 16 (4 points) To remove a single individual field from a report, _______ the check box beside the field name in the PivotTable Field List. Question 16 options: clear check fill drag Question 17 (4 points) Which of the following is one of the ways to create a Pivot Chart? Question 17 options: Insert (tab) -> Charts (group) -> PivotChart Insert (tab) -> Sparklines (group) -> PivotChart Insert (tab) -> Tables (group) -> PivotChart Insert (tab) -> Illustrations (group) -> Shapes -> PivotChart Question 18 (4 points) PivotTables_Ex1.xlsx Please refer to the attached workbook. What is the TOTAL amount of Sales in the west regions of Arizona (AZ) and California (CA)? Question 18 options: 2200 and 4300 respectively 2300 and 4300 respectively 2200 and 4100 respectively 2300 and 2200 respectively Question 19 (4 points) In Excel, if one enters a time greater than ten thousand hours, it is interpreted as ________ instead of a time value. Question 19 options: an array a text string a scientific number a database object Question 20 (4 points) If cell A1 contained the text MR. JOHN Q. PUBLIC, what would the formula (=PROPER(A1)) return? Question 20 options: Mr. John Q. Public John Q. Public Mr. John q. Public Public, John Q. Question 21 (4 points) The function ______________ updates specific characters in a string with a new value (i.e., with new text). Hint: This function is used when you know the text to be replaced but not the specific location. Question 21 options: FIND_AND_REPLACE() SUBSTITUTE() FIND() SEARCH()
Aparna S.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD