wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Ci Quiz

Total questions: 20

Worksheet time: 4mins

Name
Class
Date
1.

Which is not a function in MS Excel

a)

SUM

b)

AVG

c)

MAX

d)

MIN

2.

On an Excel Sheet, the active cell is indicated by?

a)

A Blinking Border

b)

A Dotted Border

c)

A Dark Wide Border

d)

By Italic Text

3.

To create an interactive Pivot table for the web, you use a MS office Web Component called?

a)

HTML

b)

Pivot Table Field List

c)

Pivot Table List

d)

Pivot Table Report

4.

Which key is used to "Goto" tab in MS Excel?

a)

F9

b)

F7

c)

F6

d)

F5

5.

How can we set Page Border in Excel?

a)

From Home

b)

From Edit Menu

c)

You can not set Page Border in Excel

d)

From Tools Menu

6.

Which of these keys are used in MS Excel to Copy Value from above cell?

a)

Ctrl+ ;

b)

Ctrl+ "

c)

Ctrl+ :

d)

Ctrl+ D

7.

___________function in excel tells how many numeric entries are there.

a)

NUM

b)

SUM

c)

COUNT

d)

CHKNUM

8.

To minimize workbook in MS Excel

a)

Ctrl + F9

b)

Ctrl + F8

c)

Ctrl + F7

d)

Ctrl + F6

9.

The maximum number of rows in a worksheet is (xls file format)

a)

1,084,657

b)

1,048,756

c)

1,084,675

d)

1,048,576

10.

The maximum number of columns in a worksheet is (xls file format)

a)

15,834

b)

16,384

c)

17,534

d)

15,384

11.

What is the file extension of Powerpoint application

a)

.docx

b)

.ppt

c)

.jpeg

d)

.ptt

12.

The following are view of powerpoint, except

a)

Slide Show viewslide sorter view

b)

Slide Show view

c)

Outline view

d)

Normal view

13.

What is animation?

a)

Accelerate static images

b)

Print out

c)

Changing the pictures in the graph

d)

To make a picture

14.

The file formats _____________ can add to power point shows

a)

WAV

b)

MPEG

c)

JPEG

d)

All of the above

15.

Shortcut key for the slide show view is

a)

F1

b)

F3

c)

F5

d)

F4

16.

Tcode ________ is used to display a specific journal entry of a document number.

a)

FBL1N

b)

FBCJ

c)

FB03

d)

FB08

17.

This icon in SAP creates new GUI window

a)
b)
c)
d)
18.

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?

a)

Enable column titles

b)

Move titles above data

c)

Use first row as headers

d)

Promote top row

19.

in Power BI, filters are applicable in:

a)

Visualization Level

b)

Page Level

c)

Report Level

d)

All of the above

20.

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.

a)

True

b)

False