Back to notes
What are the options available on Excel's Start Page upon launch?
Press to flip
Create a blank workbook, browse templates, and access recent workbooks.
What does the Quick Analysis Tool in Excel do?
Provides quick totals like sums or more complex insights without manual calculations.
How do you resize a column to fit its content?
Double-click the boundary between the column headers.
What steps are involved in moving a column to a new position?
Highlight the column and drag it to the desired position.
Describe how to enter a series of months using the Fill Handle.
Click into the starting cell, enter the first month, then drag the Fill Handle down to auto-fill subsequent months.
Describe how to insert and customize a chart in Excel.
Navigate to the Insert tab, select a chart type, and use the customization tools available.
What is the web address to access Microsoft Excel online?
excel.new
How would you write a SUM function to sum a range of cells?
Use the formula `=SUM(B2:B4)`.
How are cells within a worksheet organized in Excel?
Cells are organized in columns (letters) and rows (numbers).
How do you format numbers with a thousands separator in Excel?
Highlight the cells, go to the Home tab, and click the thousands separator icon.
Explain the process for sorting and filtering data in Excel.
Use dropdowns next to headers to sort data, and apply filters to focus on specific periods.
How can you share an Excel workbook with team members?
Click the Share button in the top right corner and share via OneDrive.
What are Pivot Tables and how do you create one?
Pivot Tables summarize and analyze data; create one from the Insert tab by selecting a data range.
How do you create a table in Excel?
Click on Insert > Table, and ensure the headers option is enabled.
What is Conditional Formatting used for in Excel?
To visualize trends in data, such as using color scales to indicate performance.
How can you quickly zoom in or out on an Excel worksheet?
Use the zoom controls in the bottom right or CTRL + Mouse Wheel.
Previous
Next