MS Office & Productivity

505 MCQs

Exam-focused practice

AI Explanations

Learn after each answer

Free Forever

No subscription needed

Showing Q 21–40 of 505 MCQs

Navigation

All Subjects Up one level

Covered Exams

FPSCNTSCSSPPSCOTSIBA

Practice MS Office & Productivity MCQs

Start a quiz for active recall, or browse individual MCQs with explanations below.

21Top open an existing workbook, click the open button on the___________toolbar?

A.form

B.standard

C.Drawing

D.Formatting

easyFPSCNTS

22Which among following is not associated with spelling dialogue box?

A.Edit

B.Ignore All

C.Ignore

D.Change

easyFPSCNTS

23To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?

A.Pivot Table Report

B.Pivot Table List

C.Pivot Table Field List

D.HTML

easyFPSCNTS

24How many columns are in one Microsoft Excel sheet?

A.65,536

B.16,384

C.1,048,576

D.None of Above

easyFPSCNTS

25How many rows are in one Microsoft Excel sheet?

A.65,536

B.16,384

C.1,048,576

D.None of Above

easyFPSCNTS

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

A.Data

B.Tools

C.Formatting

D.Layout

easyFPSCNTS

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

A.Smart tip

B.Soft Tip

C.Web Tip

D.Cell Tip

easyFPSCNTS

28With which of the following all formulas in excel starts ?

A./

B.*

C.$

D.=

easyFPSCNTS

29Which one is example of spreadsheet software?

A.MS WORD

B.MS EXCEL

C.MS POWERPOINT

D.None of these

easyFPSCNTS

30Which key is used for help in Ms Excel?

A.F1

B.F2

C.F3

D.None of these

easyFPSCNTS

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

A.Ctrl + "

B.Ctrl+ E

C.Ctrl+ E

D.Ctrl+ D

easyFPSCNTS

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

A.Ctrl+ ”

B.Ctrl+ ;

C.Ctrl+ :

D.Ctrl+ ‘

easyFPSCNTS

33Move to next cell in row in Ms Excel:

A.Tab

B.Shift

C.Space

D.None of these

easyFPSCNTS

34Move to Next Sheet in Ms Excel:

A.Ctrl + Page Down

B.Shift + Page Down

C.Page Down

D.None of these

easyFPSCNTS

35Microsoft Office Suite spreadsheet program is _________?

A.None of these

B.Microsoft Word

C.Microsoft Excel

D.Microsoft PowerPoint

easyFPSCNTS

36Microsoft Office Accounting is:

A.A tool for managing business finances

B.None of these

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

D.Diagram and flow-charting software

easyFPSCNTS

37Microsoft Office InterConnect is:

A.An application that supports editing scanned documents

B.None of these

C.Business-relationship database

D.A scanning and OCR application

easyFPSCNTS

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

A.Hyperlink

B.Index

C.Transpose

D.Rows

easyFPSCNTS

39The Greater Than sign is an example of ________ operation ?

A.Arithmetic

B.Logical

C.Conditional

D.Greater

easyFPSCNTS

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

A.Hyperlinked

B.placed in a word table

C.linked

D.embedded

easyFPSCNTS

Pageof 26

MS Office MCQs for FPSC, NTS, PPSC and Office Jobs - Page 2 | MCQist