Advance Excel /50 4 Quiz Enrollment No.Name 1 / 50 The advantage of using a spreadsheet is: calculations can be done automatically. changing data automatically updates calculations more flexibility all of the above 2 / 50 You can print only an embedded chart by Moving the chart to a chart sheet before you print Formatting the chart before you print Selecting the chart before you print a and c 3 / 50 which do you press to enter the current date in a cell? Ctrl + Shift + Ctrl + ; Ctrl + F10 All of above 4 / 50 It is acceptable to let long text flow into adjacent cells on a worksheet when Data will be entered in the adjacent cells No data will be ente4red in the adjacent cells There is no suitable abbreviation for the text There is not time to format the text 5 / 50 When the formula bar is activated, you can see The Edit Formula button The Cancel button The Enter button All of above 6 / 50 You can merge the main document with data source in Excel. In mail mergeoperation, Word is usually server source client none 7 / 50 If cell A1 contains 50 and B1 contains 20, what will =A1-B1 return? 30 -30 70 0 8 / 50 a fast way to add up this column of number is to click in the cell below the numbersand then: click subtotals on the data menu view the sum in the formula bar click the autosum button on the standard toolbar, then press enter all of above 9 / 50 Which function converts miles to kilometers, kilograms to pounds, and so on? Convert Product Change All of above 10 / 50 To copy cell contents using drag and drop, press the End key Shift key Esc key None of above 11 / 50 What happens if you remove the check mark from Row & Column headers onOptions dialog box? This will remove row headings and column headings of your data This will remove the column headings (A, B, C, This will remove row and column heading of chart This will remove row and column heading of table 12 / 50 you can use the formula palette to format cells containing numbers create and edit formulas containing functions entered assumptions data copy a range of cells 13 / 50 To edit data in an embedded Excel worksheet object in a Word document Use the Excel menu bar and toolbars inside the word application Edit the hyperlink Edit the data in a Excel source application Use the Word menu bar and toolbars 14 / 50 A user wishes to remove a spreadsheet from a workbook. Which is the correctsequence of events that will do this? Go to File-Save As – Save As Type – Excel worksheet Right click on the spreadsheet tab and select DELETE Right click on the spreadsheet and select Insert – Entire Column None of above 15 / 50 To name a constant, you use the …… dialog box Create names Define name Paste name Format cells 16 / 50 You can quickly change the appearance of your work by choosing Auto Format fromthe …. Menu Edit View Format Tools 17 / 50 The auto calculate feature Can only add values in a range of cells Provides a quick way to view the results of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet a and c 18 / 50 Which of the cell pointer indicates that you can fill series? Doctor’s symbol (Big Plus) small thin plus icon Mouse Pointer with anchor at the tip None of above 19 / 50 To open an existing workbook, you can click the Open button on the …… toolbar. Drawing Formatting Forms Standard 20 / 50 A ….. is a group of cells that form a rectangle on the screen. Calculation Formula Range Range address 21 / 50 Which of the following is a correct order of precedence in a formula calculation? Multiplication and division, exponential positive and negative value Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation None of above 22 / 50 What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chartreport if the source data chas changed Format Report Pivot Table Refresh Data Show Detail 23 / 50 Which of the following will not set text in selected cells to italics? Pressing Ctrl + I on the keyboard Using the Tools – Wizard – Web Form menu item Using the Format – Cells – Font menu item None of the above 24 / 50 Documentations should include Destination and users of the output data Source of input data Information on the purpose of the workbook All of above Correct Answer 25 / 50 You can use the formula pallette to format cells containing numbers create and edit formula containing functions enter assumptions data copy a range of cells 26 / 50 By default the cell pointer moves down when you press Enter. From where can youchange this setting? Tools >> Options >> View tab Tools >> Options >> Calculation tab Tools >> Options >> Edit tab Tools >> Options >> Transition tab 27 / 50 Which of the following is not an option in the spelling dialog box? Edit Ignore Ignore all Change 28 / 50 Which formula can add the all the numeric values in a range of cells, ignoring thosewhich are not numeric, and place the resulting a differene cell Count Average Sum None of above 29 / 50 To drag a selected range of data to another worksheet in the same workbook, usethe Tab key Alt key Shift key Ctrl key 30 / 50 You can open the consolidate dialog box byt choosing Consolidate from the …..menu. Insert Format Tools Data 31 / 50 To select an individual data marker or data label, you must Double click the data series Right click selected marker Click once to select the series markers or labels and click the desired marker or label again Double click the marker or label 32 / 50 If you press ……, the cell accepts your typing as its contents. Enter Ctrl+Enter Tab Insert 33 / 50 The cell reference fro a range of cells that starts in cell B1 and goes over to columnG and down to row 10 is…… B1-G10 B1.G10 B1;G10 B1:G10 34 / 50 You can create hyperlinks from the Excel workbook to A webpage on company internet A web page on the internet Other Office 97 application documents All 35 / 50 The accounting style shows negative numbers in Bold Brackets Parentheses Quotes 36 / 50 Each excel file is called a workbook because It can contain text and data It can be modified It can contain many sheets including worksheets and chart sheets You have to work hard to create it 37 / 50 Which of these is a quick way to copy formatting from a selected cell to two othercells on the same worksheet? Use Ctrl to select all three cells, then click the paste button on the standard toolbar Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to All of above 38 / 50 Rounding errors can occur When you use multiplication, division or exponentiation in a formula When you use addition and subtraction in a formula Because Excel uses hidden decimal places in computation When you show the results of formulas with different decimal places than the calculated results 39 / 50 To hold row and column titles in places so that they do not scroll when you scroll aworksheet, click the Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu 40 / 50 What happens when you press Ctrl + X after selecting some cells in Excel? The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up 41 / 50 which of the following special function keys allow the content in cell esc shift return Tab 42 / 50 You can copy cell formats from one cell to another by using the Backspace key Default font Format painter Formatting toolbar 43 / 50 You can use the drag and drop method to Copy cell contents Delete cells contents Add cell contents All of above 44 / 50 Tab scroll buttons are place on Excel screen towards the bottom right corner towards the bottom left corner towards the top right corner towards the top left corner 45 / 50 A function inside another function is called a ….. function Nested Round Sum Text 46 / 50 To balance your checkbook in Excel, your best method is Copy your check amounts into Excel so that you’ll have a neat printout to work on Use Excel to check your arithmetic Download the Checkbook register templates from Templates on Microsoft Office Online All of above 47 / 50 The default font used in Excel is Arial Algerial Times New Roman Preeti 48 / 50 Which of the following can not be hidden from Tools >> Options then View tab? Startup Task Pane Formula bar Status bar Scroll Bar 49 / 50 You can select a single range of cells by Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells Pressing the Shift key and an arrow key Dragging over the desired cells 50 / 50 What function displays row data in a column or column data in a row? Hyperlink Index Transpose Rows Your score is LinkedIn Facebook Twitter VKontakte 0% Facebook WhatsApp Twitter
