Computer Science for Exams

QuesoitnResouloitn–ExceIl
[Link]ães
1. Considering the resources of Excel and the figure 5. Considering that you are working with the
above, indicate the correct alternative regarding the Excel, indicate the WRONG statement:
motive do appearance two characters
'########' in cell D4. a) The texts are normally aligned to
left of the cells, unless they are
formatted in another way
b) Formulas must always start with
the symbol = (equals sign), with the exception of
functions that do not require the use of this
character.
c) The numbers are normally aligned to
to the right of the cells, unless they are
formatted in another way)
a) Incorrect function parameter. Both texts and numbers can be
circular reference. aligned in the center of the cells.
c) Division by zero. e) We can insert a chart through the
d) Column width insufficient. chart assistant, found in the bar of
e) Unformatted cell. tools.

2. In Excel, the formula=$A$4-A5 is written in the cell6. Observing the student 'Fulano' in the spreadsheet above and
A3. If the user copies this formula to the cell assuming that the minimum average for approval is 7,
B6, Excel will rewrite this formula as: which of the formulas below was used to obtain
automatically the Student Status in column 'F'?
a) =$A$4-B5
=A4-B8
= $B$7 - B8
=A4-A5
=A7+A5

To create a new blank spreadsheet in Excel,

it should be activated:
a) = If(E2>=7,[approved],[disapproved])
File - New b) = If(E2>7; (approved); (failed))
b) File - Save c) = If(E2>=7;"approved";"failed")
d) = If(E2>=7;"failed";"approved")
c) Insert - Spreadsheet
e) = If(E2>=7;failed;approved)
d) Insert - New
e) Edit – New 7. What will be the result when we apply the formula
=COUNTA(A1:A3) in cell A4 in the table of
4. Observe in the following figure a section of a Microsoft Excel below?
MS Excel spreadsheet.
a) 6
To obtain the sum b) 1
two values nas c) 3
selected cells, d) 4
NO is not an alternative e) 123
correct

8. In MS Excel, the reference is

a) the version of the application.

a) Check the sum value on the status bar b) the creation date of the spreadsheet.
b) Use the formula =A1+A2+A3+A4:A6 c) the identification of a cell or range of
c) Use the formula =SUM(A1:A6) cells in a spreadsheet.
d) Use the formula =SUM(A1;A2;A3;A4;A5;A6) d) the bar that displays information about a
selected command.
e) Use the formula =SUM(A1+A2+A3+A4+A5+A6) e) a column of the spreadsheet.

Prof. Marco Guimarães - Resolution of Questions - NUCE - Computer Science - Excel II Page 1
 Computer Science for Competition
ResouloitnofIssues–ExceIl
[Link]ães

9. Regarding the MS EXCEL ® application: 12. Answer this question based on Figure e
in the information contained therein. If it is given
I. The procedure for selecting a set of a click with the left mouse button on
cells in sequence within the same
column is to click with the mouse on the 1st cell to be the icon: , what value will the content contain
selected and, holding the SHIFT key B1 cell?
pressed, click on the last desired cell.
II. The procedure for selecting a set of 2,990
randomly alternating cells within
a spreadsheet is to click on the desired cell and,
b) 2.9
holding down the CTRL key, click on the 3
other cells of the spreadsheet.
3.0
III. The procedure for copying the content of a
cell is to click on the desired cell, and keeping the 3.00
ALT key pressed, click on the new cell to
paste the content.
13. Analyze the statements below, based on the Figure
It is/are correct. and the information contained therein.

a) only I.
b) only I and III.
c) only II and III.
d) only I and II.
e) a I, a II and a III.

10. Regarding MS Excel, it is correct to state that

a) there cannot be a relationship between the value of a

cell and the values of other cells.
b) one or more hidden columns are
transferred to an auxiliary file to be
this can be accessed for its re-airing.
c) the lines can be ordered according to the I. When a click is made with the left button
values of the cells in a chosen column.
mouse over the button , it will appear the
d) the Split and Freeze Panes commands have the
value 23 in cell address A4.
same function.
II. The Zoom value (100%) is standard in this version
e) all the columns of the same spreadsheet
they must have the same width. do Excel 2003.
III. When clicking with the left button

mouse over the button, it will be request to

11. To represent the existing range of cells
between Candidate Beltrano's Score 1 and Score 3, protection password against changes.
we use the following notation:
Which one(s) is/are correct?

a) Only I and II.

b) Only I.
c) Only II.
d) Only III.
e) Only II and III.

14. Which of the functions below is not a function of

Microsoft Office Excel?
a) B3–D3
B3:D3 a) Somase
c) B3;D3 b) Degrees
d) from B3 to D3 c) Average
e) B3...D3 d) Maximum
e) Subtract

Prof. Marco Guimarães - Problem Solving - NUCE - Computer Science - Excel II Page 2
 Computer Science for Competition
QuesoitnResouloitn–ExceIl
[Link]ães

15. Based on the Figure, if the user places the 18. If the user clicks the left button on
left mouse button over the cell handle mouse on the cell handle or fill handle,
pointed by the arrow number 9, and press the (as the tip of the arrow shows letter M), and
referred button, holding it down and releasing it drag while holding down the mentioned button and
about cell D1. At the end of this operation, the released over cell E2, at the end of this process
the value contained in the cell address D1 will be: What will the content of cell E2 look like?

8. a) 2
b) 14. b) 3
c) 11.
d) 13. c) 4
e) 5. d) 1

16. Consider that it is typed and visible in Excel 53

the following values contained in the respective
cell addresses that follow: A1=8 / A2=5 /
A3=2 / A4=5. The user positioned the cursor on the
cell B1, and typed exactly as follows:

SUM(A1:A4) and then, immediately after, he pressed the same

the ENTER key. Identify how it will be
content of cell B1. Excel 2003 screen (partial view)
a) 13
20 19. Based on the image represented in Figure 2,
if the user presses the left button of
c) 10 mouse over the arrow that indicates the letter X (handle of
#NAME? filling), keeping the mentioned button
pressured and loose up to cell C3, at the end of this
e) SUM(A1:A4) process, what value will be contained in the cell content
C3?

17. Regarding the figure above, consider that the a) 3

the cursor is in A3 (process in editing). And soon b) 8
after, the user pressed the ENTER key. Thus c) 11
So, determine the content of cell A3. d) 5
-2
a) 2.5
b) 2
c) 2.6 20. Consider that in an Excel spreadsheet, it was
d) 3 entered and the cell addresses are visible
2.7 containing respectively the following values:
A1=4 / A2=6 / A3=5 / B1=8 / B2=2 / B3=4 / C1=2 /
C2=10 / C3=12. And the cursor is located at
cell A5, containing exactly the following
function:

=IF(A1<>B3,MIN(A2:C3,0),SUMIF(B1:B3,2,C1:C3))
and, right after this operation, the user pressed
the ENTER key. Determine how the content will be
from cell A5.

a) 6
b) 2
Based on Figure 1 above and the information contained in it. c) 0
contained, answer question number 35. d) 16
e) 10

Prof. Marco Guimarães - Resolution of Questions - NUCE - Computer Science - Excel II Page 3
 Computer Science for Competitions
IssueResouloitn-ExceIl
[Link]ães

21. Observe the figure below.

Figure 1 Excel 2003 Window

The function of the button indicated by the arrow corresponds to

a) styles. To answer the next question, take as a basis the

b) permission. Figure 1 above, and all the information contained therein.

c) insert hyperlink. 24. The window shows a partial view of a screen of

d) research. Excel 2003 in editing. Consider that the cursor
is positioned at cell address A5. If
e) Visual Basic editor. the user presses the ENTER key the value that
will be in cell A5

22. The two figures below were extracted from a) 15.

MS-Excel in Portuguese: b) 6.
c) 12.
d) 5.
e) 9.

25. The window shows a partial view of a screen of

Excel in editing. Consider that the cursor is
positioned at cell address A4. If the
user press the ENTER key the value that
The expression =sum(Avocado;Pineapple) will have as will be in cell A4.
resultado:

17 a) 1.61.
34
b) 5.5.
c) 46
d) 73 c) 0.
e) 136
d) 1.25.
e) 2.2.
23. Observe in the following figure a section of a
Excel spreadsheet, Portuguese version:
26. To obtain a cell whose text is in two
lines, as in the figure below, should use the
following key combination:

If the formula shown is applied to cell D1, the a) Alt+Shift+Enter

the result of the cell will be:
b) Alt+Enter
a) 6 c) Ctrl+Enter
b) 15
c) 16 d) Ctrl+Shift+Enter
d) 21 e) Shift+Enter
e) False

Prof. Marco Guimarães - Resolution of Questions - NUCE - Computer Science - Excel II Page 4
 Computer Science for Competition
ResouloitnofIssues-ExceIl
[Link]ães

27. Regarding Excel and based on the Figure and in 30. Consider the spreadsheet below, prepared in Excel
information contained therein, what form 2007.
corresponds to the correct calculation of the AVERAGE function
only from column A, involving all the If the formula entered in cell A2 is propagated
computer numbers? for cell B2, the result displayed in both
cells after executing the formulas will be,
respectively, equal to 6 and

a) 2
b) 3
c) 4
d) 5
=AVERAGE(A2:A4) e) 6
=AVERAGE*(A2:A4)
=AVERAGE(A2;A4) 31. Consider that the user wants to add the values
from cells B3 to B14 in a spreadsheet in Microsoft
=AVERAGE(A4:B4) Excel. This formula can be done in various ways.
=AVERAGE&(A2:A4) forms, with the EXCEPTION of:

a) =SUM(B3:B8)+SUM(B9:B14);
=SUM(B3:B4:B5:B6:B7:B8:B9:B10:B11:B12:B13:B14);
28. Regarding Excel and based on the Figure above =SUM(B3:B14);
and the information contained in it, in case the user =SUM(B3;B14);
position the left mouse button over the =B3+B4+B5+B6+B7+B8+B9+B10+B11+B12+B13+B14.
arrow pointed by the letter A (handle of
(filling), keeping the mentioned pressed
button is loose over cell E1, just after this 32. What is the Microsoft Office Excel tool that
procedure, what value will be at the address of allows keeping some of the data visible
cell E1? while the user scrolls through a
spreadsheet?
a) 15
a) Freeze panels;
b) 5 b) Hide;
c) 20 c) Organize;
Page break;
-15 e) Format line.
10
33. In Excel, the formula =AVERAGE(A1:A5) returns a
arithmetic mean of the contained numbers:

29. Consider the spreadsheet below, created in Excel in cells A1, A2, A3, A4, and A5;
2007.
b) in all cells of rows 1 to 5;
If the formula entered in cell A3 is propagated to c) in all the cells of column A;
in cell B3, the result that will be displayed in both
cells after executing the formulas will be, d) nas células A1 eA5;
respectively, equal to 12 and in cells A2, A3, A4.

11 34. Which of the following alternatives is NOT a category?

of Excel functions?
b) 12
c) 13 a) Statistics.
b) Database.
d) 16 c) Formulas.
17 d) Date and time.
e) Financial.

Prof. Marco Guimarães - Resolution of Questions - NUCE - Computer Science - Excel II Page 5
 Computer Science for Exams
ResouloitnoQ
f uesoitnsE
-xceIl
[Link]ães

35. In Microsoft Excel 2007 - Portuguese version a) when selecting cell A6, type =SUM(A1&A5)
(Brazil) - it is desired to sum the contents of the cells and then press Enter, the result of the cell
A1, A2, A3, A4, B1, B2 and B4. Which of the following A6 was 153.
Does the command typed in cell C1 perform that action?

=SUM(A1:B4) b) when selecting cell C6, type =SUM(A1:C6)

b) =sum(A1:B4-B3) and then press Enter, the result of the cell
=SUM(A1:B4)-B3 C6 was 495.
=SUM((A1:B4)-B3)
=SUM(A1:B4)/B3 c) when selecting cell C6, type =SUM(A1:A5)
and then press Enter, the result of the cell
36. In Microsoft Excel 2007 - Portuguese version
C6 was 153.
A set of cells are
filled, each one, with integers,
d) when selecting the cells from A1 to A5, press
except one of them that is filled with the
the Ctrl key, and holding it down, select
name "João". When selecting ALL these cells
the cells from A5 to C5 and then click on the
and select the 'Currency' format in the 'Number' tab
AutoSum button, the result of cell A6 was 300.
effect on these cells will be:
e) when selecting cell B6, type =SUM(A1:C5)
a) all of them will be preceded by 'R$'.
and then press Enter, Excel displayed
b) all of them, except the cell containing 'João'
an error message and the result of cell C6
that will remain unchanged will be preceded
was 0.
of "R$".
c) an error message will be displayed
indicating that the cell containing "João" does not
38. Microsoft Excel is a spreadsheet manager.
could have been selected during the electronics. Consider the spreadsheet below. Check
choice of the format 'Currency'.
the alternative in which the formulas appear that
d) the command will be ignored, and no cell we should put in E5eF5, respectively,
will be changed. to calculate the total in R$ and the total in US$.
a message will be displayed, demanding Starting from these cells and using the handle of
confirmation of the command. If selected filling, these formulas may be
the option "OK", the cell containing "João" will be
copied up to line 11.
modified, and if the option is selected
"Ignore" this cell will remain unchanged.
The other cells will be preceded by "R$".
independent of this choice.

37. In Microsoft Excel,

A user received a Microsoft spreadsheet.

Excel, as shown to the side. How
task, you should fill in cells A6, B6 and C6
according to the pre-established rules. After
fulfilling this task, it is correct to say that,
a) =C5 / D5 and =E5 / *$C$2
=C5 * D5 and =E5 * $C$2
c) =C5 * D5 and =$E$5 / C2
=C5 / D5 and =E5 / $C$2
e) =C5 * D5 e =E5 / C$2

Prof. Marco Guimarães - Question Resolution - NUCE - Computer Science - Excel II Page 6
 Computer Science for Competition
ResouloitnoQ
f uesoitns–ExceIl
[Link]ães

39. A user received an Excel spreadsheet, II. The formula "=SUM(C2:D4)" returns as
as presented on the side. Your first the amount is "R$ 2,500.00".
the task was to complete column 'B' so that III. The formula that calculates the total of the salaries
a cell was filled with the date Employee Marcos Campos is "=B3-C3".
equivalent to the previous cell, plus a
month, that is, the cell 'B2' should be filled Select the alternative that indicates the statement(s)
with 1/2/2000, and so on. For CORRECT(S).
to facilitate the filling, he selected the cell
"B1" and double-clicked on the small square a) Only I.
what appeared in the bottom right corner of the selection.
b) Only I and II.
Only II.
After this procedure, cell "B13" of this d) Only II and III.
the spreadsheet was filled with e) Only III.

01/01/2000. 43. A cell in an Excel spreadsheet can occupy several

b) 13/01/2000. columns and/or rows using the type of
c) 01/01/2001. formatting:
01/01/2013.
e) 01/13/2000, presenting
a) Format spreadsheet.
an error message when
b) Format line.
user.
c) Format column.
Merge cells.
e) Hide cell gridlines.
40. The header and footer of a spreadsheet
Excel spreadsheets can be customized 44. Excel, in its standard form:
com:
I. Create a new workbook with three
a) A specific section for each one. spreadsheets.
b) Mixed cells for individual formatting II. Create a new spreadsheet with three sheets
of each one. work.
c) Three specific sections for each one. III. Allows the removal of sheets from the workbook.
d) Three specific sections for the header and IV. Allows you to remove worksheets from the spreadsheet.
one for the footer. V. allows for the inclusion of new spreadsheets in the folder of
e) Three specific sections for the footer and one work.
for the header. VI. Allows the inclusion of new workbooks in
spreadsheet.

41. What is an Excel workbook? It is correct what is stated ONLY in:

a temporary file. a) I and V.

b) A part of a spreadsheet b) II and IV.
c) A range of cells.
a set of spreadsheets. c) II and VI.
e) A spreadsheet d) I, III and V.
e) II, IV and VI.

42. Analyze the following statements about the spreadsheet 45. It is INCORRECT to state in an Excel spreadsheet
do Microsoft Excel. what:

a) An interval can be a line.

b) A range can be a column.
c) A range can consist of multiple rows and columns
adjacent.
d) Several intervals can be selected when
same time.
I. The average of the totals paid to employees e) The cells within a range do not always
present in the spreadsheet can be calculated by are contiguous.
=AVERAGE(D1,D4)

Prof. Marco Guimarães - Resolution of Questions - NUCE - Computer Science - Excel II Page 7
 Informatics for Competition
ResouloitnofIssues–ExceIl
[Link]ães

46. In Excel 2007 and according to the data from 49. If the formula presented is entered in cell A4,
the table displayed below, what is the result of the function =IF(OR(MOD(C3,B1)>A1;MED(A1:C3)>A3);
=IF(AVERAGE(A1:A4)>=B4/B1;LARGE(A1:C4;6); TRUNCATE(AVERAGE(A1:B1));C2), what will be the
MIN(A1:C4,4) that was typed in cell A6. result?

a) 3
14
c) 0
d) 2
e) 3.5

50. The formula =SUMIF(B1:B5,A2,C1:C5) was entered.

12 in cell B7, when you press the ENTER key, what the
b) 6
result.
c) 5
d) 3
e) 4 a) 5
11
c) 2
47. In cell A11 the user entered the formula 14
e) 7
=COUNTIF(A2:A9, A2) and pressed the key
ENTER, after this operation, what is the result
found in cell A11?

a) 1
b) 6
c) 4
d) bean
e) 16
Excel II Answer Key

Resp. Resp. Resp.

1 D 18 D 35 C
48. In an Excel table, the were typed the 2 B 19 E 36 B
values A1=6, A2=43, B1=15, B2=65, C1=35 and 3 C 20 E 37 D
C2=7, and the following was typed in cell A4 4 B 21 D 38 E
formula: 5 B 22 A 39 B
6 C 23 C 40 C
=SE(B2<A1&C2;MULT(B1*3);C1/A1) 7 C 24 D 41 D
8 C 25 C 42 D
9 D 26 B 43 D
a) Error 10 C 27 A 44 D
b) 6 11 B 28 D 45 E
12 A 29 C 46 B
c) 5 13 A 30 C 47 C
45 14 E 31 D 48 D
e) 43 15 B 32 A 49 A
16 E 33 A 50 D
17 B 34 C

Prof. Marco Guimarães - Question Resolution - NUCE - Computer Science - Excel II Page 8