> > AppSheet MCQs > Basic AppSheet MCQs

Basic AppSheet MCQ

1. A ____ is used to display only certain records within a table that meet the specified criteria.

Comment

Template

Filter

Answer

Correct Answer: Filter

Note: This Question is unanswered, help us to find answer for this one

2. Can the app have icons on the device's home screen?

Yes - the icon is a shortcut to AppSheet which then loads the app

No - the app can have a logo but cannot be added to the home screen

Yes - but only in tablets, not smartphones

No - you can only load apps from AppSheet's App Gallery

Answer

Correct Answer: Yes - the icon is a shortcut to AppSheet which then loads the app

Note: This Question is unanswered, help us to find answer for this one

3.

You want to capture GPS locations in one column but AppSheet didn't recognize the column for that purpose. You then:

Go to Data > Column Structure and change the field type to LatLong

Rebuild the spreadsheet to have more recognizable column headers

Create a Map view to capture GPS data

Create an ENUM with the key locations

Answer

Correct Answer: Go to Data > Column Structure and change the field type to LatLong

Note: This Question is unanswered, help us to find answer for this one

4.

Which field types let you produce a drop-down list?

ENUM, Ref, and ENUMLIST

Selection, List, Ref, and Text

Drop-Down, Enumeration, and List

Number, Boolean, and List

Answer

Correct Answer: ENUM, Ref, and ENUMLIST

Note: This Question is unanswered, help us to find answer for this one

5.

Where can you use Slices in the app?

Controls (views), Workflow Rules, Formatting

Conditional Branching, Forms, App Security

App Sign-in, Whitelist, Column Structure

Branding, Formatting, Controls, Options

Answer

Correct Answer: Controls (views), Workflow Rules, Formatting

Note: This Question is unanswered, help us to find answer for this one

6.

What types of apps can AppSheet build?

Data driven apps from cloud-stored data

Mobile apps from social media profiles

UI driven apps

Games

Answer

Correct Answer: Data driven apps from cloud-stored data

Note: This Question is unanswered, help us to find answer for this one

7.

What happens if you change the order of the columns in the back-end spreadsheet of an AppSheet app?

You must refresh the column structure and review any changes to the app derived from that action

AppSheet will generate a copy of the app from the new column structure

You must request that every app user sync the app and tell you if they are seeing any errors

You must un-publish the app and then re-publish the new version

Answer

Correct Answer: You must refresh the column structure and review any changes to the app derived from that action

Note: This Question is unanswered, help us to find answer for this one

8.

How does AppSheet manage mobile deployment?

Light deployment model with a "container" app (AppSheet) that serves the app created by the user

Publishes directly to the App Store

Creates a website that is loaded through a mobile browser

AppSheet apps only open in desktop PCs

Answer

Correct Answer: Light deployment model with a "container" app (AppSheet) that serves the app created by the user

Note: This Question is unanswered, help us to find answer for this one

9.

You have a list of locations in a column that AppSheet didn't automatically recognize as an address type. How do you get those locations in a map?

Go to Column Structure and change the column type to Address. Then add a map view that points to the column

Add a map view and select the column you want to show in the map

Create a computed key that includes the target column and a column with GPS coordinates

Re-write the locations with GPS coordinates in [ ] brackets

Answer

Correct Answer: Go to Column Structure and change the column type to Address. Then add a map view that points to the column

Note: This Question is unanswered, help us to find answer for this one

10.

What happens when you have a duplicate primary key?

AppSheet will warn of the duplicate value while creating the app

When you update one of the items with the duplicate primary key, all information will be duplicated

The app will crash and not function outside of the app emulator

Appsheet automatically deletes the record

Answer

Correct Answer: AppSheet will warn of the duplicate value while creating the app

Note: This Question is unanswered, help us to find answer for this one

11.

Where can users load AppSheet apps?

iOS, Android, and modern mobile and desktop browsers

iOS only

Android and desktop browser

Desktop and mobile browser only

Answer

Correct Answer: iOS, Android, and modern mobile and desktop browsers

Note: This Question is unanswered, help us to find answer for this one

12.

Which of the following is NOT a message type (Warnings, Errors, Info) in the AppSheet editor?

ORANGE: There is an error with the data definition which must be refreshed

YELLOW: The app is still functional but there may be unexpected app behavior from usage

RED: The app cannot function due to a critical error that must be repaired before continuing work with the app

BLUE: The app is functional but AppSheet did a change to the app behavior to preserve stability of the app and data

Answer

Correct Answer: ORANGE: There is an error with the data definition which must be refreshed

Note: This Question is unanswered, help us to find answer for this one

13.

In AppSheet, what are Slices?

A subset of the rows and columns of a table

A ranked view of data that matches certain criteria

A method to delete unnecessary data in an app

Slices are ways to divide the top and bottom of an app view

Answer

Correct Answer: A subset of the rows and columns of a table

Note: This Question is unanswered, help us to find answer for this one

14.

What happens when you make an app a Sample App?

The app becomes publicly available in your App Portfolio at www.appsheet.com

The app changes its status to Sample and becomes part of AppSheet's sample gallery

The app begins to accept new data entries from anyone with access to the app

You can sell the app in the App Store

Answer

Correct Answer: The app becomes publicly available in your App Portfolio at www.appsheet.com

Note: This Question is unanswered, help us to find answer for this one

15.

You want to create two apps that look at the same data, but have minor differences in UX. What's a quick way to achieve it?

Create an app and then copy it while using the same data as the original, then tweak the second app

Start the second app from scratch by loading the same spreadsheet to a new app

AppSheet can only serve one app per spreadsheet

Select the "Sample App" option under Settings

Answer

Correct Answer: Create an app and then copy it while using the same data as the original, then tweak the second app

Note: This Question is unanswered, help us to find answer for this one

16.

What are the two recommended options to "un-deploy" an app?

Delete the app or remove a user email from the whitelist to lock the user out from the app

Delete the spreadsheet or replace it with dummy data

Remove all the views in the app or send "cease use" email to the users

Contact AppSheet Support to request an "un-deployment" service

Answer

Correct Answer: Delete the app or remove a user email from the whitelist to lock the user out from the app

Note: This Question is unanswered, help us to find answer for this one

17.

What does a Ref type let you do?

It creates a reference between the field and the primary key in another table, generating a drop-down when adding data

It lets you add a search term for reference in a field

It lists similar terms in the same dataset

It references the number of tables, rows, and columns of the spreadsheet, showing the file's metadata

Answer

Correct Answer: It creates a reference between the field and the primary key in another table, generating a drop-down when adding data

Note: This Question is unanswered, help us to find answer for this one

18.

How many views can you add in an app?

Up to 3 views in the bottom bar, unlimited in the "hamburger" menu

3 views in the bottom bar and up to five in the "hamburger" menu

Up to 3 views combined in the bottom bar and "hamburger" menu

Up to 10 combined views between the "hamburger" menu and bottom bar

Answer

Correct Answer: Up to 3 views in the bottom bar, unlimited in the "hamburger" menu

Note: This Question is unanswered, help us to find answer for this one

19.

Once your AppSheet App is ready, how do you get it to the intended app users?

Send email invitations to the app users via the Share/Install button

Publish the app in the corresponding app store

The user must request access to the app via www.appsheet.com/appname. When access is granted, the app is installed with the user

Use the app deployment button

Answer

Correct Answer: Send email invitations to the app users via the Share/Install button

Note: This Question is unanswered, help us to find answer for this one

20.

Which statement best describes the role of columns in AppSheet apps?

Columns define the type of data which then corresponds to specific mobile app behavior

Columns mark the width of the views in the app

The number of columns define the number of views in the app

Columns define whether the data is ready for tablet or smartphone use

Answer

Correct Answer: Columns define the type of data which then corresponds to specific mobile app behavior

Note: This Question is unanswered, help us to find answer for this one

21.

What's the optimal way for AppSheet apps to run on a mobile device?

First install AppSheet from the App Store, then install your AppSheet app

Run the app in a mobile web browser

Deploy the app via admin console

Run the app via virtualized desktop

Answer

Correct Answer: First install AppSheet from the App Store, then install your AppSheet app

Note: This Question is unanswered, help us to find answer for this one

22.

When the app user is adding data, how are those changes recorded in the back-end spreadsheet by default?

As the app creator. The spreadsheet and cloud storage use the credentials of the app creator to update the file

As the app user. The spreadsheet and cloud storage use the credentials of the app user to update the file

As AppSheet. AppSheet uses its own credentials to update the spreadsheet file

A copy of the spreadsheet is automatically saved in the app user's Google Drive

Answer

Correct Answer: As the app creator. The spreadsheet and cloud storage use the credentials of the app creator to update the file

Note: This Question is unanswered, help us to find answer for this one

23.

What happens if I refresh/regenerate the column structure of the app due to major spreadsheet/app changes after I have deployed it?

App users need to sync the app to get the latest version before submitting new data

App users need to go to the app editor and regenerate the app

App users need to download a copy of the spreadsheet to compare the columns against the app

Because the app hasn't changed, then the app will continue to work as intended

Answer

Correct Answer: App users need to sync the app to get the latest version before submitting new data

Note: This Question is unanswered, help us to find answer for this one

24.

If there is no single column with unique data in the spreadsheet, what would AppSheet attempt next?

Create a computed key from a composite set of existing columns. If no unique values are available from the composite, it will assign the row number as the primary key

Block the app from working

Create an additional column with random values. All other columns in the table will shift one place to the right

Repace the data in the first column to have unique values

Answer

Correct Answer: Create a computed key from a composite set of existing columns. If no unique values are available from the composite, it will assign the row number as the primary key

Note: This Question is unanswered, help us to find answer for this one

25.

When you add a view (control), what information is displayed in the app?

You can select the target information. It can be a table or a slice

AppSheet always selects the target information based on the view's name

You pick the slice but AppSheet picks the default table

You can only pick slices for new views

Answer

Correct Answer: You can select the target information. It can be a table or a slice

Note: This Question is unanswered, help us to find answer for this one

26.

You app captures images. How can you change the resolution of the images uploaded through the app?

Go to Settings > Content > Image upload resolution

Image resolution is set to the device's default

You can change the resolution in Column Structure > Image Type

Image resolution is standard to the screen resolution

Answer

Correct Answer: Go to Settings > Content > Image upload resolution

Note: This Question is unanswered, help us to find answer for this one

27.

You only want a specific group of people to see the data in the app and not be able to share it. What do you do?

Require sign-in to the app and manage the user whitelist

Share the spreadsheet with only a small group of people and then distribute the link to the app broadly

Make the tables read-only and create a slice with a field: Matches the user email

Send the link to the group of people and ask them not to share

Answer

Correct Answer: Require sign-in to the app and manage the user whitelist

Note: This Question is unanswered, help us to find answer for this one

28.

Where are signatures and images stored when captured with AppSheet?

In the App Creator's cloud storage for the app

In the cloud drive of the App User

In AppSheet's cloud storage

Both in the App Creator's and App User's respective cloud drives

Answer

Correct Answer: In the App Creator's cloud storage for the app

Note: This Question is unanswered, help us to find answer for this one

29.

You want to display information from two different tables in the same app. What do you do?

Go to the Data tab and add another table.

AppSheet only shows information from a single table

Merge spreadsheets, create a helper column, and use a slice to show two views of the same data

Put the two tables side-by-side in the first tab of the spreadsheet. AppSheet will recognize the tables and produce an app accordingly

Answer

Correct Answer: Go to the Data tab and add another table.

Note: This Question is unanswered, help us to find answer for this one

30.

What are the different update modes for a given table?

Read Only, Add, Delete, Update, All Changes

Read Only and Write Only

Add, Delete, Update

Read, Delete, and Write Only

Answer

Correct Answer: Read Only, Add, Delete, Update, All Changes

Note: This Question is unanswered, help us to find answer for this one

31.

What is the difference between ENUM and ENUMLIST?

ENUMLIST allows multiple selection while ENUM allows single choice

ENUMLIST allows for "Other" values while ENUM is a fixed list

ENUM allows only up to 5 items while ENUMLIST shows more than 5 items

ENUM and ENUMLIST have the same behavior

Answer

Correct Answer: ENUMLIST allows multiple selection while ENUM allows single choice

Note: This Question is unanswered, help us to find answer for this one

32.

You want your app to only capture data through a form without showing results of the forms. Which of the following is correct?

Make the table you plan to use ADDS ONLY, then create a single view in the app that is of Form Type

AppSheet cannot deliver forms-only apps

Define a list view as ALL CHANGES, then remove any unnecessary views

Define a list view as ADDS AND UPDATES and include a Submit view to the app

Answer

Correct Answer: Make the table you plan to use ADDS ONLY, then create a single view in the app that is of Form Type

Note: This Question is unanswered, help us to find answer for this one

33.

Once the app is deployed, how do you know if it's being used?

Use the Stats charts available in Account > Activity

Send a small survey to your app users and ask them if they are using the app

Create a chart in the app that tracks the number of times the app is loaded every day

Use an API to track app usage

Answer

Correct Answer: Use the Stats charts available in Account > Activity

Note: This Question is unanswered, help us to find answer for this one

34.

What AppSheet concept is defined with this description?

Primary Key

Selection Record

Employee ID

Primary Record

Answer

Correct Answer: Primary Key

Note: This Question is unanswered, help us to find answer for this one

35.

Once the app is ready for deployment, how do you inform people the app is available?

By sending an invitation email from the Share/Install button or user whitelist

Through its listing in the App Store

By adding their email to the user list

By sending an email to the users directly and asking them to download AppSheet

Answer

Correct Answer: By sending an invitation email from the Share/Install button or user whitelist

Note: This Question is unanswered, help us to find answer for this one

36.

What are App Formulas?

A mechanism to define values that are computed dynamically in the mobile app

Combinations of apps that use references to display rich information

Spreadsheet formulas that also work in the app

A method to create formatting rules for AppSheet apps

Answer

Correct Answer: A mechanism to define values that are computed dynamically in the mobile app

Note: This Question is unanswered, help us to find answer for this one

37.

You want to receive an email notification every time a new entry has been made through the app. What do you do?

Add a Workflow rule in the Settings > Workflow tab to send you an email for data ADDS

Request that each app user send you an email when they enter information

Create a script/macro that automatically sends an email when a new row is added

Create an automated email to remind you to check the spreadsheet every 15 minutes to find new data

Answer

Correct Answer: Add a Workflow rule in the Settings > Workflow tab to send you an email for data ADDS

Note: This Question is unanswered, help us to find answer for this one

38.

What sub-sections are available under the Data tab in the Advanced Editor?

Tables - Column Structure - Slices

Column Structure - Formatting - Workflow

Data - UX - Settings

Tables - Workflow - Views

Answer

Correct Answer: Tables - Column Structure - Slices

Note: This Question is unanswered, help us to find answer for this one

AppSheet MCQs | Topic-wise

MCQ on Basic AppSheet

General AppSheet MCQs

AppSheet Subjects

More Resources

AppSheet MCQ

AppSheet Skill Assessment

AppSheet PDF

Related MCQs

ASP.NET MCQs

ASP.NET with SQL Server MCQs

Assembla MCQs

Assembly language MCQs

AWS Lambda MCQs

Basic AppSheet MCQ

1. A ____ is used to display only certain records within a table that meet the specified criteria.

2. Can the app have icons on the device's home screen?

3. You want to capture GPS locations in one column but AppSheet didn't recognize the column for that purpose. You then:

4. Which field types let you produce a drop-down list?

5. Where can you use Slices in the app?

6. What types of apps can AppSheet build?

7. What happens if you change the order of the columns in the back-end spreadsheet of an AppSheet app?

8. How does AppSheet manage mobile deployment?

9. You have a list of locations in a column that AppSheet didn't automatically recognize as an address type. How do you get those locations in a map?

10. What happens when you have a duplicate primary key?

11. Where can users load AppSheet apps?

12. Which of the following is NOT a message type (Warnings, Errors, Info) in the AppSheet editor?

13. In AppSheet, what are Slices?

14. What happens when you make an app a Sample App?

15. You want to create two apps that look at the same data, but have minor differences in UX. What's a quick way to achieve it?

16. What are the two recommended options to "un-deploy" an app?

17. What does a Ref type let you do?

18. How many views can you add in an app?

19. Once your AppSheet App is ready, how do you get it to the intended app users?

20. Which statement best describes the role of columns in AppSheet apps?

21. What's the optimal way for AppSheet apps to run on a mobile device?

22. When the app user is adding data, how are those changes recorded in the back-end spreadsheet by default?

23. What happens if I refresh/regenerate the column structure of the app due to major spreadsheet/app changes after I have deployed it?

24. If there is no single column with unique data in the spreadsheet, what would AppSheet attempt next?

25. When you add a view (control), what information is displayed in the app?

26. You app captures images. How can you change the resolution of the images uploaded through the app?

27. You only want a specific group of people to see the data in the app and not be able to share it. What do you do?

28. Where are signatures and images stored when captured with AppSheet?

29. You want to display information from two different tables in the same app. What do you do?

30. What are the different update modes for a given table?

31. What is the difference between ENUM and ENUMLIST?

32. You want your app to only capture data through a form without showing results of the forms. Which of the following is correct?

33. Once the app is deployed, how do you know if it's being used?

34. What AppSheet concept is defined with this description?

35. Once the app is ready for deployment, how do you inform people the app is available?

36. What are App Formulas?

37. You want to receive an email notification every time a new entry has been made through the app. What do you do?

38. What sub-sections are available under the Data tab in the Advanced Editor?

3.

You want to capture GPS locations in one column but AppSheet didn't recognize the column for that purpose. You then:

4.

Which field types let you produce a drop-down list?

5.

Where can you use Slices in the app?

6.

What types of apps can AppSheet build?

7.

What happens if you change the order of the columns in the back-end spreadsheet of an AppSheet app?

8.

How does AppSheet manage mobile deployment?

9.

You have a list of locations in a column that AppSheet didn't automatically recognize as an address type. How do you get those locations in a map?

10.

What happens when you have a duplicate primary key?

11.

Where can users load AppSheet apps?

12.

Which of the following is NOT a message type (Warnings, Errors, Info) in the AppSheet editor?

13.

In AppSheet, what are Slices?

14.

What happens when you make an app a Sample App?

15.

You want to create two apps that look at the same data, but have minor differences in UX. What's a quick way to achieve it?

16.

What are the two recommended options to "un-deploy" an app?

17.

What does a Ref type let you do?

18.

How many views can you add in an app?

19.

Once your AppSheet App is ready, how do you get it to the intended app users?

20.

Which statement best describes the role of columns in AppSheet apps?

21.

What's the optimal way for AppSheet apps to run on a mobile device?

22.

When the app user is adding data, how are those changes recorded in the back-end spreadsheet by default?

23.

What happens if I refresh/regenerate the column structure of the app due to major spreadsheet/app changes after I have deployed it?

24.

If there is no single column with unique data in the spreadsheet, what would AppSheet attempt next?

25.

When you add a view (control), what information is displayed in the app?

26.

You app captures images. How can you change the resolution of the images uploaded through the app?

27.

You only want a specific group of people to see the data in the app and not be able to share it. What do you do?

28.

Where are signatures and images stored when captured with AppSheet?

29.

You want to display information from two different tables in the same app. What do you do?

30.

What are the different update modes for a given table?

31.

What is the difference between ENUM and ENUMLIST?

32.

You want your app to only capture data through a form without showing results of the forms. Which of the following is correct?

33.

Once the app is deployed, how do you know if it's being used?

34.

What AppSheet concept is defined with this description?

35.

Once the app is ready for deployment, how do you inform people the app is available?

36.

What are App Formulas?

37.

You want to receive an email notification every time a new entry has been made through the app. What do you do?

38.

What sub-sections are available under the Data tab in the Advanced Editor?