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 1

1 / 12

In MS Excel to delete duplicate values which menu is used?

Data

Tools

Formatting

Layout

2 / 12

Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________?

Smart tip

Soft Tip

Web Tip

Cell Tip

3 / 12

With which of the following all formulas in excel starts ?

/

*

$

=

4 / 12

Which one is example of spreadsheet software?

MS WORD

MS EXCEL

MS POWERPOINT

None of these

5 / 12

Which key is used for help in Ms Excel?

F1

F2

F3

None of these

6 / 12

Which of these keys are used in Ms Excel to copy value from above cell?

Ctrl + “

Ctrl+ E

Ctrl+ E

Ctrl+ D

7 / 12

Which of these keys are used in Ms Excel to copy formula from above cell?

Ctrl+ ”

Ctrl+ ;

Ctrl+ :

Ctrl+ ‘

8 / 12

Move to next cell in row in Ms Excel:

Tab

Shift

Space

None of these

9 / 12

Move to Next Sheet in Ms Excel:

Ctrl + Page Down

Shift + Page Down

Page Down

None of these

10 / 12

Microsoft Office Suite spreadsheet program is _________?

None of these

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

11 / 12

Microsoft Office Accounting is:

A tool for managing business finances

None of these

Project management software to keep track of events and to create network charts and Gantt charts

Diagram and flow-charting software

12 / 12

Microsoft Office InterConnect is:

An application that supports editing scanned documents

None of these

Business-relationship database

A scanning and OCR application

Your score is

The average score is 56%

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