answer multiple choice questions
Which of the following Excel functions are used to move data from a Word file to Excel? Select al that apply. Please add checkmark next to the correct answer(s). 1 A. CONCATENATE. 2 B. Text to columns. 3 C. Copy and paste. 4 D. CTRL + . 5 E. Data-Sort. 6 F. CTRL+A. 62A Alphanumeric data refers to a field, such as address, that contains both letters and numbers. 63A A quick way to format all zip codes in a column to be five digits is to: Please add checkmark next to the correct answer(s). 1 A. Home-Number-Special-Zip Codes. 2 B. Highlight the column and right justiry all numbers. 3 C. Search for any cells that have fewer than five digits and FIX. 4 D. Enter a ' before any cell in a state that starts with a 0. Freeze panes is a handy tool for: (Select all that apply) Please add checkmark next to the correct answer(s). 1 A. Locking in the left column of cells. 2 B. Hiding the top row while viewing other rows. 3 C. Ensuring the far-left column does not move when scrolling through other columns. 4 D. Password protecting rows or columns so they cannot be changed. 5 E. Keeping the top row the same while scrolling through other rows #65A To quickly get rid of blank rows (i.e., rows with no data) in a large worksheet: Please add checkmark next to the correct answer(s). 1 A. Search for "blank rows." 2 B. Use IF statements. 3 C. Use Data-Sort by any column to send blank rows to the bottom of the sheet. 4 D. Highlight cells that have no data and delete that row. Each of these methods will help find companies in a particular state in a large spreadsheet. Select all that apply. Please add checkmark next to the correct answer(s). 1 A. Turn the spreadsheet into a table and search the column for state. 2 B. Home-Styles-Conditional Formatting-Highlight Cells Rules. 3 C. Data-Sort \&. Filter-Sort and choose column for state. 4 D. Home-Styles-Conditional Formatting-New Rule. 5 E. View-Window-Freeze Panes. 6 F. Data-Data Types-Geography. * 67A A benefit of using the Sort command is that data in hidden rows or columns will be ignored. Yes No x68A To hide a worksheet: Please add checkmark next to the correct answeri(s). 1 A. Home-Hide. 2 B. Right-click on the tab name and choose Hide. 3 C. Data-Hide. 4 D. File-Options-Advanced. *. 6.9A This method is not a very efficient way to import data from a PDF to Excel, Select all that apply. This method is not a very efficient way to import data from a PDF to Excel. Select all that apply. Please add checkmark next to the correct answer(s). 1 A. Convert data from PDF to Word and then import Word to Excel. 2 B. Import data directly from PDF and then clean it up in Excel. 3 C. Cut and paste data from PDF into Excel. 4 D. Use Adobe Acrobat to have more functionality in converting PDF to Excel. 5 E. Retype the data in the PDF directly into Excel. x610A An effective way to convert Excel to Word and be able to add data in Word is to copy the Excel document and: Please add checkmark next to the correct answer(s). 1 A. Paste into Word, click on the table and choose auto-fit to contents. 2 B. Paste into Word as a picture. 3 C. Paste into Word as text. 4 D. Embed it into Word
