Electronic Spreadsheet - Set 6
यस पेजमा प्रश्न 1–10 (कुल 50 मध्ये)। विकल्पमा थिचेर उत्तर दिनुहोस् — सही/गलत तुरुन्तै देखिन्छ।
- कुल प्रश्न50
- यो पेजमा10 (1–10)
- पृष्ठ1 / 5
- परीक्षा समय30 मिनेट
- जाँचतुरुन्तै
1.
A..........in Excel offers you different ways to view a set of figures, and allows you to switch between them quite easily ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. Scenario
2.
............In Excel is used to get a particular result when you're not too sure of the starting value?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: B. Goal seek
3.
Which of the following is not a statistical function in Excel?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: D. DSUM
4.
............calculates the interest paid during a specific period of an investment ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. IPMT
5.
.........function is used to calculate the amount paid as interest on a loan during a period of the lifetime of a loan or an investment ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: C. NPV
6.
In Excel financial function, PMT means?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: C. Payment
7.
In Excel financial function, NPER is?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: D. Number of Periods
8.
How do you rearrange the data in ascending or descending order ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. Data , Sort
9.
If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest) , which of the following would be the correct order of the list
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. Zip codes (ascending), then last name (ascending), then first name (ascending)
10.
To keep specific rows and columns from scrolling off the screen you first must position the cell pointer
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: D. both below and right of the row and column you want to remain on the screen
पृष्ठ 1 / 5 · प्रश्न 1–10 (कुल 50)

