WorksheetsCAT Grade 11 Module 11 SL Quiz
Total questions: 8
Worksheet time: 5mins
What are the correct steps for linking an Excel chart to another application?
1. Copy the chart
2. Paste the chart in the new application
3. Insert a Hyperlink
1. Select paste special in the other application
2. Select link
3. Browse for the chart you want to link
1. Copy the chart
2. Select Paste Special in the new application
3. Select link
4. Choose Excel Chart Object
Fields refer to the Access table’s _____________.
cells
rows
data
columns
Queries are used when ______________ need to be added to one or more fields.
edits
conditions
records
choices
A (a) key is a field with values that uniquely identify each row in a table.
If you want to add a new field to the table you must navigate to (a) view.
If I type: “Is Null” as my condition in a query I am looking for the cells that are ______________.
zeros
fields
empty
names
Which data type would you choose if you wanted to create a formula for determining a new value, such as total cost?
Currency
Calculated
Expression
OLE Object
If you only want to show the names starting with a T from a table which condition will you use in a query?
>=T
T*
T
*T*
