Excel Yr 9 Revision

Multiple Choice

What does the formula =COUNT(A1:A9) do?

• Counts the number of cells filled with text

• Counts the number of cells filled with data

• Counts the number of empty cells

• Counts the total number of cells in the range

Multiple Choice

Which of the following is a correct syntax for the COUNTIF function?

• `=COUNTIF(range, criteria)`

• `=COUNTIF(criteria, range)`

• `=COUNTIF(range)`

• `=COUNTIF(criteria)`

Multiple Choice

What does the COUNTIF function do in Excel?

• Counts the number of cells that contain numbers

• Counts the number of cells that meet a specified condition

• Counts the total number of cells in a range

• Counts the number of empty cells

Multiple Choice

What is the purpose of the COUNTIF formula in the context of the attendance table?

• To count the total number of students

• To count how many P's, A's, M's, or H's for each student

• To calculate the average attendance

• To determine the percentage of present students

Multiple Choice

What function is used in the spreadsheet to count the occurrences of names containing 'Brown'?

• SUMIF

• COUNTIF

• AVERAGEIF

• VLOOKUP

Multiple Choice

What does the VLOOKUP formula do?

• It adds numbers together

• It retrieves specific information from a table

• It formats cells

• It creates charts

Multiple Choice

What happens if the `range_lookup` argument in VLOOKUP is set to FALSE?

• It returns an approximate match.

• It returns an exact match.

• It returns the first value in the column.

• It returns the last value in the column.

Multiple Choice

What does the VLOOKUP function primarily do in Excel?

• It calculates the sum of a range of cells.

• It searches for a value in the first column of a table and returns a value in the same row from a specified column.

• It filters data based on specific criteria.

• It formats cells based on conditions.

Multiple Choice

Which of the following is a correct syntax for the VLOOKUP function?

• `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`

• `=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])`

• `=VLOOKUP(col_index_num, lookup_value, table_array, [range_lookup])`

• `=VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup])`

Multiple Choice

In the VLOOKUP function, what does the `col_index_num` argument specify?

• The row number to search in.

• The column number from which to return the value.

• The number of cells to skip.

• The number of rows to include in the search.

Multiple Choice

What is the purpose of the VLookup workbook mentioned in the image?

• To learn about VLookup

• To create a presentation

• To write an essay

• To conduct a survey

Multiple Choice

Avery is trying to create a budget spreadsheet. How is an absolute reference designated in a formula?

• With a dollar sign ($)

• With an ampersand sign (&)

• With a percentage sign (%)

• With an exclamation mark (!)

Multiple Choice

During a math class, Elijah is learning about different types of cell references in spreadsheets. What type of cell reference changes when copied to another cell?

• Absolute reference

• Mixed reference

• Relative reference

• Fixed reference

Multiple Choice

During a class project, Hannah is working on a spreadsheet. Which key can she press to toggle between relative and absolute references?

• F6

• F4

• F2

• F5