Font size
WorksheetsClass 6 TCS Analysing data
Total questions: 20
Worksheet time: 10mins
The Count function is used to calculate the number of cells that contain
Pictures
Text
Numbers
none of these
Why do we use the concatenation function?
For Calculation
To split the cells
To join the content of the cells
to copy the cell
Why do we need to use Charts in Ms. Excel?
that can we see our data Visulluy
For data calculation
For Decoration
Analyze the data very carefully
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
Which symbol must be typed first to use a formula
Plus +
Minus -
Equal ==
Question Mark?
MS Excel Spreadsheet used for
Art Work
Collecting Information & Analyzing Data
Games
For Reading
MAX function used to find
Minimum number in selected cells
Average number in selected cells
Maximum number in selected cells
Lucky Number
Adding two cellc Numbers
=SUM(A1+A13)
=SUM(__)
A1+A13= SUM
Total
what does this error mean '######'
column is not wide enough
column is missing numbers
column is showing an error
column is too narrow
In Excel Spread sheet, box that holds data
Spreadsheet
Cell
Row
Data
Microsoft Excel is ____________________software.
Database
Spreadsheet
Presentation
Word Processing
Replace text based on content we use _______ function
Count
if
SUBSTITUTE
Date
Which of the following nested IF functions are CORRECT?
=IF(B5=”Shirt”,IF(A5=”large”,20,10),”Unavailable”)
=IFS(B5=”Shirt”,IF(A5=”large”,20,10),”Unavailable”)
=IF(B5=”Shirt”,=IF(A5=”large”,20,10),”Unavailable”)
=IF:(B5=”Shirt”,IF(A5=”large”,20,10),”Unavailable”)
Which of the following is the correct formula for the IF function in Excel?
IF (logical_test, value_if_true, value_if_false)
=IF (logical_test, value_if_true, value_if_false)
=(logical_test, value_if_true, value_if_false)
all of these
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut men
Which tab contains the tool "Insert Tables"?
Insert
Data
Review
View
Ms Excel is part of
Access
Microsoft Office
PowerPoint
Database
To join cells data into one cell we use the following feature
Merge Cells
Merge Across
Unmerge Cells
All
To print Your sheet we use the follwing shortcut
Ctrl + T
Ctrl + S
Ctrl + C
Ctrl + P
Which of the following program is best for Analyzing data
Free Fire
Ms Power point
Ms Excel
Ms Word
