Which formula would result in the average for the numbers in cells D4 to D9 appearing in your spread sheet?
=AVERAGE(D4:D9)
1 of 18
£400 is invested in a shares ISA. The annual dividend from this investment is £18. What is the percentage yield on this investment?
4.5%
2 of 18
An Excel Formula can have only one answer
False
3 of 18
In Excel a ready made formula is called a function. The Autism (sigma) can be used to insert a function
True
4 of 18
If you create a new excel file and put a cursor on a cell A1, the Name box will show what?
A1
5 of 18
Information technology is creating new roles for employees in the workforce
True
6 of 18
Managing account collections is an example of
Finance Business Proces
7 of 18
..... is (are) data that has been organisational to have meaning and value to a recipient. Complete this sentence with one of the following words:
Information
8 of 18
A student's decision to drop one module and add another would be considered a transaction to the university's information system but not to its accounting system
True
9 of 18
A pensioner invested a lump sum; part of 5% and part at 3% interest per annum. How much was invested at 3% in the situation described? The lump sum was £25,000, and the total annual interest on the investment was £970
£14,000
10 of 18
In general organisations try to automate date entry as much as possible
True
11 of 18
Greg is moving lawns in the neighbourhood for the summer. Which of the following is not an example of a transaction he has in his business
Driving to the client's house
12 of 18
You can used Named Cells instead of Dollar signs to denote an absolute cell
True
13 of 18
Which of the following is the correct formula to calculate the average price for all garments listed below?
= AVERAGE (B8:B18)
14 of 18
A student's decision to drop one course and add another would be considered a transaction to the university's information but not to its accounting system?
True
15 of 18
Information is data that have been assembled and organised to be useful
True
16 of 18
Looking at the spread sheet below if you had entered the formula =b18*C18 in the cell D18, what answer would you expect in cell D18?
2578.00
17 of 18
If the formula = A12 was entered into Cell A22 on the sheet below, what would you expect to find there?
Skirt
18 of 18
Other cards in this set
Card 2
Front
£400 is invested in a shares ISA. The annual dividend from this investment is £18. What is the percentage yield on this investment?
Back
4.5%
Card 3
Front
An Excel Formula can have only one answer
Back
Card 4
Front
In Excel a ready made formula is called a function. The Autism (sigma) can be used to insert a function
Back
Card 5
Front
If you create a new excel file and put a cursor on a cell A1, the Name box will show what?
Comments
No comments have yet been made