Asked by Emily Calabrese on Jul 09, 2024
Verified
To total the values in a SalesPrice field in Table Datasheet view,you click the Total cell in the SalesPrice column,click the arrow,and then click _____.
A) Total
B) Sum
C) Count
D) Avg
SalesPrice Field
A specific field in a database designated to hold the sales price of items or services.
Sum
An aggregate function in database and spreadsheet software that calculates the total of a set of numerical values.
- Master the skills of aggregating and determining statistical information in query datasheets and tables.
Verified Answer
KT
Kaitlin TarverJul 14, 2024
Final Answer :
B
Explanation :
The correct option for totaling the values in a field is to click on the Total cell in the column and select the Sum option from the drop-down menu. This will add up all the values in the SalesPrice field. The other options such as Count will give the total number of values in the field, Avg will give the average value of the field, and Total will give the total number of rows in the table.
Learning Objectives
- Master the skills of aggregating and determining statistical information in query datasheets and tables.