Excel Basics Quiz for Beginners
Uploaded by
ScribdTranslationsExcel Basics Quiz for Beginners
Uploaded by
ScribdTranslationsALUNO:______________________________________________ DATA: _____/______/_____
EXCEL TEST
What is Microsoft Excel?
A file manager.
B. An electronic spreadsheet.
C. A figure cataloguer.
D. An electronic dictionary.
What is a cell?
A. An Excel function.
B. It is a unit of the spreadsheet in which data is entered and stored.
C. It is the name given to a set of numbers.
D. It is the name given to a workbook.
3. How do we know that a cell is active?
A. It stays with the red background.
B. It is larger than the others.
C. It has a bold border.
D. It keeps blinking.
4. What are workbooks for?
A. To give a better appearance to the spreadsheet.
Not at all.
C. To reduce the total file size.
D. To organize many spreadsheets in the same file.
5. What can we do with conditional formatting?
We can highlight a value if it reaches a certain value.
B. We can change the data of a cell.
C. We can combine several cells.
D. Change the language used in the spreadsheet.
6. In Excel, which signs do we use for multiplication and division?
A. - e +
B. $ e %
C. * e /
D. < e >
7. What is the function used to compare through a logical test and return as a response
a value assigned as true and another assigned as false?
A. Soma
B. Be
C. Average
D. Test
8. In an Excel spreadsheet, we find various boxes that we name:
A. Data
B. Forms
C. Lines
D. Cells
9. What kind of software is Excel?
A. An operating system
B. A calculation utility
C. A text and number editor
A spreadsheet editor app
10. How should we proceed to change the width of a column?
A. Opening the measurements dialog using the shortcut ctrl + m
B. Changing the measurement through the menu bar in edit
C. Clicking on the header of the column on the right and holding down the mouse button
pressing, dragging the cursor to the desired measure
D. Determining the measure by the formatting bar
11. Let's say there are several values to be summed that start in cell B5 and
extend to cell B20. What formula should be used to solve this calculation?
A. =SUM(B5+B20)
B. =B5+B20
C. =B5:B20
D. =SUM(B5:B20)
What is a cell?
A. It is the result of the intersection of a row with a column.
B. A self-help comic
C. A place in the formula bar to insert calculations
D. Local that stores the spreadsheets
13. What is merging cells?
A. Link the content of multiple cells
B. Merge two or more cells
C. Select multiple cells
D. Attach data to the cells
14. How should we proceed to lock the references of a cell so that when using the
filler handle, its content is not selected?
A. Placing the $ before the = sign
B. Placing the $ symbol before the letter or number of a cell reference
C. Placing the $ at the end of the formula
D. Placing the $ after the cell name
15. How should we proceed to copy the content of a cell to others making with
that its content be sequenced?
A. Using the cut and paste commands
B. Using the shortcuts ctrl + c and ctrl + v
C. Selecting all cells with the mouse
D. Using the fill handle of the cell
16. The information entered in a cell may be:
A. Fixed or relative
B. Constants or formulas
C. Numbers and formulas
D. Formulas or functions
17. A cell or range can be represented in Excel by all the options below,
except:
A. IV1
B. Valor_caixa_do_mes_de_abril
C. X700
D. A:A
E. Nda
18. The graphic symbol that within a formula locks (absolute reference) a column and/or
line, avoiding change when dragging (autofill) is:
A. %
B. &
C. *
D. $
E. Nda
Consider the following table:
A B C
1 Name Note Situation
2 John 55
3Maria 80
4 Average
19. Select the correct formula to show 'approved' in cell C2 if the student is with the
a score above 60, and failing if below the same value:
=IF(B1>60,"approved","rejected")
=IF(B2>60,"approved","rejected")
=IF(A2<60,"failed", "passed")
=IF(B2>60,"failed","approved")
E. Nda
20. Considering the same previous table: select the correct formula to display in the cell
B4 the average of the students:
=AVERAGE(C2:C3)
B. =AVERAGE(A2:A3)
C. =AVERAGE(B2:B3)
=AVERAGE(B1)
E. Nda