Excel Exam Study Guide UPDATED Actual Exam Questions and CORRECT Answers
6 views 0 purchase
Course
Excel
Institution
Excel
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
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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
