AppSheet MCQs

AppSheet MCQs

These AppSheet multiple-choice questions and their answers will help you strengthen your grip on the subject of AppSheet. You can prepare for an upcoming exam or job interview with these 30 AppSheet MCQs.
So scroll down and start answering.

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


A.   Tables - Column Structure - Slices

B.   Column Structure - Formatting - Workflow

C.   Data - UX - Settings

D.   Tables - Workflow - Views

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


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

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

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

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

What are App Formulas?


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

B.   Combinations of apps that use references to display rich information

C.   Spreadsheet formulas that also work in the app

D.   A method to create formatting rules for AppSheet apps

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


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

B.   Through its listing in the App Store

C.   By adding their email to the user list

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

What AppSheet concept is defined with this description?


A.   Primary Key

B.   Selection Record

C.   Employee ID

D.   Primary Record

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


A.   Use the Stats charts available in Account > Activity

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

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

D.   Use an API to track app usage

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


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

B.   AppSheet cannot deliver forms-only apps

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

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

What is the difference between ENUM and ENUMLIST?


A.   ENUMLIST allows multiple selection while ENUM allows single choice

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

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

D.   ENUM and ENUMLIST have the same behavior

What are the different update modes for a given table?


A.   Read Only, Add, Delete, Update, All Changes

B.   Read Only and Write Only

C.   Add, Delete, Update

D.   Read, Delete, and Write Only

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


A.   Go to the Data tab and add another table.

B.   AppSheet only shows information from a single table

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

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

Where are signatures and images stored when captured with AppSheet?


A.   In the App Creator's cloud storage for the app

B.   In the cloud drive of the App User

C.   In AppSheet's cloud storage

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

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?


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

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

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

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

Your app has an ENUM type field with three options, and one of them is HOUSE. You want every row that has HOUSE in that field to have a BLUE font color. How do you achieve that?


A.   Create a slice for all rows where that field equals HOUSE, then create a formatting rule that defines the color of the font as BLUE and select all columns to be formatted

B.   Create a new formatting rule that points to the column with the ENUM and define font color as BLUE

C.   Create a new view called HOUSE. AppSheet will automatically show all items with the word HOUSE and select Action as BLUE

D.   Create a Workflow rule to change the font color to BLUE

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


A.   Go to Settings > Content > Image upload resolution

B.   Image resolution is set to the device's default

C.   You can change the resolution in Column Structure > Image Type

D.   Image resolution is standard to the screen resolution

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


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

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

C.   You pick the slice but AppSheet picks the default table

D.   You can only pick slices for new views

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


A.   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

B.   Block the app from working

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

D.   Repace the data in the first column to have unique values

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


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

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

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

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

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


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

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

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

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

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


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

B.   Run the app in a mobile web browser

C.   Deploy the app via admin console

D.   Run the app via virtualized desktop

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


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

B.   Columns mark the width of the views in the app

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

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

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


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

B.   Publish the app in the corresponding app store

C.   The user must request access to the app via When access is granted, the app is installed with the user

D.   Use the app deployment button

How many views can you add in an app?


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

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

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

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

What does a Ref type let you do?


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

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

C.   It lists similar terms in the same dataset

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

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

B.   Delete the spreadsheet or replace it with dummy data

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

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

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?


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

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

C.   AppSheet can only serve one app per spreadsheet

D.   Select the "Sample App" option under Settings

What happens when you make an app a Sample App?


A.   The app becomes publicly available in your App Portfolio at

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

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

D.   You can sell the app in the App Store

In AppSheet, what are Slices?


A.   A subset of the rows and columns of a table

B.   A ranked view of data that matches certain criteria

C.   A method to delete unnecessary data in an app

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

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


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

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

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

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

Where can users load AppSheet apps?


A.   iOS, Android, and modern mobile and desktop browsers

B.   iOS only

C.   Android and desktop browser

D.   Desktop and mobile browser only

What happens when you have a duplicate primary key?


A.   AppSheet will warn of the duplicate value while creating the app

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

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

D.   Appsheet automatically deletes the record

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?


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

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

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

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

How does AppSheet manage mobile deployment?


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

B.   Publishes directly to the App Store

C.   Creates a website that is loaded through a mobile browser

D.   AppSheet apps only open in desktop PCs

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


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

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

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

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

What types of apps can AppSheet build?


A.   Data driven apps from cloud-stored data

B.   Mobile apps from social media profiles

C.   UI driven apps

D.   Games

Where can you use Slices in the app?


A.   Controls (views), Workflow Rules, Formatting

B.   Conditional Branching, Forms, App Security

C.   App Sign-in, Whitelist, Column Structure

D.   Branding, Formatting, Controls, Options

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


A.   ENUM, Ref, and ENUMLIST

B.   Selection, List, Ref, and Text

C.   Drop-Down, Enumeration, and List

D.   Number, Boolean, and List

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


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

B.   Rebuild the spreadsheet to have more recognizable column headers

C.   Create a Map view to capture GPS data

D.   Create an ENUM with the key locations

38: Can the app have icons on the device's home screen?

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

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

C.   Yes - but only in tablets, not smartphones

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

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

A.   Comment

B.   Template

C.   Filter