Mastering Computer Basics

What is the shortcut key for saving a document in Microsoft Word?

• Ctrl + S

• Shift + S

• Ctrl + P

• Alt + S

How can you insert a page break in Microsoft Word?

• Select 'New Page' from the 'File' menu

• Insert a page break by going to the 'Insert' tab and selecting 'Page Break' or by pressing 'Ctrl + Enter'.

• Click on 'Page Layout' and choose 'Break'

• Use the 'Home' tab and click 'Insert Page'

What feature in Microsoft Word allows you to check spelling and grammar?

• Spelling & Grammar feature

• Text Highlighting tool

• Page Layout options

• Thesaurus feature

How do you change the font size in Microsoft Word?

• Use the 'Insert' tab to adjust font size.

• Right-click the text and select 'Change Font Size'.

• Change the font size in the 'View' tab.

• Select the text, go to the 'Home' tab, and adjust the font size in the 'Font' group.

What function in Excel is used to sum a range of cells?

• MAX

• AVERAGE

• COUNT

• SUM

How can you create a chart in Excel?

• Open the 'View' tab and select 'Zoom'

• Click on 'File' and select 'Save As'

• Right-click on the data and choose 'Delete'

• Select data, go to 'Insert' tab, choose chart type, and customize.

What is the purpose of the VLOOKUP function in Excel?

• To create a chart from a data set.

• To search for a value in a table and return a corresponding value from another column.

• To format cells based on their values.

• To calculate the sum of a range of cells.

How do you freeze panes in an Excel worksheet?

• Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.

• Select the cell, go to 'Data' > 'Freeze Panes' > 'Freeze First Column'.

• Select the cell, go to 'Home' > 'Freeze' > 'Freeze Top Row'.

• Right-click the cell and choose 'Freeze Panes' from the context menu.

What is the primary use of PowerPoint?

• Editing photos

• Creating and delivering presentations

• Writing code

• Creating spreadsheets

How can you add a transition effect between slides in PowerPoint?

• Right-click on the slide and choose 'Add Animation'.

• Select the 'Design' tab and change the slide layout.

• Select the 'Transitions' tab, choose a transition effect, and apply it to the desired slides.

• Use the 'Insert' tab to add a video between slides.