Deck 18: Produce Spreadsheets

Question 1

Writing Microsoft Excel formulas is the same as writing formulas in maths class.

Answer 1

False

Question 2

By clicking on the question mark icon on the top right-hand corner of the computer screen, you will be taken to the software's 'Help' function.

Answer 2

True

Question 3

If all the information is inputted into a single spreadsheet cell:

A) there would be no options to sort by
B) there would be many options to sort by
C) the spreadsheet will only be accessible by the originator's computer
D) the spreadsheet would only be able to be sorted by the y-axis

Answer 3

A

Question 4

When creating a new spreadsheet it is not essential to have a very clear idea of what is required as the eventual outcome for the spreadsheet will not be affected.

Question 5

The specific information you put into columns and into rows will:

A) determine what page the information will appear
B) provide a variety of impressive graphs only on certain pages
C) have an impact on how the data is presented
D) only be useful if it is all in the same font

Question 6

Writing Microsoft Excel formulas is a little different to the way they are done in a maths class. Microsoft Excel formulas start with:

A) a letter
B) a bracket
C) the equals sign
D) the forward slash symbol

Question 7

A final check must also be made to ensure that the information presented is not only in line with the organisation's policies and procedures, but also with:

A) suppliers' recommended information
B) local community guidelines
C) any legislative requirements - requirements that, if breached, could cause legal or ethical problems
D) specific requests by your manager so they are recognised for the work

Question 8

A final check should be made of all data and formatting requirements:

A) before it can be published on the Internet
B) after you have sent it to a customer
C) after your manager has given it to the senior manager
D) before it is sent to the relevant staff members for approval or distribution

Question 9

Cells are arranged in columns (z-axis) and rows (x-axis) and, while you can put endless streams of information in single cells, it is generally best to separate information as much as possible.

Question 10

A pie chart is used when you want to show comparisons and trends between selected categories.