What is the default file extension for an Excel workbook?.xls.xlsx.xlsm.csvB) .xlsxThe default file extension for a modern Excel workbook is .xlsx.
Which of the following is a valid Excel formula?=2 + 32 + 3=2 * 32 * 3A) =2 + 3A formula must start with an equal sign (=) to be valid in Excel.
What does the VLOOKUP function do?Searches for a value vertically in a tableSearches for a value horizontally in a tableFinds the maximum valueFinds the minimum valueA) Searches for a value vertically in a tableVLOOKUP stands for vertical lookup, which searches for a value in the first column of a table and returns a value in the same row from another column.
What does the Excel function =SUM(A1:A10) do?Adds the numbers from A1 to A10Multiplies the numbers from A1 to A10Divides the numbers from A1 to A10Subtracts the numbers from A1 to A10A) Adds the numbers from A1 to A10The SUM function adds up all the values in the specified range.
Which key is used to start a new line within a cell in Excel?EnterCtrl + Enter Alt + EnterShift + EnterC) Alt + EnterAlt + Enter creates a new line within the same cell.
How do you freeze the top row in Excel?View → Freeze Panes → Freeze Top RowInsert → Freeze RowView → Lock RowFormat → Freeze Top RowA) View → Freeze Panes → Freeze Top RowYou can freeze the top row through the "Freeze Panes" option in the "View" tab.
What is the shortcut key to select the entire worksheet?Ctrl + ACtrl + Shift + AShift + AAlt + AA) Ctrl + ACtrl + A selects the entire worksheet in Excel.
What type of data can a cell in Excel contain?Only numbersOnly textNumbers, text, or datesOnly formulasC) Numbers, text, or datesA cell can contain numbers, text, dates, formulas, or a combination of these.
What does the CONCATENATE function do?Joins two or more strings of textAdds two numbersSeparates text into columnsFormats textA) Joins two or more strings of textThe CONCATENATE function joins multiple strings of text into one string.
Which of the following is NOT a valid Excel function?=SUM=AVERAGE=COUNT=MULTIPLYD) =MULTIPLYExcel has no MULTIPLY function; multiplication is done with the * operator.
What does the =IF() function do?It checks a condition and returns one value if true, and another if false.It calculates the sum of two numbers.It multiplies two numbers.It checks if a number is divisible by another.A) It checks a condition and returns one value if true, and another if false.The =IF() function evaluates a condition and returns one value if true, and another if false.
Which of the following Excel chart types is best suited for showing proportions of a whole?Line chartColumn chartPie chartScatter plotC) Pie chartPie charts are ideal for showing proportions of a whole.
What is a Pivot Table used for in Excel?Performing calculationsOrganizing and summarizing large sets of dataCreating chartsFormatting cellsB) Organizing and summarizing large sets of dataPivot tables are used to summarize, analyze, and explore large datasets.
How can you change the width of a column in Excel?Double-click the column borderRight-click and choose "Column Width"Both A and BUse the "Format" menuC) Both A and BYou can either double-click the column border or use the "Column Width" option to change the width.
Which of the following functions returns the current date in Excel?=DATE()=TODAY()=CURRENTDATE()=NOW()B) =TODAY()The =TODAY() function returns the current date in Excel.
Which feature allows users to apply the same formatting across multiple cells or ranges?Copy and PasteFormat PainterConditional FormattingAutoFillB) Format PainterThe Format Painter allows you to copy formatting from one cell and apply it to others.
What is the purpose of the COUNTIF() function?Counts the number of non-empty cellsCounts the number of cells that meet a conditionCounts the total number of rowsCounts the number of text cellsB) Counts the number of cells that meet a conditionThe COUNTIF() function counts the number of cells that meet a specific condition.
Which function returns the largest number from a range of cells?=LARGE()=MAX()=SUM()=AVERAGE()B) =MAX()The =MAX() function returns the largest value in a range.
How do you apply a cell reference that doesn't change when copied to other cells?Use a relative referenceUse an absolute referenceUse a mixed referenceUse a dynamic referenceB) Use an absolute referenceAn absolute reference (e.g., $A$1) remains fixed when copied to other cells.
What is the shortcut for saving a workbook in Excel?Ctrl + SCtrl + PCtrl + CCtrl + NA) Ctrl + SCtrl + S is the shortcut for saving a workbook.
How do you hide a row in Excel?Right-click the row and select "Hide"Use the "Format" menuPress Ctrl + HBoth A and BD) Both A and BYou can hide a row by right-clicking and selecting "Hide" or using the "Format" menu.
What is the result of the formula =A1+B1 when A1 contains 10 and B1 contains 5?5101550C) 15The formula adds the values in A1 and B1, so the result is 15.
What is the purpose of the "Data Validation" feature in Excel?To ensure data is correctly formattedTo check if data meets specific conditionsTo filter dataTo calculate dataB) To check if data meets specific conditionsData validation ensures that the data entered into a cell meets specific conditions, such as a range of numbers or specific text.
Which Excel function is used to find the average of a range of numbers?=AVG()=AVERAGE()=MEAN()=MID()B) =AVERAGE()The =AVERAGE() function calculates the average of a specified range of numbers.
What happens when you press Ctrl + Z in Excel?Undo the last actionRedo the last actionSave the documentCopy the selected dataA) Undo the last actionCtrl + Z is the shortcut for undoing the last action.
Excel files have a default extension of ?123Wk1 Xlw .Xlsx .Xlsx This is the explaination of this mcsqs
Microsoft Excel is a powerful_______ ?DBMS package Spreadsheet package Word processing package Communication S/W package Spreadsheet package This is the explaination of this mcsqs
An excel workbook is a collection of ?Worksheets and ChartsCharts Worksheets Workbooks Worksheets and ChartsThis is the explaination of this mcsqs
Which of the following is latest version of Excel?20162003 201920072019This is the explaination of this mcsqs
Which area in an excel window allows entering values and formulas?Standard toolbarFormula barMenu bar Title bar Formula bar This is the explaination of this mcsqs
Which symbol must all formula begin with?@(+ = = This is the explaination of this mcsqs
Ms-Excel is based on …….?OS/2UNIX DOSWINDOWSWINDOWSThis is the explaination of this mcsqs
To save a workbook, you ?Select Edit SaveSelect Edit SavePress Ctrl+F5 Click the Save option in File Menu Click the Save option in File Menu This is the explaination of this mcsqs
The first cell in excel worksheet is labeled as ?A0AaA1 AAA1 This is the explaination of this mcsqs
Excel displays the current cells address in the ?Title barName box Status bar Formula bar Name box This is the explaination of this mcsqs
The name box ?Appears below the menu barAppears below the status bar Appears to the left of the formula bar Shows the location of previously active cell Appears to the left of the formula bar This is the explaination of this mcsqs
What is the shortcut key to hide entire row?Ctrl + -Ctrl + 9 Ctrl + R Ctrl + H Ctrl + 9 This is the explaination of this mcsqs
A worksheet can have maximum ________ number of rows in Excel 2019 ? 6553532000 10,48,576 1638410,48,576 This is the explaination of this mcsqs
What is the shortcut key to replace a data within sheet ?Ctrl + FCtrl + H Ctrl + Shift + R Ctrl + R Ctrl + H This is the explaination of this mcsqs
To select an entire column in MS-Excel , press?Ctrl + S Ctrl + Arrow Key Ctrl + C None of the aboveNone of the aboveThis is the explaination of this mcsqs
What is the shortcut key to highlight the entire column?Ctrl+ SpacebarCtrl+ PageUp Ctrl+ Enter Ctrl+ C Ctrl+ SpacebarThis is the explaination of this mcsqs
What do you mean by Workspace?Group of WorkbooksGroup of Rows Group of worksheets Group of columns Group of WorkbooksThis is the explaination of this mcsqs
The software which contains rows and columns is called ?Word processingSpreadsheet DrawingDatabaseSpreadsheetThis is the explaination of this mcsqs
Which of the following syntax is correct regarding SUM function in Excel?=SUM (A1:A9,B1:B9) =SUM(A1:B9) =SUM(A1,B1) All of the aboveAll of the aboveThis is the explaination of this mcsqs
What is the symbol for dividing?#&%/ / This is the explaination of this mcsqs
What is the symbol of multiplying?* ! / > *This is the explaination of this mcsqs
.What is an example of function?A1+A2=SUM(A1:A2) =A1+A2 =add(A1:A2) =SUM(A1:A2) This is the explaination of this mcsqs
What is an example of formula ?SUM(A1:A2)A1+A2 =add(A1:A2) =A1+A2 =A1+A2 This is the explaination of this mcsqs
Which key do you press to check spelling?F9 F7 F5 F3 F7 This is the explaination of this mcsqs
Where a row and column meet, what do you call that?A box A block A cell None of the aboveA cell This is the explaination of this mcsqs
Which of the following is not a term of MS-Excel?DocumentColumnsRows Cells DocumentThis is the explaination of this mcsqs
Which chart can be created in Excel? Pie Line AreaAll of theseAll of theseThis is the explaination of this mcsqs
Ctrl+D shortcut key in Excel will ?Fill down in the selection Apply double underline for the active cell Open the font dialog box None of aboveFill down in the selection This is the explaination of this mcsqs
In order to perform a calculation in a spreadsheet, you need to use a ? variableField Formula Table Formula This is the explaination of this mcsqs
Q 30. Which of the following is not an option of spelling dialog box?ChangeIgnore all IgnoreEditEditThis is the explaination of this mcsqs
You can add image to a template by clicking the Picture from ? ReviewInsert Slide Show Design Insert This is the explaination of this mcsqs
Which of the following is not an example of a value?Serial Number 507710.57 May 10, 2001 350Serial Number 50771This is the explaination of this mcsqs
Which of the following options is not located in the Page Setup dialog box?Headers and FootersMargins Page Orientation Page Break Preview Page Orientation This is the explaination of this mcsqs
Which of the following is not a valid data type in excel?Label Character NumberDate/timeCharacterThis is the explaination of this mcsqs
Hyperlinks can be ?Pictures Drawing objects Text All of aboveAll of aboveThis is the explaination of this mcsqs
You can open the Sort dialog box by choosing Sort from ?DataToolsFormats View DataThis is the explaination of this mcsqs
In Excel, by default Numeric Values appears in ?Justify alignedCenter aligned Right aligned Left aligned Right aligned This is the explaination of this mcsqs
What will be the result if you type =A1=B1 in cell C1?Value of B1Value of A1 True or False Yes or No True or False This is the explaination of this mcsqs
"New Comment" options can be found under _____tab ?ViewReview Data Insert ReviewThis is the explaination of this mcsqs
In maximum, how many sheets can be set as a default while creating new workbook?256255254No limit255 This is the explaination of this mcsqs
A typical worksheet has ________number of columns in Excel 2019 ?A typical worksheet has ________number of columns in Excel 2019 ?65,535 32,000 16,384 16,384 This is the explaination of this mcsqs
. How many characters can be typed in a single cell in Excel?65,535 256 32,767 1,024 32,767 This is the explaination of this mcsqs
You can activate a cell by ?Pressing an arrow key Clicking the cell Pressing the Tab key All of the aboveAll of the aboveThis is the explaination of this mcsqs
Which of the following is not a basic step in creating a worksheet?Copy the worksheetEnter text and data Modify the worksheet Save workbook Copy the worksheetThis is the explaination of this mcsqs
Concatenation of text can be done using ?Ampersand (&)Hash(#) Exclamation (!) Apostrophe(‘) Ampersand (&)This is the explaination of this mcsqs
Data can be arranged in a worksheet in a easy to understand manner using ?changing fonts applying styles auto formatting All of aboveAll of aboveThis is the explaination of this mcsqs
Which of the following is invalid statement? The width of a row can be specified manually or fit automaticallyYou can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet Sheets tabs can be colored The width of a row can be specified manually or fit automaticallyThis is the explaination of this mcsqs
When the formula bar is activated, you can see ?The Enter button The Cancel button The Edit formula button All of the aboveAll of the aboveThis is the explaination of this mcsqs
When you work with large worksheets , you may need to ? Specify only certain print areas Add and remove page breaks Size the worksheet to fit on the specific number of pages All of aboveAll of aboveThis is the explaination of this mcsqs
What does the VLOOKUP function do?Finds related record Checks whether text is the same in one cell as in the next Looks up text that contain All of aboveFinds related record This is the explaination of this mcsqs
Which of the following methods can not be used to enter the data in a cell?Clicking on the formula barPressing the Esc key Pressing the Tab key Pressing an arrow key Pressing the Esc key This is the explaination of this mcsqs
Which of the following will not cut information?Pressing Ctrl+XClicking the cut button on Home Tab Selecting Cut from quick access toolbar Pressing Ctrl+C Pressing Ctrl+C This is the explaination of this mcsqs
This type of software is similar to an accountant's worksheet ?GraphicsSpreadsheets DatabaseWord processing SpreadsheetsThis is the explaination of this mcsqs
Which of the following is the oldest spreadsheet package?StarCalcExcelLotus 1-2-3 VisiCalc VisiCalc This is the explaination of this mcsqs
Which of the following is a popular DOS based spreadsheet package ?Lotus 1-2-3 Excel Smart cell Word Lotus 1-2-3This is the explaination of this mcsqs
A worksheet range is a ?A group of worksheetsA group of cells A range of values such as from 23 to 234 A command used for data modeling A group of cells This is the explaination of this mcsqs
Which of the following formulas will excel not be able to calculate?=SUM(A1:A5)-10=SUM(A1:A5)/(10-10) =SUM(A1:A5)*.5 =SUM(Sales)-A3 =SUM(Sales)-A3 This is the explaination of this mcsqs
To copy cell contents using drag and drop press the ?Esc keyCtrl key Shift key End key Ctrl key This is the explaination of this mcsqs
Each excel file is called a workbook because ?You have to work hard to create it It can contain many worksheets and charts It can be modified It can contain text and data It can contain many worksheets and charts This is the explaination of this mcsqs
Which button do you click to add up series of numbers?The total buttonThe quicktotal button The formula button The autosum button The autosum button This is the explaination of this mcsqs
Which function will you use to enter current time in a worksheet cell?=time()=now() ctrl + shift + ; =today()ctrl + shift + ; This is the explaination of this mcsqs
Which of the following is not a valid Zoom percentage in Excel?500300 100400400This is the explaination of this mcsqs
When you insert an Excel file into a Word document, the data are ?EmbeddedLinkedPlaced in a word table Hyperlinked LinkedThis is the explaination of this mcsqs
Macros "run" or executed from the ……… menu ? dataViewFormat Insert View This is the explaination of this mcsqs
How are data organized in a spreadsheet ?Height and widthRows and columns Layers and planes Lines and spaces Rows and columns This is the explaination of this mcsqs
Rows and columns Columns Rows The entire worksheet All of aboveAll of aboveThis is the explaination of this mcsqs
Which types of charts can excel produce ?Bar charts and line graph onlyBar charts, line graphs and pie charts Only line graphs Line graphs and pie charts only Bar charts, line graphs and pie charts This is the explaination of this mcsqs
You want to track the progress of the stock market on a daily basis. Which type of chart should you use ?Column chartLine chart Row chart Pie chart Line chart This is the explaination of this mcsqs
Which of the following is not a way to complete a cell entry?Pressing spacebarClicking the Enter button on the Formula Pressing any arrow key on the keyboard Pressing enter Pressing spacebarThis is the explaination of this mcsqs
You can use the horizontal and vertical scroll bars to ? View different worksheetsEdit the content of a cell View different rows and columns to edit the contents of a cell Split a worksheet into two panes View different rows and columns to edit the contents of a cell This is the explaination of this mcsqs
Which symbol is used before a number to make it a label?‘(apostrophe)_(underscore) “(quote) =(equal‘(apostrophe)This is the explaination of this mcsqs
Right clicking something in Excel ?Deletes the objectSelects the objects Opens a shortcut menu listing everything you can do to the object Nothing the right mouse button is there for left handed people Opens a shortcut menu listing everything you can do to the object This is the explaination of this mcsqs
To delete an embedded object, first ?Select it and then press the delete keyPress the Shift + Delete keys Select the object by clicking it Double click the object Select it and then press the delete keyThis is the explaination of this mcsqs
When creating a vertical page break ?The active cell must be in column AThe active cell must be in row 1 The active cell can be anywhere in the worksheet The active cell must be A1 The active cell must be in row 1 This is the explaination of this mcsqs
To create a formula, you can use ?Values and cell referencesCell references but not values Values but not cell references Values or cell references although not both at same time Values and cell referencesThis is the explaination of this mcsqs
Excel probably considers the cell entry January 1, 2000 to be a ?Text stringFormula Value Label ValueThis is the explaination of this mcsqs
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ?Press Alt+HomePress Shift+Home Press Home Press Ctrl+Home Press Ctrl+Home This is the explaination of this mcsqs
Which of the following methods can not be used to edit the contents of a cell ?Double clicking the cellPressing the F2 key Clicking the formula bar Press the Alt key Press the Alt key This is the explaination of this mcsqs
MS-Excel provides the default value for steps in Fill Series dialog box?105 1 0 1 This is the explaination of this mcsqs
In the formula, which symbol specifies the fixed columns or rows?&% * $$This is the explaination of this mcsqs
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the ?Split command on the window menu Hold titles command on the Data Menu Freeze panes command on the View Menu Unfreeze panes command on the Insert Menu Freeze panes command on the View Menu This is the explaination of this mcsqs
You can enter which type of data into worksheet cells?Formulas onlyValues and Formulas but not labels Labels and Values but not formulas Labels, Values, Formulas Labels, Values, Formulas This is the explaination of this mcsqs
Which tool you will use to join some cells and place the content at the middle of joined cell ?Click on Merge and Center tool on Home TabFrom Insert Tab choose Merge and Center From format cells dialog box select the centered alignment From View Tab click on Merge cells check box Click on Merge and Center tool on Home TabThis is the explaination of this mcsqs
Which button do you click to add up a series of numbers?The total buttonThe quick button The formula button The autosum button The autosum button This is the explaination of this mcsqs
Which of the following Excel screen components can NOT be turned on or off?Toolbar Status bar Formula bar None of the aboveNone of the aboveThis is the explaination of this mcsqs
Which of the following option is not available in Paste Special dialog box?SQRTDivide Subtract Add SQRTThis is the explaination of this mcsqs
Which command will you choose to convert a column of data into row?Right Click>>Paste Special>>Transpose Cut and Paste Both of above None of aboveRight Click>>Paste Special>>Transpose This is the explaination of this mcsqs
Long text can be broken down into many lines within a cell. You can do this through ?Wrap Text >Cells ,Layout tab Justify in Edit>>Cells Wrap Text from Home Tab All of aboveWrap Text from Home Tab This is the explaination of this mcsqs
Which of the following series type is not valid for Fill Series dialog box?Time Autofill Growth LinearTimeThis is the explaination of this mcsqs
Which of the following you can use in Paste Special command ? Formulas Formats ValidationAll of the aboveAll of the aboveThis is the explaination of this mcsqs
To return the remainder after a number is divided by a divisor in EXCEL we use the function ?DIV( )MOD( ) FACT( ) ROUND( ) MOD( ) This is the explaination of this mcsqs
How do you rearrange the data in ascending or descending order ?Data SubtotalsData , Table Data, Form Data , Sort Data , Sort This is the explaination of this mcsqs
How many worksheets can a workbook have ?Limited by Available memory255 8 3Limited by Available memoryThis is the explaination of this mcsqs
Which would you choose to create a bar diagram?Format, ChartTools, Chart Insert, Chart Edit, Chart Insert, Chart This is the explaination of this mcsqs
Which setting you must modify to print a worksheet using letterhead? OrientationLayout Margin Paper Margin This is the explaination of this mcsqs
We can save and protect the workbook by ?Read Only Recommended Protection Password Write Reservation Password Any of aboveAny of aboveThis is the explaination of this mcsqs
In order to perform a calculation in a spreadsheet, you need to use a ?VariableFieldFormula Table FormulaThis is the explaination of this mcsqs
You accidentally erased a record in the sheet. What command can be used to restore it automatically?Replace Undo Copy Insert Undo This is the explaination of this mcsqs
NOT, AND, OR and XOR are ?Relational operators Arithmetic operators Logical operators None of aboveLogical operators This is the explaination of this mcsqs
MS-Excel can be used to automate ? Accounts receivable, accounts payable Transaction registers, Inventory control Financial statements, Business forecasting Any of aboveAny of aboveThis is the explaination of this mcsqs
What is the shortcut key to hide entire column?Ctrl + CCtrl + H Ctrl + 0 Ctrl + - bCtrl + 0 This is the explaination of this mcsqs
What is the shortcut key to insert new sheet in current workbook?Shift + F11Ctrl + F11 Alt + F11 F11Shift + F11This is the explaination of this mcsqs
Multiple Calculations can be made in a single formula using ?Smart formulaComplex formula Array Formula Standard formula Array Formula This is the explaination of this mcsqs
How do you wrap the text in a cell?Format cells, alignmentFormat cells, number Format cells, protection Format cells, font Format cells, alignmentThis is the explaination of this mcsqs
When working in the page break preview, you can ?Change the print area Add or remove page breaks View exactly where each page break occurs All of above All of aboveThis is the explaination of this mcsqs
Excel uniquely identifies cells within a worksheet with a cell name ?Column letters and row numbers Column number and row letters Cell names All of aboveColumn letters and row numbers This is the explaination of this mcsqs
When you work with large worksheets , you may need to ?Specific only certain print areas Add and remove page breaks Size the worksheet to fit on the specific number of pages All of aboveAll of aboveThis is the explaination of this mcsqs
Data can be arranged in a worksheet in an easy to understand manner using ?Changing fonts Applying styles Auto formatting All of aboveAll of aboveThis is the explaination of this mcsqs
Rounding Errors can occur ?When you show the results of formulas with different decimal places that the calculated resultsBecause excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formulaWhen you use multiplication, division, or exponentiation in a formulaThis is the explaination of this mcsqs
Which of the following is correct?=AVERAGE(A1:A9,B1:B9) =AVERAGE(A1,B1,C1) =AVERAGE(4,5,6,7) All of aboveAll of aboveThis is the explaination of this mcsqs
Excel worksheet cells work very similarly to what comman element of the window graphical user interface ?Combo boxesText boxes List boxes Option buttons Text boxes This is the explaination of this mcsqs
When you use the fill effects in the format data series dialog box, you can not ?Select a background colorSelect a pattern Select a fore ground color Rotate text on the chart Rotate text on the chart This is the explaination of this mcsqs
Except for the ______ function, or formula with a logical function shows the word "TRUE" or " FALSE" as a result ?NOTOR AND IF IF This is the explaination of this mcsqs
Chart tips can ?Chart tips can ?Show the name of a data series Show the value of data point b and cb and cThis is the explaination of this mcsqs
To view a cell comment ?Click the comment command on the view buttonPosition the mouse pointer over the cell Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell This is the explaination of this mcsqs
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?Data sheetModule sheet Chart sheet Work sheet Data sheetThis is the explaination of this mcsqs
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?Speed HeadingsRows and columns NoneSpeed This is the explaination of this mcsqs
When you print preview a worksheet ?The active portion of the worksheet is displayed The selected range is displayed The entire worksheet is displayed All of aboveAll of aboveThis is the explaination of this mcsqs
When you see a cell with a red triangle in the top right corner, what does this signify?A formula cannot be entered into the cellThe font color for text in the cell is red There is a comment associated with the cell There is an error in the cell There is a comment associated with the cell This is the explaination of this mcsqs
Which of the formulas will Excel Not be able to calculate ?10+50=B7+14 =B7+B1 =10+50 10+50This is the explaination of this mcsqs
You can use drag and drop method to ?Copy cell contents Move cell contents Add cell contents A and BA and BThis is the explaination of this mcsqs
It is acceptable to let long text flow into adjacent cells in a worksheet when ?There is no time to format the textThere is not suitable abbreviation of the textNo data will be entered in the adjacent cells Data will be entered in the adjacent cells No data will be entered in the adjacent cells This is the explaination of this mcsqs
A circular reference is ?Always erroneousA formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool A formula that either directly or indirectly depends on itself This is the explaination of this mcsqs
When you copy a formula ?Excel doesn’t adjust relative cell referencesExcel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel edits cell references in the newly copied formula This is the explaination of this mcsqs
You can drag and drop to embed excel worksheet data in a word document ?By dragging a range of excel data to the word button on the taskbar while pressing Alt Key By dragging a range of excel data to the word button on the taskbar while pressing Shift Key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl Key None of Above By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl Key This is the explaination of this mcsqs
To drag a selected range of data to another worksheet in the same workbook, use the ?Ctrl KeyShift Key Alt Key Tab Key Alt Key This is the explaination of this mcsqs
You can select a single range of cells by ?Dragging over the desired cellsPressing Shift Key and an Arrow Key Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the shift key while creating lower right cell in a group of cells Dragging over the desired cellsThis is the explaination of this mcsqs
When you group worksheets ?you can enter variable data on multiple worksheets at one time you can print more than one worksheet at a time you can enter common data, formats, and formulas on multiple worksheets at one b and cb and cThis is the explaination of this mcsqs
When all the numbers between 0 and 100 in a range should be displayed in Red color , apply ?Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional formatting command on format menu Use =if() function to format the required numbers red All of the aboveApply Conditional formatting command on format menuThis is the explaination of this mcsqs
You can check the conditions against ______when applying conditional formatting ?FormulaCell value Both of above None of the aboveNone of the aboveThis is the explaination of this mcsqs
The number in our worksheet look like this: 1000. You want them to look like this: $1,000. How can you accomplish this?You have to retype everything and manually add the dollar signs, commas, and decimals. Click the Currency Style button on the formatting toolbar (Home tab). Select Format> Money from the menu None of aboveClick the Currency Style button on the formatting toolbar (Home tab).This is the explaination of this mcsqs
Which of the following describes how to select all the cells in a single column?Pressing Ctrl+A on the keyboard Left click on the gray column title button Use data-text to columns menu item Right click on column and select Pick from list ) Left click on the gray column title button This is the explaination of this mcsqs
Hyperlinks cannot be ?PicturesDrawing objects like rectangle ovals Special shapes like stars and banners All can be hyperlinksAll can be hyperlinksThis is the explaination of this mcsqs
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?Click format painter on the formatting toolbar twice then click in each cell you want to copy the formatting to... Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify Use Ctrl to select all three cells, then click the paste button on the standard toolbar All of the aboveClick format painter on the formatting toolbar twice then click in each cell you want to copy the formatting to... This is the explaination of this mcsqs
Tab scroll buttons are placed on Excel screen ?Towards the top left cornerTowards the top right corner Towards the bottom left corner owards the bottom right corner Towards the bottom left corner This is the explaination of this mcsqs
Documentation should include ?Information on the purpose of the workbook Source of input data Destination and users of the output data All of the aboveAll of the aboveThis is the explaination of this mcsqs
The default header for a worksheet is ?The sheet tab name The date and time Your name None NoneThis is the explaination of this mcsqs
Which function will you use to enter current time in a worksheet cell?=currentTime()=time() =now() =today() =now() This is the explaination of this mcsqs
You can group noncontiguous worksheets with ?The alt + enter keyThe ctrl key and mouse The shift key and the mouse The group button on the standard toolbar The ctrl key and mouse This is the explaination of this mcsqs
Weight refers to ? The design and appearance of charactersUpright or slanted shade The height of the printer character The print density of characters The print density of characters This is the explaination of this mcsqs
You need the insert function dialog box ?Type = in cell Click on functions in Home tab Right click a cell and then click insert All of aboveClick on functions in Home tab This is the explaination of this mcsqs
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special. Select the range you want, include both cells, point to fill on the Edit menu, and then click downSelect both cells, and then drag the fill handle over the range you want, for instance 18 more rows All of aboveSelect both cells, and then drag the fill handle over the range you want, for instance 18 more rows This is the explaination of this mcsqs
. A function inside another function is called a ….. Function. ?Text Sum Round Nested Nested This is the explaination of this mcsqs
Which function calculates your monthly mortage payment?PV(Present Value) NPER(Number of Periods) PMT(Payment) All of abovePMT(Payment) This is the explaination of this mcsqs
What is an expression that tells how the numbers in determined set of cells are to be calculated?Query Data Field FormulaFormulaThis is the explaination of this mcsqs
If you are working in English(US), Chinese or Japanese, Excel 2016 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?Point to speech on the tools menu, and then click speech Click validation on the data menu Add speak cells on enter command from quick access toolbar All of above Add speak cells on enter command from quick access toolbar This is the explaination of this mcsqs
To copy cell contents using drag and drop, press the ?Ctrl KeyEsc Key Shift Key End Key Ctrl KeyThis is the explaination of this mcsqs
If you press …, the cell accepts your typing as its contents ?InsertTABCtrl + Enter Enter Enter This is the explaination of this mcsqs
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?F11F7F5 F3F11This is the explaination of this mcsqs
You can use the formula palette to ?Copy a range of cellsEntered assumptions data Create and edit formulas containing functions Format cells containing numbers Create and edit formulas containing functions This is the explaination of this mcsqs
“Qtr 1, Qtr 2, Qtr 3” is an example of a ?SyntaxSeries Function Formula Series This is the explaination of this mcsqs
You can edit existing Excel data by pressing the ?F4 KeyF3 Key F2 Key F1 Key F2 Key This is the explaination of this mcsqs
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ?B1:G10B1;G10 B1.G10 G1-G10 B1:G10This is the explaination of this mcsqs
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?Right click on the spreadsheet and select Insert – Entire Column Right click on the spreadsheet tab and select DELETE Go to File-Save As – Save As Type – Excel worksheet None of aboveNone of aboveThis is the explaination of this mcsqs
Which feature describes a background that appears as a grainy, non smooth surface ?TextureSolid Pattern GradientGradientThis is the explaination of this mcsqs
The Spelling Tool is placed in ________ Tab ? Formula View Reviewinsert ReviewThis is the explaination of this mcsqs
Formatting a cell in Currency, you can specify ?Currency Symbol Decimal Places Both of above None of aboveBoth of above This is the explaination of this mcsqs
If you need a text to show vertically in a cell. How will you achieve this?Choose Center Across Selection from Horizontal combo box in Format Cells dialog boxChoose Distributed from the vertical drop down list of Format Cells dialog box Choose 90 Degrees in Orientation of Format Cells dialog box cChoose Vertical on Text alignment in Format Cells dialog box Choose 90 Degrees in Orientation of Format Cells dialog boxThis is the explaination of this mcsqs
You can automatically adjust the size of text in a cell if they do not fit in width by ?From Format Cells dialog box mark Shrink to fit check box From Format choose Columns and then Autofit Selection Double clicking on the right border of column header All of aboveFrom Format Cells dialog box mark Shrink to fit check box This is the explaination of this mcsqs
Which of the cell pointer indicate that you can make selection ?Doctor’s Symbol (Big Plus)Mouse Pointer with anchor at the tip Small thin plus icon None of aboveDoctor’s Symbol (Big Plus) This is the explaination of this mcsqs
Which of the cell pointer indicate that you can fill series ?Mouse Pointer with anchor at the tip Small thin plus icon Doctor’s Symbol (Big Plus) None of aboveSmall thin plus icon This is the explaination of this mcsqs
Which one is the last column header in Excel 2019?XFTXFL XFX XFX XFX This is the explaination of this mcsqs
How can you remove borders applied in cells?Open the list of Border tool in Home tab and choose no border Choose None on Border Tab of Format cells Both of above None of aboveBoth of above This is the explaination of this mcsqs
You can set page border in excel from ?You can not set page border in ExcelFrom Line Style tool in Drawing toolbar From Border tool in Formatting toolbar From Border tab in Format Cells dialog box You can not set page border in ExcelThis is the explaination of this mcsqs
Which of the following you can paste selectively using Paste Special Command?FormulasFormatsValidationAll of aboveAll of aboveThis is the explaination of this mcsqs
Paste Special allows some operations while you paste to new cell. Which of the following operation is valid? DivideGoal Seek PercentageSquare DivideThis is the explaination of this mcsqs
Comments put in cells are called ?Soft TipWeb Tip Cell Tip Smart Tip Cell Tip This is the explaination of this mcsqs
Which of the following is not true regarding Conditional formatting?You can delete any condition from conditional formatting dialog box if it is not requiredYou can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for bold and apply for italics on them You can add more than one condition to check You can set condition to look for bold and apply for italics on them This is the explaination of this mcsqs
Getting data from a cell located in a different sheet is called ?FunctioningUpdating Referencing Accessing Referencing This is the explaination of this mcsqs
What happens when you press Ctrl + X after selecting some cells in Excel?The selected cells are deleted and cells are shifted upThe selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and store in clipboard ) The cells selected are marked for cutting This is the explaination of this mcsqs
In EXCEL, you can sum a large range of data by simply selecting a tool button called…?Auto formatAuto Sum Auto correct Auto correct Auto Sum This is the explaination of this mcsqs
Which function is not available in the consolidate dialog box?SumMax Average PMTPMTThis is the explaination of this mcsqs
Which language is used to create macros in Excel? JavaC++ C Visual Basic Visual Basic This is the explaination of this mcsqs
Which tool you will use to join some cells and place the content at the middle of joined cell?Click on Merge and Center tool on Home TabFrom Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on Home TabThis is the explaination of this mcsqs
How can you set 0.5 inch indentation for a cell in Excel ?The indentation can be specified only when printing.Indentation can be set from Format Cells dialog box You can specify indentation only if you turn the rulers on Excel does not have indentation feature. Indentation can be set from Format Cells dialog box This is the explaination of this mcsqs
Merge cells option can be applied from ?Formatting toolbar Format Cells dialog box alignment tab Both of above None of aboveFormat Cells dialog box alignment tab This is the explaination of this mcsqs
You can auto fit the width of column by ?Double clicking on the column left border of column headerDouble clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on column right border on column header This is the explaination of this mcsqs
Selecting the column G & H then choose Insert by right clicking, What will happen?2 Columns will be inserted after Column I2 Columns will be inserted after Column H 2 Columns will be inserted after Column G 2 Columns will be inserted after Column F 2 Columns will be inserted after Column F This is the explaination of this mcsqs
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell ?The Settings tab under the menu Home>>Conditional FormattingThe Setting tab under the menu Data >>Filter>>Advanced Filter The Setting tab under the menu Data>>Validation The Setting tab under the menu Data>>Cells The Setting tab under the menu Data>>Validation This is the explaination of this mcsqs
If particular workbook have to open each time When Excel started, where that workbook should be placed?XLSTART FOLDEREXCELSTART FOLDER AUTOSTART FOLDER AUTOEXEC FOLDER XLSTART FOLDERThis is the explaination of this mcsqs
If the values in A1 is “MCQ” and B1 is “Questions”, Which function will return “MCQ@Questions” in cell C1?=A1 $ “@” $ B1=A1 & “@” & B1 =A1 # “@” # B1 =A1 + “@” + B1 =A1 & “@” & B1 d) This is the explaination of this mcsqs
What does COUNTA() function do?Counts non-empty cellsCounts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cellsThis is the explaination of this mcsqs
What is the correct way to refer the cell A10 on sheet3 from sheet 1?A1Sheet3.A10 Sheet1!A10 Sheet3!A10 Sheet3!A10 This is the explaination of this mcsqs
What is entered by the function =today() a) F8 b) F9 c) F10 d) F11 a) The date value for the day according to system clock ?Today’s date as Text format The time value according to system clock The date value for the day according to system clock All of aboveThe date value for the day according to system clock This is the explaination of this mcsqs
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? F11 F10 F9F8F9 This is the explaination of this mcsqs
The shortcut key CTRL+R is used in Excel to ?Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell None of aboveFill the selection with active cells to the rightThis is the explaination of this mcsqs
While finding and replacing some data in Excel, which of the following statement is valid?Excel does not have option to match case for find You can Find and Replace within the sheet or workbook Both are valid None are validYou can Find and Replace within the sheet or workbook This is the explaination of this mcsqs
Which of the following is not true about Find and Replace in Excel ?You can search by rows or columns or sheetsYou can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search for bold and replace with italics This is the explaination of this mcsqs
Which is the shortcut key to replace a data with another in sheet?CTRL+ FCTRL + H CTRL + Shift + R CTRL + R CTRL + H This is the explaination of this mcsqs
Which of the following is correct syntax in Excel?=if(LogicalTest, TrueResult), If(LogicalTest, FalseResult)=if(LogicalTest, TrueResult) (LogicalTest, FalseResult)=if(LogicalTest, (TrueResult,FalseResult)) =if(LogicalTest, TrueResult, FalseResult) =if(LogicalTest, TrueResult, FalseResult) This is the explaination of this mcsqs
If 4/6 entered in a cell without applying any formats, Excel will treat this as?DateTextNumberFractionDateThis is the explaination of this mcsqs
To record a sequence of keystrokes and mouse actions to play back later we use ?Macro RecorderCalculator Sound Recorder Media player Macro RecorderThis is the explaination of this mcsqs
What are the tabs that appear at the bottom of each workbook called?Sheet TabsLocation Tabs Position Tabs Reference Tabs Sheet TabsThis is the explaination of this mcsqs
A _____________ is grid with labeled columns and rows? ToolbarToolbar Worksheet Dialog box WorksheetThis is the explaination of this mcsqs
The active cell ?Receives the data the user entersis defined by a bold border around the cell It is the formula bar Only A and BOnly A and BThis is the explaination of this mcsqs
B7:B9 indicates ?Cells B8 onlyCells B7 through Cells B7 and cell B9 only. None of the aboveCells B7 through B9. This is the explaination of this mcsqs
Cancel and Enter button appear in the: ?Sheet tabsMenu bar Formula bar Title bar Formula bar This is the explaination of this mcsqs
Special category of Number tab in format cells dialog box can be used to apply formats like ?Phone Number Zip Code Both of above None of aboveBoth of above This is the explaination of this mcsqs
Formatting a cell in Number format you can’t set ?Currency SymbolNegative Numbers Use 1000 separator Decimal Places Currency SymbolThis is the explaination of this mcsqs
Which would you choose to create a bar diagram?Data, Bar ChartPage Layout, Bar Chart Insert, Bar Chart Home, Bar Chart Insert, Bar Chart This is the explaination of this mcsqs
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?Column ChartPie Chart Line Chart XY Chart Pie Chart This is the explaination of this mcsqs
In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a ?Database of rainfallChart showing rainfall amounts Photograph of rainfall Calendarshowing rainfall amounts This is the explaination of this mcsqs
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? Save Edit Save As New Save As This is the explaination of this mcsqs
Which of the following function will use to find the highest number in a series of number?HIGHEST(B1:B3)High(B1:B3) MAXIMUM(B1:B3) MAX(B1: B3) MAX(B1: B3) This is the explaination of this mcsqs
Which of the following shortcuts can be used to insert a new line in the same cell?Shift + EnterCtrl + Enter Alt + Enter EnterAlt + Enter This is the explaination of this mcsqs
What is the shortcut key to insert new comment in a cell?SHIFT + F2CTRL + F2 ALT + F2 F2SHIFT + F2This is the explaination of this mcsqs