Page 36 - iPro_trackGPT_V5_Class8
P. 36
A cell range refers to a group of cells selected together in a worksheet.
A cell reference is the address of a cell that you can use in a formula to show a specific
cell.
Functions are built-in formulas in Excel used for performing both simple and complex
calculations.
A chart is a graphical representation of data designed to make information easier to
understand and analyse.
Sorting means arranging data in a certain order, like ascending (from smallest to largest)
or descending (from largest to smallest) order.
Tech Trivia Section A (Objective)
A. Tick ( ) the correct option.
1. If the range includes cells from C4 to E10, then it is written as ...........................
a. C4;E10 b. C4:E10
c. C4,E10 d. C4 to E10
2. Which function returns the remainder after a number is divided by the divisor?
a. ABS b. SQRT
c. MOD d. ROUND
3. Which function returns the length of the text string?
a. LEN b. LENGTH
c. WID d. WIDTH
4. What is the default name of a worksheet in Excel?
a. Sheet1 b. Worksheet1
c. Untitled1 d. Workbook1
5. Which chart is divided into slices, with each slice showing how big a value is compared to
the whole chart?
a. Bar Chart b. Column Chart
c. Line Chart d. Pie Chart
34 TrackGPT iPRO (V5.0)-VIII

