Question:Multiple calculations can be made in a single formula usingOptions:A. standard formulasB. array formulaC. complex formulasD. smart formula Correct Answer B. array formula Show Your Love! Share this page! Share0 Share +10 Tweet0 Pin0 Share0 This question “Multiple calculations can be made in a single formula using … A. standard formulas B. array formula C. […]

## You can group noncontiguous worksheets with

Question:You can group noncontiguous worksheets withOptions: check A. The Alt + Enter key check B. The Ctrl key and mouse check C. The Shift key and the mouse check D. The group button on the standard toolbar Correct Answer B. The Ctrl key and mouse This question “You can group noncontiguous worksheets with … A. […]

## Which function do you use to return the remainder after a number is divided by a divisor?

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 […]

## to calculate the average of three cells A1, A2 and A3, you can use the following formula

Question:To calculate the average of three cells A1, A2 and A3, you can use the following formulaOptions: check a) =AVERAGE(A1:A3) check b) = AVERAGE(A1, A2, A3) check c)Both and b check d) None of the above Correct Answer c)Both and b Show Your Love! Share this page! Share0 Share +10 Tweet0 Pin0 Share0 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

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 […]

## What do you mean by Workspace?

This question “What do you mean by Workspace? a. Group of Columns b. Group of Worksheets c. Group of Rows d. Group of Workbooks” is asked from Spreadsheet Calculation System topic and more specifically, it is from MS Excel Workspace.The question was asked in Computer Operator Examination conducted by Public Service Commission in 2074 for […]

## What type of chart is useful for comparing part of a whole?

This question “What type of chart is useful for comparing part of a whole? a. Pie chart b. Column chart c. Line chart d. Dot graph” is asked from MS Excel and more specifically, it is from MS Chart.The question was asked in Computer Operator Examination conducted by Public Service Commission in 2074 for Civil […]

## In MS Excel concatenation of text can be done using …

This question “In MS Excel concatenation of text can be done using… a. Apostrophe b. Exclamation c. Hash d. Ampersand” is asked from Spreadsheet Calculation topic and more specifically, it is from Excel Operators & Functions.The question was asked in Computer Operator Examination conducted by Public Service Commission in 2074 for Sushil Koirala Memorial Cancer […]

## 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 […]

## In MS Excel concatenation of text can be done using

This question “In MS Excel concatenation of text can be done using … a) Apostrophe b) Exclamation c) Hash d) Ampersand” is from Computer Operator Examination Question paper of 2074 conducted by PSC.The question aims to test candidates knowledge about text operators available on MS Excel. Among the few text operators, it is related to […]

## What would be the result if you type =A1=B1 in cell C1

This question “What would be the result if you type =A1=B1 in cell C1?” was asked in Computer Operator Examination of 2074 conducted by Public Service Commission PSC. The question was asked from Spreadsheet Calculation (Excel) and aims to test the candidate’s knowledge about Excel Formula. Being more specific, it is about cell references. Show […]

## 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 […]