1) MS Excel is mainly used for: a) Creating presentations b) Editing images c) Performing calculations and data analysis d) Sending emails 2) The intersection of a row and a column in Excel is called a: a) Box b) Worksheet c) Cell d) Table 3) Which symbol is used to start a formula in MS Excel? a) # b) @ c) $ d) = 4) What is the default file extension of an Excel workbook? a) .docx b) .pptx c) .xlsx d) .txt 5) Which function is used to find the total of selected cells? a) COUNT() b) TOTAL() c) SUM() d) ADD() 6) Which option is used to change the appearance of text in a worksheet? a) Formula b) Formatting c) Filtering d) Sorting 7) Which feature in MS Excel allows you to visually represent data using bars, lines, or slices? a) Formatting b) Filtering c) Sorting d) Charts 8) Which Excel feature automatically fills a series of values such as numbers, dates, or days? a) Data Validation b) AutoFill c) AutoSum d) Flash Fill e) data f) none 9) Which function calculates the average of a range of cells? a) MEAN() b) MID() c) AVERAGE() d) AVG() 10) What is the name of the highlighted cell in a worksheet? a) Current cell b) Active cell c) Selected cell d) Primary cell

Gr8-Term2Examination

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？