Mastering MS Office and Google Sheets

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

• =ADD(range)

• =TOTAL(range)

• =SUMIF(range)

• =SUM(range)

How do you apply conditional formatting to highlight cells in MS Excel?

• Select cells, Data > Sort > Choose order > Apply changes.

• Select cells, Home > Conditional Formatting > Choose rule > Set conditions and format.

• Select cells, View > Freeze Panes > Adjust layout.

• Right-click cells, Format Cells > Choose style > Set alignment.

Which function would you use to find the average of a set of numbers in Google Sheets?

• COUNT

• MAX

• AVERAGE

• SUM

What is the shortcut to format a cell as currency in MS Excel?

• Alt + H, C, U

• Shift + F2

• Ctrl + Shift + $

• Ctrl + Alt + C

How can you create a drop-down list in a cell using Google Sheets?

• Select a cell, go to Data > Data validation, choose 'List of items', enter items, and click 'Save'.

• Use the 'Format' menu to change cell color.

• Right-click the cell and select 'Insert Comment'.

• Type directly into the cell without any settings.

What formula would you use to count the number of cells that contain numbers in a range in MS Excel?

• =SUM(range)

• =AVERAGE(range)

• =MAX(range)

• =COUNT(range)

How do you change the text color of a cell based on its value in Google Sheets?

• Use Conditional Formatting to set text color based on cell value.

• Use a formula to calculate the text color.

• Change the background color of the cell instead.

• Manually change the text color for each cell.

How do you format a cell to display a date in a specific format in MS Excel?

• Select the cell, then press 'Ctrl + D' to format as date.

• Right-click the cell, select 'Format Cells', choose 'Date', and select the desired format.

• Use the 'Insert' menu to add a date format.

• Double-click the cell and type the date format directly.