NEW
Font size
WorksheetsCBA Excel 1
Total questions: 10
Worksheet time: 5mins
What is the function of Ms Excel?
Word processing
Presentation media
Quiz media
Number Processing
To start a new document from the starting point in Excel, we choose
File - New - Blank Workbook
File - New - Browse template
Click Add New Sheet
Click plus sign on bottom-left worksheet
To organize column width and row height we click ____ toolbar
Clipboard
Format
Font
Alignment
To make extra long text appear in multiple rows in one cell, we click ___ toolbar
Space
Enter
Wrap text
Format cells
Formula to add number in several cells
=SUM
=AVERAGE
=MIN
=MAX
Formula to find mean of several data
=SUM
=AVERAGE
=MIN
=MAX
Formula to find the biggest number of a collection of data
=SUM
=AVERAGE
=MIN
=MAX
Formula to count how many data exist in a workbook
=SUM
=MED
=SQRT
=COUNT
Formula to make long decimal number appear in round number
=SUM
=ROUND
=SQRT
=COUNT
Excel help us to automatically provide following number of a sequence number. How to do it?
Type number and enter till the data we need is appearing
Drag mouse to destination point
Insert - Table
Type two number first then drag thick plus sign until we got the sequence data we need
