NEW
Font size
WorksheetsITBM || Quiz: 02
Total questions: 12
Worksheet time: 10mins
What is the intersection of a column and a row on a worksheet called ?
A.Column
B.Value
C.Address
D.Cell
Which functionin Excel tells how many numeric entries are there ?
A.NUM
B.COUNT
C.SUM
D.CHKNUM
Which functionin Excel checks whether a condition is true or not ?
A.SUM
B.COUNT
C.IF
Where can you find the Clear, Select, and Move options?
in the left-click menu
in the Analyze tab
in the Field List
Your PivotTable includes data for your company's eight sales regions identified by abbreviations, such as NE and SW. How can you create a pivot eight rows tall?
Drag Regions into Rows in the Field List.
Drag Regions into Values in the Field List.
Drag Regions into Columns in the Field List
What is the simplest way to insert a PivotTable if you want your entire data set to be included, and have the PivotTable in a new worksheet?
Select any empty cell in the worksheet, choose PivotTable in the Insert tab, and then select OK in the pop-up box that appears.
Select any cell from the source data, choose PivotTable in the Insert tab, and then select OK in the pop-up box that appears.
New Worksheet is selected in the pop-up box by default.
Highlight the source data, choose PivotTable in the Insert tab, and then select OK in the pop-up box that appears.
How can you best describe a PivotTable?
a way to dice, slice, filter, and organize your underlying data set
a lens through which you can dice, slice, filter, and organize your data
a way to create a copy of your data set, so you can dice, slice, filter, and organize the data
Transaction data of the bank is?
A. structured data
B. unstructured datat
C. Both A and B
D. None of the above
Which of the following are Benefits of Big Data Processing?
A. Businesses can utilize outside intelligence while taking decisions
B. Improved customer service
C. Better operational efficiency
D. All of the above
The size of data in Big Data is of ___________ bytes.
A. Terra
B.Mega
C.Giga
D.Peta
Facebook Tackles Big Data With _______
A. Prism
B.Prism Data
C.Project Prism
D.None of the above
The primary characteristics of Big Data are ________
A. Volume
B.Variety
C.Value
D.All of the above
