ADVANCED EXCEL FUNCTIONS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 When you insert an excel file into a word document. The data are Hyperlinked placed in a word table Linked Embedded Use the word menu bar and tool bars You want to track the progress of the stock market on a daily basis. Which type of chart you use? Pie chart Row chart Line chart Column chart What type of chart will you use to compare performance of sales of two products? Column chart Line chart Pie chart Both A and B Which of following functions MS-Excel have 1 SUM 2 CONCATENATE? Only 1 Only 2 None of 1 and 2 Both 1 and 2 Comments put in cells are called? Smart tip Cell tip Web tip Soft tip A function inside other function is called Nested Function Round Function Inner Function None of the above Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used with only two columns in the array. VLookup Now Lookup CountIf This is created from the row or columns headings in the data. A category describes what is shown in the chart Category axis Data series Value axis Data marker Which of the following is an example of text in a spreadsheet? 2763 Sales 1994 1995 =A1+A2+A3 .=sum (A1+A2+A3) What is the keyboard shortcut for creating a chart from the selected cell range? F2 F4 F8 F11 What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"? Count CountA IF SUM Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns Headings Speed None Shows the values on the chart. Excels creates a range of values based on the data Row headings Gridlines Category axis Value axis The NOW function calculates the difference in days between two dates. True False How will you graphically represent expenditure in different departments ? Column Chart Line Chart Pie Chart Dot Chart When you insert an Excel file into a Word document, the data are Hyperlinked Placed in a word table Linked Embedded What term refers to a specific set of values saved with the workbook? Range Scenario Trend line What-if analysis In MS-Excel Comments put in cells are called Smart tip Cell tip Web tip None of these IF Statement can be written to carry out an action True False A chart that displays on the same worksheet as the data graph Value axis Gridline Embedded chart Getting data from a cell located in a different worksheet is called? Accessing Referencing Updating Functioning This is an optional for the chart’s categories Category title legend graph title embedded chart Which would you choose to create a bar diagram? Edit, chart Insert, chart Tools, chart Format, chart What function will result in the total number of entries in the cell range B5 to B14 Count MAX MIN SUM What type of chart is good for single series of data? Column Chart Line Chart Pie Chart Cone Chart You can select the current row in MS-Excel Worksheet by pressing? Ctrl + Space bar F8 + arrow key Shift + arrow key Shift + Space bar You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None Which function is used to return the number of cells in a range that meet a condition set forth in the formula? Lookup VLookup NOW CountIF This is an optional for the chart’s categories Category title legend graph title embedded chart which element of a worksheet can be protected from accidental modification Contents Objects Scenarios All of the above Previous Next Total Question16 Wrong Answer13 Right Answer13
