Excel Basics for Grade 2

How do you enter data into a cell in Excel?

• Click on the desired cell, then type the data directly into the cell.

• Telepathically transmit the data into the cell

• Send a carrier pigeon with the data written on a note

• Shout the data out loud

What is the shortcut key to format cells in Excel?

• Ctrl + 1

• Alt + 1

• Shift + 1

• Ctrl + F

What is the function of the SUM formula in Excel?

• Subtracts the values in a range of cells.

• Divides the values in a range of cells.

• Multiplies the values in a range of cells.

• Adds up the values in a range of cells.

How can you change the font style of a cell in Excel?

• Use the 'Insert' tab to change font style

• Select the cell or range of cells, go to the 'Home' tab, choose font style from the 'Font' group

• Right-click on the cell and select font style

• Press Ctrl + F to change font style

What does the 'AutoFill' feature in Excel do?

• It changes the font style of selected cells

• It deletes all data in the worksheet

• It creates a new worksheet

• It quickly fills cells with a series of data by dragging the fill handle over the desired range.

Explain the difference between 'Merge & Center' and 'Wrap Text' in Excel.

• Merge & Center adjusts row height, while Wrap Text combines cells.

• Merge & Center wraps text, while Wrap Text centers text.

• Merge & Center combines cells, while Wrap Text adjusts row height.

• Merge & Center changes font size, while Wrap Text changes font style.

What is the purpose of the 'Bold' and 'Italic' options in Excel?

• The purpose of 'Bold' and 'Italic' options in Excel is to calculate formulas automatically

• The purpose of the 'Bold' and 'Italic' options in Excel is to emphasize or highlight specific text within a cell.

• The purpose of 'Bold' and 'Italic' options in Excel is to change the font color

• The purpose of 'Bold' and 'Italic' options in Excel is to insert new rows in the spreadsheet

How do you create a simple addition formula in Excel?

• Type =A1+B1 in the desired cell to add the values in cells A1 and B1.

• Enter =SUM(A1, B1) in the desired cell to add the values in cells A1 and B1.

• Type =A1*B1 in the desired cell to multiply the values in cells A1 and B1.

• Use =A1+B1 in a blank cell to subtract the values in cells A1 and B1.

What is the significance of the 'Currency' format in Excel?

• The 'Currency' format in Excel is significant for displaying numerical values as currency with symbols, decimal places, and thousand separators.

• The 'Currency' format in Excel is used for creating charts.

• The 'Currency' format in Excel is used for changing font styles.

• The 'Currency' format in Excel is only applicable to text data.

How can you copy formulas to multiple cells in Excel?

• Right-click and select 'Copy' then 'Paste' in the desired cells

• Drag the fill handle across the range of cells where you want to copy the formula.

• Use the 'Copy' and 'Paste' buttons in the toolbar

• Manually type the formula in each cell