ONLINE PRACTICE TEST

Excel Chapter 4

Prepare with 10 practice questions with answers and explanations.

10 questions Answers & explanations Immediate online access
Online access $9.99
Unlock this practice test Try sample questions
Excel Chapter 4

THE PRACTICE TEST

Practice test at a glance

Questions
10
Format
Multiple choice
Access
2 years
Price
$9.99
Answers
Included
Explanations
Included

GET FULL ACCESS

Unlock the full practice test

ONLINE ACCESS

$9.99

Unlock all 10 practice questions, answers and explanations.

  • Immediate access after payment
  • One question at a time in practice mode
  • Jump directly to any question
  • One-time payment

We'll send your purchase information to this address.

Payment is processed by PayPal.

TRY IT FIRST

Sample practice questions

Try some of the questions before buying. Answers and explanations are available with online access.

1) You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup options except which one to accomplish this task?
  1. Change the print page order
  2. Adjust page breaks
  3. Set a print area
  4. Print titles.
2) You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z?
  1. Freeze Panes command
  2. New Window command and cascade the windows
  3. Hide Rows command
  4. Split Rows command
3) Which statement is not a recommended guideline for designing and creating an Excel table?
  1. Ensure that no blank columns separate data columns within the table
  2. Avoid naming two fields with the same name
  3. Leave one blank row between records in the table
  4. Include field names on the first row of the table
4) Which of the following characters are wildcards in Excel? (Check all that apply.)
  1. $
  2. #
  3. ?
  4. *
5) What should you do to ensure that records in a table are unique?
  1. Use the Remove Duplicates command
  2. Look at each row yourself and manually delete duplicate records
  3. Do nothing; a logical reason probably exists to keep identical records
  4. Find the duplicate records and change some of the data to be different.
6) Which Conditional Formatting rule is best suited to apply formatting to the top five values in a range of values?
  1. Greater Than
  2. Above Average
  3. Between
  4. Top 10 Items
7) Which date filter option enables you to restrict the view to only dates that occur in March of 2018?
  1. Between
  2. Equals
  3. Before
  4. After
8) Which of the following is an unqualified structured reference?
  1. =Sales[Purchase_Price]-Sales[Down_Payment]
  2. =[Sales]Purchase_Price-[Sales]Down_Payment
  3. =Purchase_Price-Down_Payment
  4. =[Purchase_Price]-[Down_Payment]
9) Which of the following is not an aggregate function that can be applied in a total row?
  1. VLOOKUP
  2. COUNT
  3. MAX
  4. AVERAGE
10) If you would like to set a conditional formatting rule based on the function =AND(G6="Finance", H7<7000), which formatting rule type is needed?
  1. Format only cells that contain
  2. Format all cells based on their values
  3. Format only values that are above or below average
  4. Use a formula to determine which cells to format

Ready for all 10 questions?

Unlock the full practice test

About the