Microsoft Excel - gkquestionsguru.com

11.	The active cell:
a.	Is defined by a bold border around the cell
b.	Receives the data the user enters
c.	It is the formula bar
d.	Only A and B Option “D” is correct. An active cell is a rectangular box that highlights (a bold border around) the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.

12.	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 Option “D” is correct. Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts. A list of Excel Financial Functions in Excel are: ⇒Investment value functions including 1. FV 2. FVSCHEDULE 3. NPV 4. PV 5. RECEIVED 6. XNPV ⇒Internal rate of return functions including 1. IRR 2. MIRR 3. XIRR ⇒Asset depreciation functions including 1. AMORDEGRC 2. AMORLINC 3. DB 4. DDB 5. SLN 6. SYD 7. VDB ⇒Payment functions including 1. CUMIPMT 2. CUMPRINC 3. IPMT 4. ISPMT 5. PMT 6. PPMT ⇒Dollar conversion including 1. DOLLARDE 2. DOLLARFR ⇒Yield functions including 1. YIELD 2. YIELDDISC 3. YIELDMAT 4. ODDFYIELD 5. ODDLYIELD 6. TBILLEO 7. TBILLYIELD ⇒Price functions including 1. PRICE 2. PRICEDISC 3. PRICEMAT 4. ODDFPRICE 5. ODDLPRICE 6. TBILLPRICE

13.	B7:B9 indicates:
a.	Cells B7 and cell B9 only
b.	Cells B7 through B9
c.	Cell B8 only
d.	None of the above Option “B” is correct. B7:B9 indicates a range of cell between Cells B7 through B9.

14.	The Cancel and Enter buttons appear in the:
a.	Title bar
b.	Formula bar
c.	Menu bar
d.	Sheet tabs Option “B” is correct. Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.

15.	Which of the following methods cannot be used to enter data in a cell?
a.	Pressing an arrow key
b.	Pressing the Tab key
c.	Pressing the Esc key
d.	Clicking on the formula bar Option “C” is correct. Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it’s original state.

16.	Which of the following is not a basic step in creating a worksheet?
a.	Save workbook
b.	Modifiy the worksheet
c.	Enter text and data
d.	Copy the worksheet Option “D” is correct. Copy the worksheet is not a basic step in creating a worksheet.

17.	How do you select an entire column?
a.	Select Edit > Select > Column from the menu
b.	Click the column heading letter
c.	Hold down the shift key as you click anywhere in the column
d.	Hold down the Ctrl key as you click anywhere in the column Option “B” is correct. To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

18.	How can you print three copies of a workbook?
a.	Select File > Properties form the menu and type 3 in the Copies to print text box
b.	Select File > Print from the menu and type 3 in the Number of copies text box
c.	Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
d.	Press Ctrl+P+3 Option “B” is correct. Select File > Print from the menu and type 3 in the Number of copies text box

19.	To create a formula, you first:
a.	Select the cell you want to place the formula into
b.	Type the equals sign (=) to tell Excel that you’re about to enter a formula
c.	Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d.	Choose the new command from the file menu Option “B” is correct. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

20.	To center worksheet titles across a range of cells, you must-
a.	Select the cells containing the title text plus the range over which the title text is to be centered
b.	Widen the columns
c.	Select the cells containing the title text plus the range over which the title text is to be enfettered
d.	Format the cells with the comma style Option “A” is correct. Select the cells containing the title text plus the range over which the title text is to be centered

Pages: 1 2 3 4 5 6 7

Jayakrishna sahu
3 May 2024 at 14:36

Appcation is a great of humanlife
Diane.G
13 July 2024 at 08:00

Very interesting details you have noted, thank you for posting.Raise blog range
Long Herold
10 October 2024 at 19:37

Some really choice content on this site, saved to favorites.
bij nl
14 November 2024 at 09:24

Hey! Do you know if they make any plugins to assist with Search Engine Optimization? I’m
trying to get my website to rank for some targeted keywords but I’m not seeing very good success.
If you know of any please share. Cheers! I saw similar text
here: Eco bij