MS Office & Productivity

505 MCQs

Exam-focused practice

AI Explanations

Learn after each answer

Free Forever

No subscription needed

Showing Q 81–100 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.

81Which of the following is last column in MS Excel-2016?

A.XFD

B.ZZZ

C.ZXF

D.ZAZ

easyFPSCNTS

82Which shortkey is suitable for reach at the last Row of MS Excel?

A.Ctrl + Space

B.Shift + Ctrl +Enter

C.Ctrl + Down Arrow

D.Ctrl + =

easyFPSCNTS

83In MS Word, “Justify” works to make text straight in both sides but How Justify works in MS Excel?

A.Text in Columns

B.Text in Rows

C.Text in selection

D.None

easyFPSCNTS

84Which shortcut key is for auto sum ?

A.Alt + =

B.Ctrl + Shift

C.Alt + F1

D.Ctrl + =

easyFPSCNTS

85________________________ is not a valid data type in excel?

A.Number

B.Label

C.Character

D.none

easyFPSCNTS

86What is the use of a horizontal Scroll Bar in MS Excel?

A.to view the data from left to the right

B.to view the data in Excel from up and down

C.to view the data from right to the left

D.None of these

easyFPSCNTS

87MS Excel is based on: _____________?

A.UNIX

B.DOS

C.WINDOWS

D.OS/2

easyFPSCNTS

88Which shortcut key is used to create chart in MS Excel?

A.F10

B.F12

C.F11

D.None

easyFPSCNTS

89How do you display current date and time in MS Excel ?

A.Date()

B.Year()

C.Now()

D.Time()

easyFPSCNTS

90Letters in Excel denote: ______________?

A.Columns

B.rows

C.numbers

D.reference

easyFPSCNTS

91Another name for a pre programmed formula in excel is ___________?

A.Cell

B.Graph

C.Function

D.Range

easyFPSCNTS

92How are data organized in a spreadsheet ?

A.Lines and spaces

B.Layers and planes

C.Rows and columns

D.Height and width

easyFPSCNTS

93In Excel, which is used to perform what if analysis?

A.Goal seek

B.Solver

C.Scenario Manager

D.All of above

easyFPSCNTS

94What is a group of cells called in Excel?

A.Cell Range

B.Workbook

C.Margin

D.None of these

easyFPSCNTS

95How to split a single columns’ text into multiple columns?

A.Data>>Sort & Filter

B.Data>>Text to Columns

C.Home>>Fill>>Justify

D.Home>>Editing>>Justify

easyFPSCNTS

96Which function allows to define names/text in formulas except the use of selection in MS Excel?

A.Defined Names

B.Create from Selection

C.Formulas Bar

D.Name Manager

easyFPSCNTS

97The maximum margins can be set in MS Excel are ____________?

A.02 (Normal & Wide margins)

B.04 (Normal, Wide, Narrow & Moderate

C.03 ( Normal, Wide & Narrow)

D.Just one margin

easyFPSCNTS

98What is a motion path in Microsoft PowerPoint

A.A type of animation entrance effect

B.A method of advancing slides

C.A method of moving items on a slide

D.All of the above

easyFPSCNTS

99in the context of animations, what is a trigger in Microsoft PowerPoint?

A.An action button that advances to the next slide

B.An item on the slide that performs an action when clicked

C.The name of a motion path

D.All of above

easyFPSCNTS

100If you have a PowerPoint show you created and want to send using email to another teacher you can add the show to your email message as a (an)____________?

A.Inclusion

B.Attachment

C.Reply

D.Forward

easyFPSCNTS

Pageof 26

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