Computer MCQ-19 Leave a Comment / By odishatutorial.com / 6 October 2023 MS Excel MCQ 1 / 30Whatsapp Group Join Telegram channel JoinExcel is a program that is used to prepare a (A) Slide presentation (B) Spreadsheet (C) Text document (D) Database 2 / 30What are the basic rectangular building blocks of a spreadsheet ? (A) Cells (B) Zoom slider (C) Help button (D) All of these 3 / 30Another name for a pre-programmed formula in Excel is (A) Cell (B) Graph (C) Function (D) Range 4 / 30Which of the following identifies a cell in Excel ? (A) Address (B) Formula (C) Name (D) Label 5 / 30----- appear at the bottom of the Excel window. (A) Title bar (B) Formula bar (C) Work sheet tabs (D) Name box 6 / 30What is the extension of saved file in MS Excel ? (A) .xls (B) .xks (C) .xos (D) .xbs 7 / 30Which term is used to join the selected cells in to one cell ? (A) Filter (B) Wrap (C) Pivot (D) Merge 8 / 30A formula in Excel always begins with an ----- (A) Equal sign (B) Colon (C) Comma (D) Space 9 / 30Which of the following Excel charts represents only one value for each variable ? (A) Bar (B) Pie (C) Line (D) Function 10 / 30A(n) ______ is a series of two or more adjacent cells in a column or row or rectangular group of cells. (A) List (B) Section (C) Range (D) Area 11 / 30What is the default row height of MS Excel ? (A) 10 (B) 12 (C) 13 (D) 15 12 / 30What refers to the horizontal cells which can contain information ? (A) Ribbon (B) Rows (C) Columns (D) Horizontal scrollbar 13 / 30Which bar show the used formula of selected active cell ? (A) Formula bar (B) Ribbon (C) Menu bar (D) Scroll bar 14 / 30Typed text showed in active cell and also in ---- (A) Formula bar (B) Ribbon (C) Title bar (D) Scroll bar 15 / 30How many columns are there in old version of MS Excel ? (A) 250 (B) 256 (C) 265 (D) 269 16 / 30To minimize the currently selected window, press (A) Ctrl+ F11 (B) Ctrl+ F12 (C) Ctrl+ F9 (D) Ctrl+ F10 17 / 30Which of the following is the default numbers of worksheet in MS Excel ? (A) 2 (B) 3 (C) 4 (D) 5 18 / 30To maximize the currently selected window, press (A) Ctrl+ F9 (B) Ctrl+ F10 (C) Ctrl+ F11 (D) Ctrl+ F12 19 / 30Formulas in Excel are made up of _____ (A) Arithmetical operators and functions (B) Only arithmetic operators (C) Only symbols (D) Only functions 20 / 30Which of the following is the comparison operator ? (A) * (B) ^ (C) = (D) + 21 / 30On an Excel sheet, the active cell is indicated by (A) A dark wide border (B) A dotted border (C) A blinking border (D) None of the above 22 / 30Workbook is a collection of (A) Worksheets (B) Page set-up (C) Buttons (D) Diagrams 23 / 30In a spreadsheet, a ------ is a number you will use in a calculation. (A) Value (B) Cell (C) Field (D) Label 24 / 30To display the save as dialog box, press (A) F2 (B) F3 (C) F5 (D) F12 25 / 30The result of a formula in a cell is the (A) Displayed value (B) Range (C) Value (D) Label 26 / 30Which of the following is an active cell in excel ? (A) Cell address (B) Range (C) Formula (D) Current cell 27 / 30What is the default column width of MS Excel ? (A) 5.5 (B) 2.98 (C) 6.49 (D) 8.43 28 / 30A ------ is rectangular grid of rows and columns used to enter data. (A) Cell (B) Spreadsheet (C) Worksheet (D) Workspace 29 / 30In Excel which of the following formulas will Excel not be able to calculate ? (A) =SUM(A1:A5)-10 (B) =SUM(A1:A5)/(10-10) (C) =SUM(A1:A5)*.5 (D) =SUM(Sales)-A3 30 / 30You can undo and redo up to _____ action in Microsoft Office Excel, even after a worksheet is saved. (A) 50 (B) 99 (C) 100 (D) 500 Your score isThe average score is 52% 0% Restart quiz