MockTest

You are working on a budget spreadsheet in Google Sheets. You have multiple columns of expenses, and you need to calculate the total amount spent in column B and show the result in cell B10. What formula would you use in cell B10?

• =SUM(B2:B10)

• =TOTAL(B2:B10)

• =ADD(B2:B10)

• =SUM(B1:B10)

You want to conditionally format a column in Google Sheets to highlight all cells with values greater than 1000. Which action will achieve this?

• Select the column → Format → Conditional formatting → Set rule for "greater than" 1000.

• Select the column → Data → Conditional formatting → Set rule for "greater than" 1000.

• Select the column → Format → Number → Conditional formatting → Set rule for "greater than" 1000.

• Select the column → Insert → Conditional formatting → Set rule for "greater than" 1000.

You’re creating a presentation and want to insert a transition between slides for a smoother flow. Which option should you choose?

• Insert → Transition

• Slide → Transition

• Format → Transition

• Tools → Transition

You need to make your slides automatically advance every 5 seconds during a presentation. Where can you set this?

• Slide Show → Slide Settings → Auto-advance every 5 seconds

•  File → Publish → Auto-advance every 5 seconds

• Slide → Transition → Auto-advance every 5 seconds

• View → Presentation Mode → Set auto-advance

You are creating a survey using Google Forms. You want to make the "Name" field required. Which setting should you enable for the "Name" question?

• Click the three dots next to the question → Make this question required.

• Click on the "Responses" tab → Enable required.

• Click "Add question" → Set as required.

• Click the gear icon in the top right → Make this question required.

A respondent is having trouble answering a question in your Google Form. You want to make the question multiple-choice, so they can select one answer from the options. What is the correct question type to choose?

• Short answer

• Multiple choice

• Paragraph

• Checkboxes

You are writing a document in Google Docs and want to apply a consistent font style and size across the entire document. Which action should you take?

• Format → Paragraph styles → Apply to all

• Select the text → Tools → Apply style

• Select the text → Format → Text → Choose font and size

• Format → Paragraph styles → Apply style to all

You need to share a Google Docs document with a colleague and allow them to edit it. What should you do?

• Click on the "Share" button → Select "Can view"
  
  

• Click on the "Share" button → Select "Can edit"

• Click on "File" → "Share" → Select "Can comment"

• Click on the "Send" button → Select "Can view"

You want to insert a table of contents at the beginning of your Google Docs document. Which feature should you use?

• Insert → Table of contents

• Tools → Table of contents

• Format → Table of contents

• View → Table of contents

You are collaborating on a Google Doc and want to see all changes made by your colleagues. What feature should you use?

• View → Show comments

• File → Version history → See version history

• Tools → Change tracking

• Edit → Revision history