B.   Column Structure - Formatting - Workflow

C.   Data - UX - Settings

D.   Tables - Workflow - Views

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

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

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

B.   Selection Record

C.   Employee ID

D.   Primary Record

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

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

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

B.   Read Only and Write Only

C.   Add, Delete, Update

D.   Read, Delete, and Write Only

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

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

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

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

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

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

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

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

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

B.   Run the app in a mobile web browser

C.   Deploy the app via admin console

D.   Run the app via virtualized desktop

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

B.   Publish the app in the corresponding app store

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

D.   Use the app deployment button

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

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

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

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

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

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

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

B.   iOS only

C.   Android and desktop browser

D.   Desktop and mobile browser only

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

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

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

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

B.   Mobile apps from social media profiles

C.   UI driven apps

D.   Games

B.   Conditional Branching, Forms, App Security

C.   App Sign-in, Whitelist, Column Structure

D.   Branding, Formatting, Controls, Options

B.   Selection, List, Ref, and Text

C.   Drop-Down, Enumeration, and List

D.   Number, Boolean, and List

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

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

A.   Comment

B.   Template