Questions Answer
1. Sum a range of cells: =SUM(A1:A10)
2. Find an average of numbers: =AVERAGE(A1:A10)
3. Find the maximum value in a range: =MAX(A1:A10)
4. Find the minimum value in a range: =MIN(A1:A10)
5. Link cells from different sheets: =Sheet2!A1
6. Concatenate two cells: =CONCATENATE(A1, B1) or =A1 & B1
7. Sum if cells meet a condition: =SUMIF(A1:A10, ">5")
8. Use INDEX to retrieve a value: =INDEX(A1:A10, 5) (retrieves the 5th value in
the range)
9. Round a number to the nearest integer: =ROUND(A1, 0)
10. Extract the left part of a text string: =LEFT(A1, 3) (extracts the first 3 characters)
11. Extract the right part of a text string: =RIGHT(A1, 3) (extracts the last 3
characters)
12. Use VLOOKUP function: =VLOOKUP(B1, A1:C10, 2, FALSE) (looks
up B1 in the first column of A1:C10 and
returns the value in the 2nd column)
13. Use HLOOKUP function: =HLOOKUP(B1, A1:C10, 2, FALSE) (looks
up B1 in the first row of A1:C10 and returns
the value in the 2nd row)
14. Calculate the square root =SQRT(A1)
15. Generate a random number: =RAND() (between 0 and 1) or
=RANDBETWEEN(1, 100) (between 1 and
100)
16. Count cells with numerical data: =COUNT(A1:A10)
17. Count cells with any data: =COUNTA(A1:A10)
18. Find the current date: =TODAY()
19. Add days to a date: =A1 + 10 (adds 10 days to the date in A1)
20. Calculate the percentage change: =(B1-A1)/A1100
21. Check if a cell is empty: =IF(ISBLANK(A1), "Empty", "Not Empty")
22. Return the absolute value: =ABS(A1)
23. Check if a condition is true: =IF(A1>10, "True", "False")
24. Sum only visible cells: =SUBTOTAL(9, A1:A10)
25. Sum visible and invisible cells: =SUM(A1:A10)
Figure 1
Title bar
Quick Access Toolbar
Name box
Formula bar
Scroll bars
Cells
Spreadsheet area
View buttons
Zoom controls
Status bar
Leaf bar
Row bar
Menu bar
Column bar
Control buttons
Toolbar/ribbons
Dialog Box Launcher
