Back to notes
What key allows you to move between cells when entering data in MS Excel?
Press to flip
Use the 'Tab' key.
Why is it important to understand different data types in MS Excel?
To use formulas and perform accurate calculations.
Name two common formulas used in MS Excel for calculations.
SUM and AVERAGE.
How can you move between fields when entering text in MS Word?
Use the 'Tab' key to move between fields.
How do you select data ranges for operations in MS Excel?
Drag to select or use keyboard shortcuts to highlight specific ranges.
Describe the steps to insert a new column in MS Excel.
Right-click on a column header and select 'Insert' to add a new column.
What is a common tab used in both MS Word and Excel for creating new documents?
'File' tab.
What are the different data types you need to understand when using MS Excel?
Text and numbers.
Give an example of when you might use the automatic calculations feature in MS Excel.
When updating a sales report that requires real-time summation and averages.
Which tab in MS Word allows you to adjust margins and other page settings?
The 'Layout' tab.
What are some basic text formatting options available in MS Word?
Bold, italics, and underline.
How do you create a new worksheet in MS Excel?
Click on 'File' → 'New' to open a new Excel worksheet.
How do you align text to the left, right, or center in MS Word?
Go to the 'Home' tab and use the alignment options.
How do you create a new document in MS Word?
Click on 'File' → 'New' to create a new document.
What is a good practice to avoid data loss in MS Word and Excel?
Save your work frequently.
Where would you go to insert tables or images in an MS Word document?
Use the 'Insert' tab.
How can you insert page numbers in an MS Word document?
Go to 'Insert' → 'Page Number'.
How can you import data from different file types in MS Excel or Word?
Use the 'Import' option to bring in data from various file formats.
What feature can you use to create charts for data visualization in MS Excel?
Use the 'Insert Chart' option by selecting the data you want to visualize.
Previous
Next