Import Data into Workbooks
What file types can be imported into Excel?
Excel can import CSV, TXT, XML, and other data file types.
How can you quickly scroll through a large worksheet?
Use the scroll bar or the arrow keys on your keyboard.
What is the shortcut for opening the Format Cells dialog box?
Press Ctrl + 1.
How do you set up a custom view in Excel?
Go to the "View" tab, select "Custom Views", and then "Add"
What steps must you follow to import data from the web into Excel?
Use the "Get Data" option, choose "From Web", and enter the URL of the web page.
What does the 'Freeze Panes' feature do?
It keeps specific rows or columns visible while you scroll through the rest of the worksheet.
How can you format numbers as currency in a worksheet?
Select the cells, right-click, choose "Format Cells", and select "Currency".
How can you change the default file format for saving workbooks?
Go to "File", then "Options", select "Save", and choose the default format under "Save files in this format".
How do you import data from a CSV file into Excel?
Open Excel, go to the "Data" tab, select "Get Data", then "From File", and choose "From Text/CSV"
What is the shortcut to jump to the last cell with data in a worksheet?
Press Ctrl + Arrow Key (direction)
How can you add borders to a cell or range of cells?
Select the cells, right-click, choose "Format Cells", go to the "Border" tab, and select your preferences.
How do you customize the Ribbon in Excel?
Right-click on the Ribbon and select "Customize the Ribbon".
What is the purpose of the "Get & Transform" feature in Excel?
It allows users to connect, combine, and refine data from different sources.
What feature allows you to quickly find and replace text within a workbook?
The "Find and Replace" feature (Ctrl + H).
What is a quick way to apply bold formatting to selected text?
Press Ctrl + B.
Where can you adjust the zoom level in a workbook?
Use the zoom slider in the bottom right corner of the Excel window or the "View" tab.
What function allows you to bring data from a different file format into Excel?
The "Import" function allows you to bring in data from various sources.
What shortcut can you use to quickly navigate between sheets in a workbook?
Use Ctrl + Page Up or Ctrl + Page Down.
How do you change the color of a cell?
Select the cell, then use the "Fill Color" option in the Home tab.
How can you set the default view to 'Page Layout'?
Go to the "View" tab, then select "Page Layout" and save the workbook.