EXCEL Practice Test: Video 4 Answers (24 Questions)

Question 1

Which function returns the number of cells in a range that meet a given condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells within a range that satisfy a single specified criterion.

Question 2

How do you switch Workbook Views to Page Break Preview on the ribbon?

Accepted Answer

View

Answer

The 'Page Break Preview' option, along with other workbook views like Normal and Page Layout, is located under the 'View' tab on the Excel ribbon. This view is essential for preparing worksheets for printing, as it visually displays where page breaks will occur and allows for easy adjustment.

Question 3

What does VLOOKUP's fourth argument (range_lookup) do when set to FALSE?

Accepted Answer

Returns an exact match only

Answer

Setting range_lookup to FALSE forces VLOOKUP to find an exact match and return #N/A if none exists.

Question 4

What are the shortcut keys on the keyboard for inserting a table?

Accepted Answer

ALT + N + T

Answer

The shortcut keys ALT + N + T are used to insert a table in Excel. ALT activates the ribbon, N goes to the Insert tab, and T specifically selects 'Table'. Excel tables provide enhanced functionality for data management, including automatic filtering, structured references, and easy formatting.

Question 5

What is the result of =MOD(17, 5)?

Accepted Answer

2

Answer

MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2.

Excel Practice Test

Excel Practice Test

EXCEL Practice Test: Video 4 Answers (24 Questions)