Font size
WorksheetsExternal Lab AMC-105
Total questions: 12
Worksheet time: 7mins
Write your name
Write you enrolment no. ( full )
What is the intersection of a column and a row on a worksheet called?
Column
Cell
Row
Value
What type of chart will you use to compare performance of two employees in the year 2016 ?
Pie chart
Dot chart
Column chart
Line chart
Which one is NOT a Function in MS Excel ?
SUM
AVG
MIN
MAX
Functions in MS Excel must begin with
A Minus sign
A Plus Sign
An Equal Sign
A > Sign
Which function in Excel checks whether a condition is true or not ?
IF
SUM
AVERAGE
COUNT
In Excel, Columns are labelled as
1,2,3 etc
$A1 , $A2, etc
A1, A2, etc
A, B, C, etc
Which function in Excel tells how many numeric entries are there?
NUM
SUM
COUNT
CHKNUM
Statistical calculations and preparation of tables and graphs can be done using
Excel
Adobe Photoshop
Notepad
Power Point
How will you graphically represent expenditure in different departments ?
Column Chart
Line Chart
Dot Chart
Pie Chart
The basic unit of a worksheet into which you enter data in Excel is called a
cell
column
table
box
