Questions for MS Excel MCQs to help you prepare for tests, examinations, and qualifications. As a response, you’ll encounter questions about the Workbook, Menu bar, Toolbar, Column headings, Row headings, a Name box, Formula bar, and a lot more. Anyone can easily pass their exam if they follow this systematic learning strategy.

4

Created on April 07, 2022 By Preptestsonline

MS Excel MCQs set 2

1 / 13

Which of the following you can paste selectively using Paste Special Command?

Validation

Formats

Formulas

All of above

2 / 13

You can set page border in excel from: __________?

From Border tab in Format Cells dialog box

From Border tool in Formatting toolbar

From Line Style tool in Drawing toolbar

You can not set page border in Excel

3 / 13

Excel displays the current cells address in the __________?

Formula bar

Status bar

Name box

Title bar

4 / 13

The first cell in excel worksheet is labeled as _________?

AA

A1

Aa

None of these

5 / 13

An excel workbook is a collection of __________?

Workbooks

Worksheets

Charts

Worksheets and Charts

6 / 13

Which of these key are used in ms excel to insert current time In workbook.

Ctrl + Shift + ;

Ctrl+!

Ctrl+*

None of these

7 / 13

Getting data from a cell located In a different sheet is called ___________?

Accessing

Referencing

Updating

Functioning

8 / 13

Which element is deficient in milk _________?

Iron

Phosphorus

Sodium

Calcium

9 / 13

In Ms Excel Ready made templates are available under _______ tab ?

File

Insert

Design

None of Above

10 / 13

You can edit existing Excel data by pressing the:________ key?

F1 Key

F2 Key

F3 Key

F4 Key

11 / 13

---

When you insert an Excel file into a word document, the data are?

Hyperlinked

placed in a word table

linked

embedded

12 / 13

The Greater Than sign is an example of ________ operation ?

Arithmetic

Logical

Conditional

Greater

13 / 13

Which function displays row data into column or column data into row?

Hyperlink

Index

Transpose

Rows

Your score is

The average score is 44%

LinkedIn Facebook Twitter VKontakte

0%

Restart quiz

PPSC/FPSC accepts applications (from male and female candidates) for the following Lecturers’ Jobs or out of all these subjects as per the Higher Education Department’s requirements:

https://preptestsonline.com/auditing-mcqs/auditing-mcqs-with-answersPPSC/FPSC Exam/Tests for Lecturer Journalism, Lecturer Library Science, Lecturer Mathematics, Lecturer Pakistan Studies, Lecturer Persian, Lecturer Philosophy, Lecturer Political Science, Lecturer Saraiki, Lecturer Social Work, Lecturer Sociology, Lecturer Statistics, Lecturer Zoology, Lecturer Arabic, Lecturer Botony, Lecturer Civics, Lecturer Commerce, Lecturer Computer Science, Lecturer Geography, Lecturer Fine Arts, Lecturer Home Economics Lecturer History, Lecturer English, Lecturer Urdu, Lecturer Finance, Lecturer HRM, Lecturer Marketing, Lecturer Accounting, Lecturer Auditing, Lecturer Civil engineer, Lecturer Software Engineer, Lecturer Mechanical Engineer, Lecturer Chemical Engineer,

Here are the links to free PDF books to seek help in the preparation for Lecturer Jobs offered by the Higher Education Department through the Punjab Public Service Commission (PPSC) and Federal Public Service Commission (FPSC).

Download Links for Books

• Download link for PPSC Lecturer Job Islamic Studies (Islamiyat): Islamic Studies – PDF Books for PPSC
• Download link for PPSC Lecturer Job Pakistan Studies: Pakistan Studies – PDF Books for PPSC
• Download link for PPSC Lecturer Job Biology / Download link for PPSC Lecturer Job Botony: Biology/Botony – PDF Book for PPSC
• Download link for PPSC Lecturer Job English: English – PDF Books for PPSC
• Download link for PPSC Lecturer Job Physics / Download link for PPSC Lecturer Job Chemistry: Physics Chemistry – PDF Books for PPSC

More Practice Tests

• PPSC TEST MCQS
• FPSC TEST MCQS
• NTS TEST MCQS
• SUBJECT-WISE MCQS
• ENGINEERING MCQS
• MANAGEMENT SCIENCE MCQS
• EVERYDAY SCIENCE MCQS
• GENERAL KNOWLEDGE MCQS