Font size
WorksheetsData Analysis Using Excel Test
Total questions: 25
Worksheet time: 29mins
Which formula will you use to calculate the Number of people who were absent?
=COUNTBLANK(Attendance)
=SUM(Attendance)
=COUNTA(Attendance)
=COUNT("Attendance")
Identify the MS Excel Window...
Which one is not a function in ms excel?
RIGHT
MID
LEFT
CLEAR
What does COUNTA function do?
Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells
What is MS Excel primarily used for?
Graphic design
Analyzing and visualizing data
Word processing
Creating presentations
What is the key element of a Pie Chart in Excel?
Vertical bars of varying heights
Data points connected by lines
Circular graph divided into slices
Horizontal bars
Which function returns the number of characters in cell T4?
TEXTLENGTH(T4)
EXACT(T4)
LEN(T4)
CHAR(T4)
if statement structure is:
if(value-if-true,logical-test,value-if-false)
if(logical-test,value-if-false-value-if-true)
if(logical-test,value-if-true,value-if-false)
To create a new workbook
Ctrl + N
Ctrl + PageUp
Ctrl + O
To move to the previous sheet
Ctrl + PageDown
Ctrl + W
Ctrl + PageUp
To hide selected row
Ctrl + Space
Ctrl + 9
Ctrl + 0
The first cell in a worksheet is what?
A1
1A
FX
Cell Name
What does every formula in MS EXCEL start with?
+
-
=
*
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.
