A space was used in formulas that reference multiple ranges; a comma separates range references A. #REF! B. #NUM! C. #NULL! D. #VALUE! Ans. C
MS EXCEL
Text in the formula is not recognized then display A. #Name? B. #None? C. #div!! D. none of above Ans. A
MS EXCEL
A formula or a function inside a formula cannot find the referenced data
A. #N/A! B. #NAME? C. #NULL! D. ######## Ans. A
MS EXCEL
This error #DIV/0! display when A. mismatch value B. trying divided by 0 C. trying divided by 1 D. none of these Ans. B
MS EXCEL
Top open an existing workbook, click the open button on the…………toolbar? A. form B. standard C. Drawing D. Formatting Ans. B
MS EXCEL
A Spreadsheet contains? A. columns B. Rows C. rows & columns D. none of these Ans. C
MS EXCEL
Formula palette is used to? A. format cells containing number B. created and edit formulas containing functions C. entered assumption data D. Copy all cells Ans. B
MS EXCEL
You can activate a cell by A. Pressing the Tab key B. Clicking the cell C. Pressing an arrow key D. All of the above Ans. D
MS EXCEL
Which of the following is not a way to complete a cell entry? A. Pressing enter B. Pressing any arrow key on the keyboard C. Clicking the Enter button on the Formula bar D. Pressing spacebar Ans. D
MS EXCEL
Which of the following will not cut information? A. Pressing Ctrl + C B. Selecting Edit>Cut from the menu C. Clicking the Cut button on the standard D. Pressing Ctrl+X Ans. A
MS EXCEL
Which of the following methods can not be used to enter data in a cell A. Pressing an arrow key B. Pressing the Tab key C. Pressing the Esc key D. Clicking on the formula bar Ans. C
MS EXCEL
Which keys are used to Open tab in Ms Excel? A. Ctrl + O B. Ctrl + G C. Ctrl + U D. Shift + F11 Ans. A
MS EXCEL
Which key is used to “Goto” tab in Ms Excel? A. F5 B. F9 C. F6 D. None of These Ans. A
MS EXCEL
Which key is used to Repeat last action in Ms Excel? A. F4 B. F2 C. F7 D. F1 Ans. A
MS EXCEL
Which key is used for help in Ms Excel A. F1 B. F4 C. F2 D. F5 Ans. A
MS EXCEL
What type of chart will you use to compare performance of sales of two products ?
A. Column Chart B. Line Chart C C. Pie Chart D. Both A and B Ans. A
MS EXCEL
It is a collection of data that is stored electronically as a series of records in a table.
A. Spreadsheet B. Presentation C. Database D. MS-Word Ans. C
MS EXCEL
An Excel file is generally called a / an :
A. E-Spreadsheet B. Woorksheet C. Workbook D. Sheet Ans. C
MS EXCEL
In Excel, which one denoted a range from B1 through E5
A. B1 - E5 B. B1:E5 C. B1 to E5 D. B1$E5 Ans. B
MS EXCEL
How many sheets are there, by default, when we create a new Excel file ?
A. 1 B. 3 C. 5 D. 9 Ans. B
MS EXCEL
The basic unit of a worksheet into which you enter data in Excel is called a
A. cell B. table C. box D. column Ans. A
MS EXCEL
What type of chart is good for single series of data ?
A. Column Chart B. Line Chart C. Pie Chart D. Cone Chart Ans. C
MS EXCEL
What type of chart is good for single series of data ?
A. Column Chart B. Line Chart C. Pie Chart D. Cone Chart Ans. C
MS EXCEL
How will you graphically represent expenditure in different departments ?
A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart Ans. C
MS EXCEL
What do you use to create a chart?
A. Pie Wizard B. Excel Wizard C. Data Wizard D. Chart Wizard Ans. D
MS EXCEL
In Excel, Rows are labelled as ______
A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc. Ans. B
MS EXCEL
What type of chart is useful for comparing parts of a whole ?
A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Ans. A
MS EXCEL
The ____ feature of MS Excel quickly completes a series of data
A. Auto Complete B. Auto Fill C. Fill Handle D. Sorting Ans. B
MS EXCEL
The process of arrenging the items of a column in some sequence or order is known as :
A. Arrengin B. Autofill C. Sorting D. Filtering Ans. C
MS EXCEL
What type of chart is useful for showing trends or changes over time
A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Ans. C
MS EXCEL
The Greater Than sign (>) is an example of _____ operator.
A. Arithmatic B. Logical C. Conditional D. Greater Ans. B
MS EXCEL
In Excel, Columns are labelled as ___
A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc D. $A$1, $A$2, etc. Ans. A
MS EXCEL
Which functionin Excel checks whether a
condition is true or not ?
A. SUM B. COUNT C. IF D. AVERAGE Ans. C
MS EXCEL
Functions in MS Excel must begin with ___
A. () sign B. An Equal Sign C. A Plus Sign D. A > Sign Ans. B
MS EXCEL
Which one is not a Function in MS Excel ?
A. SUM B. AVG C. MIN D. MAX Ans. B
MS EXCEL
What type of chart will you use to compare
performance of two employees in the year 2016 ?
A. Column Chart B. Line Chart C. Pie Chart D. Dot Chart Ans. B
MS EXCEL
Statistical calculations and preparation of
tables and graphs can be done using
A. Adobe Photoshop B. Excel C. Notepad D. Power Point Ans. B
MS EXCEL
A features that displays only the data in
column (s) according to specified criteria
A. Formula B. Sorting C. Filtering D. Pivot Ans. C
MS EXCEL
Which functionin Excel tells how many numeric entries are there ?
A. NUM B. COUNT C. SUM D. CHKNUM Ans. B
MS EXCEL
What type of chart is useful for comparing values over
categories ?
A. Pie Chart B. Column Chart C. Line Chart D. Dot Graph Ans. B
MS EXCEL
What is the intersection of a column and a row on a worksheet called ?
A. Column B. Value C. Address D. Cell Ans. C
MS EXCEL
What is the intersection of a column and a row on a worksheet called ?
A. Column B. Value C. Address D. Cell Ans. C
MS EXCEL
Which of the following is not a valid Zoom percentage in Excel? A. 10 B. 100 C. 300 D. 500 Ans. D
MS EXCEL
You can group non contiguous worksheets with A. The alt+enter key B. The ctrl key and mouse C. The shift key and the mouse D. The group button on the standard toolbar Ans. B
MS EXCEL
You can group non contiguous worksheets with A. The alt+enter key B. The ctrl key and mouse C. The shift key and the mouse D. The group button on the standard toolbar Ans. B
MS EXCEL
The Software which contains rows and columns is called ______ A. Database B. Drawing C. Spreadsheet D. Word processing Ans. C
MS EXCEL
What is the keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 Ans. D
MS EXCEL
The cell reference for cell range of G2 to M12 is _______ A. G2.M12 B. G2;M12 C. G2:M12 D. G2-M12 Ans. C
MS EXCEL
Which of the following methods will not enter data in a cell? A. Pressing the Esc key B. Pressing an arrow key C. Pressing the tab key D. Clicking the enter button to the formula bar Ans. A
MS EXCEL
Which of the following is not an option of the spelling dialog box? A. Ignore B. Ignore all C. Edit D. Change Ans. C
MS EXCEL
Which of the following is not an option of the spelling dialog box? A. Ignore B. Ignore all C. Edit D. Change Ans. C
MS EXCEL
The default header for a worksheet is A. Username B. Date and Time C. Sheet tab Name D. None Ans. D
MS EXCEL
Formulas in Excel start wit A. % B. = C. + D. – Ans. B
MS EXCEL
Formulas in Excel start wit A. % B. = C. + D. – Ans. B
MS EXCEL
Which of the following is not an underline option in the format cells dialog box? A. Double B. Single Accounting C. Double Accounting D. Single Engineerin Ans. D
MS EXCEL
A function inside another function is called _______ A. Nested function B. . Round function C. Sum function D. Text function Ans. A
