Page 86 - TGPT_V5.0_C5_Flipbook
P. 86
Hintbot
To use the the common functions like SUM, AVERAGE, MAX and MIN: click
on the down-arrow of the AutoSum command.
To use other functions: click on More Functions option.
Timeline
Predefined border styles can be used to quickly add borders around cells or ranges of cells.
The default time format is hours : minutes : seconds AM/PM in Excel.
Wrap Text feature can be used to display multiple lines of text inside a cell.
The default column width is 8.43 characters and the default row height is 15 points.
Cell contents can be edited by replacing the cell contents and using the formula bar.
You can easily copy and move the contents of a cell, a range of cells and an entire worksheet.
Formulas in Excel begin with an equal (=) sign.
Functions are predefined formulas in Excel to perform both simple and complex calculations.
Choose the correct option.
1. Which of these is the default time format in Excel?
a. minutes : hours : seconds AM/PM
b. minutes : seconds : hours AM/PM
c. seconds : hours : minutes AM/PM
d. hours : minutes : seconds AM/PM
2. Which key is used to edit a cell?
a. Esc key b. Enter key
c. F2 key d. Alt key
84 Premium Edition-V

