Scribd
Upload
31 views2 pages

Spreadsheet Functions Test

The document is a test on spreadsheet functions and skills, asking users to write formulas for various tasks such as finding the highest number, calculating totals, and determining averages. It also includes questions about the SEARCH function, tabular data, and spreadsheet formatting. The test assesses understanding of basic spreadsheet operations and their applications.

Uploaded by

aburezeq2011
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
31 views2 pages

Spreadsheet Functions Test

The document is a test on spreadsheet functions and skills, asking users to write formulas for various tasks such as finding the highest number, calculating totals, and determining averages. It also includes questions about the SEARCH function, tabular data, and spreadsheet formatting. The test assesses understanding of basic spreadsheet operations and their applications.

Uploaded by

aburezeq2011
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Spreadsheet Functions and Skills Test

1. 1. What function would you use to find the highest number in a range of cells? Write the
formula using the range A1:A10.

______________________________________________

______________________________________________

______________________________________________

2. 2. What function would you use to calculate the total of numbers in cells B1 to B5?

______________________________________________

______________________________________________

______________________________________________

3. 3. Write a formula to find the average of values in cells C1 to C6.

______________________________________________

______________________________________________

______________________________________________

4. 4. Write the formula to count how many times the word 'Rainy' appears in the range D2
to D20.

______________________________________________

______________________________________________

______________________________________________

5. 5. What does the SEARCH function do in a spreadsheet? Give an example.

______________________________________________

______________________________________________

______________________________________________

6. 6. Describe what tabular data is and why spreadsheets are useful for it.

______________________________________________

______________________________________________
______________________________________________

7. 7. Write a formula to find the lowest value in cells E1 to E10.

______________________________________________

______________________________________________

______________________________________________

8. 8. Explain the difference between the MIN and MAX functions.

______________________________________________

______________________________________________

______________________________________________

9. 9. You have a list of numbers in column F. Write formulas to calculate both the total and
the average.

______________________________________________

______________________________________________

______________________________________________

10. 10. How can you format a spreadsheet to make it easier to read and understand? Give
two examples.

______________________________________________

______________________________________________

______________________________________________

You might also like