HTML
   HTML5
   CSS
   CSS3
   JavaScript
   jQuery
   AngularJS
   Articles
   Tech Articles
   Blog
Google News
logo
Microsoft Excel - Quiz(MCQ)
1 .
When released the first version of Microsoft Excel?
A)
September 30, 1986
B)
September 30, 1985
C)
September 30, 1984
D)
September 30, 1983

Correct Answer :   September 30, 1985

Explanation : Microsoft released the first version of Excel for the Macintosh on September 30, 1985, and the first Windows version was 2.05 (to synchronize with the Macintosh version 2.2) on November 19, 1987.

2 .
Excel is a ____ program developed by Microsoft.
A)
Document
B)
Data management
C)
Spreadsheet
D)
All of the above

Correct Answer :   Spreadsheet

3 .
Which of the following format you can decide to apply or not in AutoFormat dialog box?
A)
Font format
B)
Border format
C)
Number format
D)
All of the above

Correct Answer :   All of the above

Explanation : AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

4 .
What is the intersection of a column and a row on a worksheet called?
A)
Cell
B)
Value
C)
Column
D)
Address

Correct Answer :   Cell

5 .
What is the extension of a Microsoft Excel file?
A)
.xcl
B)
.xlsm
C)
.xlsx
D)
.msxcl

Correct Answer :   .xlsx

Explanation : ".xlsx" is the extension of a Microsoft Excel file.

6 .
What is the default file name of Microsoft Excel file?
A)
book.xlsx
B)
book1.xlsx
C)
sheet.xlsx
D)
sheet1.xlsx

Correct Answer :   book1.xlsx

Explanation : The default file name of Microsoft Excel file is "book1.xlsx".

7 .
How can you remove borders applied in cells?
A)
Choose None on Border tab of Format cells
B)
Open the list on Border tool in Format Cell toolbar then choose first tool (none)
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Both (A) and (B)

Explanation :

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

8 .
Where can you set the shading color for a range of cells in Excel?
A)
Choose required color on Fill Color tool in Drawing toolbar
B)
Choose required color on Fill Color tool in Formatting toolbar
C)
Choose required color form Patterns tab of Format Cells dialog box
D)
All of the above

Correct Answer :   All of the above

Explanation : 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.

9 .
How do you display current date only in MS Excel?
A)
Now ()
B)
Today ()
C)
Time ()
D)
Date ()

Correct Answer :   Today ()

Explanation :

DATE : returns the serial date value for a date
TODAY : returns today’s date
NOW : returns the current date and time
TIME : assemble a proper time.

10 .
How do you wrap the text in a cell?
A)
Format cells alignment
B)
Format cells number
C)
Format cells font
D)
Format cells protection

Correct Answer :   Format cells alignment

Explanation :

Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.

11 .
Shortcut key CTRL + D is used to ________.
A)
Open font dialog box
B)
Fill down in the selection
C)
Open format cells dialog box
D)
Shift current cell's value in the right cell

Correct Answer :   Fill down in the selection

12 .
Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?
A)
Stylish Cells
B)
Table Styles
C)
Cells as Table
D)
Format as Table

Correct Answer :   Format as Table

Explanation : The option "Format as Table" is used to quickly convert a range of cells to a table with its own style converted in MS Excel

13 .
Which option is used to hide/show the Headings in MS Excel?
A)
View Menu > Show Group > Titles
B)
View Menu > Show Group > Headers
C)
View Menu > Show Group > Headings
D)
View Menu > Show Group > Gridlines

Correct Answer :   View Menu > Show Group > Headings

Explanation : To hide and show(unhide) Headings. The correct option / step is View Menu > Show Group > Headings.

14 .
What does COUNTA() function do?
A)
Counts non-empty cells
B)
Counts empty cells
C)
Counts cells having number
D)
Counts cells having alphabets

Correct Answer :   Counts non-empty cells

Explanation : COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

15 .
Excel uniquely identifies cells within a worksheet with a cell name
A)
Cell names
B)
Cell locator coordinates
C)
Column letters and row numbers
D)
Column numbers and row letters

Correct Answer :   Column letters and row numbers

Explanation : Column letters and row numbers in Excel uniquely identifies cells within a worksheet with a cell name.

16 .
The auto calculate feature is _______
A)
Can only add values in a range of cells
B)
Automatically creates formulas and adds them to a worksheet
C)
Provides a quick way to view the result of an arithmetic operation on a range of cells
D)
None of the above

Correct Answer :   Provides a quick way to view the result of an arithmetic operation on a range of cells

Explanation : The auto calculate feature provides a quick way to view the result of an arithmetic operation on a range of cells.

17 .
Microsoft Excel is used for?
A)
Analysis
B)
Data Entry
C)
Accounting
D)
All of the above

Correct Answer :   All of the above

Explanation :

Microsoft Excel is typically used for :
 
* Analysis
* Data entry
* Data management
* Accounting
* Budgeting
* Data analysis
* Visuals and graphs
* Programming
* Financial modelling,
* And many more

18 .
What is the collection of worksheets called?
A)
Book
B)
Workbook
C)
Ledger
D)
Testbook

Correct Answer :   Workbook

Explanation : The collection of worksheets is called a workbook.

19 .
The total number of rows in a worksheet?
A)
Unlimited
B)
65,535
C)
1,068,576
D)
1,048,576

Correct Answer :   1,048,576

Explanation : The total number of rows in a worksheet is 1,048,576.

20 .
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A)
Apply Conditional Formatting command on Format menu
B)
Use =if() function to format the required numbers red
C)
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D)
All of the above

Correct Answer :   Apply Conditional Formatting command on Format menu

Explanation : 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.

21 .
Which of the following is not true regarding Conditional Formatting?
A)
You can add more than one condition to check
B)
You can apply Font, border and pattern formats that meets the specified conditions
C)
You can set condition to look for Bold and apply Italics on them
D)
You can delete any condition from Conditional Formatting dialog box if it is not requried

Correct Answer :   You can set condition to look for Bold and apply Italics on them

22 .
You can use the formula palette to_______
A)
Copy a range of cells
B)
Enter assumptions data
C)
Format cells containing numbers
D)
Create and edit formula containing functions

Correct Answer :   Create and edit formula containing functions

Explanation :

Formula palette is used to create and edit formula.

It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.

23 .
When a range is selected, how can you activate the previous cell?
A)
Press Enter
B)
Press Tab
C)
Press the Alt key
D)
None of the above

Correct Answer :   None of the above

Explanation : To go to previous cell we use Go To function Ctrl + G.

24 .
You can convert existing excel worksheet data an charts to an HTML document by using_____
A)
FTP wizard
B)
Internet assistant wizard
C)
Import wizard
D)
Intranet wizard Intranet wizard

Correct Answer :   Internet assistant wizard

25 .
Which tool you will use to join some cells and place the content at the middle of joined cell?
A)
From Format Cells dialog box click on Merge Cells check box
B)
Click on Merge and Center tool on formatting toolbar
C)
From Format Cells dialog box select the Centered alignment
D)
From Format Cells dialog box choose Merge and Center check box

Correct Answer :   From Format Cells dialog box click on Merge Cells check box

Explanation :

* In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

* In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

26 .
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
A)
Select Format > Money from the menu
B)
You have to retype everything and manually add the dollar signs, commas, and decimals
C)
Click the Currency Style button on the formatting toolbar
D)
None of the above

Correct Answer :   Click the Currency Style button on the formatting toolbar

27 .
Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?
A)
Statistics
B)
Workbook Statistics
C)
Excel Statistics
D)
Workbook Analysis

Correct Answer :   Workbook Statistics

Explanation : "Workbook Statistics" displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook.

28 .
Which function is used to find the sum of complex numbers in MS Excel?
A)
ADD()
B)
SUM()
C)
CSUM()
D)
IMSUM()

Correct Answer :   IMSUM()

Explanation :

The IMSUM() function is used to find the sum of complex numbers in MS Excel.
 
Example:
 
=IMSUM("1-2i", "2+4i") // Returns 3+2i

29 .
Which is the correct syntax of the HEX2BIN() function in MS Excel?
A)
=HEX2BIN (number)
B)
=HEX2BIN (number, BASE)
C)
=HEX2BIN (number, BASE, [places])
D)
=HEX2BIN (number, [places])

Correct Answer :   =HEX2BIN (number, [places])

Explanation :

The correct syntax of HEX2BIN() function in MS Excel is:
 
=HEX2BIN (number, [places])
 
Example:
 
=HEX2BIN("F") // Return 1111
=HEX2BIN("F",8) // Returns 00001111

30 .
Which function is used to remove extra spaces from the text in MS Excel?
A)
TRIM()
B)
TRUNC()
C)
REMOVE()
D)
All of the above

Correct Answer :   TRIM()

Explanation :

The TRIM() function is used to remove extra spaces from the text in MS Excel.
 
Syntax :
 
=TRIM (text)
Example:
 
=TRIM("     Hello      World!    ") // Returns "Hello World!"

31 .
What is the short cut key to highlight the entire column?
A)
Ctrl + C
B)
Ctrl + Enter
C)
Ctrl + Space Bar
D)
Ctrl + Page Up

Correct Answer :   Ctrl + Space Bar

Explanation : Ctrl + Space Bar is the short cut key to highlight the entire column.

32 .
In the formula, which symbol specifies the fixed columns or rows?
A)
;
B)
$
C)
*
D)
%

Correct Answer :   $

Explanation : The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

33 .
A circular reference is _________
A)
Geometric modeling tool
B)
A cell that points to a drawing object
C)
Always erroneous
D)
A formula that either directly or indirectly depends on itself

Correct Answer :   A formula that either directly or indirectly depends on itself

Explanation : A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.

34 .
Which of following is Not one of Excel's what-if function?
A)
Solver
B)
Auto Outline
C)
Goal seek
D)
Scenario manager

Correct Answer :   Auto Outline

Explanation : Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

35 .
When you insert an excel file into a word document. The data are
A)
Linked
B)
Embedded
C)
Use the word menu bar and toolbars
D)
Hyperlinked placed in a word table

Correct Answer :   Linked

Explanation : When we insert an excel file into a word document and keep the source file linkage when data is updated in source file update data in liked file also. The data are Linked. In Embedded objects file become part of document and does not get updated when source file is updated.

36 .
You can use drag-and-drop to embed excel worksheet data in a word document_______
A)
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
B)
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C)
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
D)
None of the above

Correct Answer :   By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

Explanation : We can use 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 the Ctrl key.

37 .
Data can be arranged in a worksheet in a easy to understand manner using_______
A)
Changing fonts
B)
Auto formatting
C)
Applying styles
D)
All of the above

Correct Answer :   All of the above

Explanation : Data can be arranged in a worksheet in a easy to understand manner using all or any of the above options.

38 .
The total number of columns in a worksheet?
A)
26
B)
256
C)
12,834
D)
16,384

Correct Answer :   16,384

Explanation : The total number of columns in a worksheet is 16,384.

39 .
What is the column width in a worksheet?
A)
26 characters
B)
128 characters
C)
255 characters
D)
256 characters

Correct Answer :   255 characters

Explanation : The column width in a worksheet is 255 characters.

40 .
The total number of characters that a cell contains is?
A)
30,768 characters
B)
32,767 characters
C)
65,535 characters
D)
1,32,767 characters

Correct Answer :   32,767 characters

Explanation : The total number of characters that a cell contain are 32,767 characters.

41 .
Tab scroll buttons are place on Excel screen______
A)
Towards the bottom left corner
B)
Towards the top left corner
C)
Towards the top right corner
D)
Towards the bottom right corner

Correct Answer :   Towards the bottom left corner

Explanation : On the bottom left of the worksheet we find the Sheet Tab Scroll Buttons to move to the First sheet, Previous sheet, Next sheet, and Last sheet. They are followed by the tabs for the worksheets in our workbook and the Insert Worksheet button or tab, depending on the version of Excel we are using.

42 .
The Name box on to the left of formula bar
A)
Shows the name of workbook currently working on
B)
Shows the name of worksheet currently working on
C)
Shows the name of cell or range currently working on
D)
None of the above

Correct Answer :   Shows the name of worksheet currently working on

Explanation : Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.

43 .
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
A)
Data sheet
B)
Macro sheet
C)
Work sheet
D)
Chart sheet

Correct Answer :   Data sheet

44 .
The ____ function is used to convert to text in a number format in MS Excel.
A)
NUM()
B)
CONVERT()
C)
TEXT()
D)
CONVERTTEXT()

Correct Answer :   TEXT()

Explanation : The TEXT() function is used to convert to text in a number format in MS Excel.

45 .
Which function is used to get the location of text in a string in MS Excel?
A)
INDEX()
B)
FIND()
C)
STRINGSEARCH()
D)
SEARCH()

Correct Answer :   SEARCH()

Explanation :

The SEARCH() function is used to get the location of text in a string.
 
Syntax :
 
=SEARCH (find_text, within_text, [start_num])
Example:
 
=SEARCH("How","Hello, world! How are you?") // Returns 15

46 .
Show/Hide Gridlines option is available in the ____ Menu.
A)
Data
B)
Format
C)
Insert
D)
Page Layout

Correct Answer :   Page Layout

Explanation : In the "Page Layout" Menu, the option to show/hide gridlines available.

47 .
Under which menu, we can insert Header and Footer on the sheet?
A)
Data
B)
Insert
C)
Review
D)
Format

Correct Answer :   Insert

Explanation : The header and Footer option is available in the "Insert" Menu. We can insert the Header and Footer in the sheet by clicking on the "Header and Footer" option from "Text Group" in the "Insert" Menu.

48 .
Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?
A)
Conditional Formatting
B)
Styling
C)
Special Formatting
D)
Compare Formatting

Correct Answer :   Conditional Formatting

Explanation : By using the "Conditional Formatting" feature, we can apply special formatting based on the conditions.

49 .
Which of the following is not information you can specify using the solver?
A)
Constraints
B)
Target cell
C)
Input cells
D)
Changing cells

Correct Answer :   Input cells

Explanation : Solver is used to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in the objective and constraint cells. Versions of Solver prior to Excel 2007 referred to the objective cell as the “target cell,” and the decision variable cells as “changing cells” or “adjustable cells”.

50 .
You can check the conditions against __________ when applying conditional formatting.
A)
Formula
B)
Cell value
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Both (A) and (B)

Explanation : We can check the conditions against Cell value or Formula when applying conditional formatting.

51 .
You can set Page Border in Excel from_____
A)
From Border tool in Formatting toolbar
B)
From Line Style tool in Drawing toolbar
C)
From Border tab in Format Cells dialog box
D)
You can not set page border in Excel

Correct Answer :   You can not set page border in Excel

Explanation : There is no option to set page border in Excel.

52 .
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
A)
Source
B)
Client
C)
Server
D)
None of the above

Correct Answer :   Client

Explanation : You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client

53 .
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A)
F8
B)
F9
C)
F10
D)
F11

Correct Answer :   F9

Explanation : Manual calculation mode means that Excel will only recalculate all open workbooks when we request it by pressing F9. It allows to choose whether we want to update formulas in worksheets or entire workbook.

54 .
Where can you change automatic or manual calculation mode in Excel?
A)
Double CAL indicator on status bar
B)
Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button

Explanation : When you press F9 or click Calc Sheet on the Calculation tab on the Tools/Options menu. Calculation also occurs every time that you save the file if you have the checkbox “Recalculate workbook before saving” checked under File > Options > Formulas.

55 .
How can you show or hide the gridlines in Excel Worksheet?
A)
Click Gridline tool on Forms toolbar
B)
Go to Tools > Options > View tab and mark or remove the check box named Gridline
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Both (A) and (B)

Explanation :

In Excel 2016, 2013, 2010, 2007, click on View > Show > Gridlines.

For Excel 2003 and Earlier: Navigate to Tools > Options or Click Gridline tool on Forms toolbar.

56 .
What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
A)
Shift + F9
B)
Shift + F10
C)
Shift + F11
D)
Shift + F12

Correct Answer :   Shift + F11

Explanation : The keyboard shortcut to insert a new sheet in the current workbook is "Shift + F11".

57 .
What is the keyboard shortcut to insert a new comment in a cell in MS Excel?
A)
Shift + F2
B)
F2
C)
Alt + F2
D)
Ctrl + F2

Correct Answer :   Shift + F2

Explanation : The keyboard shortcut to insert a new comment in a cell is "Shift + F2".

58 .
Which Excel function is used to get the discount rate for security?
A)
DSC()
B)
PERC()
C)
DISCOUNT()
D)
DISC()

Correct Answer :   DISC()

59 .
Which is not a Text function in MS Excel?
A)
DB()
B)
CHAR()
C)
CODE()
D)
CLEAN()

Correct Answer :   DB()

Explanation : The DB() is a financial function, not a Text function, the rest of the others are text functions.

60 .
Which chart type is used to show the proportions of a while?
A)
Bar Chart
B)
Doughnut Chart
C)
Area Chart
D)
Hierarchy Chart

Correct Answer :   Doughnut Chart

Explanation : In MS Excel, the Doughnut Chart is used to show the proportions of a while. It can be used when the total of your numbers is 100%.

61 .
A numeric value can be treated as a label value if it precedes with
A)
Hash (#)
B)
Ampersand (;)
C)
Apostrophe (‘)
D)
Exclamation (!)

Correct Answer :   Apostrophe (‘)

Explanation : An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.

62 .
Getting data from a cell located in a different sheet is called ________
A)
Updating
B)
Accessing
C)
Referencing
D)
Functioning

Correct Answer :   Referencing

Explanation :

Getting data from a cell located in a different sheet is called Cell reference.

There are Three types of Cell reference in Excel :
* Relative
* Absolute
* Mixed

63 .
A worksheet range is a_______
A)
A group of cells
B)
A group of worksheets
C)
A command used for data modeling
D)
A range of values such as from 23 to 234

Correct Answer :   A group of cells

64 .
How many hyperlinks can be there in a worksheet?
A)
32,767
B)
32,768
C)
65,535
D)
65,530

Correct Answer :   65,530

Explanation : There can be a maximum of 65,530 hyperlinks in a worksheet.

65 .
How many times undo levels can be used in a worksheet?
A)
25
B)
50
C)
75
D)
100

Correct Answer :   100

Explanation : There are 100 undo levels in a worksheet.

66 .
How many users can open the Excel file at the same time?
A)
512 users
B)
256 users
C)
128 users
D)
64 users

Correct Answer :   256 users

Explanation : A total number of 256 users can open the excel file at the same time. For this, the "Allow changes by more than one user..." setting should be enabled.

67 .
The intersection of a column and a row in a worksheet is called ____.
A)
Box
B)
Range
C)
Cell
D)
Page Break

Correct Answer :   Cell

Explanation : The intersection of a column and a row in a worksheet is called a "Cell".

68 .
The fill function can be ____ to complete formulas in a range.
A)
Right clicked
B)
Double-clicked
C)
Triple clicked
D)
Single clicked

Correct Answer :   Double-clicked

Explanation : The fill function can be double-clicked to complete formulas in a range.

69 .
Which of the cell pointer indicates you that you can make selection?
A)
Doctor’s symbol (Big Plus)
B)
Small thin plus icon
C)
Mouse Pointer with anchor at the tip
D)
None of the above

Correct Answer :   Doctor’s symbol (Big Plus)

Explanation : Doctor’s symbol (Big Plus) indicates we that we can make selection to cell.

70 .
Which of the cell pointer indicates that you can fill series?
A)
Small thin plus icon
B)
Doctor’s symbol (Big Plus)
C)
Mouse Pointer with anchor at the tip
D)
None of the above

Correct Answer :   Small thin plus icon

Explanation : Small thin plus icon cell pointer indicates that you can fill series.

71 .
Which of the cell pointer indicate that you can move the content to other cell?
A)
Small thin plus icon
B)
Doctor’s symbol (Big Plus)
C)
Mouse Pointer with anchor at the tip
D)
None of the above

Correct Answer :   Mouse Pointer with anchor at the tip

Explanation : Mouse Pointer with anchor at the tip cell pointer indicate that you can move the content to other cell.

72 .
Which chart type is used to show trends over time and categories?
A)
Bar Chart
B)
Doughnut Chart
C)
Hierarchy Chart
D)
Area Chart

Correct Answer :   Area Chart

73 .
Which chart type is used to visually compare values across a few categories?
A)
Area Chart
B)
Bar Chart
C)
Doughnut Chart
D)
Hierarchy Chart

Correct Answer :   Bar Chart

Explanation : In MS Excel, the Bar Chart is used to visually compare values across a few categories.

74 .
Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?
A)
Text Flip
B)
Orientation
C)
Text Layout
D)
Cell Orientation

Correct Answer :   Orientation

Explanation : In MS Excel, the 'Orientation' feature is used to rotate the text diagonally or vertically of the selected cells.

75 .
Which keyboard shortcut is used to apply 'Wrap Text' on the selected text?
A)
Alt + H + W
B)
Alt + W
C)
Alt + W + H
D)
Ctrl + H + W

Correct Answer :   Alt + H + W

Explanation : The keyboard shortcut used to apply 'Wrap Text' on the selected text is Alt + H + W

76 .
The Chart wizard term data categories refers to;
A)
A chart plot area
B)
The data range that supply chart data
C)
A horizontal axis
D)
The organization of individual values with a chart’s data series

Correct Answer :   A horizontal axis

Explanation : The Chart wizard term data categories refers to a horizontal axis.

77 .
The chart wizard term data series refers to_____
A)
A data label
B)
A chart legend
C)
A set of values you plot in a chart
D)
A collection of chart data markers

Correct Answer :   A collection of chart data markers

Explanation : The chart wizard term data series refers to a collection of chart data markers.

78 .
Which of the following is not an example of a value?
A)
350
B)
0.57
C)
May 10 2001
D)
Serial Number 50771

Correct Answer :   Serial Number 50771

Explanation : Serial Number 50771 is alpha numeric can not be considered as value.

79 .
A worksheet can have a maximum of ________ number of rows in excel 2007.
A)
256
B)
1024
C)
65535
D)
1048576

Correct Answer :   1048576

Explanation :

Excel 2003 and earlier 65,536 Rows.
Excel 2007 and higher 1,048,576 Rows.

80 .
How many characters can be typed in a single cell in Excel?
A)
65535
B)
32767
C)
1024
D)
256

Correct Answer :   32767

Explanation : A cell can contain 32,767 number of characters.

81 .
A typical worksheet has ________ number of columns.
A)
16384
B)
1024
C)
256
D)
128

Correct Answer :   16384

Explanation :

* Excel 2003 and earlier 256 (as label ‘IV’) columns.

* Excel 2007 and higher 16,384 (as label ‘XFD’) columns.

82 .
Which of the following formulas will Excel not be able to calculate?
A)
=SUM(A1:A5)*.5
B)
=SUM(Sales)-A3
C)
=SUM(A1:A5)-10
D)
=SUM(A1:A5)/(10-10)

Correct Answer :   =SUM(Sales)-A3

Explanation : SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.

83 .
Which of the following formulas is not entered correctly?
A)
10+50
B)
=10+50
C)
=B7+14
D)
=B7*B1

Correct Answer :   10+50

Explanation :

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Here in option D 10+50 there is no equal sign (=), so it is not correct.

84 .
Which symbol must all formula begin with?
A)
+
B)
(
C)
=
D)
@

Correct Answer :   =

Explanation : A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

85 .
Which of the following is an absolute cell reference?
A)
A1
B)
#a#1
C)
!A!1
D)
$A$1

Correct Answer :   $A$1

Explanation : The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

86 .
Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
A)
IF
B)
OR
C)
ANDIF
D)
AND

Correct Answer :   AND

Explanation :

The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.
 
Syntax :
 
=AND (logical1, [logical2], ...)

87 .
Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?
A)
IF
B)
OR
C)
AND
D)
ANDIF

Correct Answer :   OR

Explanation :

The OR() function is used to test multiple conditions and returns TRUE if one or more evaluates to TRUE, and returns FALSE if all arguments evaluate to FALSE.
 
Syntax :
 
=OR (logical1, [logical2], ...)

88 .
What is the correct syntax of IF() function?
A)
=IF (logical_test, [value_if_true], [value_if_false])
B)
=IF (logical_test: [value_if_true], [value_if_false])
C)
=IF (logical_test, {[value_if_true]}, {[value_if_false]})
D)
=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))

Correct Answer :   =IF (logical_test, [value_if_true], [value_if_false])

Explanation :

The correct syntax of IF() function is :
 
=IF (logical_test, [value_if_true], [value_if_false])

89 .
Which function is used to trap and handle errors?
A)
IFNA()
B)
ERROR()
C)
IFERROR()
D)
IFTRAP()

Correct Answer :   IFERROR()

Explanation :

The IFERROR() function is used to trap and handle errors.
 
Syntax : =IFERROR (value, value_if_error)

Example :  =IFERROR (A2/C2,"Please enter a value in C2")

90 .
Long text can be broken down into many lines within a cell. You can do this through
A)
Justify in Edit > Cells
B)
Text Wrapping in Format > Cells
C)
Wrap Text in Format > Cells
D)
All of the above

Correct Answer :   Wrap Text in Format > Cells

Explanation :

Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.

91 .
Which of the following series type is not valid for Fill Series dialog box?
A)
Growth
B)
Time
C)
Linear
D)
Autofill

Correct Answer :   Time

Explanation : Time series type is not valid for Fill Series dialog box in excel.

92 .
Which of the following you can paste selectively using Paste Special command?
A)
Formats
B)
Formulas
C)
Validation
D)
All of the above

Correct Answer :   All of the above

Explanation : We can paste formula, value, formats, comments, validation using Paste Special command.

93 .
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A)
Divide
B)
Square
C)
Goal Seek
D)
Percentage

Correct Answer :   Divide

Explanation : Paste Special allows Divide operation while you paste to new cell.

94 .
What happens when you press Ctrl + X after selecting some cells in Excel?
A)
The cells selected are marked for cutting
B)
The selected cells are deleted and cells are shifted up
C)
The selected cells are deleted and the cells are shifted left
D)
The cell content of selected cells disappear from cell and stored in clipboard

Correct Answer :   The cells selected are marked for cutting

Explanation : When we pressing the ctrl+x in the Microsoft excel sheet it means we cut the content from that cell simply means the cells selected are marked for cutting and the user has need to move the content from one cell to another cell.

95 .
Which feature is used to wrap extra-long text into multiple lines in MS Excel?
A)
Text Wrap
B)
Word Wrap
C)
Wrap Text
D)
Letter Wrap

Correct Answer :   Wrap Text

Explanation : In MS Excel, 'Wrap Text' feature is used to wrap extra-long text into multiple lines so that you can see all text.

96 .
In MS Excel, 'Merge and Center' is used to ____.
A)
Combine and centre the content of the current row
B)
Combine and centre the content of the selected cell
C)
Concatenate the text of the two cells and returns the text
D)
None of the above

Correct Answer :   Combine and centre the content of the selected cell

Explanation : In MS Excel, 'Merge and Center' is used to combine and centre the content of the selected cell.

97 .
What is the correct value of the function? =ROUND (1.9867,2)
A)
1.00
B)
1.61
C)
1.98
D)
1.99

Correct Answer :   1.99

Explanation : The function =ROUND (1.9867,2) will return 1.99

98 .
Which programming language is used to write a Macro in MS Excel?
A)
C
B)
C++
C)
Java
D)
Visual Basic

Correct Answer :   Visual Basic

Explanation : Visual Basic is the programming language that is used to write a Macro in MS Excel.

99 .
The currently selected cell address is displayed in ____.
A)
Name Box
B)
Formula Bar
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Name Box

Explanation : Currently selected cell address is displayed in the Name Box.

100 .
What is the keyboard shortcut to view formulas instead of values in MS Excel?
A)
ALT + `
B)
CTRL + `
C)
CTRL + ALT + `
D)
CTRL + SHIFT + F

Correct Answer :   CTRL + `

Explanation : The keyboard shortcut to view formulas instead of values is CTRL + `.

101 .
What is the keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar in MS Excel?
A)
ALT + '
B)
CTRL + '
C)
CTRL + ALT + '
D)
CTRL + SHIFT + F

Correct Answer :   CTRL + '

Explanation : The keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar is CTRL + '.

102 .
Which menu option can be used to split windows into two_____
A)
View > split
B)
Window > split
C)
Format > window
D)
View > window > split

Correct Answer :   View > window > split

Explanation : View > Window > Split option can be used to split windows into two.

103 .
Which of the following is the latest version of Excel_______ in 2022
A)
Excel 365
B)
Excel 2007
C)
Excel 2016
D)
Excel 2019

Correct Answer :   Excel 365

Explanation : Office 365, always receive updates to the latest version of Office.

104 .
To copy cell contents using drag and drop press the_____
A)
Esc key
B)
End key
C)
Ctrl key
D)
Shift key

Correct Answer :   Ctrl key

Explanation : To copy cell contents using drag and drop press the Ctrl key else it will move the data.

105 .
Comments can be added to cells using_____
A)
File > Comments
B)
Edit > Comments
C)
View > Comments
D)
Insert > Comments

Correct Answer :   Insert > Comments

106 .
Right clicking something in Excel:
A)
Selects the object
B)
Deletes the object
C)
Opens a shortcut menu listing everything you can do to the object
D)
Nothing the right mouse button is there for left handed people

Correct Answer :   Opens a shortcut menu listing everything you can do to the object

Explanation : Right clicking something in Excel opens a shortcut menu listing everything you can do to the object.

107 .
You can edit a cell by______
A)
Clicking the formula button
B)
Double clicking the cell to edit it in-place
C)
Selecting Edit > Edit Cell from the menu
D)
None of the above

Correct Answer :   Double clicking the cell to edit it in-place

Explanation : Double clicking the cell to edit it in-place

108 .
You can use the drag and drop method to_________
A)
Copy cell contents
B)
Move cell contents
C)
Add cell contents
D)
Both (A) and (B)

Correct Answer :   Both (A) and (B)

Explanation : Drag-and-drop is a mouse technique that we can use in Excel to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving cell entries around a worksheet, we can also adapt it to copy a cell selection.

109 .
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
A)
Press Esc
B)
Press the Erase key
C)
Press the Enter button
D)
Press the Edit Formula button

Correct Answer :   Press Esc

Explanation : Pressing the Esc key while editing a cell aborts the operation and leaves the cell in it’s original state.

110 .
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A)
Press Home
B)
Press Ctrl + Home
C)
Press Alt + Home
D)
Press Shift + Home

Correct Answer :   Press Ctrl + Home

Explanation : Ctrl + Home key is the fastest way of getting to cell A1 in a spreadsheet.

111 .
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
A)
List boxes
B)
Combo boxes
C)
Text boxes
D)
Option buttons

Correct Answer :   Text boxes

Explanation : Excel worksheet cells work very similarly to Text boxes graphical user interface.

112 .
You can enter which types of data into worksheet cells?
A)
Formulas only
B)
Values and formulas but not labels
C)
Labels values and formulas
D)
Labels and values but not formulas

Correct Answer :   Labels values and formulas

Explanation : We can enter Labels, values, and formulas into worksheet cells.

113 .
Which function is used to trap and handle #N/A errors?
A)
ERROR()
B)
IFERROR()
C)
IFERRORNA()
D)
IFNA()

Correct Answer :   IFNA()

Explanation :

The IFNA() function is used to trap and handle #N/A errors.
 
Syntax : =IFNA (value, value_if_na)

Example : =IFNA(VLOOKUP(A5,xtable,2,0),"Error: Not found")

114 .
Which function is used to get a date n working days in the future or past?
A)
WORKDAY()
B)
DAYM()
C)
DAY()
D)
WORKDATE()

Correct Answer :   WORKDAY()

Explanation :

The WORKDAY() function is used to get a date n working days in the future or past.
 
Syntax : =WORKDAY (start_date, days, [holidays])

115 .
Which function is used to match multiple values and returns the first match?
A)
IF()
B)
SWITCH()
C)
IIF()
D)
IFS()

Correct Answer :   SWITCH()

Explanation :

The SWITCH() function is used to match multiple values and returns the first match.
 
Syntax : =SWITCH (expression, val1/result1, [val2/result2], ..., [default])

Example : =SWITCH(G4,0,"Sun",1,"Mon",2,"Tue",3,"Wed",4,"Thu",5,"Fri",6,"Sat")

116 .
Which function is used to create a date with year, month, and day?
A)
DATE()
B)
CURDATE()
C)
DATEDIF()
D)
DATEVALUE()

Correct Answer :   DATE()

Explanation :

The DATE() function is used to create a date with year, month, and day.
 
Syntax : =DATE (year, month, day)

Example : =DATE(2022,2,20) // returns Feb 20, 2022

117 .
Which function is used to get days, months, or years between two dates?
A)
DATE()
B)
CURDATE()
C)
DATEDIF()
D)
DATEVALUE()

Correct Answer :   DATEDIF()

Explanation :

The DATEDIF() function is used to get days, months, or years between two dates.
 
Syntax : =DATEDIF (start_date, end_date, unit)

Example :
 
=DATEDIF("20-02-2020","20-02-2022","y") // Returns 2
=DATEDIF("20-02-2020","20-02-2022","m") // Returns 24
=DATEDIF("20-02-2020","20-02-2022","d") // Returns 731

118 .
What is the keyboard shortcut to insert a SUM formula in MS Excel?
A)
ALT + S
B)
CTRL + =
C)
ALT + =
D)
CTRL + ALT + =

Correct Answer :   ALT + =

Explanation : The keyboard shortcut to insert a SUM formula is "ALT + =". For this, select the cell range and press "ALT+=". You will get the SUM of the values of the selected range.

119 .
To remove the content of selected cells you must issue ______ command
A)
Delete
B)
Clear All
C)
Clear Delete
D)
Clear Contents

Correct Answer :   Clear Contents

Explanation : To remove the content of selected cells we must issue Clear Contents command. Clear Contents will clear only the data, will not clear any formats.

120 .
Which command will you choose to convert a column of data into row?
A)
Cut and Paste
B)
Paste Special > Transpose
C)
Both (A) and (B)
D)
None of the above

Correct Answer :   Paste Special > Transpose

Explanation : Transpose (rotate) data from rows to columns or vice versa. To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

121 .
Ctrl + D shortcut key in Excel will
A)
Fill down in the selection
B)
Open the font dialog box
C)
Apply double underline for the active cell
D)
None of the above

Correct Answer :   Fill down in the selection

Explanation : Ctrl+D fills the cell beneath with the contents of the selected cell in a column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

122 .
The shortcut key Ctrl + R is used in Excel to
A)
Right align the content of cell
B)
Remove the cell contents of selected cells
C)
Fill the selection with active cells to the right
D)
None of the above

Correct Answer :   Fill the selection with active cells to the right

Explanation : Ctrl+R fills the row cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Right arrow to select multiple cells. Then press Ctrl+R to fill them with the contents of the original cell.

123 .
What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?
A)
CTRL + 1
B)
ALT + 1
C)
CTRL + F
D)
CTRL + SHIFT + F

Correct Answer :   CTRL + 1

Explanation : The keyboard shortcut to display the Format Cells dialog box is "CTRL + 1".

124 .
What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?
A)
ALT + SHIFT + "
B)
CTRL + ALT + "
C)
CTRL + SHIFT + C
D)
CTRL + SHIFT + "

Correct Answer :   CTRL + SHIFT + "

Explanation : The keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar is "CTRL + SHIFT + "".

125 .
What is the keyboard shortcut to switch between open Excel windows?
A)
ALT + TAB
B)
CTRL + TAB
C)
CTRL + ALT + TAB
D)
None of the above

Correct Answer :   CTRL + TAB