Mastering Docs and Sheets Skills

What is the first step to create a new document in Google Docs?

• Print the document before creating it.

• Open Google Docs in your web browser.

• Download a template from Google Drive.

• Share the document with others first.

How can you change the font size of a selected text in a document?

• Increase the font size by pressing Ctrl + Z.

• Select the text and press the 'Delete' key to change the font size.

• Highlight the text and select a new font size from the toolbar.

• Change the font size by right-clicking the text and selecting 'Edit'.

What is the method to insert an image from your computer into a Google Docs document?

• Drag and drop the image directly into the document

• Right-click on the document and select 'Add Image'

• Click 'File' > 'Insert Image' > 'From Drive'

• Click 'Insert' > 'Image' > 'Upload from computer'.

How do you wrap text around an image in Google Docs?

• Click on 'File' and select 'Download as PDF'.

• Select the image, go to 'Image options', and choose 'Wrap text'.

• Select the image, then delete it.

• Right-click the image and choose 'Insert link'.

What feature allows multiple users to edit a document simultaneously in Google Docs?

• Single-user access

• Real-time collaboration

• Document version history

• Offline editing

How can you add comments to a specific part of a document in Google Docs?

• Use the keyboard shortcut Ctrl + C to copy the text.

• Highlight the text, click 'Add comment', type your comment, and click 'Comment'.

• Click 'File' and choose 'Add comment' from the menu.

• Right-click the text and select 'Insert comment'.

What formula would you use to calculate the sum of a range of cells in Google Sheets?

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1:A10)

• =SUMIF(A1:A10)

How can you sort data in Google Sheets from highest to lowest?

• Right-click the range and select 'Sort by column A'.

• Select the range, click 'Data', then 'Sort range', and choose 'Z → A'.

• Select the range, click 'Data', then 'Sort range', and choose 'A → Z'.

• Use the filter option to sort data from lowest to highest.

What is the function to filter data based on specific criteria in Google Sheets?

• AVERAGE

• SORT

• SUM

• FILTER

How do you create a chart to visualize data in Google Sheets?

• Select data, go to Insert > Chart, customize in the chart editor, and insert the chart.

• Highlight data, click on Format > Chart, and print the chart.

• Select data, go to File > New > Chart, and save the file.

• Choose data, navigate to Data > Create Chart, and share the chart.