Microsoft Word and Excel Quizzizz 1/10-1/11

What is the shortcut key to make text bold in Microsoft Word?

• Ctrl + A

• Alt + B

• Shift + B

• Ctrl + B

How can you change the line spacing in Microsoft Word?

• By pressing Ctrl + B

• By going to the 'Home' tab and selecting the 'Line and Paragraph Spacing' button

• By going to the 'View' tab and selecting 'Zoom'

• By clicking on the 'Insert' tab and selecting 'Page Break'

Explain the steps to insert a chart in Excel.

• Select the data, go to 'Insert' tab, click on 'Chart', and select the type of chart

• Use the 'Format' tab to create a chart

• Copy and paste the data into the chart

• Go to 'File' tab, click on 'New', and select 'Chart'

What are the different types of charts available in Excel?

• Red, Blue, Green, Yellow, Orange, Purple, Pink, Brown, Black, White

• Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Radar, Combo

• Apple, Banana, Orange, Mango, Pineapple, Watermelon, Grapes, Strawberry, Kiwi, Pear

• A, B, C, D, E, F, G, H, I, J

What is the function of the SUM formula in Excel?

• To add up the values in a range of cells.

• To find the average of the values in a range of cells.

• To multiply the values in a range of cells.

• To subtract the values in a range of cells.

How do you use the VLOOKUP formula in Excel?

• Enter the formula in a cell, specifying the lookup value, table array, column index number, and range lookup.

• VLOOKUP can only be used for numerical data, not text.

• Enter the formula in a cell, specifying the lookup value, table array, row index number, and range lookup.

• Use the VLOOKUP function to create a new table in Excel.

Explain the steps to create a pie chart in Excel.

• Select the data you want to include in the chart > Go to the Insert tab > Click on the Pie Chart option > Choose the desired pie chart style

• Select the data you want to include in the chart > Go to the View tab > Click on the Pie Chart option > Choose the desired pie chart style

• Go to the Data tab > Click on the Pie Chart option > Choose the desired pie chart style

• Select the data you want to include in the chart > Go to the Home tab > Click on the Pie Chart option > Choose the desired pie chart style