Posted on October 28, 2020January 6, 2021 by Rabiul IslamMS Excel Test 0% 17 Created on October 28, 2020 MS Excel Test Welcome to MS Excel Test. Please attend the quiz in a quite place and with a stable internet connection. An use of unauthorized medium or any unfairness will violate the exam policy. 1 / 25 Category: Uncategorized Q1: To select an entire column in MS-EXCEL, press? CTRL+ C CTRL + Arrow key CTRL + S None of the above 2 / 25 Category: Uncategorized Q2: Which is not the function of “Edit, Clear” command? Delete contents Delete notes Delete cells Delete formats 3 / 25 Category: Uncategorized Q3: What does COUNTA () function do? count cells having alphabets counts empty cells count cells having numbers counts non-empty cells 4 / 25 Category: Uncategorized Q4: In the formula, which symbol specifies the fixed columns or rows? $ * % & 5 / 25 Category: Uncategorized Q5: Which would you choose to create a bar diagram? Edit, Chart Insert, chart Tools, chart Format, chart 6 / 25 Category: Uncategorized Q6: Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Math & Trigonometry Statistical Financial 7 / 25 Category: Uncategorized Q7: What is the correct way to refer the cell A10 on sheet3 from sheet1? sheet3!A10 sheet1!A10 Sheet3.A10 A10 8 / 25 Category: Uncategorized Q8: We can save and protect the workbook by Write preservation Password Protection password Read-only recommended Any of the above 9 / 25 Category: Uncategorized Q9: You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use? New Save As Edit Save 10 / 25 Category: Uncategorized Q10 To record a sequence of keystrokes and mouse actions to play back later we use: Media player Sound recorder Calculator Macro recorder 11 / 25 Category: Uncategorized Q11: In order to perform a calculation in a spreadsheet, you need to use a: Table Formula Field Variable 12 / 25 Category: Uncategorized Q12 A function inside another function is called _______ Nested function Round Function Sum function Text function 13 / 25 Category: Uncategorized Q13: A features that displays only the data in column (s) according to specified criteria Formula Sorting Filtering Pivot 14 / 25 Category: Uncategorized Q14: In Excel 3-D reference in a formula Cannot be modified Only appears on summary or worksheet Limits the formatting options Spans worksheet 15 / 25 Category: Uncategorized Q15 In MS-Excel numeric value can be treated as a label value if it precedes with Apostrophe (‘) Exclamation (!) Hash (#) None of these 16 / 25 Category: Uncategorized Q16: ____ returns the least common multiple. LCCM() LCM() TLCM() RTLCM() 17 / 25 Category: Uncategorized Q17: This is not a function category in Excel. Logical Text Financial Data series 18 / 25 Category: Uncategorized Q18: Typed text showed in active cell and also in ___ Formula bar Ribbon Title bar Scroll bar 19 / 25 Category: Uncategorized Q19: Excel documents are stored as files called Workgroups Worktables Worksheets Workforce 20 / 25 Category: Uncategorized Q20: What refers to the horizontal cells which can contain information? Ribbon Rows Columns Horizontal scrollbar 21 / 25 Category: Uncategorized Q21: To minimize the currently selected window, press Ctrl+ F11 Ctrl+ F12 Ctrl+ F9 Ctrl+ F10 22 / 25 Category: Uncategorized Q22: Which of the following is the comparison operator? * ^ = + 23 / 25 Category: Uncategorized Q23: Workbook is a collection of Worksheets Page set-up Buttons Diagrams 24 / 25 Category: Uncategorized Q24: Which Excel feature enables predefined layouts to selected tables in the worksheet? Autograph Autoformat Header and Footer Spelling and Grammar 25 / 25 Category: Uncategorized Q25: Which function displays row data in a column or column data in a row? Rows Transpose Hyperlink Index Your score is The average score is 35% LinkedIn Facebook Twitter VKontakte 0% Restart quiz