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
 New
 Info
 Options

 

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
 Analysis
 Connections

 

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

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
 =SUM(A5:A10)
 =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
 LOWER
 PROPER
 CONCATENATE

 

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

 

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
 Review
 Data
 File

 

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
 CONCATENATE function
 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
 Margins
 Header/Footer
 Sheet

 

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

 

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
 Permissions
 Versions

 

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

 

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-my-paper-pay-someone-to-write-my-paper

do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods

Contact

Scroll to Top