Higher Admin Spreadsheets

What is the purpose of using absolute cells in spreadsheets?

• To change the value of the cell

• To make the cell invisible

• To highlight the cell in a different color

• The purpose of using absolute cells in spreadsheets is to keep a specific cell reference constant when copying a formula to other cells.

How do you calculate the sum of a range of cells in a spreadsheet?

• Use the AVERAGE function

• Manually add the numbers

• Use the SUM function in the spreadsheet software.

• Multiply the cells together

What is the syntax for the COUNTIF function in spreadsheets?

• =AVERAGEIF(range, criteria)

• =MAXIF(range, criteria)

• =SUMIF(range, criteria)

• The syntax for the COUNTIF function in spreadsheets is =COUNTIF(range, criteria).

What is the purpose of the HLOOKUP function in spreadsheets?

• The purpose of the HLOOKUP function is to search for a value in the top row of a table or an array, and then return a value in the same column from a specified row.

• The purpose of the HLOOKUP function is to perform mathematical calculations on a range of cells in a spreadsheet.

• The purpose of the HLOOKUP function is to search for a value in the leftmost column of a table or an array, and then return a value in the same row from a specified column.

• The purpose of the HLOOKUP function is to create a new table based on the data in an existing table in a spreadsheet.

What is the purpose of the VLOOKUP function in spreadsheets?

• The purpose of the VLOOKUP function is to calculate the sum of a range of cells in a spreadsheet

• The purpose of the VLOOKUP function is to change the font style of a specific cell in a spreadsheet

• The purpose of the VLOOKUP function is to search for a value in the first column of a table and return a value in the same row from a specified column.

• The purpose of the VLOOKUP function is to create a new worksheet in a spreadsheet

What are some guidelines for printing spreadsheets to ensure readability?

• Printing in landscape mode only

• Using a very small font size

• Not adding any headers or footers

• Some guidelines for printing spreadsheets to ensure readability include adjusting the page layout, setting appropriate print area, using appropriate font size and style, adding headers and footers, and considering color and contrast for better visibility.

How do you lock specific cells in a spreadsheet to prevent editing?

• By changing the font color of the cells

• By selecting the cells, right-clicking, choosing 'Format Cells', checking the 'Locked' box in the 'Protection' tab, and then protecting the sheet.

• By deleting the cells

• By emailing the spreadsheet to yourself

What is the purpose of the IF function in spreadsheets?

• The purpose of the IF function in spreadsheets is to calculate the average of a range of cells

• The purpose of the IF function in spreadsheets is to perform a logical test and return one value if the test is true and another value if the test is false.

• The purpose of the IF function in spreadsheets is to change the font style of a cell

• The purpose of the IF function in spreadsheets is to insert a new row at the bottom of the spreadsheet

What is the purpose of the HLOOKUP function in spreadsheets?

• The purpose of the HLOOKUP function is to search for a value in the bottom row of a table or an array, and then return a value in the same column from a specified row.

• The purpose of the HLOOKUP function is to search for a value in the leftmost column of a table or an array, and then return a value in the same row from a specified column.

• The purpose of the HLOOKUP function is to search for a value in the top row of a table or an array, and then return a value in the same column from a specified row.

• The purpose of the HLOOKUP function is to search for a value in the rightmost column of a table or an array, and then return a value in the same row from a specified column.

What is the purpose of the VLOOKUP function in spreadsheets?

• The purpose of the VLOOKUP function is to calculate the sum of a range of cells in a spreadsheet

• The purpose of the VLOOKUP function is to change the font style of a specific cell in a spreadsheet

• The purpose of the VLOOKUP function is to create a new worksheet in a spreadsheet

• The purpose of the VLOOKUP function is to search for a value in the first column of a table and return a value in the same row from a specified column.