Question:Which function do you use to return the remainder after a number is divided by a divisorOptions:a. Round()b. FACT()c. MOD()d. DIV() Correct Answer c. MOD() Show Your Love! Share this page! Share0 Share +10 Tweet0 Pin0 Share0 This question “Which function do you use to return the remainder after a number is divided by a […]

## The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is

This question “The cell reference for a range of cells that starts in cell B1 and goes over to column E and down to row 10 is a) B1:E9 b) B1-E9 c) B1:E10 d) B1-E10” is asked from MS Excel topic and more specifically, it is from Naming Cells and Ranges.The question was asked in […]

## Which of the following is not an example of a value in Excel?

This question “Which of the following is not an example of a value in Excel? a. 721 b. May 13, 2018 c. 43% d. Serial number 43” is asked from Spreadsheet Calculation Systems topic and more specifically, it is from MS Excel Data Types.The question was asked in Computer Operator Examination conducted by Public Service […]

## Which function in Excel tells how many numeric entries are there?

This question “Which function in Excel tells how many numeric entries are there? a. NUM b. CHKNUM c. SUM d. COUNT” is asked from MS Excel topic and more specifically, it is from MS Excel Functions.The question was asked in Computer Operator Examination conducted by Public Service Commission in 2074 for Nagarik Lagani Kosh (Civil […]

## In MS Excel, getting data from a cell located in a different sheet is called

This question “In MS Excel, getting data from a cell located in a different sheet is called … a) Accessing b) Updating c) Referencing d) Functioning” was asked in Computer Operator Examination of 2074 conducted by PSC.The question is about general introduction to spreadsheets and MS Excel. More specifically, it aims to test candidates knowledge […]

## The formula “=T(value)” is used to check whether a value is…

The formula “=T(value) ” is used to check whether a value is a)Text (b) number (c) line chart (d) trueThis question was asked in written examination for Assistant Computer Operator Examination of 2017 conducted by Public Service Commission.The question is asked from Spreadsheet Calculation portion of the syllabus and MS Excel is the prescribed application.It aims […]