PPSCFPSCNTSPakistan govt jobs
- Subject
- Microsoft Excel Mcqscomputer-mcqs › microsoft-excel-mcqs
- Published
- 16 Nov 2021
- Last updated
- 28 May 2026
Explanation
Obtaining data from a cell in a different worksheet is known as referencing, which allows one sheet to use information stored in another.
More Microsoft Excel Mcqs
Practice related questions from the same subject.
- 1.How many predefined margin settings are available by default in MS Excel?
- 2.Which feature allows you to divide the text in a single column into multiple columns in a spreadsheet?
- 3.Which feature in MS Excel enables you to assign custom names to cells or ranges in formulas without relying on selection?
- 4.In MS Word, the "Justify" alignment adjusts text to align evenly on both the left and right margins. How does the "Justify" alignment function in MS Excel?
- 5.Which keyboard shortcut allows you to jump directly to the last row in an Excel worksheet?
- 6.In MS Excel 2016, what is the label of the final column in a worksheet?
- 7.In Microsoft Excel, given a list of sales figures in column A, which formula will accurately return the second largest distinct value from that list?
- 8.In Microsoft Excel, which function is used to eliminate extra spaces from a text string, leaving only single spaces between words?
More in Computer Mcqs