WorksheetsMS EXCEL BASIC COMPUTATIONS AND FUNCTIONS
Total questions: 20
Worksheet time: 1hrs 2mins
Before we start with the second part of Microsoft Excel, let us first learn how to use the basic formulas of excel. Please take note of these formulas.
=SUM (cell1, cell2,...) (ADD/SUM UP VALUES)
=(cell1-cell2,...) (SUBTRACT VALUES)
=QUOTIENT(cell1, cell2,...) (DIVIDE VALUES)
=(cell1*cell2,...) (MULTIPLY VALUES)
Example:
=SUM(A1,A2) click enter and the answer will be revealed. If you want to do more than 2 values, simple highlight all the cells that you want to include. Like =SUM(A1,A2,A3,A4,A4) you can do the same thing to the other formulas. Try this first on your MS Excel application.
Once you're done with this, please type OKAY
(a)
What formula do you use if you want to subtract multiple values in MS Excel?
=DIFFERENCE(cell1,cell2)
=(cell1,cell2)
=(cell1-cell2)
=SUBTRACT(cell1,cell2)
What is the answer if you will add all of these numbers?
191
119
192
129
What is the result when multiplying these numbers in Excel?
10, 535
10, 553
10, 353
10, 335
In order to multiply items in Excel, you would use:
=1 ^ 2
=1 @ 2
=1 # 2
=1 * 2
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Count
Average
Sum
Subtract
On an Excel sheet, the active cell is indicated by ____.
A dark wide border
A dotted border
A blinking border
None of the above
The first cell in EXCEL worksheet is labeled as:
AA
A1
Aa
A0
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?
Yes
No
This is known as
Cell
Row
Column
Worksheet
The cell address of the highlighted cell is
C4
A4
4
C
Microsoft excel file is known as
worksheet
cell address
formula bar
workbook
In Microsoft Excel spreadsheets, rows are labelled as _______
1,2,3,…..
A,B,C,….
A1,B1,C1….
I,II,III,…..
An Excel formula begins with what symbol?
#
@
&
=
Subtract the following numbers in MS Excel
49
-48
-49
48
Which of the following is NOT a valid Excel function?
SUM
COUNT
AVERAGE
MINUS
Which of the following is a valid way to reference a cell in Excel?
1A
A1
R1C1
Cell(1,1)
What is the shortcut key to save a workbook in Excel?
Ctrl + S
Ctrl + P
Ctrl + C
Ctrl + Z
Which of the following is a valid way to create a chart in Excel?
Chart > Insert
View > Chart
Data > Chart
Insert > Chart
What is the default file extension for an Excel workbook?
.xlsb
.xlsm
.xlsx
.xls
