NEW
Font size
WorksheetsEDPM Basics
Total questions: 20
Worksheet time: 10mins
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen.
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen.
The past cell in a worksheet. It is indicated by a dark border onscreen.
2. Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data.
3. What is a spreadsheet?
An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.
An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.
An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.
An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.
4. What is a sheet in Excel?
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single template that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
5. What is the green bar at the top of Excel referred to as?
the data bar
the function bar
the ribbon
the row
6. The letters in Excel represent the _______?
columns
rows
data
functions
7. The numbers in Excel represent the _____?
columns
rows
data
functions
8. What is the name of this cell?
B10
5B
B5
A5
9. What is a file which contains one or more spreadsheets?
spreadsheet
workbook
cell
cell range
10. Which is an example of a cell address?
126
A9
=SUM
75/65
11. A column is vertical.
true
false
12. A row is horizontal.
true
false
13. You can add, subtract, multiply and divide in excel.
true
false
14. Excel allows you to
read stories
invent ideas
work with data
15. A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
Insert
Formula Bar
Tables
16. The ______ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
Autorepair
Autocheck
Gramar
Autocorrect
17. The cell in your worksheet that has been selected. It will have bolder gridlines around it.
TRUE
FALSE
18. Which tab in Excel has charts and tables?
review
home
file
insert
19. Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:
a) The cell reference for the selected cells is B:21, C:28, D:22, E:26 and F:25.
b) The cell reference for the selected cells is row 15, column F
c) The cell reference for the selected cells is F4:F5
d) The cell reference for the selected cells is B15:F15
20. Which of the following functions are you likely to find under the Insert tab on the Ribbon?
Insert a page break.
Insert a formula.
Insert a table.
Insert track changes.
