INDIA MCQ

Multiple choice questions (MCQ) of Government and Computer Networking | INDIA MCQ

You are here: Home / Home

Microsoft Excel Set-19

by Leave a Comment

“Qtr 1, Qtr 2, Qtr 3” is an example of aa. Formulab. Functionc. Seriesd. SyntaxYou can edit existing Excel data by pressing thea. F1 keyb. F2 keyc. F3 keyd. F4 keyThe cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….a. G1-G10b. B1.G10c. B1;G10d. B1:G10A user wishes to remove a spreadsheet from a workbook. Which is the … [Read more...]

Microsoft Excel Set-17

by Leave a Comment

A function inside another function is called a ….. function.a. Nestedb. Roundc. Sumd. TextHow should you print a selected area of a worksheet, if you’llwant to print a different area next time?a. On the file menu, point to print area, and then click set print area.b. On the file menu, click print, and then click selection under printwhatc. On the view menu, click custom views, … [Read more...]

Microsoft Excel Set-16

by Leave a Comment

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a resulta. IFb. ANDc. ORd. NOTMacros are “run” or executed from the ….. menu.a. Insertb. Frmatc. Toolsd. DataYou can open the consolidate dialog box byt choosing Consolidate from the ….. menu.a. Insertb. Formatc. Toolsd. DataEach excel file is called a workbook becausea. It can … [Read more...]

Microsoft Excel Set-15

by Leave a Comment

Charts tips cana. Show the formatting of a data labelb. Show the name of a data seriesc. Show the value of data pointd. b and cThe Name boxa. Shows the location of the previously active cellb. Appears t the left of the formula barc. Appears below the status bard. Appears below the menu barHow do you change column width to fit the contents?a. Single-click the boundary to the … [Read more...]

Microsoft Excel Set-14

by Leave a Comment

What term refers to a specific set of values saved with the workbook?a. Rangeb. Scenarioc. Trend lined. What-if analysisGot functions? No? You need the insert function dialog box. How do you get it?a. Right click a cell and then click insertb. Click the insert menu and then click functionc. Type = in a celld. All of the aboveWhich of the following describes how to select all … [Read more...]