MS Office & Productivity

505 MCQs

Exam-focused practice

AI Explanations

Learn after each answer

Free Forever

No subscription needed

Showing Q 61–80 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.

View MCQs

61What is a cell in Excel?

A.A row

B.A column

C.A unit of data

D.A unit of formatting

easyFPSCNTS

Full Page

62Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

A.Decoration

B.Data appearance

C.Functions

D.Charting

easyFPSCNTS

Full Page

63Which of following is not an element of computer spreadsheet interface?

A.Pencil work

B.Active cell

C.Menu bar

D.Workbook

easyFPSCNTS

Full Page

64in MS-Excel__________ short cut key is used for hiding rows.

A.Ctrl+H

B.Ctrl+7

C.Ctrl+9

D.None of the above

easyFPSCNTS

Full Page

65Title bar in MS-Excel displays name of the __________ ?

A.Worksheet

B.Workbook

C.Formula

D.Location

easyFPSCNTS

Full Page

66What is the intersection of a column and row called in Excel?

A.A cell

B.A range

C.A column header

D.A row header

easyFPSCNTS

Full Page

67What is the function of the SUM function in Excel?

A.To add up a range of cells

B.To find the average of a range of cells

C.To count the number of cells in a range

D.To find the maximum value in a range of cells

easyFPSCNTS

Full Page

68What is the function of the IF function in Excel?

A.To perform a logical test and return a value based on the result

B.To add up a range of cells

C.To find the average of a range of cells

D.To count the number of cells in a range

easyFPSCNTS

Full Page

69What is the function of the VLOOKUP function in Excel?

A.To perform a vertical lookup and return a value based on a specified criteria

B.To perform a horizontal lookup and return a value based on a specified criteria

C.To add up a range of cells

D.To find the average of a range of cells

easyFPSCNTS

Full Page

70To insert chart in MS Excel, which shortcut key used?

A.Alt+F1

B.F2

C.F3

D.F4

easyFPSCNTS

Full Page

71Default file name in MS Excel is?

A.Document 1

B.Workbook 1

C.Book1

D.Worksheet

easyFPSCNTS

Full Page

72Maximum zoom percentage in Excel is _________?

A.100%

B.300%

C.400%

D.500%

easyFPSCNTS

Full Page

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

A.File

B.Insert

C.Design

D.None of Above

easyFPSCNTS

Full Page

74What are the small squares arranged in rows and columns called in Excel?

A.Cells

B.Columns

C.Blocks

D.Rows

easyFPSCNTS

Full Page

75What does the term “filter” refer to in Excel?

A.To permanently delete rows or columns

B.To format the appearance of cells

C.To temporarily hide certain data based on specific criteria

D.To create a chart

easyFPSCNTS

Full Page

76In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?

A.Length

B.Counter

C.Count

D.None of These

easyFPSCNTS

Full Page

77In Excel, Conditional formatting is in: ______________?

A.Insert Tab

B.Page layout

C.View Tab

D.Home Tab

easyFPSCNTS

Full Page

78What is the function of Vlookup formula in Excel ?

A.VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value.

B.VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value.

C.VLOOKUP returns a value from the same row as the lookup value, but from a column specified by the user.

D.VLOOKUP scans the entire table and returns the first value found that matches the lookup criteria.

easyFPSCNTS

Full Page

79In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

A.TRIM

B.SUBSTITUTE

C.CLEAN

D.REPT

easyFPSCNTS

Full Page

80In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

A.=LARGE(A:A, 2)

B.=LARGE(UNIQUE(A:A), 2)

C.=INDEX(SORT(UNIQUE(A:A), , -1), 2)

D.=SMALL(UNIQUE(A:A), 2)

easyFPSCNTS

Full Page

Pageof 26

MS Office & Productivity

Practice MS Office & Productivity MCQs

Ready to Test?