MS EXCEL TEST 0% 0 votes, 0 avg 0 MS EXCEL Quiz MS EXCEL TEST 1 / 50 Which of the following is not a valid Zoom percentage in Excel? 10 100 300 500 MS Excel provide zoom levels from 10 to 400, so 500% is not a valid zoom level in MS Excel. 2 / 50 The default style for new data keyed in a new workbook is ___________? Comma Normal Currency Percent By Default, MS Excel accepts data as NORMAL/GENERAL in each cell. Butyou can change it later 3 / 50 Which of these keys are used in MS Excel to copy value from above cell? Ctrl + “ Ctrl+ E Ctrl+ E Ctrl+ D CTRL + D is used to copy the content of above cell in below cell. Where as CTRL+R is used to copy the content of left cell in right cell. 4 / 50 Functions and formulas in MS Excel must begin with ___ () sign Equal Sign Plus Sign > Sign Functions and formulas in MS Excel must begin with equal ( = ) Sign 5 / 50 Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them. 6 / 50 In MS-Excel__________ short cut key is used for hiding rows. Ctrl+H Ctrl+7 Ctrl+9 None of the above There a re various keys to do this task 1. CTRL+9 is used to hide selected Rows. 2. CTRL + SHIFT + ( is also used to hide the selected rows. 7 / 50 What do you use to create a chart? Pie Wizard Excel Wizard Data Wizard Chart Wizard Chart Wizard is an easy way to create beautiful and attractive charts. 8 / 50 Which of the following is the latest version of MS Excel? Excel 2016 Excel 2017 Excel 2019 Office 365 Latest Version of MS Excel is Excel 2019. 9 / 50 Which of the following you can paste selectively using Paste Special Command? Validation Formats Formulas All of above The Paste Special command in Microsoft Excel selectively pastes validation, formats, formulas, comments 10 / 50 In a computer spreadsheet, block of cells is called __________ ? Workbook Function Column Range When we select multiple cell at same time this block of cell is known as Cell Range. 11 / 50 Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ? Decoration Data appearance Functions Charting To generate a chart from data in ms excel is called charting. 12 / 50 How many rows are in one Microsoft Excel sheet? 65,536 16,384 1,048,576 None of Above in MS Excel 2007 and above there are 1048576 Rows 13 / 50 What type of chart is useful for comparing parts of a whole? Pie Chart Column Chart Line Chart Dot Graph Pie chart is useful for comparing parts of a whole. 14 / 50 Which function calculates the largest value in a set of numbers? Average Count MIN MAX MAX() Function is used to find the largest value in set of values in MS Excel 15 / 50 What type of chart is good for single series of data? Column Chart Line Chart Pie Chart Cone Chart Bars (or columns) are the best types of graphs for presenting a single data series. 16 / 50 When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted. 17 / 50 Which of the following will not enter data in a cell? Pressing the Esc key Pressing the Tab Key Both of these None of above Precessing escape key in ms excel, the data entry will be cancelled and data will not be entered in cell. 18 / 50 If you press ___, the cell accepts your typing as its -contents? Tab Ctrl+Enter Enter Alt+Enter Enter Button is used to make the MS Excell accept its contents entered in a cell. 19 / 50 In MS Excel to delete duplicate values which Tab is used? Data Review View Insert There is a remove duplicate option in Data Tab which can be used to remove duplicate values in a sheet. 20 / 50 To open an existing workbook, click the open button on the ___________ toolbar? form standard Drawing Formatting To open an existing file, we can use open icon in standard tool bar on the other hand we also can use CTRL+ O short Key for same purpose. 21 / 50 How can you remove borders applied in cells? Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none) Both of above None of above On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button. 22 / 50 How many columns are in one Microsoft Excel sheet? 65,536 16,384 1,048,576 None of Above in MS Excel 2007 and above there are 16384 Columns and 1048576 Rows 23 / 50 Statistical calculations and preparation of tables and graphs can be done using Adobe Photoshop Excel Notepad Power Point Statistical calculations and preparation of tables and graphs can be done by using MS Excel. 24 / 50 In a computer spreadsheet, each cell contain a __________ ? Label Value Formula All of these In MS Excel, a Cell can contain Lable, value, formula or function. 25 / 50 Ctrl+Shift+1 shortcut Key in excel are used to __________? Format number in comma format Format number in currency format Format number in date format Format number in time format Ctrl+Shift+1 shortcut Key in excel is used to format number in comma format 26 / 50 Which of the following is invalid statement? Sheet tabs can be colored Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically The width of a row and be specified manually or fit automatically is invalid statement. 27 / 50 In a computer spreadsheet rows are labeled ________ ? by letters by numbers by cell references by symbols In MS Excell, Rows are labeled with numbers. It starts from 1 and ends up on 1048576. You can use CTRL+Down Arrow to check last line number. 28 / 50 Actual working area of Computer’s Microsoft Excel is ________ ? Workbook Worksheet Note sheet Notebook Working area of MS excel workbook is called worksheet. 29 / 50 A features that displays only the data in column (s) according to specified criteria Formula Sorting Filtering Pivot Filtering is the feature that displays only the data in column(s) according to specified criteria. 30 / 50 In MS Excel Readymade templates are available under _______ tab? File Insert Design None of Above When considering Microsoft Word, Microsoft Excel, Microsoft Power Point, the templates are in file tab. 31 / 50 Which of these keys is used in MS Excel to copy formula from above cell? Ctrl+ ” Ctrl+ ; Ctrl+ : Ctrl+ ' CTL + ' (Apostrophe ) key is used in MS Excel to copy formula from above cell? 32 / 50 In excel columns are labeled as____________? A, B, C, etc. 1, 2, 3, etc. A1, A2, A3, etc. $A$1, $A$2, etc. Columns a are labeld as characters in MS Excel and Rows are labeled with numbers. 33 / 50 Main window in a computer spreadsheet is called ___________ ? Work book Work Account book Work sheet Workbook is the main window of MS Excel 34 / 50 How we can view a cell comment? position the mouse pointer over the cell click the comment command on the view menu click the edit comment commands on the Insert menu click the Display comment command on the window menu When we hover the pointer on a cell MS Excel show the contents in a celltip 35 / 50 Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell. 36 / 50 Which of these will not select all the cells in a document? Using the Edit – Select All menu Pressing Ctrl + A on the keyboard Clicking three times with the right mouse button in the spreadsheet None of These Clicking three times with the right mouse button in the spreadsheet is not a valid shortcut in MS Excel. 37 / 50 What type of chart will you use to compare performance of two employees in the year 2016 ? Column Chart Bar Chart Pie Chart Dot Chart For comparisons, bar charts are useful. Bar graphs are used to compare two groupings of data or to follow changes over time. So, Bar charts can be used to compare the performance of two employees in the year 2016 38 / 50 Comment put on Excel cell which is displayed by taking the Mouse Pointer there, is called__________? Smart tip Soft Tip Web Tip Cell Tip when we place mouse over a cell having comments, a small box appeared which contains comments this box is called tooltip. 39 / 50 Excel displays the current cells address in the __________? Formula bar Status bar Name box Title bar Name box in MS Excel is used to display the address of currently selected cell. 40 / 50 Which function in Excel checks whether a condition is true or not? SUM COUNT IF AVERAGE If is a condition based function and performs an action if the given condition is true and igrnone if the condition is false. 41 / 50 Title bar in MS-Excel displays name of the __________ ? Worksheet Workbook Formula Location Title bar contains name of both file and program. As MS Excel file is called Workbook. So we can say that title bar contains the name of workbook. 42 / 50 What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph Column Chart is useful for comparing values over categories. 43 / 50 Move to next cell in row in MS Excel: Tab Shift Space None of these Pressing Tab key, Conteol will move to the next cell in worksheet. 44 / 50 What is maximum zoom level in MS Excel. 10 100 300 400 MS Excel provide zoom levels from 10 to 400. 45 / 50 The Greater Than sign is an example of ________ operation? Arithmetic Logical Conditional Greater The Greater Than sign is an example of logical operation 46 / 50 To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called? Pivot Table Report Pivot Table List Pivot Table Field List HTML Pivot Table Report can be used to create an interactive Pivot Table for the web. 47 / 50 Getting data from a cell located in a different sheet is called ___________? Accessing Referencing Updating Functioning Getting data from a cell located in a different sheet is called reffering. We use cell reference to get data from other cells in ms excel. 48 / 50 You can edit existing Excel data by pressing the: ________ key? F1 Key F2 Key F3 Key F4 Key F2 Key is used to edit or rename in MS Windows environment. 49 / 50 Which of following is not an element of computer spreadsheet interface? Pencil work Active cell Menu bar Workbook MS Excel is a accounting based sofware and pencil work is not a valid option in it. 50 / 50 The ____ feature of MS Excel quickly completes a series of data Auto Complete Auto Fill Fill Handle Sorting Auto Fill is the feature of MS Excel which quickly completes a series of data. Your score is LinkedIn Facebook Twitter VKontakte