Which function counts cells that contain a certain criteria e.g. all the cells containing "Halloween", sumif, countif, min, max, Which function sum the values in a range of data that meet certain criteria?, countif, sum, sumif, average, Every formula begins with an…, *, (, :, =, To multiply in Excel you use the…, x, *, \, >, Sally works in a cinema. She wants to know how many of the tickets sold for a movie were for adults and how many were for children. Which function will she use?, average, countifs, max, vlookup, Tim needs to calculate the best selling product for today. Which function should be used?, average, min, max, countif, Which function has been used here to return the price of the items?, countif, countifs, sumif, vlookup, Which symbol is used before the before both the column letter and the row number to prevent it from changing when the formula is copied or filled to other cells?, €, $, @, =, To calculate a percentage you can use, =part*total, =part/total, =sum(), =max(), A5, B2, C10 are all, formulae, functions, cell references, rows, Which tool is best to duplicate information from one cell to another?, fill handle, sort, filter, format, Which of the following would be used to organise names in a spreadsheet alphabetically?, filter, format, merge and centre, sort, Which function counts cells in a range that are NOT empty?, COUNTIF, COUNTIFS, COUNT, COUNTA, Zoe needs to format a cell to currency. Which option should she select?, Tom is calculating a percentage. His formula is =c2/b2. How should he format the cell to show the answer as a percentage?, When text is too long in a cell what should be used?, bigger font, border, text wrap, format to currency, This is used to..., wrap text, add colour to cells, add a border around data, to make text bold, What has been used here to make the data stand out?, conditional formatting, data validation, Conditional formatting is used to..., make data / trends stand out, prevent errors, to confuse the audience, to show currency values, What has been used here to reduce the chance of an error?, Conditional formatting, Data Validation (drop down list), text wrap, border, What has been used here to visually show the trend / variation in the data?, sparklines, data validation, conditional formatting, a border

Task 2 Excel

만든이
인쇄
퍼가기

순위표

현재 순위표 기능을 개선하기 위해 노력하고 있습니다. 피드백을 제공하여 도움을 주세요.

피드백 제공

비주얼 스타일

옵션

현재 활동 설정을 개선하는 작업을 진행 중입니다. 여러분의 피드백을 주시면 도와주시기 바랍니다.

피드백 제공

템플릿 전환하기

자동 저장된 게임을 복구할까요?