Excel Chapter 10 Exam Study Guide.
LOWER function - answerA function that converts all uppercase letters to lowercase.
Element - answerAn XML component, including that start tag, an end tag, and associated
data.
Start tag - answerAn XML code indicating an element's starting point and element's ...
LOWER function - answer✔✔A function that converts all uppercase letters to lowercase.
Element - answer✔✔An XML component, including that start tag, an end tag, and associated
data.
Start tag - answer✔✔An XML code indicating an element's starting point and element's name.
Comma separated values (CSV) file - answer✔✔A file that uses commas to separate text into
columns.
Text file - answer✔✔A file that contains letters, numbers, and symbols only; it does not contain
formatting, sound, or video.
Delimiter - answer✔✔A character used top separate text into columns.
PROPER function - answer✔✔A function that capitalizes the first letter in a text strong and any
other letters in the text that follow any character other than a letter.
Tab-delimited file - answer✔✔A file that uses tabs to separate data into columns.
End tag - answer✔✔An XML code indicating an element's ending point and name.
CONCATENATE function - answer✔✔A function that joins two or more text strings into one
text string.
Web query - answer✔✔A data connection that links an Excel worksheet to a particular data table
on a Web page.
eXtensible Markup Language (XML) - answer✔✔A data-structuring standard for sharing data
across applications, operating systems, and hardware.
Tag - answer✔✔A user-defined marker that identifies the beginning or ending or a piece of
XML data.
Fixed-width text file - answer✔✔A file that stores data in columns that have a specific number
of characters designated for each column.
, EXAM STUDY MATERIALS 8/7/2024 11:29 AM
Refresh - answer✔✔The process of updating data in Excel to match current data in the external
data source.
Importing - answer✔✔The process of inserting data from one application or file into another.
SUBSTITUTE function - answer✔✔A function that substitutes new text for old text in a text
string.
Flash Fill - answer✔✔A feature that fills in data or values automatically based on one or two
examples you enter.
UPPER function - answer✔✔A function that converts text to uppercase letters.
A text file separates data by a special character called a:
a. Delimiter
b. Column spacer
c. Start tag
d. Position holder - answer✔✔1. Delimiter
You created a Web query to determine how many bushels of corn were harvested in your state
last year. You referenced a USDA Web page. You need to view that page again and cannot
remember the URL. You should:
a. Create a hyperlink to the URL.
b. Open the Excel workbook and open the Connection Properties dialog box where the URL is
listed.
c. Use the Find command to locate the URL.
d. Open the Excel workbook and use the Data Import Wizard to find the URL. - answer✔✔b.
Open the Excel workbook and open the Connection Properties dialog box where the URL is
listed.
Last week, you created a Web query in Excel to import price and volume data about the stock
that interest you from a Web site. You open the file today and refresh the data. What will your
spreadsheet show?
a. The values you saved in the file last week and any calculations based on that data.
b. The new values with the calculations reflecting the current values of the stocks.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Brightstars. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
