MS Office & Productivity

505 MCQs

Exam-focused practice

AI Explanations

Learn after each answer

Free Forever

No subscription needed

Showing Q 41–60 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.

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

A.F1 Key

B.F2 Key

C.F3 Key

D.F4 Key

easyFPSCNTS

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

A.Accessing

B.Referencing

C.Updating

D.Functioning

easyFPSCNTS

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

A.Ctrl + Shift + ;

B.Ctrl+!

C.Ctrl+*

D.None of these

easyFPSCNTS

44An excel workbook is a collection of __________?

A.Workbooks

B.Worksheets

C.Charts

D.Worksheets and Charts

easyFPSCNTS

45The first cell in excel worksheet is labeled as _________?

A.AA

B.A1

C.Aa

D.None of these

easyFPSCNTS

46Excel displays the current cells address in the __________?

A.Formula bar

B.Status bar

C.Name box

D.Title bar

easyFPSCNTS

47You can set page border in excel from: __________?

A.From Border tab in Format Cells dialog box

B.From Border tool in Formatting toolbar

C.From Line Style tool in Drawing toolbar

D.You can not set page border in Excel

easyFPSCNTS

48In MS Excel, Conditional Formatting is in ______ tab?

A.Home

B.View

C.Page Layout

D.Insert

easyFPSCNTS

49Which of the following is the latest version of MS Excel?

A.Excel 2016

B.Excel 2017

C.Excel 2021

D.Office 365

easyFPSCNTS

50Which Shortcut keys are used to strikethrough highlighted selection in Excel?

A.Ctrl+4

B.Ctrl+5

C.Ctrl+6

D.None of the above.

easyFPSCNTS

51Ctrl+Shift+1 shortcut Keys in excel are used to __________?

A.Format number in comma format

B.Format number in currency format

C.Format number in date format

D.Format number in time format

easyFPSCNTS

52In Ms Excel, which of the following special function keys allow the content in cell?

A.Shift

B.Esc

C.Tab

D.Space

easyFPSCNTS

53In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of __________ ?

A.Calculations

B.Formulas

C.Functions

D.Relative addressing

easyFPSCNTS

54Microsoft Excel 2019 files have a default extension of___________?

A..Xlsx

B..Xls

C..excel

D..123

easyFPSCNTS

55In a computer spreadsheet, block of cells is called __________ ?

A.Workbook

B.Function

C.Column

D.Range

easyFPSCNTS

56What displays the content of active cell?

A.Name box

B.Row headings

C.Formula bar

D.None of these

easyFPSCNTS

57Which function calculates the largest value in a set of numbers in Excel?

A.Average

B.Count

C.Minimum

D.Maximum

easyFPSCNTS

58User developed instruction for excel are called__________?

A.Progrms

B.Macros

C.Procedured

D.All of these

easyFPSCNTS

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

A.10

B.100

C.300

D.500

easyFPSCNTS

60In 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.

easyFPSCNTS

Pageof 26

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