题目内容

The main general purposes of a spreadsheet are: I to automate the performance of mathematical calculations II to manipulate data efficiently and effectively III to present data professionally IV to store data for use by the business

A. I and II only
B. I and III only
C. I, II and IV only
D. All of the above

查看答案

搜索结果不匹配？点我反馈

更多问题

What formula should be used in cell B6?

A. SUM(B3:B5)
B. SUM(B3,B5)
C. =SUM(B3:B5)
D. =SUM(B3,B5)

查看答案

A company sells its products to two countries, Country A and Country B.Which of the following would provide the best visual representation of both the total revenue earned by the company and the proportion of revenue that originated from Country A and Country B?

A. Line graph
B. Composite bar chart
C. Pie chart
D. Scatter graph

查看答案

A management accountant has produced a spreadsheet for use as a template for costing projects.The management accountant wishes to send the spreadsheet to budget holders for them to input the details of their projects. To prevent standard data being accidently changed by other staff, the management accountant wishes to lock cells A14, C14, C32 and D32.What is the first step to take in order to lock these cells?

A. Select cells A14, C14, C32 and D32
B. Select cell A14
C. Select the entire workbook
D. Click on Format Cells

查看答案

Two statements regarding the use of passwords to protect spreadsheets are shown below. I Passwords reduce the risk of data being lost II Passwords reduce the risk of data being altered by unauthorised personnelIs each statement true or false?

A. Statement I is true and statement II is false
B. Statement I is false and statement II is true
C. Both statements are true
D. Both statements are false

查看答案

The main general purposes of a spreadsheet are: I to automate the performance of mathematical calculations II to manipulate data efficiently and effectively III to present data professionally IV to store data for use by the business

A. I and II only B. I and III only C. I, II and IV only D. All of the above

What formula should be used in cell B6?

A company sells its products to two countries, Country A and Country B.Which of the following would provide the best visual representation of both the total revenue earned by the company and the proportion of revenue that originated from Country A and Country B?

Two statements regarding the use of passwords to protect spreadsheets are shown below. I Passwords reduce the risk of data being lost II Passwords reduce the risk of data being altered by unauthorised personnelIs each statement true or false?

A. I and II only
B. I and III only
C. I, II and IV only
D. All of the above