Questions from Microsoft Excel and Access for Accounting

Q: Refer to the front matter at the beginning of this text and

Refer to the front matter at the beginning of this text and then identify some new features in the 2016 version of Excel.

Q: Why would you use conditional formatting?

Why would you use conditional formatting?

Q: Explain the difference between a worksheet and a workbook.

Explain the difference between a worksheet and a workbook.

Q: Add, change, and delete records to the What SUP database

Add, change, and delete records to the What SUP database (use the Ch10-02 file) a. Add the following record to the Buyers table: BuyerID 605, Farley, 555-7187. b. Add G as a CategoryID with a Category...

Q: Add pictures to the What SUP database (use the Ch10-

Add pictures to the What SUP database (use the Ch10-02 file; do not use the file you just updated in Assignment 1) a. Add pictures for the remaining products in the Product table using the picture fil...

Q: Change the structure of the What SUP database (Use the Ch10

Change the structure of the What SUP database (Use the Ch10-02 file; do not use the file you just updated in Assignment 1 or 2.) a. Add the following product to the Product table. Product-ID: 117; Pro...

Q: a. Create and print a select query that lists the buyer

a. Create and print a select query that lists the buyer name, buyer phone number, and product name of product number 234. (Hint: The product number should not appear on your printed query if you answe...

Q: a. Create and print a select query that lists the product

a. Create and print a select query that lists the product name, quantity, supplier contact name, and supplier phone number for any Inflatable SUPs. Save this query as Ch 11 Assignment 2a before you pr...

Q: a. Edit Query 1 by adding the field Postal-Code

a. Edit Query 1 by adding the field Postal-Code from the Supplier Table and deleting the field Stateor-Province. Save this query as Ch 11 Assignment 3a before you print it. b. Edit Query 2 to include...

Q: Create a Financial Analysis for What SUP, Inc. as of

Create a Financial Analysis for What SUP, Inc. as of December 31, 2019. You are to create this financial analysis as of December 31, 2019, from the information found on file ch3-02.xls. This file cont...