BIS Week 4 Quiz (Updated)

Share on facebook
Share on whatsapp
Share on twitter
Share on pinterest
Share on linkedin
Share on reddit
Share on skype
Share on email

BIS Week 4 Quiz (Updated)


Question 1.Question :(TCO 8) To import a text file into Excel, click ________ on the File tab.
Student Answer: Open


Question 2.Question :(TCO 8) To create a connection between the original data source and the imported data in Excel, use the ________ on the Data tab.
Student Answer: Data Validation command
 Connection command
 Edit Links command
 Commands in the Get External Data group


Question 3.Question :(TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections.
Student Answer: Get External Data
 Data Tools


Question 4.Question :(TCO 8) Text to Columns command splits text in one column into separate ________.
Student Answer: columns

Hi there! Get instant help with . Without paying anything upfront.


Question 5.Question :(TCO 8) Which of the following is an example of a text string?
Student Answer: =B5*B7
 =IF(B3>B4, B3)
 John Doe


Question 6.Question :(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.
Student Answer: UPPER


Question 7.Question :(TCO 8) Which of the following functions does not change the case or capitalization of text?
Student Answer: PROPER


Question 8.Question :(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.
Student Answer: Type New List
 Use Existing List
 Import from Excel
 Select from Outlook Contacts


Question 9.Question :(TCO 8) The New Comment command is located on the ________ tab.
Student Answer: View


Question 10.Question :(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.
Student Answer: Split Names Wizard
 PivotTable feature
 Convert Text to Columns Wizard


Question 11.Question :(TCO 8) The ________ tab on the Page Setup dialog box provides options for printing comments.
Student Answer: Page


Question 12.Question :(TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab.
Student Answer: File


Question 13.Question :(TCO 8) To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties.
Student Answer: Properties
 Show All Properties


Question 14.Question :(TCO 8) Which function is similar to the Find and Replace feature?
Student Answer: CONCATENATE


Question 15.Question :(TCO 8) You can automate the deleting of duplicate rows from your spreadsheet by using the _________ on the Data tab of the Ribbon.
Student Answer: Text to Columns command
 Remove Duplicates command
 Consolidate command
 Group command



do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods


Scroll to Top