Excel Exam Study Guide UPDATED Actual Exam Questions and CORRECT Answers

Excel Exam Study Guide UPDATED Actual
Exam Questions and CORRECT Answers
1) When Excel opens, a new blank ________ is displayed.
A) presentation
B) database
C) document

D) workbook - CORRECT ANSWER✔✔- D


2) Pages in a workbook are referred to as ________.
A) sub workbooks
B) grid sheets
C) worksheets

D) pages - CORRECT ANSWER✔✔- C


3) In Excel, the term worksheet and ________ mean the same thing.
A) spreadsheet
B) datasheet
C) reference sheet

D) workbook - CORRECT ANSWER✔✔- A


4) When identifying a cell as C12, you are using its ________ address.
A) worksheet
B) grid
C) cell

D) workbook - CORRECT ANSWER✔✔- C


5) A cell that is outlined in green and has data typed in it is the ________ cell.
A) home
B) fill

,C) active

D) selected - CORRECT ANSWER✔✔- C


6) When a cell is active, its column and row headings are ________.
A) bolded
B) shaded
C) flashing

D) hidden - CORRECT ANSWER✔✔- B


7) The bar, located below the Ribbon, that displays the active cell's content is the ________
bar.
A) formula
B) display
C) data

D) name - CORRECT ANSWER✔✔- A


8) The cell content shown in the formula bar is referred to as the ________ value.
A) hidden
B) actual
C) displayed

D) underlying - CORRECT ANSWER✔✔- D


9) If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is
________.
A) deleted
B) wrapped
C) truncated

D) hidden - CORRECT ANSWER✔✔- C


10) Two or more adjacent cells in a worksheet are a(n) ________.
A) range

,B) array
C) group

D) unit - CORRECT ANSWER✔✔- A


11) Which cells are included in the notation A1:D1?
A) A1, B1, and C1
B) B1, C1, and D1
C) A1, B1, C1, and D1

D) A1 and D1 - CORRECT ANSWER✔✔- C


12) Which symbol inserted between two cell addresses indicates a range?
A) colon
B) semi-colon
C) period

D) comma - CORRECT ANSWER✔✔- A


13) When a range is selected, the name box displays the cell address of ________.
A) all cells in the range
B) the first cell in the range
C) the last cell in the range

D) none of the cells in the range - CORRECT ANSWER✔✔- B


14) An underlying value that does mathematical calculations on numeric values in a
worksheet is ________.
A) a cell address
B) a text value
C) the Formula AutoComplete

D) a formula - CORRECT ANSWER✔✔- D


15) The ________ displays a list of functions that match the first letter typed.

, A) formula bar
B) Quick Access Toolbar
C) the Formula AutoComplete

D) edit feature - CORRECT ANSWER✔✔- C


16) 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 - CORRECT ANSWER✔✔- A


17) When a formula is in an active cell, the underlying formula is visible in the ________.
A) status bar
B) worksheet
C) formula bar

D) Name Box - CORRECT ANSWER✔✔- C


18) The letter that displays at the top of a column is the ________.
A) column heading
B) row heading
C) named range

D) cell reference - CORRECT ANSWER✔✔- A


19) Themed Cell Styles is an option in the ________ gallery.
A) Conditional Formatting
B) Cell Styles
C) Format as Table

D) Format - CORRECT ANSWER✔✔- B


20) Which is an example of an Excel function?