Statech

Yousef has a series of spreadsheets that he has created in Microsoft Excel. Which of the following statements are true? Select all that apply.

• Yousef must save his Microsoft Excel spreadsheets as Google Sheets in order to edit them

• Yousef can view Microsoft Excel spreadsheets using Google Sheets

• Yousef can upload Microsoft Excel spreadsheets to Google Drive

On the Rise partner owner Thomas Omar is reviewing a Google Sheet named “On the Rise Monthly Sales Figures.” He’d like to better analyze the data by filtering the data. What does he need to do?

• Select one or more cells, open the Data menu, hover over Filter views, then select Create a new filter view

• Open the Data menu, select Sort cells, then select Create a filter

• Select the Filter menu, choose a range of cells, then select Create a filter.

Thomas Omar is working on a Google Sheet with sales data from On the Rise stores in the Asia Pacific region. He’d like to see an average sale price. This data is found in cells J3 through J44. Which of the following formulas should he use?

• AVERAGE(J3:J44)

• =AVERAGE(J3-J44)

• =SUM(J3:J44)

• =AVERAGE(J3:J44)

Thomas wants to share a Google Sheets spreadsheet with On the Rise store owner Yousef Amadi. He’d like him to be able to download and print the file but not make any changes. What type of collaborator role should he assign to him?

• Suggester

• Owner

• Viewer

• Editor

Seroja makes some changes in “On the Rise marketing data,” but later decides she’d like to return to the version shared by Kaina Gao. What does she need to do?

• Go to Trash and restore the older version

• Check her email for the older version

• Select File, Version history, then See version history, choose the version from the correct point in time, and then select Restore this version

• Ask her IT person to restore a backup of the Sheet

Thomas is reviewing a Google Sheet named “On the Rise forecast report.” He’d like to leave a comment on cell A22. What does he need to do?

• Select More options, select Add a comment, type his comment, and select Comment

• Place his cursor on cell A22, select Link to comment, type his comment, and select Comment

• Select Share, select Add a comment, type his comment, and select Comment

• Place his cursor on cell A22, select Add a comment, type his comment, and select Comment

What business's name appears first on the list?

• Arc Construction & Electric

• Namaste Solar Electric

• Solarflair Energy

• Air Group

Who among the salespeople had the greatest average August Aircall sales?

• Casiah Jones

• Logan Park

• Christian Howard

• Patricia Kruger

What is the company name?

• Nepal Insurance Company Limited

• Siddhartha Bank Limited

• NIC Asia Bank Limited

• Global IME Bank Limited

What is the credit card name?

• OpenSky® Secured Visa® Credit Card

• PCB Secured Visa®

• Harley-Davidson® Visa® Secured Card

• First National Bank Secured Visa® Card