MICROSOFT EXCEL STUDY GUIDE 1/ QUESTIONS AND ANSWERS. 2024/2025 UPDATE

MICROSOFT EXCEL STUDY GUIDE 1/
QUESTIONS AND ANSWERS. 2024/2025
UPDATE

1. In Excel, the term worksheet and mean the same
thing.
A) spreadsheet
B) datasheet
C) reference sheet
D) workbook: Answer: A. spreadsheet
2. A cell that is outlined in green is the cell.
A) home
B) fill
C) active
D) selected: Answer: C. active
3. When a cell is active, its column and row headings are

A) bolded
B) shaded
C) flashing
D) hidden: Answer: B. shaded
4. Two or more adjacent cells in a worksheet are a(n)
A
)

r

, MICROSOFT EXCEL STUDY GUIDE 1/
QUESTIONS AND ANSWERS. 2024/2025
UPDATE

a
n
g
e

B
)

a
r
r
a
y
C) group
D) unit: Answer: A) range
5. Which symbol inserted between two cell addresses
indicates a range?
A) colon
B) semi-colon
C) period
D) comma: Answer: A) colon

, MICROSOFT EXCEL STUDY GUIDE 1/
QUESTIONS AND ANSWERS. 2024/2025
UPDATE

6. If you wanted the days of the week to repeat for several cycles
in consecutive rows, you would use the feature to make
it easier.
A) AdjacentFiII
B) ValueRepeat
C) Formula AutoComplete
D) Autofill: Answer: D) Autofill
7. When a cell is part of an active function, it is
A) surrounded by a moving border
B) preceded by an Options button
C) highlighted
D) surrounded by a solid border: Answer: A) surrounded by a moving
border
8. Which is an example of an Excel function?
A) =D7/D20



9. Which cells are included in the sum calculated by the function

A) E5, F5, and G5
B) E5 and F5
C) D5, E5, F5, and G5