Microsoft Excel Quiz

January 22, 2023 Tech4nep 0 Comments bagmati pradesh computer operator, computer operator mcq, computer operator quiz, computer operator vacancy, Computer Science Old Question TSC 2079, loksewa computer operator, lumbini pradesh computer operator, mcq, Microsoft Excel Quiz, PSC, quiz, sudurpaschim computer operator, TSC

SHARE ON:

Hey are you looking for Microsoft Excel Quiz for preparing computer operator examination and other educational examination of colleges. Here tech4nep.com teams are prepare the 50 multiple choice question on Microsoft Excel for those who are preparing computer operator examination of Public Service Commission “PSC” and other organizational examination.

Let’s start Microsoft Excel Quiz:

0 votes, 0 avg

You have 40 minute for this quiz and you will notified before 5 minute

Your quiz time is finished.

Created on January 22, 2023 By

Tech4nep

Microsoft Excel Quiz

1 / 50

How many columns are there in a VisiCalc Spreadsheet?

2 / 50

What type of chart will you use to compare performance of sales of two products ?

Column Chart

Line Chart

Pie Chart

Both (Column & Line)

3 / 50

A spreadsheet is a collection of pages is called a _______

Workbook

Art book

Worksheet

Documents

4 / 50

The Greater Than sign (>) is an example of _____ operator.

Arithmatic

Logical

Conditional

Greater

5 / 50

Which of these options is not available in the Chart Options in MS Excel “CHART WIZARD”?

Axes

Data Label

Data Series

Data Table

6 / 50

How do you insert a row?

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Select the row heading where you want to insert the new row and select Edit >Row from the menu

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

All of above

7 / 50

Maximum width of a cell is

128 characters

240 characters

480 characters

1024 characters

8 / 50

Which of these charts does not exist in MS Excel

Scatter

Line

Doughnut

Graph

9 / 50

Statistical calculations and preparation of tables and graphs can be done using

Adobe Photoshop

Excel

Notepad

Power Point

10 / 50

An Excel file is generally called a / an :

E-Spreadsheet

Woorksheet

Workbook

Sheet

11 / 50

Which menu have the Fill option in MS Excel?

View

Format

Edit

Tools

12 / 50

In Excel, Rows are labelled as ______

A, B, C, etc

1,2,3 etc

A1, A2, etc.

$A$1, $A$2, etc.

13 / 50

Excel is a collection of workbook ………….

Workbooks

Worksheets

Charts and Slides

Data

14 / 50

In MS Excel, which menu does have Sort option

Edit

Format

Tool

Data

15 / 50

To create a formula, you first:

Select the cell you want to place the formula into

Type the equals sign (=) to tell Excel that you’re about to enter a formula

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

Choose the new command from the file menu

16 / 50

The process of arranging the items of a column in some sequence or order is known as :

Arrengin

Autofill

Sorting

Filtering

17 / 50

Values, entered in a cell, are always

Centred

Left aligned

Right aligned

Not aligned at all

18 / 50

What type of chart is useful for showing trends or changes over time ?

Pie Chart

Column Chart

Line Chart

Dot Graph

19 / 50

How do you select an entire column?

Select Edit > Select > Column from the menu

Click the column heading letter

Hold down the shift key as you click anywhere in the column.

Hold down the Ctrl key as you click anywhere in the column

20 / 50

Functions in MS Excel must begin with ___

An () sign

An Equal Sign

A Plus Sign

A > Sign

21 / 50

In Excel, Columns are labelled as ___

A, B, C, etc

1,2,3 etc

A1, A2, etc.

$A$1, $A$2, etc.

22 / 50

Which option of Chart Wizard contains the option of Series Name, Category and Value in Data?

Legend

Chart area

Data label

Data Titles

23 / 50

What do you use to create a chart?

Pie Wizard

Excel Wizard

Data Wizard

Chart Wizard

24 / 50

Which of these data types is not in MS Excel?

Number

Currency

Label

Date/Time

25 / 50

............. is not text function

Len

Count

Upper

Proper

26 / 50

How many icons appear in the floating tool bar?

27 / 50

How can you print three copies of a workbook?

Select File>Properties form the menu and type 3 in the Copies to print text box.

Select File >Print from the menu and type 3 in the Number of copies text box.

Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

Press Ctrl+P+3

28 / 50

Which one is not a Function in MS Excel ?

SUM

AVG

MAX

MIN

29 / 50

What type of chart is good for single series of data ?

Column Chart

Line Chart

Pie Chart

DOT Chart

30 / 50

Which sign display when Formula Error in MS Excel

31 / 50

What is the Extension of Excel Workbook in MS Excel 2007?

.xlx

.xlsx

.xlcx

Xlxx

32 / 50

Which of the following is not a basic step in creating a worksheet?

Save workbook

Modify the worksheet

Enter text and data

Copy the worksheet

33 / 50

The ____ feature of MS Excel quickly completes a series of data

Auto Complete

Auto Fill

Fill Handle

Sorting

34 / 50

Which function in Excel tells how many numeric entries are there ?

NUM

COUNT

SUM

CHKNUM

35 / 50

Which menu contains macro options in MS Excel

Insert

Format

Tools

Data

36 / 50

A features that displays only the data in column (s) according to specified criteria

Formula

Sorting

Filtering

Pivot

37 / 50

What type of chart will you use to compare performance of two employees in the year 2016 ?

Column Chart

Line Chart

Pie Chart

Dot Chart

38 / 50

In Excel, which one denoted a range from B1 through E5

B1 - E5

B1:E5

B1 to E5

B1$E5

39 / 50

MS EXCEL Based on _______ Software

WINDOWS

DOS

UNIX

LINUX

40 / 50

In MS Excel, in which bar have the currency option

Formatting Toolbar

Standard Toolbar

Status Bar

Formula bar

41 / 50

What type of chart is useful for comparing values over categories ?

Pie Chart

Column Chart

Line Chart

Dot Graph

42 / 50

How will you graphically represent expenditure in different departments ?

Column Chart

Line Chart

Pie Chart

Dot Chart

43 / 50

It is a collection of data that is stored electronically as a series of records in a table.

spreadsheet

presentation

database

MS Word

44 / 50

Which Function is used to calculate Remainder in MS Excel?

INT()

FACT()

MOD ()

DIV ()

45 / 50

To create a worksheet, it is

Not important to be knowledgeable about the task to be done

Important to understand a programming language

Important to be knowledgeable about the spreadsheet

Both a & b

46 / 50

Which function in Excel checks whether a condition is true or not ?

SUM

COUNT

AVERAGE

47 / 50

The basic unit of a worksheet into which you enter data in Excel is called a

cell

table

box

column

48 / 50

You can automatically adjust the size of the text in a cell if they do not fit in width by

Double clicking on t he right border of column header

From format cell dialog box mark shrink to fit check box

From format choose columns and then autofit selection

All of the above

49 / 50

What type of chart is useful for comparing parts of a whole ?

Pie Chart

Column Chart

Line Chart

Dot Graph

50 / 50

Which function is used to input the date only in MS Excel?

Today

Now

Time

Calendar

Your score is

Notes:

1. For more computer operator quiz link

2. For more computer operator MCQ link

3. Vacancy Notice Link

4. NEB Computer Operator Preparation Link

Post Views: 248

Colleges Syllabus

लाेकसेवा

Microsoft Excel Quiz

Let’s start Microsoft Excel Quiz:

Leave a Reply Cancel reply