Microsoft Excel Mcqs with Answers for Test Preparation

Microsoft Excel Mcqs with Answers

Microsoft Excel Mcqs for Preparation. Ms Excel Mcqs are very important Mcqs in computer section. It is very important to know the basic knowledge of computer. Most of the test conductors like FPSC, NTS, KPPSC, PPSC SPSC and others are including computer knowledge MCQs in their test guide.

Welcome to our exclusive collection of Microsoft Excel MCQ Questions and Answers. All questions are of multiple choice type. In these MCQs sets we are going to share most important questions related to Microsoft Excel. These questions are very helpful for candidates and candidates who are preparing for various official and non-official exams as well as interviews. These Mcqs are helpful in exam preparation.

Maximum zoom percentage in Excel is _________?

A. 100%
B. 300%
C. 400%
D. 500%

Default file name in MS Excel is?

Document 1
Workbook 1
Book1
Worksheet

To insert chart in MS Excel, which shortcut key used?

A. Alt+F1
B. F2
C. F3
D. F4

What is the function of the VLOOKUP function in Excel?

A. To perform a vertical lookup and return a value based on a specified criteria
B. To perform a horizontal lookup and return a value based on a specified criteria
C. To add up a range of cells
D. To find the average of a range of cells

What is the function of the IF function in Excel?

A. To perform a logical test and return a value based on the result
B. To add up a range of cells
C. To find the average of a range of cells
D. To count the number of cells in a range

See also  Basic Computer MCQs with Answers For Test Preparation

What is the function of the SUM function in Excel?

A. To add up a range of cells
B. To find the average of a range of cells
C. To count the number of cells in a range
D. To find the maximum value in a range of cells

What is the intersection of a column and row called in Excel?

A. A cell
B. A range
C. A column header
D. A row header

Title bar in MS-Excel displays name of the __________ ?

A. Worksheet
B. Workbook
C. Formula
D. Location

In MS-Excel__________ short cut key is used for hiding rows.

A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above

Which of following is not an element of computer spreadsheet interface?

A. Pencil work
B. Active cell
C. Menu bar
D. Workbook

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

A. Decoration
B. Data appearance
C. Functions
D. Charting

What is a cell in Excel?

A. A row
B. A column
C. A unit of data
D. A unit of formatting

In excel columns are labelled as____________?

A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.

Which of the following is not a valid Zoom percentage in Excel?

A. 10
B. 100
C. 300
D. 500

Pages ( 1 of 15 ): 1 2 ... 15Next ยป

Leave a Comment