Fun with Microsoft Tools

What is Microsoft Word used for?

• Designing graphics

• Creating spreadsheets

• Editing videos

• Microsoft Word is used for creating and editing text documents.

Answer explanation

Microsoft Word is primarily designed for creating and editing text documents, making it the correct choice. The other options, such as designing graphics, creating spreadsheets, and editing videos, are not its main functions.

How do you open a new document in Word?

• Click 'Edit', then 'New Document'

• Go to 'View' and choose 'New Page'

• Click 'File', then 'New', and select 'Blank Document' or use Ctrl + N.

• Press Alt + F, then select 'Create'

Answer explanation

To open a new document in Word, click 'File', then 'New', and select 'Blank Document' or simply use the shortcut Ctrl + N. This is the standard method for creating a new document.

What is the shortcut for saving a document in Word?

• Ctrl + S

• Ctrl + P

• Shift + S

• Alt + S

Answer explanation

The shortcut for saving a document in Word is Ctrl + S. This command quickly saves your work, making it essential for document management. The other options do not perform the save function.

What does Excel help you do with numbers?

• Excel is used for writing text documents.

• Excel helps you create presentations with numbers.

• Excel allows you to draw shapes with numbers.

• Excel helps you perform calculations and analyze data with numbers.

Answer explanation

Excel is primarily designed for numerical tasks, enabling users to perform calculations and analyze data effectively. The correct choice highlights this core functionality, unlike the other options which misrepresent Excel's purpose.

What is a function in Excel?

• A function in Excel is a tool for creating pivot tables.

• A function in Excel is a predefined formula that performs calculations or operations on data.

• A function in Excel is a way to format text.

• A function in Excel is a type of chart.

Answer explanation

A function in Excel is a predefined formula that performs calculations or operations on data, making it essential for data analysis and manipulation. The other options describe different features of Excel.

How do you add two numbers in Excel?

• Multiply the numbers using the '*' operator.

• Use the CONCATENATE function to add numbers.

• Use the SUM function or the '+' operator in a cell.

• Use the AVERAGE function to combine numbers.

Answer explanation

To add two numbers in Excel, you can use the SUM function or simply use the '+' operator in a cell. The other options either perform different operations or are not suitable for addition.

What symbol do you use to start a formula in Excel?

• +

• -

• *

• =

Answer explanation

In Excel, formulas always start with the equal sign '='. This indicates to Excel that what follows is a formula to be calculated, making '=' the correct choice among the options provided.

What is the purpose of the SUM function in Excel?

• To calculate the average of numbers.

• To add numbers together.

• To count the number of cells in a range.

• To find the maximum value in a range.

Answer explanation

The SUM function in Excel is specifically designed to add numbers together. It allows users to quickly calculate the total of a range of cells, making it essential for numerical data analysis.

How can you change the font in Word?

• Use the 'Insert' tab to modify font settings

• Change font by right-clicking and selecting 'Change Font'

• Access font options through the 'View' tab

• Select text, go to 'Home' tab, choose font from 'Font' group.

Answer explanation

To change the font in Word, select the text you want to modify, go to the 'Home' tab, and choose the desired font from the 'Font' group. This is the standard method for font changes in Word.

What is a cell in Excel?

• A cell in Excel is a type of formula.

• A cell in Excel is a basic unit of a spreadsheet where data is entered.

• A cell in Excel is a type of chart.

• A cell in Excel is a graphical element.

Answer explanation

A cell in Excel is the fundamental building block of a spreadsheet, where users can input data, formulas, or functions. This makes the second choice correct, as it accurately describes the purpose of a cell.