Which is not spreedsheet package? Options: a) Lotus b) Excel c) Quatro pro d) All of the above Correct Answer: d) All of the above This question was asked from MS Excel chapter and requested for the answer here by Mukesh khadka. Thank you Mukesh for the question. Please continue reading for correct answer and explanation.

## Which of the following formulas will Excel Not be able to calculate?

Which of the following formulas will Excel Not be able to calculate? Options: a) =SUM(Sales)-A3 b) =SUM(A1:A5)*.5 c) =SUM(A1:A5)/(10-10) d) =SUM(A1:A5)-10 Correct Answer: c) =SUM(A1:A5)/(10-10) This question was asked from MS Excel chapter and requested for the answer here by Yam Shrestha from Parbat. Thank you Yam for the question. Please continue reading for correct […]

## Which of the following is not an MS-Excel built-in function?

Which of the following is not a MS-Excel built in funtion? Options: a) PI b) AVG c) RAND d) RANDBETWEEN This question was asked from MS Excel chapter and requested for the answer here by Laxmi Pujara

## Excel file cannot be exported to ……..format.

Question: Excel file cannot be exported to ……..format. Options: a) DOC b) CSV c) XML d) HTML This question was asked from MS Excel chapter and requested for the answer here by Karishma

## How many characters can be typed in a single cell in Excel?

Question: How many characters can be typed in a single cell in Excel? Options: a) 256 b) 1024 c) 32000 d) 65535 This question was asked from MS Excel by Janak

## Which function is used to calculate depreciation, rates of return, future values and loan payment amounts

This question “Which function is used to calculate depreciation, rates of return, future values and loan payment amounts A) Logical B) Math & Trigonometry C) Statistical D) Financial” is asked from Spreadsheet Calculation System topic and more specifically, it is from Excel Functions and Formula.The question was asked in Computer Operator Examination conducted by Public […]

## When integrating word and excel, word is usually the ……

The question “When integrating word and excel, word is usually the …. A. Server B. Destination C. Client D. Both b and c” is asked from MS Office Applications and more specifically, it is from Mail Merge Operation.This question is asked many times in Computer Operator Examination conducted by Public Service Commission and is still […]

## Multiple calculations can be made in a single formula using …

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