ADVANCED EXCEL FUNCTIONS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 An array is a systematic arrangement of similar objects, usually in rows and columns. True False You can select the current Column in MS-Excel Worksheet by pressing? Ctrl + Space bar F8 + arrow key Shift + arrow key Shift + Space bar What type of chart will you use to compare performance of two employees in the year 2016 Column chart Line chart Pie chart Dot chart What type of chart is useful for showing trends or changes over time Pie chart Column chart Line chart Dot chart 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 When you insert an Excel file into a Word document, the data are Hyperlinked Placed in a word table Linked Embedded Shows the values on the chart. Excels creates a range of values based on the data Row headings Gridlines Category axis Value axis A features that displays only the data in column (s) according to specified criteria Formula Sorting Filtering Pivot In MS-Excel Comments put in cells are called Smart tip Cell tip Web tip None of these What type of chart is good for single series of data? Column Chart Line Chart Pie Chart Cone Chart What do you call the chart that slows the proportions of how one or more data elements relate to another data element. XY chart Line chart Pie chart Column chart The programming language in which Excel records the macro code is? Basic Visual basic Video Basic Basic2 What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph Getting data from a cell located in a different worksheet is called? Accessing Referencing Updating Functioning What function will result in the total number of entries in the cell range B5 to B14 Count MAX MIN SUM What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Location tabs Sheet tabs In MS-Excel value used in a formula that does not change is called a Cell address Constant Function None of these What term refers to a specific set of values saved with the workbook? Range Scenario Trend line What-if analysis 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 can select the current row in MS-Excel Worksheet by pressing? Ctrl + Space bar F8 + arrow key Shift + arrow key Shift + Space bar This is an optional for the chart’s categories Category title legend graph title embedded chart Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections. True False A function inside other function is called Nested Function Round Function Inner Function None of the above You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None 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 IF Statement can be written to carry out an action True False We can check the conditions against __________ when applying conditional formatting Cell value Formula Both of above None of above Which would you choose to create a bar diagram? Edit, chart Insert, chart Tools, chart Format, chart Which of the following is an example of text in a spreadsheet? 2763 Sales 1994 1995 =A1+A2+A3 .=sum (A1+A2+A3) Previous Next Total Question16 Wrong Answer13 Right Answer13
