1) Which function counts cells that contain a certain criteria e.g. all the cells containing "Halloween" a) sumif b) countif c) min  d) max 2) Which function sum the values in a range of data that meet certain criteria?   a) countif b) sum c) sumif d) average 3) Every formula begins with an… a) * b) ( c) : d) = 4) To multiply in Excel you use the… a) x b) * c) \ d) > 5) 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?  a) average b) countifs c) max d) vlookup 6) Tim needs to calculate the best selling product for today. Which function should be used? a) average b) min c) max d) countif 7) Which function has been used here to return the price of the items? a) countif b) countifs c) sumif d) vlookup 8) 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? a) € b) $ c) @ d) = 9) To calculate a percentage you can use   a) =part*total   b) =part/total  c) =sum() d) =max() 10) A5, B2, C10 are all a) formulae b) functions c) cell references d) rows 11) Which tool is best to duplicate information from one cell to another? a) fill handle  b) sort c) filter d) format 12) Which of the following would be used to organise names in a spreadsheet alphabetically? a) filter b) format c) merge and centre d) sort 13) Which function counts cells in a range that are NOT empty? a) COUNTIF b) COUNTIFS c) COUNT d) COUNTA  14) Zoe needs to format a cell to currency. Which option should she select? a) b) c) d) 15) Tom is calculating a percentage. His formula is =c2/b2. How should he format the cell to show the answer as a percentage? a) b) c) d) 16) When text is too long in a cell what should be used? a) bigger font b) border c) text wrap d) format to currency 17) This is used to... a) wrap text b) add colour to cells  c) add a border around data d) to make text bold 18) What has been used here to make the data stand out? a) conditional formatting  b) data validation 19) Conditional formatting is used to... a) make data / trends stand out b) prevent errors c) to confuse the audience d) to show currency values 20) What has been used here to reduce the chance of an error? a) Conditional formatting b) Data Validation (drop down list) c) text wrap d) border 21) What has been used here to visually show the trend / variation in the data? a) sparklines b) data validation c) conditional formatting d) a border

Task 2 Excel

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?