100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
Excel Exam Study Guide UPDATED Actual Exam Questions and CORRECT Answers $10.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. Excel
  4.  
  5. Excel

Exam (elaborations)

Excel Exam Study Guide UPDATED Actual Exam Questions and CORRECT Answers
 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

Preview 4 out of 62  pages

Document information

  • September 14, 2024
  • 62
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • Excel
  • Excel

Seller

avatar-seller
MGRADES

Reviews received

Content preview

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

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69252 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$10.99
  • (0)
Add to cart
Added