Font size
WorksheetsForm 4 Excel and Access Quiz
Total questions: 10
Worksheet time: 16mins
What are the 4 main parts of a database?
A2, B5,A13 and C5 are examples of what
(a)
Write down the function used in the cell B10 to calculate the total for 2013.
A query was created to sort out records with the manufacturer DELL. give the Code for all records that satisfy the query requirement.
Give two data types used in the Stock table.
Which formula below will add the value of B2 to the value of C3
=B2+C3
=C3+B3
=6+4
=B+C
For calculating which of the following options, An Excel spreadsheet is primarily used?
Data
Finances
Numbers
All of the above
Which is the correct formula?
=SUM(A1:A5)
Add A1 - A5
Subtract the numbers from A1 to A5
A1 = A5
At the beginning of an Excel spreadsheet formula, the function of the word '=SUM' is
To add all the data together using addition only.
To tell the person viewing that this is a function and it should be added together.
To calculate all the data correctly without any mistakes.
To inform the computer that an arithmetic function will occur.
A worksheet is a(n) ___________
Piece of graph paper
A single page in a workbook
Excel file
All of the above
