Excel Gyan
- 1.
When you enter a formula in Excel, what sign must go in front of the formula?
- A.
>
- B.
#
- C.
=
- D.
!
Correct Answer
C. =Explanation
When entering formulas, you need to put an equals (=) sign in front. Otherwise, the formula will merely be text in a cell.Rate this question:
-
- 2.
What appears in a cell when a column is not wide enough for its numerical contents?
- A.
??????????
- B.
##########
- C.
>>>>>>>>>>
- D.
!!!!!!!!!!
Correct Answer
B. ##########Explanation
####### appear if the cell is too narrow to display the numerical contents.
To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width.
To widen the column manually: Drag the divider between the column headers.Rate this question:
-
- 3.
True or False: Headers and footers only apply to a specific worksheet not the entire workbook
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Headers and footers typically appear on every page of a report. In Excel 2010, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to identify the document and to display the page numbers. Unless you specify otherwise, Excel does not automatically add either a header or footer to a new workbook.Rate this question:
-
- 4.
Which of the following tasks can be performed with Excel?
- A.
Create a spreadsheet
- B.
Create a chart
- C.
Summarise numerical data
- D.
All of the above
Correct Answer
D. All of the above -
- 5.
By default how many worksheets are in a workbook?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
C. 3 -
- 6.
What is a pivot table?
- A.
A report
- B.
An advanced filter
- C.
A filter
- D.
Vlookup
Correct Answer
A. A report -
- 7.
A_________ is a built in mathematical formula included in excel.
- A.
Function
- B.
Cell
- C.
Formula
- D.
Range
Correct Answer
A. Function -
- 8.
Which function would you use to find the largest number of a selected range?
- A.
MAXIMUM
- B.
MAX
- C.
LARGE
- D.
LARGEST
Correct Answer
B. MAX -
- 9.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
#
- B.
%
- C.
&
- D.
$
Correct Answer
D. $ -
- 10.
Which feature in Excel allows you to view two spreadsheets in one window?
- A.
Freeze panes
- B.
Split
- C.
View side by side
- D.
Mirror
Correct Answer
B. Split -
- 11.
Which of the following is mixed cell reference with a fixed row address?
- A.
P72
- B.
G$9
- C.
$K356
- D.
$F$8
Correct Answer
B. G$9 -
- 12.
Which of the following is a relative cell reference?
- A.
P72
- B.
G$9
- C.
$K356
- D.
$F$8
Correct Answer
A. P72 -
- 13.
Which of the following is an mixed cell reference with a fixed column address?
- A.
P72
- B.
G$9
- C.
$K356
- D.
$F$8
Correct Answer
C. $K356 -
- 14.
The Chart Tools commands are found in these three tabs?
- A.
Design, Shape, Layout
- B.
Layout, Format, Type
- C.
Design, Layout, Format
- D.
Styles, Shapes, Effects
Correct Answer
C. Design, Layout, Format -
- 15.
Which of the following is an absolute cell reference?
- A.
P72
- B.
G$9
- C.
$K356
- D.
$F$8
Correct Answer
D. $F$8 -
- 16.
Is it possible to insert an image from a file into an Excel spreadsheet?
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 17.
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
- A.
A1-J15
- B.
A1.J15
- C.
A1;J15
- D.
A1:J15
Correct Answer
D. A1:J15 -
- 18.
What will be the formula in the cell B3 if you want to calculate the profit?
- A.
=A1-A2
- B.
=B2-B1
- C.
=B1-B2
- D.
None of the above
Correct Answer
C. =B1-B2Explanation
Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.Rate this question:
-
- 19.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
- A.
![Excel Gyan - Quiz]()
- B.
![Excel Gyan - Quiz]()
- C.
![Excel Gyan - Quiz]()
Correct Answer
A. -
- 20.
Which feature in Excel allows you to view two spreadsheets in one window?
- A.
Freeze panes
- B.
Split
- C.
View side by side
Correct Answer
B. Split -
- 21.
Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?
- A.
ROUND
- B.
ROUNDUP
- C.
ROUNDDOWN
- D.
RAND
Correct Answer
A. ROUND -
- 22.
How do you change column width to fit the contents?
- A.
Single-click the boundary to the left of the column heading.
- B.
Double-click the boundary to the right of the column heading.
- C.
Press ALT and single-click anywhere in the column.
Correct Answer
B. Double-click the boundary to the right of the column heading. -
- 23.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
- A.
Yes
- B.
No
Correct Answer
A. Yes -
- 24.
A Formula and a function are the same thing.
- A.
True
- B.
False
Correct Answer
A. True -
- 25.
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
Correct Answer
=SUM(A1:A5)
=A1+A2+A3+A4+A5
=sum(a1:a5)
=a1+a2+a3+a4+a5 - 26.
A macro is a recording of a series of steps that completes a task or group of tasks that can be "played back" later when needed.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
A macro is a "mini program" the user creates in Excel by actually going through the steps desired while Excel records the keystrokes and commands typed.Rate this question:
-
- 27.
How many data series can be used in a pie chart?
- A.
0
- B.
As many as you want.
- C.
1
- D.
7
Correct Answer
C. 1Explanation
A pie chart would be meaningless with more than one data series, therefore Excel will not even produce a pie chart if you try to use more than one data series.Rate this question:
-
- 28.
Removing the contents of a cell is known as ____ a cell.
- A.
Clearing
- B.
Emptying
- C.
Editing
- D.
Deleting
Correct Answer
A. Clearing -
- 29.
A group of worksheet cells is called a _________.
Correct Answer
range - 30.
A document inside excel is called a
- A.
A worksheet
- B.
A workbook
- C.
A page
- D.
An object
Correct Answer
B. A workbook -
- 31.
Values in a cell are aligned at the
- A.
Left
- B.
Right
- C.
Center
- D.
Bottom
Correct Answer
B. Right -
- 32.
Text inside a cell is aligned
- A.
Left
- B.
Right
- C.
Center
- D.
Bottom
Correct Answer
A. Left -
- 33.
Number of rows in a spreadsheet
- A.
256
- B.
255
- C.
65,565
- D.
50,000
Correct Answer
C. 65,565 -
- 34.
.................is a collection of pages in a workbook
- A.
Spreadsheet
- B.
Worksheet
- C.
Spreadbook
- D.
Sheet
Correct Answer
A. Spreadsheet -
- 35.
The format for an IF statement is:
- A.
=SUM(condition,x,y)
- B.
=IF(condition,x,y)
- C.
=(condition,x,y)
Correct Answer
B. =IF(condition,x,y) -
- 36.
A graphic that allows you to compare and contrast data in a visual format.
- A.
Plot
- B.
Legend
- C.
Chart
Correct Answer
C. Chart -
- 37.
A chart that occupies its own worksheet
- A.
Embedded chart
- B.
Chart sheet
- C.
Stand alone chart
Correct Answer
B. Chart sheet -
- 38.
A key that identifies each of the data series in a chart.
- A.
Key
- B.
Map
- C.
Legend
Correct Answer
C. Legend -
- 39.
How do you spell check an Excel worksheet?
- A.
Under the Tools menu, click Spelling.
- B.
Press F7.
- C.
Click the button with ABC Check Mark icon.
- D.
Any of the above will perform a spell check.
Correct Answer
D. Any of the above will perform a spell check. -
- 40.
What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
Correct Answer
B. Displays a website -
- 41.
How would Excel display this value =ROUND(1.567) in the cell?
- A.
1
- B.
2
- C.
1.57
- D.
1.6
Correct Answer
C. 1.57 -
- 42.
What is the keyboard shortcut command to move the mouse pointer to cell A1
- A.
Control + Home
- B.
Control + F4 key
- C.
Name box
- D.
Control + A1
- E.
Control + Tab key
Correct Answer
A. Control + Home -
- 43.
Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
Correct Answer
D. TODAY() -
- 44.
What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
Correct Answer
C. Max() -
- 45.
How can you start Edit mode to edit a formula?
- A.
Tools
- B.
Format
- C.
F4
- D.
F2 or double-click cell
- E.
Find and replace
Correct Answer
D. F2 or double-click cell -
- 46.
What type of operation is being preformed in the formula =A4*B5
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
Correct Answer
E. Multiplication -
- 47.
Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
Correct Answer
B. Portrait -
- 48.
How would the cell reference $F$4 be described?
- A.
Mixed reference
- B.
Absolute reference
- C.
Relative reference
- D.
Additional reference
- E.
Money reference
Correct Answer
B. Absolute reference -
- 49.
What is the keyboard shortcut to display or hide formulas?
- A.
Control + F4 key
- B.
Control + ~
- C.
Control + K
- D.
Control + P
- E.
Control +F
Correct Answer
B. Control + ~ -
- 50.
What does the TRUNC function do?
- A.
Formats data
- B.
Indents data
- C.
Adds numbers
- D.
Removes the decimal part of the number
Correct Answer
D. Removes the decimal part of the number -
.gif)
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 27, 2014Quiz Edited by
ProProfs Editorial Team -
Feb 26, 2014Quiz Created by
Sunil Singhal
Back to top