Home / Questions / Which of the following shows the correct sequence of steps for formatting currency values

Which of the following shows the correct sequence of steps for formatting currency values

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.

Dec 23 2019 Read more Less More

Answer (UnSolved)

question Subscribe To Get Solution

Recent Questions

Chat Now

Welcome to Live Chat

Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.

Please fill in the form