Spreadsheets Flashcards
1
Q
What method of presentation cannot be produced automatically by a spreadsheet program
A
Narrative (words)
2
Q
What are the benefits of using a spreadsheet
A
Variety, speed, accuracy, legibility
3
Q
If B3 contains the number 10.547 and cell B4 contains the formula =ROUND(B3,0) ..What would the value be in B4?
A
11
4
Q
To make a cell absolutely, which symbol can be used?
£ @ $ *
A
Answer…. $
5
Q
Under which spreadsheets menu are graphs and charts
Formula. Page layout. View. Insert
A
Insert
6
Q
What is an overhead absorption rate used for?
A
To charge overheads to products
7
Q
What is OAR
A
Overhead absorption rate
8
Q
To enter a function in excel, what must you always start with?
A
=
