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

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?