41) Which of the following shows the correct sequence of steps for formatting currency values in Microsoft Excel?
A) Home → Number → Currency
B) Data → Number → Currency
C) Home → Editing → Currency
D) Data → Editing → Currency
42) Microsoft Access queries can be imported into Microsoft Excel.
43) Importing data from Microsoft Access to Microsoft Excel is easily achieved by clicking the Data tab and directing Excel to get the external data from Access.
44) A ________, which is a subset of the cells in a worksheet that has a unique name, enables data to be transferred from Microsoft Excel to Microsoft Access.
A) specified label
B) consolidation table
C) named range
D) calculated column
45) Which of the following procedures must be used to create a named range for data in Microsoft Excel?
A) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name
B) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name
C) highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name
D) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name
46) A user can produce two different reports from a single set of Microsoft Excel data, by importing this data into Microsoft Access and using the Access report generator.
47) A data table is a subset of the cells in a worksheet that has a unique name and is used to transfer data from Microsoft Excel to Microsoft Access.
48) In Microsoft Excel, a single space is used to separate the words in range names.
49) Microsoft Excel cannot be used to perform calculations on data imported from Microsoft Access.
50) Sum and average functions cannot be used in Microsoft Excel on imported data that have been created using group totals in Microsoft Access.