excel 6

There are ______ characters in the Zip Code 45392-2342.

10

The data in J2 is the Zip Code 43892-3424. What would the result be for the function =MID(J2,7,4)? 424 -34 -342 3424

3424

Cell A1 contains the area code for a phone number. Cell B1 contains the seven-digit phone number with a dash separating the third and fourth numbers. What would be the result of the formula =TEXTJOIN(A1:B1,true," ")? 555 345 0162 555-345 0162 555 345-0162 555-345-0162

555 345 0162

Cell A2 contains the first name, and B2 contains the last name. Which of the following is the correct formula to combine both the first and last name? =COMBIN(A2," ",B2) =A2 + " " + B2 =TEXTJOIN(A2:B2,false," ") =CONCAT(A2," ",B2)

=CONCAT(A2," ",B2)

If the data in I2 is 345-555-0125, which of the following would result in the data 555 being extracted? =LEFT(I2,3) =RIGHT(I2,8) =MID(I2,5,3) =LEFT(I2,LEN(I2)-5)

=MID(I2,5,3)

Which of the following options best describes a .txt file? A file used to hold music files A file used to store numbers A special spreadsheet file containing dates A file used to hold data without formatting

A file used to hold data without formatting

What is a delimiter? A process to collect data A way to combine data A way to organize data Something used to limit the use of data

A way to organize data

You can use a hyperlink to connect which of the following? A cell A range of cells A named range of cells A website

All

Which of the following can you use as a delimiter within a TEXTJOIN function? A comma (,) A space All the above A dash (-)

All the above

Which of the following situations would make most sense for combining them into one category? Birth date and year Last name and car model Favorite color and shoe size Year in college and weight

Birth date and year

What delimiter does a CSV file use? Hash tab Spacebar Comma Tab

Comma

When creating a link to a document within a workbook, which area of the Insert Hyperlink dialog box should you use? Create a new file Email address Existing file or webpage Place in this document

Existing file or webpage

Which of the following options would be the best way to separate data? Four categories: Name & address and zip code & phone number Two categories: Name + address and zip code + phone number Three categories: Name & address and zip code + phone number One category: Name + address + zip code + phone number

Four categories: Name & address and zip code & phone number

Which of the following options would be an example of the result after using the UPPER function? GUY RABIN gUY rABIN guy rabin Guy Rabin

GUY RABIN

____________ is the option users use in Excel to bring in data from sources such as TXT and CSV files.

Get & Transform Data

__________ provide navigation throughout a workbook or to external resources.

Hyperlinks

The data in H2 is I like strawberries. What would the result be for the function =LEFT(H2,4)? I li I lik I like s I like

I li

What does a delimiter do? It tells Excel where to place a title for a workbook. It provides a way to give color and style to a workbook It tells Excel how to organize data into columns. It gives information about the data being imported.

It tells Excel how to organize data into columns.

What is unique about a .csv file? t contains only numeric data. It is a file type restricted to the use of a word processing program. The file uses a space to separate data. It uses a comma as a delimiter

It uses a comma as a delimiter

What is data? It's a graphical representation. It's a group of letters, numbers, and symbols that a computer can perform an operation on. ( It's the same thing as information. It's information that is used to track daily sales.

It's a group of letters, numbers, and symbols that a computer can perform an operation on. (

To separate the area code from a phone number, use the _________ function.

Left

Using a hyperlink within a workbook makes _________ to a place within the workbook or outside the workbook easier.

Navigating

By using __________________, the reference cells can be deleted because the formulas have converted to values.

Paste Speical

Which function would be best to apply to a cell containing a title of a book in which the first letter of every word should be capitalized? TITLE PROPER LOWER UPPER

Proper

Which of the following functions would correct the capitalization errors in MAIN STREET? UPPER PROPER LOWER TITLE

Proper

Customer email addresses have been added to a file. The email addresses automatically become active links. How can you remove these active links without removing the email address? Clear the cells. Right-click or access the context menu and select remove hyperlink Use the Link option on the Insert menu. When entering the email address, enter a space after the email address.

Right-click or access the context menu and select remove hyperlink

When creating a hyperlink within a cell, what is the best method for creating the hyperlink? Always connect the cell with a website. Copy and paste the link into the cell. Select descriptive text for the link, and in the Insert tab, in the Links group, select Link to create it. Use the LINK feature and allow Excel to create the text.

Select descriptive text for the link, and in the Insert tab, in the Links group, select Link to create it.

Which is the proper way to insert a hyperlink within a cell? Copy and paste a hyperlink into the cell. Enter the link directly into the cell. =HYPERLINK(www.website.com,true,open) Select text within a cell, and then on the Insert tab, in the Links group, select Link.

Select text within a cell, and then on the Insert tab, in the Links group, select Link.

How would you replace the formulas in B2:B10 with the values from A2:A10?

Select the cells and then choose the arrow below Paste and choose Paste Values.

You can edit or remove a hyperlink using which action? Selecting the hyperlinked cell and selecting delete. Selecting the hyperlinked cell and selecting Tab. Selecting the hyperlinked cell and using the Link command found on the Insert tab. Selecting the hyperlinked cell and using the Edit tab.

Selecting the hyperlinked cell and using the Link command found on the Insert tab.

Which of the following is an example of the function LOWER? Rain wIND Snow SUNSHINE

Snow

A school secretary has an Excel file containing parents' and guardians' names and the names of the students who live with them. This information needs to be combined so that a list can be created connecting the students with the parents or guardians they live with in the same household. Remembering that there might be more than one guardian in the household and might be more than one student living in the same household, which function would be best to use in this situation? TEXTCOMB, using a comma delimiter. TEXTJOIN, using false and a comma as a delimiter. TEXTJOIN, using true and a comma with a space as a delimiter. CONCAT, using a delimiter of a space.

TEXTJOIN, using true and a comma with a space as a delimiter.

A list of items exists within the cells in column A. The items need to be placed in cell B2, with commas between each item as a list. Which of the following is the correct procedure to complete this task? Reenter the items in B2 by using commas between each item. Use =TEXTJOIN(", ",true,A1:A13) Use =COMMAS(A1:A13). Use =CONCAT(A1:A13, ", ",B2).

TextJoin

Which of the following functions allow you to combine items using a comma (,), a semicolon (;), or a space( )? ADD TEXTJOIN COMBIN CONCAT

TextJoin

Which of the following answers explains how to use the MID function? The MID function takes the data to the left and the right of a category starting from the middle of the data. MID allows the user to find the midpoint of a line. MID finds the middle columns of a group of columns within a workbook. The MID function allows the user to specify a starting point and how many characters to extract from that point.

The MID function allows the user to specify a starting point and how many characters to extract from that point.

Which of the following options would be the best way to categorize someone's name? Just one category with last name first and first name last. Two categories with the first and last name in one category and the phone number in the second category. Just one category with first and last name. Two categories with the first name in one category and the last name in a second category.

Two categories with the first name in one category and the last name in a second category.

A list of items exists within the cells in column A. The items need to be placed in cell B2, with commas between each item as a list. Which of the following is the correct procedure to complete this task? Reenter the items in B2 by using commas between each item. Use =TEXTJOIN(", ",true,A1:A13) Use =COMMAS(A1:A13). Use =CONCAT(A1:A13, ", ",B2).

Use =TEXTJOIN(", ",true,A1:A13)

How would you convert text within a spreadsheet from all-lowercase to every first letter of every word capitalized? Use a function You can't change it. Reenter the information. Use a text color tool.

Use a function

How would you combine text from different columns within a workbook? Use the COMBINE option. Use a plus sign (+) between the two cell references (for example, A2+B2). Reenter the information into a new column. Use the CONCAT option

Use the CONCAT option

Which of the following statements about hyperlinks is false? A hyperlink to a named group of cells can be created. You can link hyperlinks to several areas including an internal cell, an external document, an email address, or a website. You can remove a hyperlink by right-clicking on it or accessing the context menu, and then selecting Remove hyperlink. When removing multiple hyperlinks, they must be removed one at a time.

When removing multiple hyperlinks, they must be removed one at a time.

What three ways you can separate data within a data file. Tabs Commas Semicolons Colons

all

To combine text from one cell with another cell, use the __________ function.

concat

Explain how separating the area code from a phone number might be useful.

organize/manage