1.
When you enter a formula in Excel, what sign must go in front of the formula?
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.
2.
What appears in a cell when a column is not wide enough for its numerical contents?
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.
3.
True or False: Headers and footers only apply to a specific worksheet not the entire workbook
Correct Answer
A. True
Explanation
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.
4.
Which of the following tasks can be performed with Excel?
Correct Answer
D. All of the above
5.
By default how many worksheets are in a workbook?
Correct Answer
C. 3
6.
What is a pivot table?
Correct Answer
A. A report
7.
A_________ is a built in mathematical formula included in excel.
Correct Answer
A. Function
8.
Which function would you use to find the largest number of a selected range?
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?
Correct Answer
D. $
10.
Which feature in Excel allows you to view two spreadsheets in one window?
Correct Answer
B. Split
11.
Which of the following is mixed cell reference with a fixed row address?
Correct Answer
B. G$9
12.
Which of the following is a relative cell reference?
Correct Answer
A. P72
13.
Which of the following is an mixed cell reference with a fixed column address?
Correct Answer
C. $K356
14.
The Chart Tools commands are found in these three tabs?
Correct Answer
C. Design, Layout, Format
15.
Which of the following is an absolute cell reference?
Correct Answer
D. $F$8
16.
Is it possible to insert an image from a file into an Excel spreadsheet?
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 _____
Correct Answer
D. A1:J15
18.
What will be the formula in the cell B3 if you want to calculate the profit?
Correct Answer
C. =B1-B2
Explanation
Profit is equal to Revenue(B1) - Expense(B2). There the formula in B3 should be =B1 - B2.
19.
Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?
Correct Answer
A.
20.
Which feature in Excel allows you to view two spreadsheets in one window?
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?
Correct Answer
A. ROUND
22.
How do you change column width to
fit the contents?
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 ?
Correct Answer
A. Yes
24.
A Formula and a function are the same thing.
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.
Correct Answer
A. True
Explanation
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.
27.
How many data series can be used in a pie chart?
Correct Answer
C. 1
Explanation
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.
28.
Removing the contents of a cell is known as ____ a cell.
Correct Answer
A. Clearing
29.
A group of worksheet cells is called a _________.
Correct Answer
range
30.
A document inside excel is called a
Correct Answer
B. A workbook
31.
Values in a cell are aligned at the
Correct Answer
B. Right
32.
Text inside a cell is aligned
Correct Answer
A. Left
33.
Number of rows in a spreadsheet
Correct Answer
C. 65,565
34.
.................is a collection of pages in a workbook
Correct Answer
A. Spreadsheet
35.
The format for an IF statement is:
Correct Answer
B. =IF(condition,x,y)
36.
A graphic that allows you to compare and contrast data in a visual format.
Correct Answer
C. Chart
37.
A chart that occupies its own worksheet
Correct Answer
B. Chart sheet
38.
A key that identifies each of the data series in a chart.
Correct Answer
C. Legend
39.
How do you spell check an Excel worksheet?
Correct Answer
D. Any of the above will perform a spell check.
40.
What does a hyperlink do?
Correct Answer
B. Displays a website
41.
How would Excel display this value =ROUND(1.567) in the cell?
Correct Answer
C. 1.57
42.
What is the keyboard shortcut command to move the mouse pointer to cell A1
Correct Answer
A. Control + Home
43.
Which function enters the current date?
Correct Answer
D. TODAY()
44.
What function would display the highest sales amount in a column?
Correct Answer
C. Max()
45.
How can you start Edit mode to edit a formula?
Correct Answer
D. F2 or double-click cell
46.
What type of operation is being preformed in the formula =A4*B5
Correct Answer
E. Multiplication
47.
Which orientation is taller than it is wide?
Correct Answer
B. Portrait
48.
How would the cell reference $F$4 be described?
Correct Answer
B. Absolute reference
49.
What is the keyboard shortcut to display or hide formulas?
Correct Answer
B. Control + ~
50.
What does the TRUNC function do?
Correct Answer
D. Removes the decimal part of the number