NEW
Font size
WorksheetsCi Quiz
Total questions: 20
Worksheet time: 4mins
Which is not a function in MS Excel
SUM
AVG
MAX
MIN
On an Excel Sheet, the active cell is indicated by?
A Blinking Border
A Dotted Border
A Dark Wide Border
By Italic Text
To create an interactive Pivot table for the web, you use a MS office Web Component called?
HTML
Pivot Table Field List
Pivot Table List
Pivot Table Report
Which key is used to "Goto" tab in MS Excel?
F9
F7
F6
F5
How can we set Page Border in Excel?
From Home
From Edit Menu
You can not set Page Border in Excel
From Tools Menu
Which of these keys are used in MS Excel to Copy Value from above cell?
Ctrl+ ;
Ctrl+ "
Ctrl+ :
Ctrl+ D
___________function in excel tells how many numeric entries are there.
NUM
SUM
COUNT
CHKNUM
To minimize workbook in MS Excel
Ctrl + F9
Ctrl + F8
Ctrl + F7
Ctrl + F6
The maximum number of rows in a worksheet is (xls file format)
1,084,657
1,048,756
1,084,675
1,048,576
The maximum number of columns in a worksheet is (xls file format)
15,834
16,384
17,534
15,384
What is the file extension of Powerpoint application
.docx
.ppt
.jpeg
.ptt
The following are view of powerpoint, except
Slide Show viewslide sorter view
Slide Show view
Outline view
Normal view
What is animation?
Accelerate static images
Print out
Changing the pictures in the graph
To make a picture
The file formats _____________ can add to power point shows
WAV
MPEG
JPEG
All of the above
Shortcut key for the slide show view is
F1
F3
F5
F4
Tcode ________ is used to display a specific journal entry of a document number.
FBL1N
FBCJ
FB03
FB08
This icon in SAP creates new GUI window
You've imported a spreadsheet, but the Power BI Desktop hasn't realised that the first row should be used as column titles. What tool should you click on?
Enable column titles
Move titles above data
Use first row as headers
Promote top row
in Power BI, filters are applicable in:
Visualization Level
Page Level
Report Level
All of the above
Power BI is a cloud-based data sharing environment and once you have developed reports using Power Query, Power Pivot and Power View, you can share your insights with your colleagues.
True
False
