ch 4 excel

Question 1

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?

A. New Window command and cascade the windows
B. Freeze Panes command
C. Hide Rows command
D. Split Rows command

Answer 1

B. Freeze Panes command

Question 2

Which of the following is an unqualified structured​ reference?

A. =Purchase_Price-Rebate
B. =[Purchase_Price]-[Rebate]
C. ​=Totals[@Purchase_Price]-Totals[@Rebate]
D. =[Totals]Purchase_Price-[Totals]Rebate

Answer 2

B. =[Purchase_Price]-[Rebate]

Question 3

What should you do to ensure that records in a table are​ unique?

A. Use the Remove Duplicates command.
B. Do​ nothing; a logical reason probably exists to keep identical records.
C. Look at each row yourself and manually delete duplicate records.
D. Filter the data to show only unique records.

Answer 3

A. Use the Remove Duplicates command.

Question 4

Which of the following characters is a wildcard in​ Excel?

A. ​$
B. ​&            
C. #
D. *

Answer 4

D. *

Question 5

Which of the following conditional formatting rules cannot be applied using Quick​ Analysis?

A. Greater Than
B. Less Than
C. Top​ 10%
D. Data Bars

Answer 5

B. Less Than

Question 6

Which of the following is not an aggregate function that can be applied in a total​ row?

A. VLOOKUP
B. AVERAGE
C. MAX
D. COUNT

Answer 6

A. VLOOKUP

Question 6

Which date filter option enables you to restrict the view to only dates between June​ 16, 2024, and June​ 30, 2024?

A. Equals
B. After
C. Before
D. Between

Answer 6

D. Between

Question 7

Which statement is not a recommended guideline for designing and creating an Excel​ table?

A. Leave one blank row between records in the table.
B. Avoid naming two fields with the same name.
C. Include field names on the first row of the table.
D. Ensure that no blank columns separate data columns within the table.

Answer 7

A. Leave one blank row between records in the table.

Question 8

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?

A. Set a print area.
B. Change the print page order.
C. Print titles.
D. Adjust page breaks.

Answer 8

B. Change the print page order.

Question 9

Which conditional formatting rule is best suited to highlight sales value less than​ $300?

A. Equals
B. Between
C. Less Than
D. Greater Than

Answer 9

C. Less Than